mybatis使用xml进行增删改查代码解析

DataSource dataSource = BlogDataSourceFactory.getBlogDataSource();
TransactionFactory transactionFactory = new JdbcTransactionFactory();
//环境
Environment environment = new Environment("development", transactionFactory, dataSource);
Configuration configuration = new Configuration(environment);
//映射器类
configuration.addMapper(BlogMapper.class);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);

<?xml version="1.0" encoding="UTF-8" ?>




     
   
    
    
    
   

   
   
    select * from t_user where id=#{id}
   

   
    delete from t_user where id=#{id}
   


   
    update t_user set username=#{name},age=#{age} where id=#{id}
   

   
    insert into t_user(username,age) values(#{name},#{age})
   

   

   
    select * from t_user
   

<?xml version="1.0" encoding="UTF-8"?>



  

  
  
    
    
  

  
    
      
      
        
        
        
        
      
    
  

  
    
    
    
  

public static SqlSessionFactory getFactory(){
	/* flow the src dir*/
	String resource = "mybatis.xml";
	/*MybatisUtils.class.getResourceAsStream(resource)----- it's wrong !!!!
     * please distinguish the two up and down 
     * */
	InputStream inputStream = MybatisUtils.class.getClassLoader().getResourceAsStream(resource);
	SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
	return factory;
}
SqlSession session = factory.openSession(true);
//默认手动提交；
/*
  两种解决方式：
  1.factory.opensession(true);
  2.session.commit();
  */

/*use sql xml not annotation*/
@Test
  public void testAdd(){
	SqlSession session = MybatisUtils.getFactory().openSession();
	String statement = "com.web.mapper.userMapper.insertUser";
	/*return the effect rows*/
	int insert= session.insert(statement, new User("tom5", 15));
	/*default is not auto commit*/
	session.commit(true);
	session.close();
	System.out.println("effect rows.."+insert);
}
@Test
  public void testSelect(){
	/*set auto commit ,which equals to the above*/
	SqlSession session = MybatisUtils.getFactory().openSession(true);
	String statement = "com.web.mapper.userMapper.getUser";
	/*return the effect rows*/
	User user = session.selectOne(statement, 3);
	System.out.println("effect rows.."+user);
}
@Test
  public void testUpdate(){
	SqlSession session = MybatisUtils.getFactory().openSession(true);
	String statement = "com.web.mapper.userMapper.updateUser";
	/*return the effect rows*/
	int update= session.update(statement, new User(3,"tom4", 13));
	System.out.println("effect rows.."+update);
}
@Test
  public void testDelete(){
	SqlSession session = MybatisUtils.getFactory().openSession();
	String statement = "com.web.mapper.userMapper.deleteUser";
	/*return the effect rows*/
	int delete= session.delete(statement, 6);
	/* commit by yourself*/
	session.commit();
	System.out.println("effect rows.."+delete);
	session.close();
}
@Test
  public void testGetUsers(){
	SqlSession session = MybatisUtils.getFactory().openSession();
	String statement = "com.web.mapper.userMapper.getUsers";
	/*return the List*/
	List users= session.selectList(statement);
	session.commit();
	System.out.println("effect rows.."+users);
	session.close();
}

    select * from c_user where id=#{id};
  

@Test
  public void getUserForMap(){
	SqlSession session = MybatisUtils.getFactory().openSession();
	String statement = "com.web.mapper.userMapper.getUserForMap";
	HashMap map = new HashMap();
	map.put("id", 1);
	/*return the effect rows*/
	Object selectOne = session.selectOne(statement, map);
	/*default is not auto commit*/
	session.commit(true);
	session.close();
	System.out.println("effect rows.."+selectOne+" ,class :"+selectOne.getClass());
}

effect rows..{id=1, age=12, name=luli} ,class :class java.util.HashMap

 
    select id,site_id,site_name,site_number,province,city,area,address,internal_number,longitude,latitude
    from tb_site
    --使用动态sql
     
      
        and check_state = #{checkState,jdbcType=INTEGER}
      
      
        and site_id like concat('%',#{siteId},'%')
      
      
        and site_name like concat('%',#{siteName},'%')
      
      
        and site_number like concat('%', #{siteNumber},'%')
      
      
        and province = #{province}
      
      
        and city = #{city}
      
      
        and area = #{area}
      
     
    --添加排序
    
      order by ${sortname} ${sortorder}
    
    --添加分页
    limit ${(page-1)*pagesize},${pagesize}
 

  
    delete from tb_user
    where
    id = #{id} 
  

  
    delete from tb_user
    where
    id = #{id} 
  

  
    delete from tb_user
    where id in
    --使用foreach
     #{id} 
    
  

    select count(*) from tb_sys_role
    
      
        
        and id = #{keySysRole.id}
        
        
        and name = #{keySysRole.name}
        
        
        and available = #{keySysRole.available}