图书网上销售基于JSP

package com.goldsoft.util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class DBManager { /** * get database connection * * @return * @throws SQLException */ public static Connection getConnection(){ Connection con = null; try { Class.forName("oracle.jdbc.OracleDriver");// "com.mysql.jdbc.Driver" con = DriverManager.getConnection( "jdbc:oracle:thin:@127.0.0.1:1521:ora", "decoration", "decoration"); // "jdbc:mysql://localhost/bookge","root","" // "jdbc:mysql://localhost:3306/bookge" // user=root&password=123456&useUnicode=true&characterEncoding=gb2312"; } catch (ClassNotFoundException e) { e.printStackTrace(); } catch(SQLException se){ se.printStackTrace(); } return con; } /** * @param args */ public static void main(String[] args) throws SQLException { // TODO Auto-generated method stub System.out.println("------conn--------" + getConnection()); } public static void clearup(PreparedStatement pstmt) { if (pstmt != null) { try { pstmt.close(); } catch (SQLException se) { se.printStackTrace(); } pstmt = null; } } /** * Close database resource. * * @param conn * @param pstmt */ public static void clearup(Connection conn, PreparedStatement pstmt) { if (pstmt != null) { try { pstmt.close(); } catch (SQLException se) { se.printStackTrace(); } pstmt = null; } if (conn != null) { try { conn.close(); } catch (SQLException se) { se.printStackTrace(); } conn = null; } } /** * Close databse resource. * * @param conn * @param pstmt * @param rs */ public static void clearup(Connection conn, PreparedStatement pstmt, ResultSet rs) { if (rs != null) { try { rs.close(); } catch (SQLException se) { se.printStackTrace(); } rs = null; } if (pstmt != null) { try { pstmt.close(); } catch (SQLException se) { se.printStackTrace(); } pstmt = null; } if (conn != null) { try { conn.close(); } catch (SQLException se) { se.printStackTrace(); } conn = null; } } /** * Close databse resource. * * @param pstmt * @param rs */ public static void clearup(PreparedStatement pstmt, ResultSet rs) { if (rs != null) { try { rs.close(); } catch (SQLException se) { se.printStackTrace(); } rs = null; } if (pstmt != null) { try { pstmt.close(); } catch (SQLException se) { se.printStackTrace(); } pstmt = null; } } }