JSP图书管理系统源代码终结版mysql+tomcat+myeclipse

package bookstore.model; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import java.util.Date; import javax.naming.Context; import javax.naming.InitialContext; import javax.sql.DataSource; import org.apache.log4j.Logger; public class DBAccess{ private Connection conn; private Statement stmt; //private ResultSet rs=null; private static String sourceName = null; // private boolean isPool = true; private boolean isPool = false; private boolean autoCommit = true; private String[] jdbcParameters; static Logger logger = Logger.getRootLogger(); //static Logger log = logger.getLogger("dbaccess"); public static Connection getConn() { Connection conn = null; try { Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bookstore?user=root&password=12345&useUnicode=true&characterEncoding=gbk"); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return conn; } public static PreparedStatement prepare(Connection conn, String sql) { PreparedStatement pstmt = null; try { if(conn != null) { pstmt = conn.prepareStatement(sql); } } catch (SQLException e) { e.printStackTrace(); } return pstmt; } public DBAccess() { } public static Statement getStatement(Connection conn) { Statement stmt = null; try { if(conn != null) { stmt = conn.createStatement(); } } catch (SQLException e) { e.printStackTrace(); } return stmt; } public static void executeUpdate(Statement stmt, String sql) { try { if(stmt != null) { stmt.executeUpdate(sql); } } catch (SQLException e) { e.printStackTrace(); } } public static void close(Statement stmt) { try { if(stmt != null) { stmt.close(); stmt = null; } } catch (SQLException e) { e.printStackTrace(); } } public static void close(Connection conn) { try { if(conn != null) { conn.close(); conn = null; } } catch (SQLException e) { e.printStackTrace(); } } /*public static ResultSet getResultSet(Connection conn, String sql) { Statement stmt = getStatement(conn); ResultSet rs = getResultSet(stmt, sql); close(stmt); return rs; } */ public static ResultSet getResultSet(Statement stmt, String sql) { ResultSet rs = null; try { if(stmt != null) { rs = stmt.executeQuery(sql); } } catch (SQLException e) { e.printStackTrace(); } return rs; } public DBAccess(boolean isPool) { this.isPool = isPool; } public void setJdbcParameters(String jdbcClass, String url, String user, String pass) { jdbcParameters = new String[4]; if (jdbcClass == null) jdbcClass = "com.mysql.jdbc.Driver"; jdbcParameters[0] = jdbcClass; jdbcParameters[1] = url; jdbcParameters[2] = user; jdbcParameters[3] = pass; } /* public Connection getConn() { if (conn == null) getConnection(); return conn; } */ public void closeConn() { try{ if (conn != null){ stmt.close(); conn.close(); //if(rs != null) // rs.close(); stmt = null; conn = null; System.out.println("----"); } }catch (SQLException e){ showErrorMessage(e); } } public ResultSet query(String strSql) { System.out.println("sql:" + strSql); ResultSet rs = null; try { if (conn == null){ getConnection(); } rs = stmt.executeQuery(strSql); System.out.println("in DBAccess.query(),return"); return rs; } catch (SQLException ex) { System.out.println(ex.getMessage()); return null; } } @SuppressWarnings("finally") public String[][] Query(String sql) { String[][] strData = null; try{ if (conn == null){ getConnection(); } ResultSet rest = stmt.executeQuery(sql); ResultSetMetaData rsmd = rest.getMetaData(); int columncount = rsmd.getColumnCount(); if (rest.next()){ rest.last(); int rowcount = rest.getRow(); int i = 0; rest.first(); strData = new String[rowcount][columncount]; do{ for (int j = 0; j < columncount; j++){ strData[i][j] = rest.getString(j + 1); } i++; }while(rest.next()); } rest.close(); }catch (SQLException e){ showErrorMessage(e); } finally{ return strData; } } @SuppressWarnings("finally") public String[] QueryRowData(String sql) { String[] strData = null; try{ if (conn == null){ getConnection(); } ResultSet rest = stmt.executeQuery(sql); ResultSetMetaData rsmd = rest.getMetaData(); int columncount = rsmd.getColumnCount(); if (rest.next()){ strData = new String[columncount]; for (int i = 0; i < columncount; i++){ strData[i] = rest.getString(i + 1); } } rest.close(); }catch (SQLException e){ showErrorMessage(e); } finally{ return strData; } } public boolean insert(String sql) { // TODO Implement this org.book.model.DBAccess Interface method boolean breturn = false; try{ if (conn == null || stmt == null){ getConnection(); } //log.debug("sql=" + sql); stmt.execute(sql); breturn = true; }catch (SQLException e){ showErrorMessage(e); } finally{ return breturn; } } public boolean insert(String[] sqls) { // TODO Implement this org.book.model.DBAccess Interface method boolean breturn = false; try{ if (conn == null || stmt == null){ getConnection(); } conn.setAutoCommit(false); for (int i = 0; i < sqls.length; i++){ if (sqls[i] != null) stmt.addBatch(sqls[i]); } stmt.executeBatch(); conn.commit(); conn.setAutoCommit(autoCommit); breturn = true; }catch (SQLException e){ showErrorMessage(e); }finally{ return breturn; } } public int update(String sql) { // TODO Auto-generated method stub int ireturn = -1; if (conn == null || stmt == null){ getConnection(); } try{ ireturn = stmt.executeUpdate(sql); }catch (SQLException e){ showErrorMessage(e); }finally{ return ireturn; } } public boolean update(String[] sqls) { // TODO Auto-genera