package org.jdbc;
import java.sql.*;
public class DBConn {
private Connection conn = null; //Connection对象(连接)
public DBConn() {
this.conn = this.getConnection(); //获取数据库连接
}
public Connection getConnection() { //获取连接类
try {
/** 加载并注册SQLServer2012的JDBC驱动 */
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
/**编写连接字符串,创建并获取连接*/
conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=yfgl","sa","123456");
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public Connection getConn() {return conn;} //返回一个Connection
}