import java.sql.*;
public class JDBC {
private final String dbDriver = "oracle.jdbc.driver.OracleDriver";
private final String url = "jdbc:oracle:thin:@computer-name:1521:TAMRO";
private final String userName = "sys as sysdba";
private final String password = "password";
private Connection con = null;
public JDBC() {
try {
Class.forName(dbDriver).newInstance();
} catch (Exception ex) {
System.out.println("couldn't find driver");
}
}
public boolean creatConnection() {
try {
con = DriverManager.getConnection(url, userName, password);
con.setAutoCommit(true);
} catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("creatConnectionError!");
return false ;
}
return true;
}
public void closeConnection() {
if (con != null) {
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
System.out.println("Failed to close connection!");
} finally {
con = null;
}
}
}
public static void main(String[] args) {
JDBC jdbc = new JDBC();
boolean createConnection = jdbc.creatConnection();
System.out.println(createConnection);
}
public boolean executeUpdate(String sql) {
if (con == null) {
creatConnection();
}
try {
Statement stmt = con.createStatement();
int iCount = stmt.executeUpdate(sql);
System.out.println("update" + String.valueOf(iCount));
return true;
} catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("executeUpdaterError!");
return false;
}
}
public ResultSet executeQuery(String sql) {
ResultSet rs;
try {
if (con == null) {
creatConnection();
}
Statement stmt = con.createStatement();
try {
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
System.out.println(e.getMessage());
return null;
}
} catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("executeQueryError!");
return null;
}
return rs;
}
}
注意:
在代码中包含以下两句。
private final String dbDriver = "oracle.jdbc.driver.OracleDriver";
Class.forName(dbDriver).newInstance();
我们要在项目中添加外部JAR(在Oracle的安装目录下, G:/oracle/product/10.2.0/db_1/jdbc/lib/classesXX.jar).