本文共 3955 字，大约阅读时间需要 13 分钟。

MyBatis???????mybatis-generator????Java??

MyBatis????

?Java??????????????????????????????SQL??????LIMIT???????????????????????????????????????

MyBatis??????????????????????????????????????????????????????????????PageHelper?

??PageHelper????

1. ??????

?????????????

create table t_user (
    user_id int primary key auto_increment,
    user_name varchar(20),
    user_age int,
    user_address varchar(30)
);

2. ????

????pom.xml????????

   
    
    
    
    
        
     
      mysql
     
        
     
      mysql-connector-java
     
        
     
      5.1.38
     
    
    
    
    
    
    
        
     
      org.mybatis
     
        
     
      mybatis
     
        
     
      3.4.6
     
    
    
    
    
    
    
        
     
      com.github.pagehelper
     
        
     
      pagehelper
     
        
     
      5.1.2
     
    
    
   

3. ??JavaBean

??????????

package com.wangxing.mybatis.bean;
public class UserBean {
    private int userid;
    private String username;
    private int userage;
    private String useraddress;
    // setter?getter??
}

4. ??????

??UserMapper???

package com.wangxing.mybatis.mapper;
public interface UserMapper {
    void insertUser(List
   
     userBeans);
    List
    
      selectUser();
}
    
   

5. SQL????

??UserMapper?SQL???

   
    
    
     
        insert into t_user (username, userage, useraddress) values
        
     
      
            (${user.username}, ${user.userage}, ${user.useraddress})
        
     
    
    
    
    
        select * from t_user
    
    
    
        
     
        
     
        
     
        
     
    
    
   

6. ??MyBatis????

?mybatis-config.xml??????????

??mybatis-generator????Java??

mybatis-generator????????????????Java????????????????SQL?????????????????

1. ???????

?????mybatis-generator?????????

• mybatis-generator-core-1.3.6.jar
• mysql-connector-java-5.1.27.jar
• mybatis.bat?????
• generatorConfig.xml????

2. ??generatorConfig.xml

?????????

3.??mybatis.bat

??mybatis.bat?????????src?????Java??SQL?????

4. ????

???????????

src/
    com/
        wangxing/
            mybatis/
                bean/
                    PersonBean.java
                mapper/
                    PersonBeanMapper.xml
    mybatis-generator/src/
        main/resources/mybatis-config.xml

5. ????

?TestMain?????????

public static void testSelectByNameAndPassAndAge(String name, String pass, int age) {
    SqlSession sqlSession = null;
    try {
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config.xml"));
        sqlSession = sqlSessionFactory.openSession();
        PersonBeanMapper personBeanMapper = sqlSession.getMapper(PersonBeanMapper.class);
        PersonBeanExample personBeanExample = new PersonBeanExample();
        Criteria criteria = personBeanExample.createCriteria();
        criteria.andPerNameLike("%" + name + "%");
        criteria.andPerPassEqualTo(pass);
        criteria.andPerAgeEqualTo(age);
        List
   
     personList = personBeanMapper.selectByExample(personBeanExample);
        if (!personList.isEmpty()) {
            for (PersonBean personBean : personList) {
                System.out.println(personBean.getPerId() + "," + personBean.getPerName());
            }
        } else {
            System.out.println("????????");
        }
        sqlSession.commit();
    } catch (Exception e) {
        e.printStackTrace();
        if (sqlSession != null) {
            sqlSession.rollback();
        }
    } finally {
        if (sqlSession != null) {
            sqlSession.close();
        }
    }
}
   

???????????MyBatis????????mybatis-generator?????????Java??????????