利用SpringBoot整合Mybatis,用Mapper.xml配置文件与Mapper接口配置映射完成四个基础的增删改查语句,注意先配置好数据源环境。
User 类
public class User {
private int id;
private String name;
private String password;
//......注意配置get set 方法
}
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.example.springbootmybatis.mapper.UserXmlMapper">
<!--删除操作-->
<delete id="delete" parameterType="java.lang.Integer">
delete from user where id=#{id}
</delete>
<!--修改操作-->
<update id="update" parameterType="com.example.springbootmybatis.domain.User">
update user set name=#{name},password=#{password} where id=#{id}
</update>
<!--插入操作-->
<insert id="save" parameterType="com.example.springbootmybatis.domain.User">
<!--#{}内部是实体的属性名-->
<!--insert into user (id, name, password)
values (#{id,jdbcType=INTEGER}, #{userName,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR})-->
insert into user values (#{id}, #{name}, #{password})
</insert>
<!--查询操作-->
<select id="findAll" resultType="user">
select * from user
</select>
<!--根据id进行查询-->
<select id="findById" resultType="user" parameterType="int">
select * from user where id=#{id}
</select>
</mapper>
UserXmlMapper 接口
@Mapper
@Repository
public interface UserXmlMapper {
public void delete(int id);
public void update(User user);
public void save(User user);
public List<User> findAll();
public User findById(int id);
}
SpringBootMybatisApplicationTests 测试类
@RunWith(SpringRunner.class)
@SpringBootTest
class SpringBootMybatisApplicationTests {
private User user = new User();
@Autowired
private UserMapper userMapper;
@Autowired
private UserXmlMapper userXmlMapper;
@Test
public void testFindAll(){
List<User> list = userXmlMapper.findAll();
System.out.println(list);
}
@Test
public void testByID(){
User user = userXmlMapper.findById(1234567805);
System.out.println(user);
}
@Test
public void testInsert(){
user.setId(1234567805);
user.setName("老七");
user.setPassWord("123456");
userXmlMapper.save(user);
System.out.println("插入成功!");
}
@Test
public void testUpdate(){
user.setId(1234567805);
user.setName("张三");
user.setPassWord("123456");
userXmlMapper.update(user);
System.out.println("修改成功!");
}
@Test
public void testDelete(){
userXmlMapper.delete(1234567805);
System.out.println("删除成功!");
}
}