UserMapper usermapper;

String resource = "mybatis-config.xml";
InputStream inputStream;
SqlSessionFactory sqlsessionFactory;
SqlSession sqlSession;

@Before
public void setUp() throws Exception {
    inputStream = Resources.getResourceAsStream(resource);
    sqlsessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    sqlSession = sqlsessionFactory.openSession();

}

/**
 * 查询1个用户
 */
@Test
public void test() {
    User user = new User();
    user.setuserName("zhangsan");
    
    User one = this.usermapper.selectOne(user);
    
    System.out.println(one);
}

/**
 * 查找用户，接收一个User对象。
 */
@Test
public void testselect(){
    
    User user = new User();
    user.setSex(2);

    List<User> list = this.usermapper.select(null);
    
    for (User user2 : list) {
        System.out.println(user2);
    }
    
    System.out.println("-------------");
    
    
    List<User> list2 = this.usermapper.select(user);
    
    for (User user2 : list2) {
        System.out.println(user2);
    }
    
}

/**
 * 查询总条数
 */
@Test
public void testSlecteCount(){
    int count = this.usermapper.selectCount(null);
    System.out.println(count);
    System.out.println("--------");
    
    User user = new User();
    user.setSex(1);
    int count2 = this.usermapper.selectCount(user);
    System.out.println(count2);
}


/**
 * 根据主键查询
 */
@Test
public void testSelectByPrimaryKey(){
    User user = this.usermapper.selectByPrimaryKey(1L);
    
    System.out.println(user);
}

@Test
public void testInsert(){
    User user = new User();
    user.setAge(22);
    user.setPassword("11111");

@Test
public void testDelete(){
    User user = new User();
    user.setAge(22);
    int i = this.usermapper.delete(user);
    this.sqlSession.commit();
    System.out.println(i);
}

@Test
public void testUpdate(){
    User user = new User();
    user.setId(18L);
    user.setuserName("kk0");;
    int i = this.usermapper.updateByPrimaryKeySelective(user);
    this.sqlSession.commit();
    System.out.println(i);
}

@Test
public void testSelectByExample(){
    
    Example example = new Example(User.class);
    example.createCriteria().andEqualTo("sex", 1).andBetween("age", 10, 22);
    example.or(example.createCriteria().andLike("name", "李"));
    example.setOrderByClause("age desc");
    
    List<User> list = this.usermapper.selectByExample(example);
    
    for (User user : list) {
        System.out.println(user);
    }
}