ACCP5.0 S2结业考试机试题.rar

package Dao; import java.sql.*; public class BaseDao { // 建立驱动器 private static final String DRIVER_CLASS = com.microsoft.sqlserver.jdbc.SQLServerDriver.class.getName(); // 数据库连接地址 1433 private static final String URL = "jdbc:sqlserver://localhost:1433;DataBaseName=exam"; // 用户名 private static final String DATABASE_USER = "sa"; // 密码 private static final String DATABASE_PASSWORD = "sa"; /** * 得到数据库连接 */ public Connection getConn() throws ClassNotFoundException, SQLException { Class.forName(DRIVER_CLASS); //注册驱动 Connection con = DriverManager.getConnection(URL, DATABASE_USER,DATABASE_PASSWORD); return con; //返回连接 } /** * 释放资源 * * @throws SQLException */ public void closeAll(Connection conn, PreparedStatement pstmt, ResultSet rs) { if (rs != null) { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } if (pstmt != null) { try { pstmt.close(); } catch (SQLException e) { e.printStackTrace(); } } if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } /** * 执行SQL语句，可以进行增、删、改的操作，不能执行查询 * * @throws SQLException * @throws SQLException * @throws ClassNotFoundException */ public int executeSQL(String preparedSql, String[] param) { Connection conn = null; PreparedStatement pstmt = null; int num = 0; // 处理SQL，执行SQL try { conn = this.getConn(); pstmt = conn.prepareStatement(preparedSql); if (param != null) { for (int i = 0; i < param.length; i++) { pstmt.setString(i + 1, param[i]);//设置参数 } } num = pstmt.executeUpdate(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { this.closeAll(conn, pstmt, null); } return num; } }