数据库连接

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
}