我们在用java连接数据库时可以抽象出一个父类,以便于代码的重用。
/** 数据库连接对象 */
protected Connection con = null;
/** 数据库预编译语句对象 */
protected PreparedStatement ps = null;
/** 数据库呼叫语句对象 */
protected CallableStatement call = null;
/** 结果集对象 */
protected ResultSet rs = null;
public void getConnection() throws ClassNotFoundException, SQLException {
Class.forName("oracle.jdbc.driver.OracleDriver");
this.con = DriverManager.getConnection(
"jdbc:oracle:thin:@127.0.0.1:1521:jg16", "scott", "tiger");
}
public void closeConnection() {
try {
if (rs != null)
rs.close();
if (call != null)
call.close();
if (ps != null)
ps.close();
if (con != null)
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
下面就是一个父类:
/** 数据库连接对象 */
protected Connection con = null;
/** 数据库预编译语句对象 */
protected PreparedStatement ps = null;
/** 数据库呼叫语句对象 */
protected CallableStatement call = null;
/** 结果集对象 */
protected ResultSet rs = null;
public void getConnection() throws ClassNotFoundException, SQLException {
Class.forName("oracle.jdbc.driver.OracleDriver");
this.con = DriverManager.getConnection(
"jdbc:oracle:thin:@127.0.0.1:1521:jg16", "scott", "tiger");
}
public void closeConnection() {
try {
if (rs != null)
rs.close();
if (call != null)
call.close();
if (ps != null)
ps.close();
if (con != null)
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}