Using MyBatis to configure the mapping file is a bit cumbersome and error prone, and you can use the Jar tool to generate code automatically, which is efficient and convenient
One, download two jar, and place in G:\tool\maven\generator directory (own definition)
Mybatis-generator-core-1.3.2.jar
Mysql-connector-java-5.1.34.jar
Ii. Establishment of Do table
User_info table, Id,name,password
Third, configuration Generator.xml
<?xml version= "1.0" encoding= "UTF-8"?>
<! DOCTYPE generatorconfiguration Public "-//mybatis.org//dtd mybatis Generator Configuration 1.0//en" "/http Mybatis.org/dtd/mybatis-generator-config_1_0.dtd ">
<generatorConfiguration>
<!--database Driver package Location--
<classpathentry location= "G:\tool\maven\generator\mysql-connector-java-5.1.34.jar"/>
<context id= "Db2tables" targetruntime= "MyBatis3" >
<commentGenerator>
<property name= "Suppressallcomments" value= "true"/>
</commentGenerator>
<!--database link URL, user name, password--
<jdbcconnection driverclass= "Com.mysql.jdbc.Driver" connectionurl= "Jdbc:mysql://localhost:3306/testdb" userId= "Root" password= "root" >
</jdbcConnection>
<javaTypeResolver>
<property name= "Forcebigdecimals" value= "false"/>
</javaTypeResolver>
<!--generate the package name and location of the model--
<javamodelgenerator targetpackage= "Com.yuanmeng.springdemo.model" targetproject= "G:\TOOL\MAVEN\GENERATOR\SRC" >
<property name= "Enablesubpackages" value= "true"/>
<property name= "Trimstrings" value= "true"/>
</javaModelGenerator>
<!--generated map file package name and location--
<sqlmapgenerator targetpackage= "com.yuanmeng.springdemo.mapping" targetproject= "G:\TOOL\MAVEN\GENERATOR\SRC" >
<property name= "Enablesubpackages" value= "true"/>
</sqlMapGenerator>
<!--generate DAO's package name and location--
<javaclientgenerator type= "Xmlmapper" targetpackage= "Com.yuanmeng.springdemo.dao" targetproject= "G:\tool\maven \generator\src ">
<property name= "Enablesubpackages" value= "true"/>
</javaClientGenerator>
<!--to generate those tables (you can change TableName and domainobjectname)--
<table tablename= "User_info" domainobjectname= "UserInfo" enablecountbyexample= "false" enableupdatebyexample= " False "enabledeletebyexample=" false "enableselectbyexample=" false "selectbyexamplequeryid=" false "/>
</context>
</generatorConfiguration>
Iv. Enter the G:\tool\maven\generator and execute the order Java-jar mybatis-generator-core-1.3.2.jar-configfile Generator.xml–overwrite You can generate code
Mybatis-generator-core automatic generation of Do, mapping, DAO Code