import java.sql.* ; public class BaseDao { private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver"; private static final String URL="jdbc:sqlserver://localhost:1433;databaseName=myweb";//这里的dataBaseName 就是 sql中 create database name 中的name private static final String USER="sa"; private static final String PASSWORD=""; // 密码 //加载驱动 static{ try { Class.forName(DRIVER); } catch (ClassNotFoundException e) { System.out.println("获取加载驱动失败"); } } //获取数据库连接 public static Connection getConnection(){ try { return DriverManager.getConnection(URL,USER,PASSWORD); } catch (SQLException e) { System.out.println("链接数据库失败"); } return null; } //释放数据库资源的方法 public static void closeDb(Connection con,Statement st,ResultSet rs){ if(rs!=null)try { rs.close();} catch (SQLException e) { e.printStackTrace(); } if(st!=null)try {st.close();} catch (SQLException e) { e.printStackTrace(); } if(con!=null)try {con.close();} catch (SQLException e) { e.printStackTrace(); } } public static boolean updata(String sql,Object[] obj){ Connection conn=getConnection(); PreparedStatement ps=null; try { ps=conn.prepareStatement(sql); //判断是否有占位符需要填充数据 if(obj!=null&&obj.length>0){ for (int i = 0; i < obj.length; i++) { if(obj[i]==null)obj[i]=""; ps.setObject(i+1, obj[i]); } } if(ps.executeUpdate()>0) return true; } catch (SQLException e) { e.printStackTrace(); }finally{ closeDb(conn, ps, null); } return false; } }