Please Reference:
import java.sql.*;public class ConnOraBean {
String driverName = "oracle.jdbc.driver.OracleDriver";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String connURL= "jdbc:oracle:thin:@localhost:1521:ORCL";
String UserID = "tomcat";
String Password = "tomcat"; public ConnOraBean() {
try {
Class.forName(driverName);
}
catch (java.lang.ClassNotFoundException e)
{
System.err.println("netzero(String):" + e.getMessage());
}
} public ResultSet executeQuery(String sql) {
try {
conn = DriverManager.getConnection(connURL, UserID, Password);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery:" + ex.getMessage());
}
return rs;
} public ResultSet executeUpdate(String sql) {
try {
conn = DriverManager.getConnection(connURL, UserID, Password);
stmt=conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.executeQuery:" + ex.getMessage());
}
return rs;
} public boolean closeConn() {
try {
if (rs!=null) rs.close();
if (stmt!=null) stmt.close();
if (conn!=null) conn.close();
return true;
}
catch ( SQLException ex )
{
System.err.println("closeConn:" + ex.getMessage());
return false;
}
}
public static void main(String args[]) {
new ConnOraBean();
}
}
import java.sql.*;public class ConnOraBean {
String driverName = "oracle.jdbc.driver.OracleDriver";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String connURL= "jdbc:oracle:thin:@localhost:1521:ORCL";
String UserID = "tomcat";
String Password = "tomcat"; public ConnOraBean() {
try {
Class.forName(driverName);
}
catch (java.lang.ClassNotFoundException e)
{
System.err.println("netzero(String):" + e.getMessage());
}
} public ResultSet executeQuery(String sql) {
try {
conn = DriverManager.getConnection(connURL, UserID, Password);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery:" + ex.getMessage());
}
return rs;
} public ResultSet executeUpdate(String sql) {
try {
conn = DriverManager.getConnection(connURL, UserID, Password);
stmt=conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.executeQuery:" + ex.getMessage());
}
return rs;
} public boolean closeConn() {
try {
if (rs!=null) rs.close();
if (stmt!=null) stmt.close();
if (conn!=null) conn.close();
return true;
}
catch ( SQLException ex )
{
System.err.println("closeConn:" + ex.getMessage());
return false;
}
}
public static void main(String args[]) {
new ConnOraBean();
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货