利用配置xml文件实现 实现单表的CRUD 操作
【主要的过程】
- 首先要有表中的对象类
- 建立要查询的表的接口(在持久层中添加要查询的方法)
- 在映射文件中配置中的内容
- 配置config配置文件
【表】
1.实现查询操作
public interface IAccountMappper {
Account selectAid(Integer id);
}
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTO Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.kfm.mybatis.mapper.IAccountMappper">
<select id="selectAid" resultType="com.kfm.mybatis.model.Account">
select * from account where id = #{id}
</select>
</mapper>
中的namespace
指的是要映射的持久层的接口
中的resultType指的是查询结果所返回的类型
public class IAccountMappperTest {
@Test
public void selectAid() throws IOException {
InputStream in = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
SqlSessionFactory factory = sqlSessionFactoryBuilder.build(in);
SqlSession session = factory.openSession();
IAccountMappper mapper = session.getMapper(IAccountMappper.class);
Account account = mapper.selectAid(1);
System.out.println(account);
}
}
2.新增用户
int save(Account account);
<insert id="save" parameterType="com.kfm.mybatis.model.Account">
insert into account (uid,money) values (#{uid},#{money})
</insert>
@Test
public void save() {
IAccountMappper mapper = session.getMapper(IAccountMappper.class);
Account account = new Account();
account.setUid(2);
account.setMoney(600.22);
int i = mapper.save(account);
System.out.println(i);
session.commit();
}
【注意1】要记得提交事务,要不然你插不进数据库
【注意2】在新增用户的时候还需要注意:还要返回当前新增用户的 id 值,如果 id 是由数据库的自动增长来实现的,所以就相 当于我们要在新增后将自动增长 auto_increment 的值返回。
<insert id="save" parameterType="com.kfm.mybatis.model.Account" useGeneratedKeys="true" keyProperty="id">
insert into account (uid,money) values (#{uid},#{money})
</insert>
3.修改用户
int updatea(Account account);
<update id="updatea" parameterType="com.kfm.mybatis.model.Account">
update account set uid = #{uid},money = #{money} where id = #{id}
</update>
@Test
public void updatea() {
IAccountMappper mapper = session.getMapper(IAccountMappper.class);
Account account1 = mapper.selectAid(3);
account1.setUid(2);
account1.setMoney(310);
int i = mapper.updatea(account1);
System.out.println(i);
session.commit();
}
4.删除数据
int deletea(int id);
<delete id="deletea" parameterType="integer">
delete from account where id = #{id}
</delete>
@Test
public void deletea() {
IAccountMappper mapper = session.getMapper(IAccountMappper.class);
int i = mapper.deletea(10);
System.out.println(i);
session.commit();
session.close();
}