package com.xz.test;
import java.sql.*;
public class TestOracleCrud {
//此程序演示对oracle的curd操作
public static void main(String[] args) {
//定义我们需要的变量
//与特定数据库的连接(会话)
Connection ct = null;
//表示预编译的sql语句的对象
//把sql语句当作一个PreparedStatement对象
PreparedStatement ps = null;
//表示数据库结果集的数据表,通常通过执行查询数据库的语句生成 select
ResultSet rs = null;
try {
//1.加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//2.得到连接
ct = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orclxuzh","scott","tiger");
//3.创建PreparedStatement接口引用对象 emp后面不要加;
ps = ct.prepareStatement("select * from emp");
//4.完成查询
rs = ps.executeQuery();
while(rs.next()){
System.out.println(rs.getString("ename"));
}
} catch (Exception e) {
}
finally
{
//关闭资源还是老一套,后创建的,先关闭
if(rs != null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
rs = null;
}
if(ps != null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
ps = null;
}
if(ct != null){
try {
ct.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
import java.sql.*;
public class TestOracleCrud {
//此程序演示对oracle的curd操作
public static void main(String[] args) {
//定义我们需要的变量
//与特定数据库的连接(会话)
Connection ct = null;
//表示预编译的sql语句的对象
//把sql语句当作一个PreparedStatement对象
PreparedStatement ps = null;
//表示数据库结果集的数据表,通常通过执行查询数据库的语句生成 select
ResultSet rs = null;
try {
//1.加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//2.得到连接
ct = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orclxuzh","scott","tiger");
//3.创建PreparedStatement接口引用对象 emp后面不要加;
ps = ct.prepareStatement("select * from emp");
//4.完成查询
rs = ps.executeQuery();
while(rs.next()){
System.out.println(rs.getString("ename"));
}
} catch (Exception e) {
}
finally
{
//关闭资源还是老一套,后创建的,先关闭
if(rs != null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
rs = null;
}
if(ps != null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
ps = null;
}
if(ct != null){
try {
ct.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}