springboot+mybatis

springboot+mybatis的整合

控制层UserController.java类

@RestController
public class UserController {
    @Autowired
    UserService userService;
    @RequestMapping("/findAll")
    public List<User> findAll(){

        return userService.findAll();
    }
}

UserMapper .java类

@Repository
public interface UserMapper {

    //查询全部的user表中的数据
    List<User> findAll();
    
}

dao层类

@Data
@Accessors(chain = true) //链式加载
@NoArgsConstructor //无参构造
@AllArgsConstructor //有参构造
@TableName("user") //对象与数据表完成映射
public class User implements Serializable {
    @TableId(type=IdType.AUTO) //主键自动
    private Integer id;
    private String userName;
    private String passWord;
    private String realName;
}

主要的xml，sql语句

<?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.example.mapper.UserMapper">

    <select id="findAll" resultType="com.example.pojo.User">
        select * from user
    </select>
</mapper>

注意的springboot配置文件
主要是看看url,跟password这两个一个是连接数据的路径，我是连接的docker上面的MySQL，自己改改，密码是自己设置的密码

spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://192.168.1.100:3306/test
spring.datasource.username=root
spring.datasource.password=123456

mybatis-plus.mapper-locations=classpath*:mybatis/mapper/**Mapper.xml
mybatis-plus.typeAliasesPackage=com.example.**.entity
mybatis-plus.defaultStatementTimeout=120

主要的数据库

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `userName` varchar(32) NOT NULL,
  `passWord` varchar(50) NOT NULL,
  `realName` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;