MyBatis VII: Using the Generator tool

Source: Internet
Author: User

MyBatis can be understood as a semi-automated ORM Framework, through annotations or configuration XML mapping files to handwritten related SQL statements, and not as I introduced the ORM of the article as a whole object operation database additions and deletions. In fact, you will find that handwriting configuration XML mapping file is a very painful thing, because of this, MyBatis provides a generator tool, only need to configure the database connection string, the corresponding database driver package, and then execute the fixed-format command line statements can be done easily. Generator in: http://code.google.com/p/mybatis/wiki/Downloads?tm=2, need FQ download, here will provide generator file download at the end of the article.

First, generator file after decompression basic structure

  

1. src folder is the DAO, mapping, model file after the store is generated.

2, Generator.xml is the configuration file

3. Mybatis-generator-core-1.3.2.jar is a dependent jar package

4. The generated statement is a fixed-format command-line statement

Second, the configuration Generator.xml

The nodes that need to be modified are:

1, classpathentry database driver package location, physical absolute path

2, context\jdbcconnection database link URL, user name, password

3. Context\javamodelgenerator targetproject attribute, point to the SRC folder under Generator.xml folder, which represents the package name and location of the generated model

4, Context\sqlmapgenerator targetproject attribute, point to Generator.xml folder under the SRC folder, which represents the generated map file package name and location

5. Context\javaclientgenerator targetproject attribute, point to the SRC folder under Generator.xml folder, which represents the package name and location of the generated DAO

6, context\table TableName and Domainobjectname property, the name of the table name and the generated entity code of the database. Multiple tables on multiple context\table nodes

Sample files:

<?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= "D:\94_JavaWorkbench\0_MavenRepository\com\microsoft\sqlserver\sqljdbc4\4.0\sqljdbc4-4.0.jar" />    <ContextID= "Mybatis3generator"Targetruntime= "MyBatis3">        <Commentgenerator>            < Propertyname= "Suppressallcomments"value= "true" />        </Commentgenerator>        <!--database link URL, user name, password -        <jdbcconnectionDriverclass= "Com.microsoft.sqlserver.jdbc.SQLServerDriver"Connectionurl= "Jdbc:sqlserver://localhost:1433;databasename=northwind"userId= "sa"Password="">        </jdbcconnection>        <Javatyperesolver>            < Propertyname= "Forcebigdecimals"value= "false" />        </Javatyperesolver>        <!--Build the package name and location of the model -        <JavamodelgeneratorTargetpackage= "Northwind.model"Targetproject= "D:\94_JavaWorkbench\0_MyBatis_Generator\src">            < Propertyname= "Enablesubpackages"value= "true" />            < Propertyname= "Trimstrings"value= "true" />        </Javamodelgenerator>        <!--generated map file package name and location -        <SqlmapgeneratorTargetpackage= "Northwind.mapping"Targetproject= "D:\94_JavaWorkbench\0_MyBatis_Generator\src">            < Propertyname= "Enablesubpackages"value= "true" />        </Sqlmapgenerator>        <!--generate DAO's package name and location -        <Javaclientgeneratortype= "Xmlmapper"Targetpackage= "Northwind.dao"Targetproject= "D:\94_JavaWorkbench\0_MyBatis_Generator\src">            < Propertyname= "Enablesubpackages"value= "true" />        </Javaclientgenerator>        <!--to generate those tables (change tablename and Domainobjectname) -        <TableTableName= "Categories"Domainobjectname= "Categories"Enablecountbyexample= "false"Enableupdatebyexample= "false"Enabledeletebyexample= "false"Enableselectbyexample= "false"Selectbyexamplequeryid= "false" />        <TableTableName= "Customers"Domainobjectname= "Customers"Enablecountbyexample= "false"Enableupdatebyexample= "false"Enabledeletebyexample= "false"Enableselectbyexample= "false"Selectbyexamplequeryid= "false" />            </Context></generatorconfiguration>

  

Iii. Generating related documents

Under the current folder into DOS, two methods (D:\cd do not introduce), as follows

1. Path box input cmd

  

2. Under current folder, press Shift right mouse button to enter DOS

  

  

After the DOS window appears, enter the command: Java-jar mybatis-generator-core-1.3.2.jar-configfile generator.xml-overwrite

  

Four, in the SRC folder to view the generated files, can be copied into the project.

Attached Generator file Download: Http://files.cnblogs.com/files/wucj/Generator.rar

MyBatis VII: Using the Generator tool

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.