import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DbUtil {
private final static String db_Driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private final static String db_Url = "jdbc:sqlserver://localhost:1433;databaseName=USER";
private final static String db_User = "sa";
private final static String db_Password = "123456";
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName(db_Driver);
conn = DriverManager.getConnection(db_Url, db_User, db_Password);
} catch (ClassNotFoundException e) {
System.err.println("加载驱动失败!");
} catch (SQLException e) {
System.err.println("无法获得数据库连接!");
}
return conn;
}
public static void close(Connection conn) {
try {
if (conn != null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
/*public static void main(String[] args) {
System.out.println(getConnection());
}*/
//用于检验的方法
}
主要将jdbc有关创建链接和关闭链接的方法,关于jdbc的链接的东西,最好归结在一个类中,而且是静态方法,便于使用。