import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcQuery {
public static void main(String[] args) {
ResultSet resul=null;
Statement state=null;
Connection conn=null;
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String dirver="oracle.jdbc.driver.OracleDriver";
String uname="scott";
String pwd="tiger";
//导入jar包
try {
//2加载驱动
Class.forName(dirver);
//3创建连接
conn= DriverManager.getConnection(url,uname,pwd);
conn.setAutoCommit(false);
//4创建命令发送器（执行sql语句）
state=conn.createStatement();
//5根据命令发送器执行sql语句并接受结果集
String str="SELECT * FROM EMP";
resul=state.executeQuery(str);
//6遍历结果
while(resul.next()){
System.out.println("empno:"+resul.getInt("empno")+"--ename:"+resul.getString("ename"));
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
catch (SQLException e) {
e.printStackTrace();
} finally{
//7关闭资源
if(resul!=null){
try {
resul.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(state!=null){
try {
state.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}sultSet resul=null;
Statement state=null;
Connection conn=null;
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String dirver="oracle.jdbc.driver.OracleDriver";
String uname="scott";
String pwd="tiger";
//导入jar包
try {
//2加载驱动
Class.forName(dirver);
//3创建连接
conn= DriverManager.getConnection(url,uname,pwd);
conn.setAutoCommit(false);
//4创建命令发送器（执行sql语句）
state=conn.createStatement();
//5根据命令发送器执行sql语句并接受结果集
String str="SELECT * FROM EMP";
resul=state.executeQuery(str);
//6遍历结果
while(resul.next()){
System.out.println("empno:"+resul.getInt("empno")+"--ename:"+resul.getString("ename"));
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
catch (SQLException e) {
e.printStackTrace();
} finally{
//7关闭资源
if(resul!=null){
try {
resul.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(state!=null){
try {
state.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
转载请注明原文地址: https://ju.6miu.com/read-26429.html
