目录
数据库准备
CREATE DATABASE `learning`;
USE `learning`;
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
INSERT INTO `user` VALUES ('1', '张三', '123456', '123@qq.com');
INSERT INTO `user` VALUES ('2', '李四', '123789', '789@qq.com');
新建springboot项目,目录结构为
pom.xml依赖
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.0</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
application.yml配置
spring:
datasource:
username: root
password: 123456
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/learning?useSSL=true&useUnicode=true&characterEncoding=utf8
#type: com.alibaba.druid.pool.DruidDataSource
server:
port: 8081
mybatis:
type-aliases-package: com.ltl.domain
mapper-locations: classpath:mapper/*.xml
User实体类
package com.ltl.domain;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
private int id;
private String username;
private String password;
private String email;
public User(String username, String password, String email) {
this.username = username;
this.password = password;
this.email = email;
}
}
UserMapper接口
package com.ltl.mapper;
import com.ltl.domain.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import java.util.List;
@Mapper
@Repository
public interface UserMapper {
//添加用户
int addUser(User user);
//删除用户
int deleteUserById(int id);
//查询用户(根据id)
User queryUserById(int id);
//查询全部用户
List<User> queryAllUser();
//修改用户
int updateUser(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.ltl.mapper.UserMapper">
<insert id="addUser" parameterType="User">
insert into user(username,password,email) values (#{username}, #{password}, #{email})
</insert>
<delete id="deleteUserById" parameterType="int">
delete from user where id = #{id}
</delete>
<select id="queryUserById" parameterType="int" resultType="User">
select * from user where id = #{id}
</select>
<select id="queryAllUser" resultType="User">
select * from user
</select>
<update id="updateUser" parameterType="User">
update user set username = #{username},password = #{password},email = #{email}
where id = #{id}
</update>
</mapper>
UserController
package com.ltl.controller;
import com.ltl.domain.User;
import com.ltl.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
@RestController
public class UserController {
@Autowired
UserMapper userMapper;
//查询用户
@GetMapping("/queryAllUser")
public List<User> queryAllUser(){
List<User> userList = userMapper.queryAllUser();
for (User user : userList) {
System.out.println(user);
}return userList;
}
//添加用户,注意数据库是自增主键
@GetMapping("/addUser")
public String addUser(){
int a = userMapper.addUser(new User("springboot","mybatis","555@qq.com"));
if(a>0){
return "添加用户成功";
}
return "添加用户失败";
}
//删除用户
@GetMapping("/deleteUserById")
public String deleteUserById(){
int a = userMapper.deleteUserById(16);
if(a>0){
return "删除用户成功";
}
return "删除用户失败";
}
//编辑用户
@GetMapping("/updateUser")
public String updateUser(){
int a = userMapper.updateUser(new User(16,"springboot-mybatis","mybatis","666@qq.com"));
if(a>0){
return "修改用户成功";
}
return "修改用户失败";
}
}
运行结果