SSM框架搭建——鏈接docker下的資料庫
- 整體流程圖
- SSM基本配置
- Sresource
- servlet操作
- 業務代碼
- 測驗service
- 前端部分
- 前后端測驗
整體流程圖
先來一個整體的流程圖,不慌不慌,按照流程走,沒問題,
明人不說暗話,小劉不說廢話,直接上教程,
SSM基本配置
1.在File中選擇New,輸入maven,選擇新建一個maven project專案,

2.選擇生成簡易框架,記住自己起的專案名稱,

3.選擇型別為war包,填寫上一步的專案名稱,

4.這個時候專案是報紅色的x的,我們需要調整一下專案,


別忘了點擊右下角的Apply哦,

還是別忘啦apply,
5.生成一個pom檔案,
先右鍵專案,

做完這一步我們的專案就不報紅色的x了,看著舒服多了,
6.配置web.xml檔案


7.去引依賴,

超全依賴庫(保持更新)
能用到的依賴這個鏈接里面都有,可以先收藏,
也可以直接貼我的xml依賴,
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.dyit.ssm</groupId>
<artifactId>ssm-example</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>war</packaging>
<properties>
<com.lombok.version>1.18.16</com.lombok.version>
<com.spring.version>5.2.12.RELEASE</com.spring.version>
<com.junit.version>4.12</com.junit.version>
<com.mysql.version>8.0.22</com.mysql.version>
<com.druid.version>1.2.4</com.druid.version>
<com.mybatis.version>3.5.6</com.mybatis.version>
<com.mybatis-spring.version>2.0.6</com.mybatis-spring.version>
<com.slf4j-log4j12.version>1.7.30</com.slf4j-log4j12.version>
<com.jackson-databind.version>2.12.1</com.jackson-databind.version>
</properties>
<dependencies>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>${com.lombok.version}</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${com.spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${com.spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${com.spring.version}</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>${com.junit.version}</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${com.mysql.version}</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>${com.druid.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${com.mybatis.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>${com.mybatis-spring.version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>${com.slf4j-log4j12.version}</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>${com.jackson-databind.version}</version>
</dependency>
</dependencies>
</project>
更新一下我們引入的依賴,
在這里就可以看到我們的依賴了,

Sresource
1.建立兩個檔案夾

在resource下建兩個檔案夾,一個命名為mapper,一個命名為spring,
只有再在spring下建兩個檔案夾,方便以后放東西,
準備作業ok,
2.mvc檔案


給自己的檔案起個名字,我叫springmvc-servlet,見名知意,
3.mybatis檔案
在mybatis下面建一個檔案夾,叫config,放我們的資料庫組態檔

然后配置資料庫鏈接,

代碼我放在這里了,各位根據自己的資料庫改一下就行了,
druid.url=jdbc:mysql://192.168.0.160:3306/car_db?useUnicode=true&serverTimezone=Asia/Shanghai&useSSL=true
druid.username=root
druid.password=123
4.放日志檔案在resource下面,

代碼我放在這里,大家可以copy一下,
log4j.rootLogger=debug,Console,Logfile
#Console output
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d{yyyy-MM-dd hh:mm:ss} [%t] %rms (%-5p) [%c] -%l-- {%m}%n
log4j.appender.Logfile=org.apache.log4j.FileAppender
log4j.appender.Logfile.File=D:/logs/mybatis.log
log4j.appender.Logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.Logfile.layout.ConversionPattern=%d{yyyy-MM-dd hh:mm:ss} [%t] %rms (%-5p) [%c] -%l-- {%m}%n
log4j.logger.com.ibatis=DEBUG
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
5.配置web.xml檔案,啟動我們的容器,
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_1.xsd"
version="3.1">
<display-name>ssm-test</display-name>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring/mybatis/spring-*.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<servlet>
<servlet-name>springDispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet
</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring/mvc/springmvc-*.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springDispatcherServlet</servlet-name>
<url-pattern>/*</url-pattern>
</servlet-mapping>
</web-app>
servlet操作
1.建好我們要用的包

這是平常會用到的,先建好放著,
2.springmvc-servlet的配置

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd">
<context:component-scan base-package="com.dyit.ssm.controller"/>
<mvc:resources location="static/" mapping="staic/**"></mvc:resources>
<mvc:annotation-driven/>
</beans>
3.mybatis.xml的配置

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
<context:component-scan base-package="com.dyit.ssm">
<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!-- 讀取資料源配置資訊 -->
<context:property-placeholder location="classpath:spring/mybatis/config/druid.properties"/>
<!-- 資料源資訊 -->
<bean id="druidDataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="url" value="${druid.url}"/>
<property name="username" value="${druid.username}"/>
<property name="password" value="${druid.password}"/>
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="druidDataSource"/>
<property name="typeAliasesPackage" value="com.dyit.ssm.entity"/>
<property name="mapperLocations" value="classpath:mapper/*.mapper.xml"/>
</bean>
<!-- 系結mybatis物件 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.dyit.ssm.mapper"></property>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>
<!-- 管理事務方式 -->
<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="druidDataSource"></property>
</bean>
<tx:annotation-driven transaction-manager="txManager"/>
</beans>
業務代碼
1.先寫物體類,

package com.dyit.ssm.entity;
import org.apache.ibatis.type.Alias;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
@Alias(value = "Car")
public class Car {
private Integer id;
private String brand;
private String color;
private Double price;
}
2.在mapper包中寫實作介面,
大概就是要實作什么功能,就在這個介面中寫,

package com.dyit.ssm.mapper;
import java.util.List;
import com.dyit.ssm.entity.Car;
public interface ICarMapper {
void save(Car car);
void delete(int id);
void update(Car car);
List<Car> findAll();
}
3.在resource寫mapper的xml檔案,

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC
"-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dyit.ssm.mapper.ICarMapper" >
<!-- 表和類的映射 -->
<resultMap type="Car" id="carMap">
<id property="id" column="car_id"/>
<result property="brand" column="car_brand"/>
<result property="color" column="car_color"/>
<result property="price" column="car_price"/>
</resultMap>
<insert id="save">
INSERT INTO car_tab(car_brand,car_color,car_price)
VALUES(#{brand},#{color},#{price})
</insert>
<delete id="delete">
DELETE FROM car_tab WHERE car_id = #{id}
</delete>
<update id="update">
UPDATE car_tab
<set>
<if test="brand!=null">
car_brand = #{brand},
</if>
<if test="color!=null">
car_color = #{color},
</if>
<if test="price!=null">
car_price = #{price},
</if>
</set>
WHERE car_id = #{id}
</update>
<select id="findAll" resultMap="carMap">
SELECT * FROM car_tab
</select>
</mapper>
4.寫服務介面,

package com.dyit.ssm.service;
import java.util.List;
import com.dyit.ssm.entity.Car;
public interface ICarService {
void addCar(Car car);
void deleteById(int id);
void updateCar(Car car);
List<Car> findAll();
}
5.業務類的實作

package com.dyit.ssm.service.impl;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import com.dyit.ssm.entity.Car;
import com.dyit.ssm.mapper.ICarMapper;
import com.dyit.ssm.service.ICarService;
@Service
@Transactional
public class CarServiceImpl implements ICarService {
@Autowired
private ICarMapper mapper;
@Override
public void addCar(Car car) {
mapper.save(car);
}
@Override
public void deleteById(int id) {
mapper.delete(id);
}
@Override
public void updateCar(Car car) {
mapper.update(car);
}
@Override
public List<Car> findAll() {
return mapper.findAll();
}
}
6.dto中寫請求

package com.dyit.ssm.dto;
import java.util.Date;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class HttpResp {
private int code;
private String msg;
private Object results;
private Date time;
}
7.寫例外類

package com.dyit.ssm.exception;
public class SSMeXCEPTION extends RuntimeException {
public SSMeXCEPTION(String message) {
super(message);
}
}
測驗service
1.建立測驗類


把實作類的方法都選上,

package com.dyit.ssm.test;
import static org.junit.Assert.*;
public class Test {
@org.junit.Test
public void testAddCar() {
fail("Not yet implemented");
}
@org.junit.Test
public void testDeleteById() {
fail("Not yet implemented");
}
@org.junit.Test
public void testUpdateCar() {
fail("Not yet implemented");
}
@org.junit.Test
public void testFindAll() {
fail("Not yet implemented");
}
}
2.進行測驗


完美,測驗通過,
我們再去看看資料庫吧,

是不是完美極了呢~
前端部分
1.寫controller

package com.dyit.ssm.controller;
import java.util.Date;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.dyit.ssm.dto.HttpResp;
import com.dyit.ssm.entity.Car;
import com.dyit.ssm.service.ICarService;
@Controller
@RequestMapping("/api")
public class CarController {
@Autowired
private ICarService ics;
@PostMapping("/addCar")
@ResponseBody
public HttpResp addCar(Car car)
{
ics.addCar(car);
return new HttpResp(20001,"添加汽車成功",null,new Date());
}
@GetMapping("/findAll")
@ResponseBody
public HttpResp findAll()
{
return new HttpResp(20002,"查詢所有汽車成功",ics.findAll(),new Date());
}
}
2.啟動tomcat

添加我們的專案,

前后端測驗
我使用的是postman,
先運行我們的專案,然后在自己的測驗工具上輸入要測驗的內容,

好啦,這樣一個ssm專案就搭好了,是不是很有成就感呢,寶貝們~
轉載請註明出處,本文鏈接:https://www.uj5u.com/ruanti/255581.html
標籤:其他
下一篇:C語言專區
