spring+springMvc+mybatis整合
-
搭建一个maven 项目
我们使用idea 创建一个maven 项目 File-New-Project-Maven
填写好项目名称和组id
目录如下
-
添加pom.xml jar 包
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>11</maven.compiler.source>
<maven.compiler.target>11</maven.compiler.target>
<srping.version>4.0.2.RELEASE</srping.version>
<mybatis.version>3.2.8</mybatis.version>
<slf4j.version>1.7.12</slf4j.version>
<log4j.version>1.2.17</log4j.version>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<!-- java ee包 -->
<dependency>
<groupId>javax</groupId>
<artifactId>javaee-api</artifactId>
<version>7.0</version>
<scope>provided</scope>
</dependency>
<!-- spring框架包 start -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${srping.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${srping.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-oxm</artifactId>
<version>${srping.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${srping.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${srping.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${srping.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${srping.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>${srping.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>${srping.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${srping.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${srping.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${srping.version}</version>
</dependency>
<!-- spring框架包 end -->
<!-- mybatis框架包 start -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
<!-- mybatis框架包 end -->
<!-- 数据库驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.35</version>
</dependency>
<!-- 导入dbcp的jar包,用来在applicationContext.xml中配置数据库 -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>
<!-- jstl标签类 -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- log start -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>${log4j.version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>${slf4j.version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>${slf4j.version}</version>
</dependency>
<!-- log END -->
<!-- Json -->
<!-- 格式化对象,方便输出日志 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.6</version>
</dependency>
<dependency>
<groupId>org.codehaus.jackson</groupId>
<artifactId>jackson-mapper-asl</artifactId>
<version>1.9.13</version>
</dependency>
<!-- 上传组件包 start -->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.1</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.4</version>
</dependency>
<dependency>
<groupId>commons-codec</groupId>
<artifactId>commons-codec</artifactId>
<version>1.10</version>
</dependency>
</dependencies>
- 创建整合需要包
创建java 目录下controller,service,dao,pojo 和resources下mapper 目录
- 在resources 资源目录创建数据库配置文件jdbc.properties 和mybatis 日志打印mybatis-config
jdbc.properties
driver=com.mysql.jdbc.Driver
url= jdbc:mysql://127.0.0.1:3307/ljh?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
username=root
password=123456
initialSize=0
maxActive=20
maxIdle=20
minIdle=1
maxWait=60000
mybatis-config
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<!-- 打印查询语句 -->
<setting name="logImpl" value="STDOUT_LOGGING" />
</settings>
</configuration>
- spring 整合mybatis
在resources 创建一个application-mybatis.xml 文件用来整合 mybatis
<?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"
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.xsd">
<!-- 自动扫描 -->
<context:component-scan base-package="com.ljh.ssm" >
<!-- 不扫描@Controller注解的类-->
<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!-- 引入配置文件 -->
<!-- 引入配置文件 -->
<bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location" value="classpath:jdbc.properties" />
</bean>
<!-- -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
<!-- 初始化连接大小 -->
<property name="initialSize" value="${initialSize}"></property>
<!-- 连接池最大数量 -->
<property name="maxActive" value="${maxActive}"></property>
<!-- 连接池最大空闲 -->
<property name="maxIdle" value="${maxIdle}"></property>
<!-- 连接池最小空闲 -->
<property name="minIdle" value="${minIdle}"></property>
<!-- 获取连接最大等待时间 -->
<property name="maxWait" value="${maxWait}"></property>
</bean>
<!-- spring和MyBatis整合,不需要mybatis的配置映射文件 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 自动扫描mapping.xml文件 -->
<property name="mapperLocations" value="classpath*:com/ljh/ssm/mapper/*.xml"></property>
<!-- 加入日志打印文件 -->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
</bean>
<!-- dao 接口所在包名,spring 会自动查找其下的类,动态代理实现 不用写到的实现类 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.ljh.ssm.dao"/>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
<!-- 事务管理 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
</beans>
- spring 整合springMvc
在resources 创建一个 application-springMvc.xml 文件用来整合springMvc
<?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"
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.xsd">
<!-- 自动扫描 -->
<context:component-scan base-package="com.ljh.ssm" >
<!-- 不扫描@Controller注解的类-->
<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!-- 引入配置文件 -->
<!-- 引入配置文件 -->
<bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location" value="classpath:jdbc.properties" />
</bean>
<!-- -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
<!-- 初始化连接大小 -->
<property name="initialSize" value="${initialSize}"></property>
<!-- 连接池最大数量 -->
<property name="maxActive" value="${maxActive}"></property>
<!-- 连接池最大空闲 -->
<property name="maxIdle" value="${maxIdle}"></property>
<!-- 连接池最小空闲 -->
<property name="minIdle" value="${minIdle}"></property>
<!-- 获取连接最大等待时间 -->
<property name="maxWait" value="${maxWait}"></property>
</bean>
<!-- spring和MyBatis整合,不需要mybatis的配置映射文件 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 自动扫描mapping.xml文件 -->
<property name="mapperLocations" value="classpath*:com/ljh/ssm/mapper/*.xml"></property>
<!-- 加入日志打印文件 -->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
</bean>
<!-- dao 接口所在包名,spring 会自动查找其下的类,动态代理实现 不用写到的实现类 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.ljh.ssm.dao"/>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
<!-- 事务管理 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
</beans>
- web.xml 文件
在web.xm 配置编码过滤器和加载spring 配置文件
<?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_0.xsd" id="WebApp_ID" version="3.0">
<display-name>Archetype Created Web Application</display-name>
<!-- 编码过滤器 -->
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- spring 监听器 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:application-mybatis.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- Spring MVC 配置servlet -->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:application-springMvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
- 编写数据库文件
我们创建一张用户表,我们对他进行增删改查
create table ljh.user
(
id int auto_increment
primary key,
USERNAME varchar(100) not null,
SEX varchar(2) not null,
AGE int not null,
TEACHER_ID int null,
CREATE_TIME datetime null,
UPDATE_TIME datetime null,
DELETE_AT int null
);
- pojo 实体类实现
在pojo 目录下创建一个user.java
package com.ljh.ssm.pojo;
import java.util.Date;
/**
* @author shkstart
* @create 2021-12-2117:43
*/
public class User {
private int id;
private String username;
private String sex;
private int age;
private int teacherId;
private Date createTime;
private Date updateTime;
private int deleteAt;
public String getSex() {
return sex;
}
public User setSex(String sex) {
this.sex = sex;
return this;
}
public int getAge() {
return age;
}
public User setAge(int age) {
this.age = age;
return this;
}
public int getTeacherId() {
return teacherId;
}
public User setTeacherId(int teacherId) {
this.teacherId = teacherId;
return this;
}
public Date getCreateTime() {
return createTime;
}
public User setCreateTime(Date createTime) {
this.createTime = createTime;
return this;
}
public Date getUpdateTime() {
return updateTime;
}
public User setUpdateTime(Date updateTime) {
this.updateTime = updateTime;
return this;
}
public int getDeleteAt() {
return deleteAt;
}
public User setDeleteAt(int deleteAt) {
this.deleteAt = deleteAt;
return this;
}
public int getId() {
return id;
}
public User setId(int id) {
this.id = id;
return this;
}
public String getUsername() {
return username;
}
public User setUsername(String username) {
this.username = username;
return this;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", sex='" + sex + '\'' +
", age=" + age +
", teacherId=" + teacherId +
", createTime=" + createTime +
", updateTime=" + updateTime +
", deleteAt=" + deleteAt +
'}';
}
}
- dao 层实现
分别在dao 层创建用户接口文件 UserMapper 和resource mapper 目录存放userMapper.xml 接口实现xml 文件
UserMapper
package com.ljh.ssm.dao;
import com.ljh.ssm.pojo.User;
/**
* @author shkstart
* @create 2021-12-2115:43
*/
public interface UserMapper {
//查询用户信息
public User getUserInfo(int id);
//添加用户信息
public int insertUserInfo(User user);
//删除用户信息
public void deleteUserInfoById(int id);
//修改用户信息
public void updateUserInfo(User user);
}
UserMapper.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.ljh.ssm.dao.UserMapper">
<resultMap id="map" type="com.ljh.ssm.pojo.User">
<id property="id" column="id"/>
<result property="teacherId" column="teacher_id"/>
<result property="createTime" column="create_time" javaType="java.util.Date"/>
<result property="deleteAt" column="delete_at"/>
</resultMap>
<!-- 查询用户信息 -->
<select id="getUserInfo" parameterType="int" resultMap="map">
select *from user where id = #{id}
</select>
<!-- 添加用户信息 -->
<insert id="insertUserInfo" parameterType="com.ljh.ssm.pojo.User">
-- 返回主键
<selectKey resultType="int" keyProperty="id" order="AFTER">
select @@IDENTITY as id
</selectKey>
INSERT INTO user (USERNAME, SEX, AGE, TEACHER_ID, CREATE_TIME, UPDATE_TIME, DELETE_AT) VALUES (#{username}, #{sex}, #{age}, null, #{createTime}, null, null)
</insert>
<!-- 删除用户id -->
<delete id="deleteUserInfoById" parameterType="int">
DELETE FROM user WHERE id = #{id}
</delete>
<!-- 修改用户信息 -->
<update id="updateUserInfo" parameterType="com.ljh.ssm.pojo.User">
UPDATE user
<set>
<if test="username!=null">
username = #{username}
</if>
<if test="sex!=null">
sex = #{sex}
</if>
<if test="age!=0">
age = #{age}
</if>
<if test="createTime!=null">
create_time = #{createTime}
</if>
</set>
<where>
id = #{id}
</where>
</update>
</mapper>
- service 层实现
在service 中我们创建两个文件,UserService接口文件和接口实现类文件UserServiceImpl
UserService 实现
package com.ljh.ssm.service;
import com.ljh.ssm.pojo.User;
import org.springframework.stereotype.Service;
/**
* @author shkstart
* @create 2021-12-229:30
*/
public interface UserService {
//查询用户信息
public User getUserInfo(int id);
//插入用户信息
public int insertUserInfo(User user);
//删除用户信息
public void deleteUserInfoById(int id);
//跟新用户信息
public void updateUserInfo(User user);
}
UserServiceImpl 实现
package com.ljh.ssm.service.impl;
import com.ljh.ssm.dao.UserMapper;
import com.ljh.ssm.pojo.User;
import com.ljh.ssm.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
/**
* @author shkstart
* @create 2021-12-229:31
*/
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public User getUserInfo(int id) {
return userMapper.getUserInfo(id);
}
@Override
public int insertUserInfo(User user) {
return userMapper.insertUserInfo(user);
}
@Override
public void deleteUserInfoById(int id) {
userMapper.deleteUserInfoById(id);
}
@Override
public void updateUserInfo(User user) {
userMapper.updateUserInfo(user);
}
}
- controller 层实现
controller 实现接口调用
package com.ljh.ssm.controller;
import com.ljh.ssm.pojo.User;
import com.ljh.ssm.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;
import java.util.Date;
/**
* @author shkstart
* @create 2021-12-2115:47
*/
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
/**
* get 请求用户信息
*/
@RequestMapping(value = "/userInfo/{id}",method = RequestMethod.GET)
public User getUserInfo(@PathVariable int id){
User userInfo = userService.getUserInfo(id);
return userInfo;
}
/**
* post 请求添加用户信息
* @param user
* @return
*/
@RequestMapping(value = "/userInfo",method = RequestMethod.POST)
public int addUserInfo(User user){
user.setCreateTime(new Date());
int i = userService.insertUserInfo(user);
//返回主键id
return user.getId();
}
/**
* delete 删除请求
* @param id
*/
@RequestMapping(value = "/userInfo/{id}",method = RequestMethod.DELETE)
public void deleteUserInfoById(@PathVariable int id){
userService.deleteUserInfoById(id);
}
/**
* put 请求更新用户信息
* @param user
*/
@RequestMapping(value = "/userInfo",method = RequestMethod.PUT)
public void updateUserInfo(User user){
userService.updateUserInfo(user);
}
}
- 配置maven tomcat 插件
在 pom.xml 里面配置tomcat7 插件
<build>
<plugins>
<!-- tomcat插件控制 -->
<plugin>
<groupId>org.apache.tomcat.maven</groupId>
<artifactId>tomcat7-maven-plugin</artifactId>
<version>2.2</version>
<configuration>
<!--端口控制-->
<port>8854</port>
<!--项目路径控制意味着http://localhost:8080/abc-->
<path>/ljh</path>
<!--编码-->
<uriEncoding>UTF-8</uriEncoding>
</configuration>
</plugin>
<!-- maven插件控制 -->
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.1</version>
<configuration>
<source>11</source>
<target>11</target>
<encoding>utf-8</encoding>
</configuration>
</plugin>
</plugins>
</build>
在idea 中配置启动
14. 使用postman通过restful 风格调用controller 接口
get 方式查询用户信息
post 方式添加用户信息
put 方式修改用户信息
delete 方式删除用户信息