因為來到這邊公司要用到mybatis包帚，之前因為用的是springboot驴剔，所以就想在springboot下面去整合mybatis. 因為之前用的是hibernate剧防，所以做起來也很簡單旦装，我覺得mybatis定制化很好笛坦，就是配置起來有點麻煩狠持，之前hibernate 和 JPA用起來很快疟位，mybatis就是要寫一寫mapper.xml，但是這可以鍛煉你的一個sql編寫能力喘垂。廢話就說這么多甜刻，先上結(jié)構(gòu)圖吧绍撞。
結(jié)構(gòu)圖:
structure.png
Model:
@Data
public class User {
private Integer id;
private String name;
private Integer age;
private String email;
}
其中data 注解是lombok插件里的，自動實現(xiàn)get set 以及hashcode 得院、euqals 和 toString 還有默認(rèn)的構(gòu)造函數(shù)
Mapper:
@Mapper
public interface UserMapper {
User findUserById(@Param("id") Integer id);
int updateUser(@Param("name") String name, @Param("id") Integer id);
int insertUser(@Param("id") Integer id, @Param("name") String name,
@Param("age") Integer age, @Param("email") String email);
int deleteUser(@Param("id") Integer id);
}
@Mapper注解會自動的生成UserMapper的代理類傻铣，并注入到spring容器中，所以在Service層的話祥绞，直接@Autowired的注入就行了非洲。
Mapping:
<?xml version = "1.0" encoding = "UTF-8"?>
<!DOCTYPE mapper PUBLIC
"-//mybatis.org//DTD com.example.Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.mapper.UserMapper">
<resultMap id="result" type="com.example.model.User">
<result property="id" column="id"/>
<result property="name" column="name"/>
<result property="age" column="age"/>
<result property="email" column="email"/>
</resultMap>
<select id="findUserById" resultMap="result">
SELECT * FROM user where id = #{id};
</select>
<update id="updateUser">
UPDATE user
SET
NAME = #{name}
where id = #{id}
</update>
<insert id="insertUser">
INSERT INTO user(id,name,age,email)
VALUES (
#{id,jdbcType=INTEGER},
#{name,jdbcType=VARCHAR},
#{age,jdbcType=INTEGER},
#{email,jdbcType=VARCHAR}
)
</insert>
<delete id="deleteUser">
delete from user where id = #{id}
</delete>
</mapper>
DAO:
@Component
public class UserDao {
@Autowired
private UserMapper mapper;
public User findUserById(Integer id) {
return mapper.findUserById(id);
}
public int insert(Integer id, String name, Integer age, String email) {
return mapper.insertUser(id, name, age, email);
}
public int update(String name, Integer id) {
return mapper.updateUser(name, id);
}
public int delete(Integer id) {
return mapper.deleteUser(id);
}
}
Controller:
@RestController
public class UserController {
@Autowired
private UserDao userDao;
@RequestMapping("/user")
public User getUserById(@RequestParam(value = "id") Integer id) {
User user;
user = userDao.findUserById(id);
return user;
}
@RequestMapping("/update")
public int updateById(@RequestParam(value = "name") String name,
@RequestParam(value = "id") Integer id) {
return userDao.update(name, id);
}
@RequestMapping("/insert")
public int insert(@RequestParam(value = "name") String name,
@RequestParam(value = "id") Integer id,
@RequestParam(value = "age") Integer age,
@RequestParam(value = "email") String email) {
return userDao.insert(id, name, age, email);
}
@RequestMapping("/delete")
public int delete(@RequestParam(value = "id") Integer id) {
return userDao.delete(id);
}
}
Dependencies:
dependencies {
compile('org.springframework.boot:spring-boot-starter')
compile('org.springframework.boot:spring-boot-devtools')
compile('org.springframework.boot:spring-boot-starter-web')
compile('org.mybatis.spring.boot:mybatis-spring-boot-starter:1.1.1')
compile('org.projectlombok:lombok:1.16.8')
compile('mysql:mysql-connector-java:6.0.5')
testCompile('org.springframework.boot:spring-boot-starter-test')
}
配置文件:
spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
mybatis.mapperLocations=classpath*:Mapper/**/*.xml
Schema:
CREATE TABLE `user` (
`id` int(11) unsigned zerofill NOT NULL AUTO_INCREMENT COMMENT '自增id',
`name` varchar(255) DEFAULT NULL COMMENT '姓名',
`age` int(11) DEFAULT NULL COMMENT '年齡',
`email` varchar(255) CHARACTER SET latin1 DEFAULT NULL COMMENT '郵件',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
