- 将MyBatis Generator安装到eclipse中
安装成功后,新建一个web项目,右击src选择new再选择other中可以找到如图所示的内容
代表安装成功
- 配置环境
点击next
点击Finish后再src文件夹中会出现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 >
<context id="context1" >
<jdbcConnection driverClass="数据库驱动" connectionURL="连接字符串" userId="数据库用户名" password="数据库密码" />
<javaModelGenerator targetPackage="文件生成所在包名" targetProject="文件生成所在的项目名" />
<sqlMapGenerator targetPackage="文件生成所在包名" targetProject="文件生成所在的项目名" />
<javaClientGenerator targetPackage="文件生成所在包名" targetProject="文件生成所在的项目名" type="XMLMAPPER" />
<table schema="数据库名" tableName="数据库表名" >
<columnOverride column="数据库中字段名" property="属性名" />
</table>
</context>
</generatorConfiguration>
可以参考如下配置
<?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="e:\mysql-connector-java-5.1.24-bin.jar"/>
<context id="context1" >
<jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3305/booksale" userId="root" password="1" />
<javaModelGenerator targetPackage="sqlng" targetProject="asd" />
<sqlMapGenerator targetPackage="sqlng" targetProject="asd" />
<javaClientGenerator targetPackage="sqlng" targetProject="asd" type="XMLMAPPER" />
<table schema="booksale" tableName="user" >
<columnOverride column="username" property="username"></columnOverride>
<columnOverride column="password" property="password"></columnOverride>
</table>
</context>
</generatorConfiguration>
配置好后选中该文件,右击
点击即可配置成功,如果出现如下异常
是因为缺少mysql-connector-java-5.1.24-bin.jar文件
将文件拷到某盘路径下,之后在generatorConfig.xml文件中写如下代码,即可解决
之后再重试一次即可创建出如下文件
报错是因为缺少相对应的jar包
将mybatis对应的jar包放入lib文件夹中,即可解决
新建一个mybatis-config.xml的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" />
<dataSource type="POOLED">
<property name="driver" value="数据库驱动" />
<property name="url" value="连接字符串" />
<property name="username" value="数据库用户名" />
<property name="password" value="数据库密码" />
</dataSource>
</environment>
</environments>
<mappers>
这里的内容与下图对应
<mapper resource="sqlmapping/SignonMapper.xml" />
</mappers>
</configuration>
Mybatis环境就配置完成了
3.进行测试
public class Test {
public static void main(String[] args) throws IOException {
Signon signon=new Signon();
signon.setUsername("123321");
signon.setPassword("1111");
String configFile="mybatis-config.xml";
InputStream configStream =Resources.getResourceAsStream(configFile);
SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder();
SqlSessionFactory factory=builder.build(configStream);
SqlSession session=factory.openSession();
session.insert("insert",signon);
session.commit();
session.close();
}
}
以上完成了Mybatis环境的基本搭建