JAVA数据库DbHelper.docVIP

package util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.LinkedList; public class DBHelper { private ResultSet rs = null; private Statement stmt = null;// 语句对象 private Connection conn = null; public DBHelper() { try { /* * 加载一个类，根据类名加载一个类 加载驱动 */ Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); String url = jdbc:sqlserver://localhost:1433;DatabaseName=acbc; String username = sa; String password = conglang1314; conn = DriverManager.getConnection(url, username, password); // 创建语句对象 stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); // 连接必须一致保持 } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } public ResultSet query(String sql) { try { rs = stmt.executeQuery(sql); /*System.out.println(==+sql);*/ return rs; } catch (SQLException e) { e.printStackTrace(); } return null; } public int update(String sql) { try { if (stmt != null) { int num = stmt.executeUpdate(sql); return num; } else { return 0; } } catch (SQLException e) { e.printStackTrace(); } return 0; } public void commit() { try { mit(); } catch (SQLException e) { e.printStackTrace(); } } public void rollback() { try { conn.rollback(); } catch (SQLException e) { e.printStackTrace(); } } public void close() { try { if (rs != null) rs.close(); } catch (SQLException e) { System.out.println; } try { if (stmt != null) stmt.close(); } catch (SQLException e) { System.out.println; } try { if (conn != null) conn.close(); } catch (SQLException e) { System.out.println; } } /*void main(String[] args) { try { PreparedStatement pps = c