Java工程中使用Mybatis (工程结合Mybatis,数据结合Swing使用))
作者:书未来 时间:2023-05-27 11:52:38
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://www.cnblogs.com/symbol8888/archive/2017/04/21/6742513.html
标签:java,使用,mybatis
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
Spring Boot mybatis-config 和 log4j 输出sql 日志的方式
2021-05-31 22:13:20
![](https://img.aspxhome.com/file/2023/6/101756_0s.png)
Java 手写LRU缓存淘汰算法
2023-03-03 00:11:19
![](https://img.aspxhome.com/file/2023/0/64100_0s.jpg)
Spring注解驱动之BeanPostProcessor后置处理器讲解
2023-01-04 17:13:26
Java获取上月份最后一天日期8位的示例代码
2023-08-12 14:10:38
C#多线程之Thread类详解
2023-07-23 05:34:46
![](https://img.aspxhome.com/file/2023/1/100181_0s.png)
关于springBoot yml文件的list读取问题总结(亲测)
2023-11-04 12:37:08
![](https://img.aspxhome.com/file/2023/3/67443_0s.png)
java 算法之希尔排序详解及实现代码
2022-07-12 23:09:45
java开发之Jdbc分页源码详解
2021-10-28 16:06:48
浅谈java中异常抛出后代码是否会继续执行
2023-01-23 18:37:45
![](https://img.aspxhome.com/file/2023/7/119047_0s.jpg)
Android四大组件之BroadcastReceiver详解
2023-03-17 02:55:08
Java将Word文件转为OFD文件
2023-05-24 01:46:35
![](https://img.aspxhome.com/file/2023/7/72627_0s.jpg)
Java如果通过jdbc操作连接oracle数据库
2023-04-07 10:55:51
详解Spring cloud使用Ribbon进行Restful请求
2021-07-09 11:05:28
SpringBoot如何根据用户系统时区动态展示时间
2021-09-23 23:37:10
Springmvc返回html页面问题如何解决
2021-07-05 09:29:45
Android通过Movie展示Gif格式图片
2023-06-16 19:29:38
Android通过Socket与服务器之间进行通信的示例
2023-11-13 04:53:15
Java中Date和Calendar常用方法
2023-11-12 07:35:32
Java使用线程同步解决线程安全问题详解
2022-02-28 02:03:24
![](https://img.aspxhome.com/file/2023/9/78029_0s.png)
Java基础知识之StringWriter流的使用
2023-01-19 00:47:52