MyBatis Generator 自动生成Dao、Bean、Mapping相关

野性酷女 2022-05-31 14:13 143阅读 0赞

1、配置eclipse使用MyBatis Generator

\[java\]  [view plain][]  [copy][view plain]

1.  从 https://github.com/mybatis/generator/releases 下载MyBatis Generator  
2.  把解压后的MyBatis Generator放入eclipse对应的目录中（features/plugins）  
3.    
4.  重启eclipse，在 File->New->Other->MyBatis会找到相应选项

2、使用MyBatis Generator 自动生成Dao、Bean、Mapping

配置详情参考：http://mbg.cndocs.tk/index.html  
generatorConfig.xml

\[java\]  [view plain][]  [copy][view plain]

1.  <?xml version="1.0" encoding="UTF-8" ?>  
2.  <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config\_1\_0.dtd" >  
3.    
4.  <generatorConfiguration>    
5.          
6.      <classPathEntry    
7.          location="D:\\eclipse\\workspace\\vip\_admin\\WebContent\\WEB-INF\\lib\\mysql-connector-java-5.1.6-bin.jar" />    
8.      <context id="context1">    
9.          <commentGenerator>    
10.                 
11.             <property name="suppressAllComments" value="true"/>    
12.         </commentGenerator>    
13.             
14.         <jdbcConnection driverClass="com.mysql.jdbc.Driver"    
15.             connectionURL="jdbc:mysql://IP:PORT/springmvc" userId="root" password="root" />    
16.             
17.         <javaModelGenerator targetPackage="com.zp.bean" targetProject="vip\_admin/mbg" />    
18.             
19.         <sqlMapGenerator targetPackage="com.zp.dao.mapper" targetProject="vip\_admin/mbg" />    
20.             
21.         <javaClientGenerator targetPackage="com.zp.dao" targetProject="vip\_admin/mbg" type="XMLMAPPER" />    
22.              
23.         <table schema="springmvc" tableName="studentinfo" domainObjectName="StudentInfoVO" enableCountByExample="true" enableUpdateByExample="true"    
24.             enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true">    
25.             <columnOverride column="id" property="id"  />    
26.             <columnOverride column="name" property="name" />    
27.             <columnOverride column="classname" property="classname" />    
28.             <columnOverride column="teacher\_id" property="teacherId" />    
29.             <columnOverride column="comment" property="comment" />    
30.             <columnOverride column="type" property="type" />     
31.         </table>   
32.     </context>    
33. </generatorConfiguration>

3、生成类

\[java\]  [view plain][]  [copy][view plain]

1.  配置好后，右键点击generatorConfig.xml，选择Generate MyBatis/iBATIS  会生产相应的类

4、测试

\[java\]  [view plain][]  [copy][view plain]

1.  @Test  
2.  public void handler() throws JSONException \{  
3.      ApplicationContext context = new ClassPathXmlApplicationContext("classpath:spring/applicationContext.xml");  
4.        
5.      StudentInfoVOMapper dao = context.getBean(StudentInfoVOMapper.class);  
6.      StudentInfoVOExample example = new StudentInfoVOExample();  
7.      com.zp.bean.StudentInfoVOExample.Criteria criteria = example.createCriteria();  
8.      criteria.andIdGreaterThanOrEqualTo(7);  
9.      criteria.andNameLike("%aa%");  
10.       
11.     List<StudentInfoVO> list = dao.selectByExampleWithBLOBs(example);  
12.     for (StudentInfoVO studentInfoVO : list) \{  
13.         System.out.println(JSONUtil.serialize(studentInfoVO));  
14.     \}

5、结果

\[java\]  [view plain][]  [copy][view plain]

1.  16:20:47.725 \[main\] DEBUG o.s.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource  
2.  16:20:47.725 \[main\] DEBUG o.m.s.t.SpringManagedTransaction - JDBC Connection \[com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@24111ef1\] will not be managed by Spring  
3.  16:20:47.737 \[main\] DEBUG c.z.d.S.selectByExampleWithBLOBs - ==>  Preparing: select 'true' as QUERYID, id, name, classname, teacher\_id, type , comment from studentinfo WHERE ( id >= ? and name like ? )   
4.  16:20:47.819 \[main\] DEBUG c.z.d.S.selectByExampleWithBLOBs - ==> Parameters: 7(Integer), %aa%(String)  
5.  16:20:47.858 \[main\] DEBUG c.z.d.S.selectByExampleWithBLOBs - <==      Total: 2  
6.  16:20:47.859 \[main\] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession \[org.apache.ibatis.session.defaults.DefaultSqlSession@58be6e8\]  
7.  16:20:47.859 \[main\] DEBUG o.s.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource  
8.  \{ "classname":"一班","comment":"你好 欢迎您id=7","id":7,"name":"aa2","teacherId":1,"type":1\}  
9.  \{ "classname":"一班","comment":null,"id":10,"name":"aa11","teacherId":1,"type":2\}

[view plain]: http://blog.csdn.net/u013820054/article/details/58134957#