http://www.cnblogs.com/xdp-gacl/p/4262895.html
继续参考这篇文章写Mybaits学习总结
上一章,我修改了编码,统一为UTF8之后,便没有编码错误
<?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,namespace的值习惯上设置成包名+sql映射文件名,这样就能够保证namespace的值是唯一的 例如namespace="me.gacl.mapping.userMapper"就是me.gacl.mapping(包名)+userMapper(userMapper.xml文件去除后缀) --> <mapper namespace="pw.jonwinters.mybaits.userMapper"> <!-- 在select标签中编写查询的SQL语句, 设置select标签的id属性为getUser,id属性值必须是唯一的,不能够重复 使用parameterType属性指明查询时使用的参数类型,resultType属性指明查询返回的结果集类型 resultType="me.gacl.domain.User"就表示将查询结果封装成一个User类的对象返回 User类就是users表所对应的实体类 --> <!-- 根据id查询得到一个user对象 --> <select id="getUser" parameterType="int" resultType="pw.jonwinters.mybaits.User"> select * from users where id=#{id} </select> <select id="getAllUsers" resultType="pw.jonwinters.mybaits.User"> select * from users </select> <!-- 创建用户(Create) --> <insert id="addUser" parameterType="pw.jonwinters.mybaits.User"> insert into users(name,age) values(#{name},#{age}) </insert> <update id="updateUser" parameterType="pw.jonwinters.mybaits.User"> update users set name = #{name},age = #{age} where id = #{id} </update> <select id="getAgeThanUsers" parameterType="int" resultType="pw.jonwinters.mybaits.User"> select * from users where age > #{0} </select> <select id="getAgeThanUsers_2" parameterType="pw.jonwinters.mybaits.User" resultType="pw.jonwinters.mybaits.User"> select * from users where age > #{age} and id > 7 </select> <delete id="delUserByID" parameterType="int" > delete from users where id = #{0} </delete> <delete id="delUserByID_2" parameterType="pw.jonwinters.mybaits.User" > delete from users where id = #{id} </delete> </mapper>
<delete id="delUserByID" parameterType="int" > delete from users where id = #{0} </delete>
//这里的#{0}我测试过了,无论里面填写什么都会被解析成 session.delete(str,xxx) 第二个参数xxxx
package pw.jonwinters.mybaits; import java.util.List; import java.io.InputStream; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import org.junit.Before; import org.junit.Test; import static org.junit.Assert.*; public class MybaitsTest { private SqlSession session ; @Before public void before(){ String res = "mybaitsConf.xml"; InputStream is = MybaitsTest.class.getClassLoader().getResourceAsStream(res);//将文件变成输入流 assertNotNull(is); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is);//工厂建立配置文件对象 assertNotNull(sessionFactory); session = sessionFactory.openSession(true);//打开事务 true为自动提交 } @Test public void sqlGetByID(){ String str = "pw.jonwinters.mybaits.userMapper.getUser"; User user = session.selectOne(str,3); assertNotNull(user); System.out.println(user); System.out.println("-----------sqlGetByID"); } @Test public void sqlTestGetAll(){ String str = "pw.jonwinters.mybaits.userMapper.getAllUsers"; List<User> users = session.selectList(str); for(User u : users){ System.out.println(u); } System.out.println("-----------sqlTestGetAll"); } //@Test public void sqlInsertUser(){ User user = new User(); //user.setId(13); user.setAge(16); user.setName("赵七"); assertEquals(session.insert("pw.jonwinters.mybaits.userMapper.addUser", user), 1); //session.insert("pw.jonwinters.mybaits.userMapper.addUser", user); session.commit(); session.close(); } @Test public void sqlAgeThanUsers(){ String str = "pw.jonwinters.mybaits.userMapper.getAgeThanUsers"; List<User> users = session.selectList(str, 14); for(User u : users){ System.out.println(u); } System.out.println("-----------getAgeThanUsers"); } @Test public void sqlAgeThanUsers_2(){ String str = "pw.jonwinters.mybaits.userMapper.getAgeThanUsers_2"; User user = new User(); user.setAge(14); List<User> users = session.selectList(str,user ); for(User u : users){ System.out.println(u); } System.out.println("-----------getAgeThanUsers_2"); } @Test public void sqlUpateUserByID(){ String str = "pw.jonwinters.mybaits.userMapper.updateUser"; User user = new User(); user.setAge(221); user.setName("赵288"); user.setId(8); assertEquals(1, session.update(str, user)); System.out.println("-----------sqlUpateUserByID"); } //@Test public void sqlDelByID(){ String str = "pw.jonwinters.mybaits.userMapper.delUserByID"; assertEquals(1,session.delete(str, 3)); System.out.println("-----------sqlDelByID"); } @Test public void sqlDelByID_2(){ String str = "pw.jonwinters.mybaits.userMapper.delUserByID_2"; User user = new User(); user.setId(8); assertEquals(1,session.delete(str,user)); System.out.println("-----------sqlDelByID_2"); } }
我自己稍作了一些Sql的修改,注解查询的方法目前没有验证