<!--UserMapper.xml--><?xml version="1.0" encoding="UTF-8"?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="UserMapper"><!--查询所有--><selectid="findAll"resultType="com.domain.User">
SELECT * FROM user
</select><!--查询单个用户--><selectid="login"resultType="com.domain.User"parameterType="com.domain.User">
SELECT * FROM user WHERE username = #{username} AND password = #{password}
</select><!--增加用户--><insertid="add"parameterType="com.domain.User">
INSERT INTO user VALUES (#{username},#{password},#{age},#{sex})
</insert><!--修改用户信息--><updateid="update"parameterType="com.domain.User">
UPDATE user SET password = #{password} WHERE username = #{username}
</update><!--删除用户 单个参数时,#{}中的参数可以是任意的--><deleteid="delete"parameterType="java.lang.String">
DELETE FROM user WHERE username = #{aaa}
</delete></mapper>
packagecom.mapper;importcom.domain.User;importorg.apache.ibatis.annotations.Delete;importorg.apache.ibatis.annotations.Insert;importorg.apache.ibatis.annotations.Select;importorg.apache.ibatis.annotations.Update;importjava.io.IOException;importjava.util.List;publicinterfaceUserMapper{@Insert("insert into user values(#{username},#{password},#{age},#{sex})")Integersave(User user);@Update("update user set password=#{password} where username=#{username}")Integerupdate(User user);@Delete("delete from user where username = #{username}")Integerdelete(String username);@Select("select * from user")List<User>selectAll();}
4.编写测试类进行测试
packagecom;importcom.domain.User;importcom.mapper.UserMapper;importorg.apache.ibatis.io.Resources;importorg.apache.ibatis.session.SqlSession;importorg.apache.ibatis.session.SqlSessionFactory;importorg.apache.ibatis.session.SqlSessionFactoryBuilder;importorg.junit.Before;importorg.junit.Test;importjava.io.IOException;importjava.io.InputStream;importjava.util.List;publicclassTestMybatis{privateUserMapper userMapper;@Beforepublicvoidbefore()throwsIOException{InputStream resourceAsStream =Resources.getResourceAsStream("SqlMapConfig.xml");SqlSessionFactory sessionFactory =newSqlSessionFactoryBuilder().build(resourceAsStream);SqlSession session = sessionFactory.openSession(true);
userMapper = session.getMapper(UserMapper.class);}@TestpublicvoidtestSave(){User user =newUser();
user.setUsername("Huicoder");
user.setPassword("xxx");
user.setAge(22);
user.setSex("男");int result = userMapper.save(user);if(result>0){System.out.println("插入成功!!!");}}@TestpublicvoidtestUpdate(){User user =newUser();
user.setUsername("Huicoder");
user.setPassword("hhh");int result = userMapper.update(user);if(result>0){System.out.println("修改成功!!!");}}@TestpublicvoidtestDelete(){int result = userMapper.delete("Huicoder");if(result>0){System.out.println("删除成功!!!");}}@TestpublicvoidtestSelect(){List<User> userList = userMapper.selectAll();for(User user : userList){System.out.println(user);}}}