构建spring-boot+mybatis项目
程序员文章站
2022-04-25 07:59:23
...
构建简单的spring-boot+mybatis项目
application.properties
#服务器端口号
server.port=8888
#数据库数据源配置 serverTimezone=UTC可能会报错事件问题
spring.datasource.url=jdbc:mysql://localhost:3306/test?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#mybatis
#要解析的mapper路径
mybatis.mapper-locations=classpath:mapper/*.xml
#实体层的包路径
mybatis.type-aliases-package=com.rz.test.pojo
User实体类
package com.rz.test.pojo;
import lombok.Data;
import org.apache.ibatis.type.Alias;
//注释实体类
@Data
//给User类取别名
@Alias("user")
public class User {
private Integer id;
private String username;
private String password;
}
DAO层(持久层)
package com.rz.test.dao;
import com.rz.test.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import java.util.List;
//Dao层注解
@Repository
//通过mapper映射文件查询数据库
@Mapper
public interface TestDao {
public List<User> select();
}
Service层接口(业务逻辑层)
package com.rz.test.service;
import com.rz.test.pojo.User;
import java.util.List;
public interface TestService {
public List<User> select();
}
Service层实现类
package com.rz.test.service;
import com.rz.test.dao.TestDao;
import com.rz.test.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
//service层注解
@Service
public class TestServiceImpl implements TestService{
//自动注入bean
@Autowired
TestDao testDao;
@Override
public List<User> select() {
return testDao.select();
}
}
控制层UserController
package com.rz.test.controller;
import com.rz.test.pojo.User;
import com.rz.test.service.TestService;
import com.rz.test.service.TestServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.xml.ws.Service;
import java.util.List;
//控制层注解
@RestController
public class UserController {
//自动注入bean
@Autowired
TestServiceImpl testService;
//接口映射
@RequestMapping("/select")
public List<User> select(){
return testService.select();
}
}
创建mapper.xml配置文件,写sql语句resource->mapper文件夹下面
<?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.rz.test.dao.TestDao">
<select id="select" resultType="user">
select * from t_user
</select>
</mapper>
注意
如果改了包名,会导致主类无法加载,需在maven的plugins里面运行clean插件,再重构项目即可。也可在setting->这个路径:
勾选上这几个:
上一篇: 宋朝为什么会出现党争?原因是什么
下一篇: JS中table表格的行合并