MyBatis

                      MyBatis学习总结(二)——使用MyBatis对表执行CRUD操作

MyBatis的SQL映射文件提供了seleect insert 的科特等元素来实现Sql语句的映射

为这个mapper指定一个唯一的namespace，namespace的值习惯上设置成包名+sql映射文件名，这样就能够保证namespace的值是唯一的
例如namespace=”me.gacl.mapping.userMapper”就是me.gacl.mapping(包名)+userMapper(userMapper.xml文件去除后缀)

 * 映射sql的标识字符串，
 *     me.gacl.mapping.userMapper是userMapper.xml文件中mapper标签的namespace属性的值，
    * getAllUsers是select标签的id属性值，通过select标签的id属性值就可以找到要执行的SQL
    * 

package me.gacl.test;

import java.util.List;
import me.gacl.domain.User;
import me.gacl.mapping.UserMapperI;
import me.gacl.util.MyBatisUtil;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
public class TestCRUDByAnnotationMapper {

 @Test
 public void testAdd(){
    SqlSession sqlSession = MyBatisUtil.getSqlSession(true);         //得到UserMapperI接口的实现类对象，UserMapperI接口的实现类对象由sqlSession.getMapper(UserMapperI.class)动态构建出来
     UserMapperI mapper = sqlSession.getMapper(UserMapperI.class);
     User user = new User();
    user.setName("用户xdp");
     user.setAge(20);         int add = mapper.add(user);
     //使用SqlSession执行完SQL之后需要关闭SqlSession
     sqlSession.close();
     System.out.println(add);
 }

 @Test
 public void testUpdate(){
     SqlSession sqlSession = MyBatisUtil.getSqlSession(true);
    //得到UserMapperI接口的实现类对象，UserMapperI接口的实现类对象由sqlSession.getMapper(UserMapperI.class)动态构建出来
     UserMapperI mapper = sqlSession.getMapper(UserMapperI.class);
     User user = new User();
     user.setId(3);
     user.setName("孤傲苍狼_xdp");
     user.setAge(26);
     //执行修改操作
     int retResult = mapper.update(user);
     //使用SqlSession执行完SQL之后需要关闭SqlSession
     sqlSession.close();
     System.out.println(retResult);
 }

 @Test
 public void testDelete(){
     SqlSession sqlSession = MyBatisUtil.getSqlSession(true);
     //得到UserMapperI接口的实现类对象，UserMapperI接口的实现类对象由sqlSession.getMapper(UserMapperI.class)动态构建出来
     UserMapperI mapper = sqlSession.getMapper(UserMapperI.class);
     //执行删除操作
     int retResult = mapper.deleteById(7);
     //使用SqlSession执行完SQL之后需要关闭SqlSession
     sqlSession.close();
     System.out.println(retResult);
 }

 @Test
 public void testGetUser(){
     SqlSession sqlSession = MyBatisUtil.getSqlSession();
     //得到UserMapperI接口的实现类对象，UserMapperI接口的实现类对象由sqlSession.getMapper(UserMapperI.class)动态构建出来
     UserMapperI mapper = sqlSession.getMapper(UserMapperI.class);
     //执行查询操作，将查询结果自动封装成User返回
   User user = mapper.getById(8);
    //使用SqlSession执行完SQL之后需要关闭SqlSession
    sqlSession.close();
    System.out.println(user);
 }

 @Test7     public void testGetAll(){
     SqlSession sqlSession = MyBatisUtil.getSqlSession();
     //得到UserMapperI接口的实现类对象，UserMapperI接口的实现类对象由sqlSession.getMapper(UserMapperI.class)动态构建出来
     UserMapperI mapper = sqlSession.getMapper(UserMapperI.class);
     //执行查询操作，将查询结果自动封装成List<User>返回
     List<User> lstUsers = mapper.getAll();
     //使用SqlSession执行完SQL之后需要关闭SqlSession
     sqlSession.close();
     System.out.println(lstUsers);
 }

}

　　用到的MyBatisUtil工具类代码如下：

package me.gacl.util;

import java.io.InputStream;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class MyBatisUtil {

 /**
 * 获取SqlSessionFactory
  * @return SqlSessionFactory
  */
 public static SqlSessionFactory getSqlSessionFactory() {
     String resource = "conf.xml";
     InputStream is = MyBatisUtil.class.getClassLoader().getResourceAsStream(resource);
     SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
    return factory;
 }

/**
* 获取SqlSession
 * @return SqlSession
  *    public static SqlSession getSqlSession() {
     return getSqlSessionFactory().openSession();8     }

 /**
  * 获取SqlSession
  * @param isAutoCommit 
  *         true 表示创建的SqlSession对象在执行完SQL之后会自动提交事务
  *         false 表示创建的SqlSession对象在执行完SQL之后不会自动提交事务，这时就需要我们手动调用sqlSession.commit()提交事务
  * @return SqlSession
 */
 public static SqlSession getSqlSession(boolean isAutoCommit) {
     return getSqlSessionFactory().openSession(isAutoCommit);
}

}