如何创建从SQL到Oracle的DBlink

Question

如题所述

Answer 1

public List<Emp> findAll() {
//创建连接
Connection conn =
DBUtil.getConnection();
//创建SQL
String sql = "select * from t_emp1";
try {
//创建PreparedStatement
PreparedStatement ps =
conn.prepareStatement(sql);
//执行SQL
ResultSet rs = ps.executeQuery();
//遍历结果集
List<Emp> list = new ArrayList<Emp>();
while(rs.next()) {
Emp emp = new Emp();
emp.setId(rs.getInt("id"));
emp.setName(rs.getString("name"));
emp.setSalary(rs.getDouble("salary"));
emp.setAge(rs.getInt("age"));
list.add(emp);
}
return list;
} catch (SQLException e) {
throw new RuntimeException(
"查询员工失败.", e);
} finally {
//关闭连接
DBUtil.close(conn);
}
}