很多小伙伴都对java连接oracle数据库的操作弄的稀里糊涂,今天我就贴出终极版,一举解决所有的连接方式,下篇主要是解决利用mybatis的方式。我是小順,请大家关注我,我会给大家发更多的工具。
JAR包:
User.java
package com.edu;
public class User {
private int id;
private String name;
private int age;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
@Override
public String toString() {
return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
}
}
Mapper.java
package com.edu;
import java.util.List;
public interface Mapper {
public List<User> selectUser();
}
mapper.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="com.edu.Mapper">
<select id="selectUser" resultType="com.edu.User">
select id,name,age from person;
</select>
</mapper>
OracelExec.java
SqlSession session = null;
try {
InputStream in = RedisUtil.class.getClassLoader().getResourceAsStream("mybatis.xml");
SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(in);
session = ssf.openSession();
Mapper m = session.getMapper(Mapper.class);
List<User> l = m.selectUser();
session.close();
System.out.println(l);
/**
*取回的数据存入了列表中,列表中是一个一个的对象
*剩下的问题就是操作取回的对象l 至少现在已经连接成功oracle数据库 并取回了数据
*/
} catch (Exception e) {
e.printStackTrace();
}