java,
分享于 点击 23807 次 点评:233
java,
package DAO;
import java.sql.*;
public class DBConnection {
//数据库的url
private static String url ="jdbc:sqlserver://localhost:1433;databasename =jdbc_demo";
private static String userName = "sa";//数据库用户名
private static String password = "123456";//数据库密码
//jdbc驱动器名称
private static String driverName = "com.microsoft.sqlserver. jdbc.SQLServerDriver";
static {
try {
Class.forName(driverName);//加载JDBC驱动器
} catch (Exception ex) {
ex.printStackTrace();
}
}
public static Connection getConn() {
try {
Connection conn = DriverManager
getConnection(url,userName, password);
System.out.println("连接数据库成功");
return conn;
} catch (SQLException ex) {
System.out.println("连接数据库失败");
ex.printStackTrace();
return null;
}
}
public static void close(Connection conn, Statement stm ResultSet rs) {
try{
if (rs != null)
rs.close();
if(stm!=null)
stm.close();
if (conn != null){
conn.close();
System.out.println("数据库连接成功释放");
}
} catch (SQLException ex) {}
}
}
相关文章
- 暂无相关文章
用户点评