新建项目
spring.png
pom.xml 文件增加mysql和mybatis配置
<!--mysql数据库驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<!--mybatis-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.0</version>
</dependency>
删除application.properties，使用yml配置
新增
application-dev.yml、application.ym 文件
dev文件中jdbc:mysql://localhost:3306/ 后跟的是数据库名称
数据中新增user表，并且插入数据
CREATE TABLE `user` (
`id` int(32) NOT NULL AUTO_INCREMENT,
`username` varchar(32) NOT NULL,
`password` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
INSERT INTO `user` VALUES ('1', 'malone', '007');
INSERT INTO `user` VALUES ('2', 'oyl', '520');
新建User类
public class User {
private Integer id;
private String username;
private String password;
...省略get set
}
新建UserMapper
@Repository
public interface UserMapper {
User getUser(int id);
}
新建UserService
@Service
public class UserService {
@Autowired
UserMapper userMapper;
public User getUser(int id){
return userMapper.getUser(id);
}
}
新建UserController
@RestController
@RequestMapping("/springboot")
public class UserController {
@Autowired
private UserService userService;
@RequestMapping("getUser/{id}")
public String GetUser(@PathVariable int id){
return userService.getUser(id).toString();
}
}
resources目录下新增mapping文件夹，并且新建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.joy.mapper.UserMapper">
<resultMap id="BaseResultMap" type="com.joy.entity.User">
<result column="id" jdbcType="INTEGER" property="id" />
<result column="username" jdbcType="VARCHAR" property="username" />
<result column="password" jdbcType="VARCHAR" property="password" />
</resultMap>
<select id="getUser" resultType="com.joy.entity.User">
select * from user where id = #{id}
</select>
</mapper>
启动类Application，新增
@MapperScan("com.joy.mapper")
浏览器输入访问地址：http://localhost:8080/springboot/getUser/1 即可成功运行。
