目录
1. 新建springboot项目
在整合前,我们需要新建一个springboot项目,步骤如下:
项目是tomcat部署的,所以打成war包,jar是可执行文件
项目的依赖项
<dependencies>
<!--mybatis整合依赖-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.3.0</version>
</dependency>
<!--mysql驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.30</version>
<scope>runtime</scope>
</dependency>
<!--lombok注解实体类-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version> 1.18.24</version>
<optional>true</optional>
</dependency>
<!--测试启动-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!--web-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
</dependencies>
项目本身是继承了父boot的,所以有些依赖不需要指定版本
2. 配置application文件
来做一些简单的配置,端口号,连接配置,mapper扫描
# 端口号
server:
port: 8082
# 连接配置
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/数据库
username: xxxx
password: xxxx
# mybatis配置
mybatis:
mapper-locations: classpath:mapper/*.xml
实体类
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
private Integer id;
private String usname;
private String uspwd;
}
3. 实现Mapper层
@Mapper
public interface UserMapper {
/**
* 获取所有user对象
* @return list
*/
List<User> getUserAll();
/**
* 通过id获取User对象
* @param id
* @return 单个User
*/
User getUserById(Integer id);
/**
* 通过ID删除指定User
* @param id
* @return 影响行数
*/
int removeUserById(Integer id);
/**
* 通过类中的ID,修改指定的User
* @param user
* @return 影响行数
*/
int updateUser(User user);
/**
* 添加User
* @param user
* @return 影响行数
*/
int saveUser(User user);
}
在resources资源目录下创建mapper.xml映射文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bdql.dao.UserMapper">
<insert id="saveUser">
insert into user(usname,uspwd) values (#{usname},#{uspwd})
</insert>
<update id="updateUser">
update user set usname = #{usname}, uspwd = #{uspwd} where id = #{id}
</update>
<delete id="removeUserById">
delete from user where id = #{id}
</delete>
<select id="getUserAll" resultType="com.bdql.pojo.User">
select * from user
</select>
<select id="getUserById" resultType="com.bdql.pojo.User">
select * from user where id = #{id}
</select>
</mapper>