刚学的jsp BaseDao

   感觉这个BaseDao还是挺专业的，是好东西。

public class BaseDao {

 private static final String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
 private static final String url = "jdbc:sqlserver://localhost:1433;databaseName=playlist(数据库名称)";
 private static final String username = "sa";
 private static final String password = "sa";
 
 /**
  * 注册驱动
  */
 static{
  try {
   Class.forName(driverName);
  } catch (ClassNotFoundException e) {
   System.out.println("注册驱动异常");
   e.printStackTrace();
  }
 }
 
 /**
  * 获取数据库连接
  * @return
  */
 public Connection getConnection(){
  Connection conn = null;
  try {
   conn = DriverManager.getConnection(url, username, password);
  } catch (SQLException e) {
   System.out.println("创建连接失败");
   e.printStackTrace();
  }
  return conn;
 }
 
 /**
  * 执行增、删,改语句
  * @param sql sql语句
  * @param params 参数列表
  * @return
  */
 public int executeUpdate(String sql,Object[] params){
  Connection conn = this.getConnection();
  PreparedStatement pstmt = null;
  int result = 0;
  try {
   pstmt = conn.prepareStatement(sql);
   
   //赋值参数
   if(params != null && params.length != 0){
    for (int i = 0; i < params.length; i++) {
     pstmt.setObject(i+1, params[i]);//下标与值意义一一对应
    }
   }
   result = pstmt.executeUpdate();
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {
   this.closeAll(conn, pstmt, null);
  }
  return result;
 }
 
 /**
  * 释放资源
  * @param conn
  * @param stmt
  * @param rs
  */
 public void closeAll(Connection conn, Statement stmt, ResultSet rs){
  try {
   if(rs != null) {rs.close(); rs = null;}
   if(stmt != null) stmt.close();
   if(conn != null && !conn.isClosed()) conn.close();
  } catch (SQLException e) {
   e.printStackTrace();
  }
 }

}
以后我就把自己的学习资料放到CSDN的服务器上省省我的硬盘。呵呵