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

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

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

3.创建generatorConfig.xml文件，位置如上图中所示，内容如下(文件中配置了数据库的三张表)：

connectionURL="jdbc:oracle:thin:@127.0.0.1 :1521:orcl" userId="qmapp"

password="654321" />

targetProject="CsMybatis/src">

targetProject="CsMybatis/src">

targetPackage="com.qm.fax.model" targetProject="CsMybatis/src">

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

5.在src路径下创建mybatis.xml文件，内容如下：

/p>

PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

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.运行效果：