//纯java驱动   使用方法
package javafile;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBcon{
	private Connection con=null;//连接对象，创建执行对象Statement对象
	public DBcon(){
	}
	public Connection getCon(){//获取与对应数据库的连接
		//2,加载驱动
		String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
		//String driver="org.h2.Driver";
		//3,获得连接
		String url="jdbc:sqlserver://localhost:1433;DatabaseName=jspxskaoqin";	
		//String url="jdbc:h2:D:\\JavaEE\\container\\tomcat\\6.0.18.1\\webapps\\eeplat\\WEB-INF\\db\\h2\\config";
		try {
			Class.forName(driver);
			con=DriverManager.getConnection(url,"sa","huang");		
					
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			System.out.println("加载驱动异常");
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			System.out.println("获得连接异常！");
			e.printStackTrace();
		}		
		return con;
	}
	public static void main(String args[]){
		DBcon db=new DBcon();
		Connection con=db.getCon();
		if(con!=null){
		System.out.println("连接成功！");
	
}
	}

}