Java工程中使用Mybatis （工程结合Mybatis，数据可以结合Swing使用）

2011年6月iBatis 更名为 MyBatis，从 iBatis 到 MyBatis，不只是名称上的变化，MyBatis 提供了更为强大的功能，同时并没有损失其易用性，相反，在很多地方都借助于 JDK 的泛型和注解特性进行了简化。所以你懂的，开始学习就从MyBatis吧．

例子使用MyBatis+Oracle实现一个用户表的查询，如下：

①数据库 在MySQL中，test数据库下，简历user表，字段：iid，ifullname，ipassword，建表语句略。 

②需导入的包 只有两个： mybatis-3.4.4.jar 和 ojdbc14.jar（JDBC包） 

③目录结构 采用最简单的结构，com.mybatis包下有且仅有四个文件 configuration.xml user.xml User.java Test.java 

④mybatis配置文件configuration.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>    
    <typeAliases>    
        <typeAlias alias="User" type="com.mybatis.User"></typeAlias>    
    </typeAliases>    
        
    <environments default="development">    
        <environment id="development">    
            <transactionManager type="JDBC"></transactionManager>    
            <dataSource type="POOLED">    
                <property name="driver" value="oracle.jdbc.driver.OracleDriver" />    
                <property name="url" value="jdbc:oracle:thin:@192.168.0.87:1526:entegor" />    
                <property name="username" value="ideal" />    
                <property name="password" value="ideal" />    
            </dataSource>    
        </environment>    
    </environments>    
        
    <mappers>    
        <mapper resource="user.xml"/>    
    </mappers>    
    
</configuration>    

User表sql文件User.xml，

[xml] 

<?xml version="1.0" encoding="UTF-8"?>    
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">    
    
<mapper namespace="User">    
    <select id="selectUser" parameterType="int" resultType="User">    
        SELECT * FROM user WHERE id = #{id}    
    </select>    
        
    <select id="selectUsers" resultType="User">    
        SELECT * FROM user    
    </select>    
        
</mapper>  

表结构文件User.java

package com.mybatis;

public class User {
    private int iid;
    private String ifullname;
    private String iloginname;
    private String ipassword;
    public User(){}    
    public User(int id, String name) {    
        this.iid = id;    
        this.ifullname = name;    
    }    
    public String getIfullname() {
        return ifullname;
    }
    public int getIid() {
        return iid;
    }
    public void setIid(int iid) {
        this.iid = iid;
    }
    public void setIfullname(String ifullname) {
        this.ifullname = ifullname;
    }
    public String getIloginname() {
        return iloginname;
    }
    public void setIloginname(String iloginname) {
        this.iloginname = iloginname;
    }
    public String getIpassword() {
        return ipassword;
    }
    public void setIpassword(String ipassword) {
        this.ipassword = ipassword;
    }
    
}

⑦测试用例Test.java

package com.controller;

import java.io.IOException;
import java.io.Reader;
import java.util.List;

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.mybatis.User;

public class Test {

    public static void main(String[] args) throws IOException {
        // TODO Auto-generated method stub
        String resource = "configuration.xml";    
        Reader reader = Resources.getResourceAsReader(resource);    
        SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(reader);    
        SqlSession session = ssf.openSession();    
        try{    
            User user = session.selectOne("selectUser", 2);    
            System.out.println(user.getIfullname());    
            System.out.println(user);    
            System.out.println("--------------分隔线---------------");    
            
            List<User> users = session.selectList("selectUsers");    
            for(int i=0; i<users.size(); i++) {    
                System.out.println(users.get(i).getIfullname());    
            }    
                
        } catch (Exception e) {    
            e.printStackTrace();    
        } finally {    
            session.close();    
        }    
    }

}

 原文转自：http://blog.csdn.net/u011841085/article/details/18986261

从原文略做修改