Java工程中使用Mybatis (工程结合Mybatis,数据结合Swing使用）)

2019-11-26 12:31:20

字体：大中小

来源：转载

供稿：网友

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();      }    }}

上一篇：Spring AOP 自定义注解的实现代码

下一篇：Java微信公众平台开发（9）关键字回复以及客服接口实现