回顾一波SpringBoot+MyBatis的项目整合,搭建起来还是挺easy的。
步骤一:初始化SpringBoot项目
可以用IDEA初始化,具体步骤可参考我之前的文章https://blog.csdn.net/qq_39946015/article/details/104527057,但最近使用idea创建的时候一直连接超时;
只好直接登录springboot官网https://start.spring.io/创建,创建方式如下:
1、选择版本,填写groupId等
2、选择依赖,这里可以选择web、jdbc、mybatis、Mysql即可。
3、下载到本地
步骤二:将项目导入到IDE中
将下载后的zip压缩包解压,然后使用idea打开即可。
步骤三:代码结构
整体代码结构如下:
application.yml
server:
port: 8081
spring:
#数据库连接配置
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf-8&useSSL=false
username: root
password: root
#mybatis的相关配置
mybatis:
#mapper配置文件
mapper-locations: classpath:mapper/*.xml
type-aliases-package: com.zym.learnspringbootmybatis.entity
#开启驼峰命名
configuration:
map-underscore-to-camel-case: true
User.java
@Data
public class User implements Serializable {
private Integer id;
private String name;
private String password;
}
UserMapper.java
@Mapper
public interface UserMapper {
public List<User> findAll();
}
UserService.java
public interface UserService {
public List<User> findAll();
}
UserServiceImpl.java
@Service
public class UserServiceImpl implements UserService {
@Autowired
UserMapper userMapper;
@Override
public List<User> findAll() {
return userMapper.findAll();
}
}
UserController.java
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
UserService userService;
@RequestMapping("/findAll")
public List<User> findAll(){
return userService.findAll();
}
}
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.zym.learnspringbootmybatis.mapper.UserMapper">
<select id="findAll" resultType="User">
select * from user
</select>
</mapper>
启动类LearnspringbootmybatisApplication.java
@SpringBootApplication
@MapperScan("com.zym.learnspringbootmybatis.mapper")
public class LearnspringbootmybatisApplication {
public static void main(String[] args) {
SpringApplication.run(LearnspringbootmybatisApplication.class, args);
}
}
步骤四:创建相应的user表,并插入几条数据。
步骤五:启动项目,浏览器访问
搞定!