环境搭建:本地
1.建立maven项目
jar包和war包的区别
jar包 普通web项目
war包 动态web项目
建立好之后会有报错,不要着急
右键选中javaEE(没有的话切换javaEE视图)
切换javaEE视图
pom.xml 代码
<?xml version="1.0"?>
-<project xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://maven.apache.org/POM/4.0.0">
<modelVersion>4.0.0</modelVersion>
<groupId>com.briup</groupId>
<artifactId>baoshi4_estore</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>war</packaging>
<!-- jar的版本 -->
-<properties>
<junit.version>4.12</junit.version>
<mybatis.version>3.2.8</mybatis.version>
<mysql.version>5.1.47</mysql.version>
<log4j.version>1.2.16</log4j.version>
<jstl.version>1.2</jstl.version>
<servlet-api.version>2.5</servlet-api.version>
<jsp-api.version>2.0</jsp-api.version>
<commons-lang3.version>3.3.2</commons-lang3.version>
<commons-io.version>1.3.2</commons-io.version>
<pagehelper.version>5.1.10</pagehelper.version>
</properties>
-<dependencies>
<!-- appach组件 start -->
-<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-lang3</artifactId>
<version>${commons-lang3.version}</version>
</dependency>
-<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-io</artifactId>
<version>${commons-io.version}</version>
</dependency>
<!-- appach组件 end -->
<!-- junit start -->
-<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>${junit.version}</version>
<scope>test</scope>
</dependency>
<!-- junit start -->
<!-- log4j start -->
-<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>${log4j.version}</version>
</dependency>
<!-- log4j end -->
<!-- mybatis start -->
-<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<!-- mybatis 分页插件 -->
-<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>${pagehelper.version}</version>
</dependency>
<!-- mybatis end -->
<!-- 数据库 start -->
<!-- mysql -->
-<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.version}</version>
</dependency>
<!-- jsp 组件 start -->
-<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>${jstl.version}</version>
</dependency>
-<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jsp-api</artifactId>
<version>${jsp-api.version}</version>
<scope>provided</scope>
</dependency>
<!-- jsp 组件 end -->
<!-- 导入支付宝的依赖 -->
-<dependency>
<groupId>com.alipay.sdk</groupId>
<artifactId>alipay-sdk-java</artifactId>
<version>4.8.10.ALL</version>
</dependency>
</dependencies>
-<build>
<!-- mvn mybatis-generator:generate -->
<finalName>baoshi4_estore</finalName>
-<plugins>
-<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.5</version>
-<configuration>
<!-- 配置文件 -->
<configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
<!-- 允许移动和修改 -->
<verbose>true</verbose>
<overwrite>true</overwrite>
</configuration>
-<dependencies>
<!-- jdbc 依赖 -->
-<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
-<dependency>
<groupId>com.itfsw</groupId>
<artifactId>mybatis-generator-plugin</artifactId>
<version>1.0.11</version>
</dependency>
</dependencies>
</plugin>
-<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-resources-plugin</artifactId>
<version>2.7</version>
-<configuration>
<encoding>UTF-8</encoding>
</configuration>
</plugin>
<!-- java编译插件 必须配插件,否则默认的是jdk1.5插件 -->
-<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.2</version>
-<configuration>
<source>1.8</source>
<target>1.8</target>
<encoding>UTF-8</encoding>
</configuration>
</plugin>
</plugins>
</build>
</project>
解释一下:
properties定义了jar包的版本
dependencies定义所有版本的依赖
bulid 构建
plugins 插件
mybatis的逆向生成工具
引入两个依赖,确定插件的版本
编译插件
Mybatis Generator官网
generatorConfig.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration SYSTEM "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN">
<!-- mybatis-generator的核心配置文件 -->
-<generatorConfiguration>
<classPathEntry location="D:/repository1/repository/mysql/mysql-connector-java/5.1.47/mysql-connector-java-5.1.47.jar"/>
-<context targetRuntime="MyBatis3" id="DB2Tables">
<plugin type="org.mybatis.generator.plugins.SerializablePlugin"/>
<plugin type="org.mybatis.generator.plugins.ToStringPlugin"/>
-<commentGenerator>
<property value="true" name="suppressDate"/>
<property value="true" name="suppressAllComments"/>
</commentGenerator>
<!-- 注意!如果要重新生成pojo类,务必改成项目组数据库,用户名密码 -->
<jdbcConnection password="root" userId="root" connectionURL="jdbc:mysql://101.200.231.16:3306/estore" driverClass="com.mysql.jdbc.Driver"> </jdbcConnection>
<!--指定生成的类型为java类型,避免数据库中number等类型字段 -->
-<javaTypeResolver>
<property value="false" name="forceBigDecimals"/>
</javaTypeResolver>
<!--自动生成的实体的存放包路径 -->
-<javaModelGenerator targetProject="./src/main/java" targetPackage="com.briup.estore.bean">
<property value="true" name="enableSubPackages"/>
<property value="true" name="trimStrings"/>
</javaModelGenerator>
<!--自动生成的*Mapper.xml文件存放路径 -->
-<sqlMapGenerator targetProject="./src/main/java" targetPackage="com.briup.estore.mapper">
<property value="true" name="enableSubPackages"/>
</sqlMapGenerator>
<!--自动生成的*Mapper.java存放路径 -->
-<javaClientGenerator type="XMLMAPPER" targetProject="./src/main/java" targetPackage="com.briup.estore.mapper">
<property value="true" name="enableSubPackages"/>
</javaClientGenerator>
<!-- 映射配置 -->
<table domainObjectName="Customer" tableName="es_customer"/>
<table domainObjectName="Book" tableName="es_book"/>
<table domainObjectName="Category" tableName="es_category"/>
<table domainObjectName="OrderForm" tableName="es_orderform"/>
<table domainObjectName="OrderLine" tableName="es_orderline"/>
<table domainObjectName="ShopAddress" tableName="es_shopaddress"/>
</context>
</generatorConfiguration>