ssm = spring + spring mvc + mybatis整合开发
mybatis是一种半自动化ORM框架。
利用mybatis generator可以方便的生成 实体类 DAO接口和 mapping映射文件.
准备工作:
https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core
下载mybatis-generator-core-1.3.5.jar
https://mvnrepository.com/artifact/org.mybatis/mybatis
下载mybatis-3.4.1.jar
https://mvnrepository.com/artifact/mysql/mysql-connector-java
下载mysql-connector-java-5.1.39.jar(5.1.x系列)
ubuntu进入mysql控制台,创建数据库和表
create database mybatis;
use mybatis;
create table user_t (id int(11) not null auto_increment primary key,username varchar(40) not null,password varchar(30) not null,age int(4));
将mybatis-generator-core-1.3.5.jar, mybatis-3.4.1.jar和mysql-connector-java-5.1.39.jar放到同一个目录下,并且在这个目录下新建一个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>
<!-- 数据库驱动-->
<classPathEntry location="mysql-connector-java-5.1.39.jar"/>
<context id="DB2Tables" targetRuntime="MyBatis3">
<commentGenerator>
<property name="suppressDate" value="true"/>
<!-- 是否去除自动生成的注释 true:是 : false:否 -->
<property name="suppressAllComments" value="true"/>
</commentGenerator>
<!--数据库链接URL,用户名、密码 -->
<jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://192.168.31.33/mybatis?useSSL=false" userId="root" password="xxxxxxxx">
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false"/>
</javaTypeResolver>
<!-- 生成模型的包名和位置-->
<javaModelGenerator targetPackage="com.ssm.beans" targetProject="src">
<property name="enableSubPackages" value="true"/>
<property name="trimStrings" value="true"/>
</javaModelGenerator>
<!-- 生成映射文件的包名和位置-->
<sqlMapGenerator targetPackage="com.ssm.mapping" targetProject="src">
<property name="enableSubPackages" value="true"/>
</sqlMapGenerator>
<!-- 生成DAO的包名和位置-->
<javaClientGenerator type="XMLMAPPER" targetPackage="com.ssm.iDAO" targetProject="src">
<property name="enableSubPackages" value="true"/>
</javaClientGenerator>
<!-- 要生成的表 tableName是数据库中的表名或视图名 domainObjectName是实体类名-->
<table tableName="user_t" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
</context>
</generatorConfiguration>
如果没有添加红色字useSSL,如果mysql是高版本,例如5.7.11,mysql要求默认使用useSSL连接,如果不指定,会弹出警告:
Sun Oct 09 11:03:18 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
所有再连接属性里显式的指明不使用ssl连接。
在jar包同一目录下新建src文件夹,用来存放生成的java文件
windows命令行下运行指令:
java -jar mybatis-generator-core-1.3.5.jar -configfile generatorConfig.xml -overwrite
如果没提示出错,就会在src目录下,按照包名结构生成所有需要的java文件。