mybatis-03-增删改查实现

- pojo下的User类

在这边可以看到，使用了后面的Lombok技术
@alias别名，可以自定义resultType

@Data
@AllArgsConstructor
@NoArgsConstructor
@Alias("user")
public class User {
	private int id;
	private String name;
	private String password;}

增删改查实现

<!--    新增-->
    <insert id="addUser" parameterType="User" >
        insert into mybatis.user (id,name,pwd) values (#{id},#{name},#{password});
    </insert>


<!--    删除-->
    <select id="deleteUser" parameterType="int" resultType="java.lang.Integer">
        delete from mybatis.user where id=#{id};
    </select>

<!--    修改-->
    <update id="updateUser" parameterType="User">
        update mybatis.user set name=#{name},pwd=#{password} where id=#{id};
    </update>

<!--查询-->
    <select id="getUserById" resultMap="UserMap">
        select id,name,pwd as password from mybatis.user where id=#{id}
    </select>

值得注意的查了查询之外，所有的操作都需要提交事务。

测试类

@Test
	public void testDelete(){
		SqlSession sqlSession = MybatisUtils.getSqlSession();
		UserMapper mapper = sqlSession.getMapper(UserMapper.class);
		mapper.deleteUser(1);
		sqlSession.commit();
		sqlSession.close();
	}


	@Test
	public void testUpdate(){
		SqlSession sqlSession = MybatisUtils.getSqlSession();
		UserMapper mapper = sqlSession.getMapper(UserMapper.class);
		mapper.updateUser(new User(4,"4","4"));

		sqlSession.commit();
		sqlSession.close();
	}


	@Test
	public void testAdd(){
		SqlSession sqlSession = MybatisUtils.getSqlSession();
		UserMapper mapper = sqlSession.getMapper(UserMapper.class);

		mapper.addUser(new User(532,"dd","eee"));

		sqlSession.commit();
		sqlSession.close();

	}