packagesqlserver;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;public classDBUtil {private static String url = "jdbc:sqlserver://localhost:1433;DatabaseName=db10";private static String user = "sa";private static String password = "root";private static String jdbcName="com.microsoft.sqlserver.jdbc.SQLServerDriver";public staticConnection getConnection() {
Connection con=null;try{
Class.forName(jdbcName);
con=DriverManager.getConnection(url, user, password);
System.out.println("数据库连接成功");
}catch(Exception e) {//TODO Auto-generated catch block
System.out.println("数据库连接失败");
e.printStackTrace();
}returncon;
}public static voidclose(Connection con) {if(con!=null)try{
con.close();
}catch(SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
}
}public static voidclose(Statement state, Connection conn) {if(state!=null) {try{
state.close();
}catch(SQLException e) {
e.printStackTrace();
}
}if(conn!=null) {try{
conn.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}public static voidclose(ResultSet rs, Statement state, Connection conn) {if(rs!=null) {try{
rs.close();
}catch(SQLException e) {
e.printStackTrace();
}
}if(state!=null) {try{
state.close();
}catch(SQLException e) {
e.printStackTrace();
}
}if(conn!=null) {try{
conn.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}
}