java客户端程序集成mybatis操作数据库

最新推荐文章于 2024-12-03 14:31:45 发布

转载最新推荐文章于 2024-12-03 14:31:45 发布 · 173 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/u/2609444/blog/686468

文章标签：

#java #数据库 #python

本文介绍如何使用MyBatis Generator插件自动化生成Java实体类、Mapper接口及XML配置文件。通过具体步骤演示，包括配置generatorConfig.xml、创建mybatis.xml及编写测试类等，实现从数据库表到代码的快速生成。

2019独角兽企业重金招聘Python工程师标准>>>

1.打开eclipse，创建一个java project

2.创建lib文件夹，放入mybatis jar包和ojdbc jar包，并添加到buildpath

3.创建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">
  <commentGenerator>
   <property name="suppressDate" value="true" />
  </commentGenerator>
  <jdbcConnection driverClass="oracle.jdbc.OracleDriver"
   connectionURL="jdbc:oracle:thin:@127.0.0.1 :1521:orcl" userId="qmapp"
   password="654321" />
  <javaModelGenerator targetPackage="com.qm.fax.model"
   targetProject="CsMybatis/src">
   <property name="enableSubPackages" value="true" />
   <property name="trimStrings" value="true" />
  </javaModelGenerator>
  <sqlMapGenerator targetPackage="com.qm.fax.model.xml"
   targetProject="CsMybatis/src">
  </sqlMapGenerator>
  <javaClientGenerator type="XMLMAPPER"
   targetPackage="com.qm.fax.model" targetProject="CsMybatis/src">
   <property name="enableSubPackages" value="true" />
  </javaClientGenerator>
  <table tableName="BASIC_USER_ROLE" domainObjectName="UserRoleInfo" />
  <table tableName="BASIC_PERMISSION" domainObjectName="PermissionInfo" />
  <table tableName="APP_PRODUCTINFO" domainObjectName="ProductInfo" />
</context>
</generatorConfiguration>

4.右键点击generatorConfig.xml文件，选择生成模型（Generate Mybatis/iBATIS Artifacts）（此步需要已经安装mybatis generator插件）生成效果如下：

5.在src路径下创建mybatis.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="oracle.jdbc.OracleDriver" />
                <property name="url" value="jdbc:oracle:thin:@127.0.0.1 :1521:orcl" />
                <property name="username" value="qmapp" />
                <property name="password" value="654321" />
            </dataSource>
        </environment>
    </environments>

<mappers>
        <mapper resource="com/qm/fax/model/xml/UserRoleInfoMapper.xml" />
    </mappers>

</configuration>

6.创建测试类，编写main方法，代码如下：

package com.qm.fax.main.java;

import java.io.IOException;
import java.io.InputStream;

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 com.qm.fax.model.UserRoleInfo;
import com.qm.fax.model.UserRoleInfoMapper;

public class MainTest {

public static void main(String[ ] arg) throws IOException {
  SqlSessionFactory sessionFactory ;
  String resource = "mybatis.xml";
        InputStream in = Resources.getResourceAsStream(resource);
        sessionFactory = new SqlSessionFactoryBuilder().build(in);
  SqlSession session = null;
  session = sessionFactory.openSession();
  UserRoleInfoMapper mapper = session.getMapper(UserRoleInfoMapper.class);
  UserRoleInfo a = mapper.selectByPrimaryKey(1);
  if( a != null){
   System.out.println(a.getRoleid()+"\n");
   System.out.println(a.getUserid());
  }

}
}

7.运行效果：