java 的 basedao,Java BaseDao

packagedao;import java.sql.*;public classBaseDao {private static final String driver = "oracle.jdbc.driver.OracleDriver";private static final String url = "jdbc:oracle:thin:@localhost:1521:ACCP";private static final String uid = "scott";private static final String pwd = "scott";private staticConnection con;private staticPreparedStatement pstmt;/*** 建立连接对象

*@return

*/

public staticConnection getConnection() {try{

Class.forName(driver);

con=DriverManager.getConnection(url, uid, pwd);returncon;

}catch(ClassNotFoundException e) {

e.printStackTrace();

}catch(SQLException e) {

e.printStackTrace();

}return null;

}/*** 关闭对象

*@paramrs 数据集对象*/

public static voidClose(ResultSet rs) {if (rs != null) {try{

rs.close();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}

}if (pstmt != null) {try{

pstmt.close();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}

}if (con != null) {try{

con.close();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}

}

}/*** 执行查询操作

*@paramsql 查询的sql语句

*@paramparas 查询的参数 Object[]数组

*@return结果集*/

public staticResultSet ExecuteQuery(String sql, Object[] paras) {

getConnection();try{

pstmt=con.prepareStatement(sql);if (paras != null && paras.length > 0) {for (int i = 0; i < paras.length; i++) {

pstmt.setObject(i+ 1, paras[i]);

}

}

ResultSet rs=pstmt.executeQuery();returnrs;

}catch(SQLException e) {

e.printStackTrace();return null;

}

}/*** 执行增加、修改、删除操作

*@paramsql 操作的sql语句

*@paramparas 操作的参数

*@return受影响的行数*/

public static intExecuteUpdate(String sql, Object[] paras) {

getConnection();try{

pstmt=con.prepareStatement(sql);if (paras != null && paras.length > 0) {for (int i = 0; i < paras.length; i++) {

pstmt.setObject(i+ 1, paras[i]);

}

}int rs =pstmt.executeUpdate();returnrs;

}catch(SQLException e) {

e.printStackTrace();return -1;

}

}

}