packagecom.jackie.MyBatis.dao;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjavax.naming.Context;importjavax.naming.InitialContext;importjavax.naming.NamingException;importjavax.sql.DataSource;public classBaseDao {/*** 查找JNDI,获得数据源对象,再获得数据库连接对象*/
privateConnection getConnection() {
Connection conn= null;
Context ctx= null;try{
ctx= newInitialContext();
DataSource ds= (DataSource) ctx.lookup("java:comp/env/jdbc/mysql");
conn=ds.getConnection();
}catch (NamingException |SQLException e) {
e.printStackTrace();
}if(conn == null) {
System.err.println("无法建立数据库连接");
}returnconn;
}privatevoidcloseAll(Connection conn, Statement stmt, ResultSet rs) {try{if(rs != null & !rs.isClosed()) {
rs.close();
}if(stmt != null & !stmt.isClosed()) {
stmt.close();
}if(conn != null & !conn.isClosed()) {
conn.close();
}
}catch(SQLException e) {
e.printStackTrace();
}
}privatevoidcloseAll(Connection conn, Statement stmt) {
closeAll(conn, stmt,null);
}public intexecuteUpdate(String sql, Object... params) {int result = 0;
Connection conn= null;
PreparedStatement pstmt= null;try{
conn=getConnection();if(conn != null && !conn.isClosed()) {
pstmt=conn.prepareStatement(sql);if(params != null) {for (int i = 0; i < params.length; i++) {
pstmt.setObject(i+ 1, params[i]);
}
}
result=pstmt.executeUpdate();
}
}catch(SQLException e) {
e.printStackTrace();
}finally{
closeAll(conn, pstmt);
}returnresult;
}publicObject executeQuery(RSProcessor processor, String sql, Object... params ) {
Object result= null;
Connection conn= null;
PreparedStatement pstmt= null;
ResultSet rs= null;try{
conn=getConnection();if(conn != null && !conn.isClosed()) {
pstmt=conn.prepareStatement(sql);for (int i = 0; i < params.length; i++) {
pstmt.setObject(i+ 1, params[i]);
}
rs=pstmt.executeQuery();
result=processor.process(rs);
}
}catch(SQLException e) {
e.printStackTrace();
}finally{
closeAll(conn, pstmt, rs);
}returnresult;
}
}