package edu.gzu.kyle;
import java.sql.*;
/**
* @author Administrator
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class OracleTest {
protected Connection conn = null;
protected Statement stmt = null;
private String url = "jdbc:oracle:thin:@JH1:1521:ORA92"; //连接字符串
private String usr = "scott"; //连接使用的用户和密码
private String pwd = "tiger";
public OracleTest(){
super();
}
public void dBConn(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url, usr, pwd);
stmt = conn.createStatement();
}catch(ClassNotFoundException e){
System.out.println("Class not foune");
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}
}
public ResultSet query(String sql) throws SQLException{
return stmt.executeQuery(sql);
}
public void dBEnds(){
try{
if(stmt != null){
stmt.close();
stmt = null;
}
}catch(SQLException e){
e.printStackTrace();
}
}
public static void main(String[] args) {
String sql = "select * from emp where job='MANAGER'";
OracleTest ot = new OracleTest() ;
try{
ot.dBConn();
ResultSet rs = ot.query(sql);
while (rs.next()) {
System.out.println(rs.getString(1));
}
rs.close();
}catch(SQLException e){
e.printStackTrace();
}finally{
ot.dBEnds();
}
}
}
import java.sql.*;
/**
* @author Administrator
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class OracleTest {
protected Connection conn = null;
protected Statement stmt = null;
private String url = "jdbc:oracle:thin:@JH1:1521:ORA92"; //连接字符串
private String usr = "scott"; //连接使用的用户和密码
private String pwd = "tiger";
public OracleTest(){
super();
}
public void dBConn(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url, usr, pwd);
stmt = conn.createStatement();
}catch(ClassNotFoundException e){
System.out.println("Class not foune");
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}
}
public ResultSet query(String sql) throws SQLException{
return stmt.executeQuery(sql);
}
public void dBEnds(){
try{
if(stmt != null){
stmt.close();
stmt = null;
}
}catch(SQLException e){
e.printStackTrace();
}
}
public static void main(String[] args) {
String sql = "select * from emp where job='MANAGER'";
OracleTest ot = new OracleTest() ;
try{
ot.dBConn();
ResultSet rs = ot.query(sql);
while (rs.next()) {
System.out.println(rs.getString(1));
}
rs.close();
}catch(SQLException e){
e.printStackTrace();
}finally{
ot.dBEnds();
}
}
}