可二次开发MYSQLbishe014_jspjava源码.zip

package com.bean; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DB { public static Connection getConn() { Connection conn = null; try { //Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=lib", "sa", "4682137"); //conn = DriverManager.getConnection("jdbc:microsoft:sqlsever:localhost://1433;DatabaseName=lib", "sa", "4682137"); try { Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch (InstantiationException e) {e.printStackTrace(); } catch (IllegalAccessException e) {e.printStackTrace();} //mysql数据库的端口默认是3306；characterEncoding的指编码格式,这个一定要加，不然存到数据库的数据会乱码;最后面的两个参数是mysql数据库的用户名和密码,我的是用户名是root密码是root,连接你自己的时候,你改成你自己的就可以了 conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/bishe014?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull","root","zby8107"); }catch (ClassNotFoundException e) { e.printStackTrace(); }catch (SQLException e) { e.printStackTrace(); } return conn; } public static Statement createStmt(Connection conn) { Statement stmt = null; try { stmt = conn.createStatement(); } catch (SQLException e) { e.printStackTrace(); } return stmt; } public static ResultSet executeQuery(Statement stmt, String sql) { ResultSet rs = null; try { rs = stmt.executeQuery(sql); } catch (SQLException e) { e.printStackTrace(); } return rs; } public static ResultSet executeQuery(PreparedStatement preparedstmt) { ResultSet rs = null; try { rs = preparedstmt.executeQuery(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return rs; } public static PreparedStatement prepareStmt(Connection conn, String sql) { PreparedStatement pstmt = null; try { pstmt = (PreparedStatement) conn.prepareStatement(sql); }catch (SQLException e) { e.printStackTrace(); } return pstmt; } public static void close(Connection conn) { if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } public static void close(Statement stmt) { if (stmt != null) { try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } } public static void close(ResultSet rs) { if (rs != null) { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } } }