maven+mybatis+mysql+mybatis Generator简单学习

来源：互联网发布：杨贵妃山口百惠知乎编辑：程序博客网时间：2024/04/30 14:31

1、项目路径如下

2、pom配置如下

<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>myBatisTest</groupId>  <artifactId>myBatisTest</artifactId>  <packaging>war</packaging>  <version>0.0.1-SNAPSHOT</version>  <name>Maven Webapp Archetype</name>  <url>http://maven.apache.org</url>  <dependencies>    <dependency>      <groupId>junit</groupId>      <artifactId>junit</artifactId>      <version>3.8.1</version>      <scope>test</scope>    </dependency>    <dependency>     <groupId>org.mybatis</groupId>     <artifactId>mybatis</artifactId>     <version>3.2.6</version>    </dependency>    <dependency>     <groupId>mysql</groupId>     <artifactId>mysql-connector-java</artifactId>     <version>5.1.29</version>    </dependency>      </dependencies>  <build>    <finalName>myBatisTest</finalName>  </build></project>

3、mybatis-config.xml配置如下

<?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><environments default="development"><environment id="development"><transactionManager type="JDBC"></transactionManager><dataSource type="POOLED"><property name="driver" value="com.mysql.jdbc.Driver" /><property name="url"value="jdbc:mysql://localhost:3306/testmybatis?characterEncoding=utf-8" /><property name="username" value="root" /><property name="password" value="root" /></dataSource></environment></environments></configuration>

4、安装使用mybatis generator 工具

下载工具，地址http://pan.baidu.com/s/1c0cjDEK

解压到eclipse安装目录，重启eclise即可

1、使用mybatis generator工具

项目右键 new ，选择other ，选择如下图

选择next

选择finish，就生成了generatorConfig.xml文件

修改generatorConfig.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><!-- 驱动绝对位置 --><classPathEntrylocation="C:/Users/lei/.m2/repository/mysql/mysql-connector-java/5.1.29/mysql-connector-java-5.1.29.jar" /><context id="myBatisTest"><!-- mysql配置 --><jdbcConnection driverClass="com.mysql.jdbc.Driver"connectionURL="jdbc:mysql://localhost:3306/testmybatis?characterEncoding=utf-8"userId="root" password="root" /><!-- 实体存放位置 --><javaModelGenerator targetPackage="com.model"targetProject="myBatisTest" /><!-- mapper文件存放位置 --><sqlMapGenerator targetPackage="com.model"targetProject="myBatisTest" /><javaClientGenerator targetPackage="com.model"targetProject="myBatisTest" type="XMLMAPPER" /><!-- 表名 --><table schema="dbo" tableName="userinfo"></table></context></generatorConfiguration>

在generatorConfig.xml文件上右击选择 artifacts选项，然后就会生成对应的实体及其mapper文件

0 0