求大神给填个注释~~packagecom.mypro.dao;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statem...
求大神给填个注释~~
package com.mypro.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBUtil {
private static String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static String data = "jdbc:sqlserver://localhost:1433;databaseName=timebookDB";
private static String user = "sa";
private static String pwd = "123456";
//获得连接对象
public static Connection getConnection(){
Connection conn = null;
try{
Class.forName(driver);
conn = DriverManager.getConnection(data,user,pwd);
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}
return conn;
}
//关闭所有资源
public static void closeAll(ResultSet rs,Statement st,Connection conn){
try{
if(rs != null){
rs.close();
}
if(st != null){
st.close();
}
if(conn != null){
conn.close();
}
}catch(SQLException e){
e.printStackTrace();
}
}
}
展开