解决MyBatis中为类配置别名,列名与属性名不对应的问题

<&＃63;xml version="1.0" encoding="UTF-8"&＃63;>


 


  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

<&＃63;xml version="1.0" encoding="UTF-8"&＃63;>


 
 


 
 
 
 select * from product where id = #{id}
 
 
 
 
 select * from Product 
 
 
 
 
 insert into product (productName,dir_id,salePrice,supplier,brand,cutoff,costPrice)
 values(#{productName},#{dir_id},#{salePrice},#{supplier},#{brand},#{cutoff},#{costPrice})
 
 
 
 
 delete from product where id = #{id}
 
 
 
 update product set productName=#{productName},dir_id=#{dir_id},
 salePrice=#{salePrice},supplier=#{supplier},brand=#{brand},cutoff=#{cutoff},costPrice=#{costPrice}
 where id = #{id}
 
 

 
 
 
 
 

 select * from product where id = #{id}

  
 
  select 
   id as userId,
   username as userName,
   address as userAddress,
   sex as userSex,
   birthday as userBirthday 
  from user;
 

 
   
  
   
  
  
  
  
 

 
  select * from user
 

@Test
public void queryAll() throws IOException {
 // 1.创建工厂类.
 InputStream in = Resources.getResourceAsStream("mybatis-config.xml");
 SqlSessionFactory sqlSessiOnFactory= new SqlSessionFactoryBuilder().build(in);
 // 2.创建sql对象.
 SqlSession sqlSession = sqlSessionFactory.openSession();
 // 3.创建接口的实现类对象.
 UserMapper mapper = sqlSession.getMapper(UserMapper.class);
 // 4.调用接口中的方法 (代理)
 List users = mapper.queryAll();
 for (User user : users) {
  System.out.println(user);
 }
 sqlSession.close();
 in.close();
}