IDEA+maven+mybatis+generator笔记

1.pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">    <modelVersion>4.0.0</modelVersion>    <groupId>com.lyj</groupId>    <artifactId>MybatisTest1</artifactId>    <packaging>war</packaging>    <version>1.0-SNAPSHOT</version>    <name>MybatisTest1</name>    <url>http://maven.apache.org</url>    <dependencies>        <dependency>            <groupId>junit</groupId>            <artifactId>junit</artifactId>            <version>4.12</version>            <scope>test</scope>        </dependency>        <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>            <version>5.1.39</version>        </dependency>        <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis</artifactId>            <version>3.4.1</version>        </dependency>    </dependencies>    <build>        <!--添加mybatis-generator-maven-plugin 插件-->        <plugins>            <plugin>                <groupId>org.mybatis.generator</groupId>                <artifactId>mybatis-generator-maven-plugin</artifactId>                <version>1.3.5</version>                <configuration>                    <verbose>true</verbose>                    <overwrite>true</overwrite>                </configuration>            </plugin>        </plugins>        <!--下面这个resouces为了生成的*mapper.xml文件在java/src/com.*文件夹中能够访问到  但是必须要在generator运行完之后在添加，否则运行generator的时候会报错db.properties找不到-->        <resources>              <resource>                  <directory>src/main/java</directory>                  <includes>                      <include>**/*.xml</include>                  </includes>              </resource>          </resources>          <finalName>MybatisTest1</finalName>    </build></project>

2.编写generatorConfig.xml 自动生成mybatis映射文件的配置文件

<?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>    <properties resource="db.properties"/>    <!--mysql 连接数据库jar 这里选择自己本地位置-->    <classPathEntry location="${jdbc.driverLocation}" />    <context id="default" targetRuntime="MyBatis3">        <commentGenerator>            <!-- 是否去除自动生成的注释 true：是 ： false:否 -->            <property name="suppressAllComments" value="true" />        </commentGenerator>        <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->        <jdbcConnection driverClass="${jdbc.driverClass}"                        connectionURL="${jdbc.jdbcUrl}" userId="${jdbc.user}"                        password="${jdbc.password}">        </jdbcConnection>        <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和           NUMERIC 类型解析为java.math.BigDecimal -->        <javaTypeResolver>            <property name="forceBigDecimals" value="false" />        </javaTypeResolver>        <!-- targetProject:生成PO类的位置 -->        <javaModelGenerator targetPackage="${jdbc.pojoLocation}"                            targetProject="src/main/java">            <!-- enableSubPackages:是否让schema作为包的后缀 -->            <property name="enableSubPackages" value="false" />            <!-- 从数据库返回的值被清理前后的空格 -->            <property name="trimStrings" value="true" />        </javaModelGenerator>        <!-- targetProject:mapper映射文件生成的位置           如果maven工程只是单独的一个工程，targetProject="src/main/java"           若果maven工程是分模块的工程，targetProject="所属模块的名称"，例如：           targetProject="ecps-manager-mapper"，下同-->        <sqlMapGenerator targetPackage="${jdbc.mapperLocation}"                         targetProject="src/main/java">            <!-- enableSubPackages:是否让schema作为包的后缀 -->            <property name="enableSubPackages" value="false" />        </sqlMapGenerator>        <!-- targetPackage：mapper接口生成的位置 -->        <javaClientGenerator type="XMLMAPPER"                             targetPackage="${jdbc.mapperLocation}"                             targetProject="src/main/java">            <!-- enableSubPackages:是否让schema作为包的后缀 -->            <property name="enableSubPackages" value="false" />        </javaClientGenerator>        <!-- 指定数据库表 -->        <!--根据需要自行改动数据表-->        <table schema="" tableName="user"></table>    </context></generatorConfiguration>

3.db.properties

jdbc.driverClass=com.mysql.jdbc.Driverjdbc.jdbcUrl=jdbc:mysql:///sssptest?useUnicode=true&characterEncoding=UTF-8jdbc.user=lyjjdbc.password=123jdbc.driverLocation=E:/JAVA/maven/mysql/mysql-connector-java/5.1.39/mysql-connector-java-5.1.39.jarjdbc.pojoLocation=com.lyj.pojojdbc.mapperLocation=com.lyj.mapper

4.运行mybatis-generator-maven-plugin

5.mybatisConfig.xml配置mybatis文件

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>    <properties resource="db.properties"/>    <!--pojo类配置-->    <typeAliases>         <typeAlias alias="User" type="com.lyj.pojo.User"/>    </typeAliases>    <environments default="development">        <environment id="development">            <transactionManager type="JDBC"/>            <dataSource type="POOLED">                <property name="driver" value="${jdbc.driverClass}"/>                <property name="url" value="${jdbc.jdbcUrl}" />                <property name="username" value="${jdbc.user}"/>                <property name="password" value="${jdbc.password}"/>            </dataSource>        </environment>    </environments>    <!--mapper映射文件配置-->    <mappers>        <mapper resource="com/lyj/mapper/UserMapper.xml"/>    </mappers></configuration>

6.测试

package com.lyj.handler;import com.lyj.mapper.UserMapper;import com.lyj.pojo.User;import com.lyj.pojo.UserExample;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import java.io.Reader;/** * Created by LYJ on 2016/9/29. */public class Test {    public static void main(String... args) throws Exception {        Reader reader = Resources.getResourceAsReader("mybatisConfig.xml");        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);        SqlSession sqlSession = sqlSessionFactory.openSession();        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);        User user = userMapper.selectByPrimaryKey(1);        if (user != null)            System.out.println(user + "      --------- user    --- Test.main\n");        System.out.println(  "      ---------     --- Test.main\n");        UserExample example=new UserExample();        UserExample.Criteria c= example.createCriteria().andIdEqualTo(1);        User uu=new User();        uu.setId(1);        uu.setUserName("QQ");        //example相当于where后面的限制语句        //下面这句相当于sql:update user set id=1,name='QQ',password='',thirdId='' where id=1        userMapper.updateByExample(uu,example);        sqlSession.commit();        sqlSession.close();    }}