MyBatis 实现 crud 操作
一、基于 xml 的 crud 操作
1.搭建 MyBatis 的 环境(导入jar包,配置xml文件等),学习总结(一)有详细内容,这里略过。
2.编写表对应实体类的映射xml文件
UserMapper.xml
<mapper namespace="com.wsb.mybatis.test.UserMapper">
<select id="getUser" parameterType="int" resultType="com.wsb.mybatis.test.User">
select *
from users where id = #{id}
</select>
<insert id="addUser" parameterType="com.wsb.mybatis.test.User">
insert into users(name,age)
value(#{name},#{age})
</insert>
<update id="updateUser" parameterType="com.wsb.mybatis.test.User">
update users set
name=#{name}, age=#{age} where id=#{id}
</update>
<delete id="deleteUser" parameterType="java.lang.Integer">
delete from users where
id=#{id}
</delete>
<select id="getAllUsers" resultType="com.wsb.mybatis.test.User">
select * from users
</select>
</mapper>
3.编写crud对应的实现方法,以增加,修改为例,
MyBatisUtil.java
public class MyBatisUtil {
public static SqlSessionFactory getFactory() {
InputStream inputStream = TestUser.class.getClassLoader().getResourceAsStream("mybatis-config.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
return factory;
}
}
以下是实现
@Test
public void testAddUser(){
SqlSessionFactory factory = MyBatisUtil.getFactory();
SqlSession session = factory.openSession();
String statement = "com.wsb.mybatis.test.UserMapper.addUser";
int insert = session.insert(statement, new User(null, "wen", 11));
session.commit();
System.out.println(insert);
session.close();
}
@Test
public void testUpdateUser(){
SqlSessionFactory factory = MyBatisUtil.getFactory();
SqlSession session = factory.openSession();
String statement = "com.wsb.mybatis.test.UserMapper.updateUser";
int update = session.update(statement, new User(1, "wen2", 12));
session.commit();
System.out.println(update);
session.close();
}
二、基于注解 crud 操作
注意:MyBatis 基于注解实现 crud 操作,只需要编写对应的接口,不需要提供实现类,MyBatis 框架会自己产生对应的实现。
1.编写需要用的接口,以下以增加为例,其它的自行仿造
UserMapper.java
public interface UserMapper {
//跟xml的写法一样
@Insert("insert into users(name,age) value(#{name},#{age})")
public void add(User user);
}
2.在 MyBatis 的配置文件中注册接口,详细配置文件看学习总结(一)
mybatis-config.xml
<mapper class="com.wsb.mybatis.test2.UserMapper" />
3.测试
TestUser.java
@Test
public void testAdd2(){
SqlSessionFactory factory = MyBatisUtil.getFactory();
SqlSession session = factory.openSession();
//通过接口动态生成代理实现类
UserMapper mapper = session.getMapper(UserMapper.class);
mapper.add(new User(-1, "abc", 12));
session.commit();
session.close();
}