Question

求大神给填个注释～～ package com.mypro.dao; import java.sql.Connection; import java

求大神给填个注释～～

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();
}
}
}

Answer 1

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";//数据库jdbc连接的驱动类。
private static String data="jdbc:sqlserver://localhost:1433;databaseName=timebookDB";//连接数据库(通常用url表示）
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();
}
}
}