dataconn.java

精品课程的java源码

package com.zzx.util;

import java.sql.*;


public class DataConn {
   
	public static void main(String[] srg) {
		new DataConn().getConn();
		//System.out.println("conn successfully");
	}
	/*  
     * mysql数据库驱动
     * */
//	final String driver = "com.mysql.jdbc.Driver";
//	final String url = "jdbc:mysql://localhost:3306/jpkc";
//	final String user = "root";
//	final String password = "root";

	
	//sql server 2000的数据驱动
//	final String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // 加载server2005 JDBC驱动
//	final String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jpkc"; // 连接服务器和数据库
//	final String user = "sa";
//	final String password = "123456";
	
	
	final String   driver ="net.sourceforge.jtds.jdbc.Driver";
	final String   url = "jdbc:jtds:sqlserver://localhost:1433/jpkc";
	final String user = "sa";
	final String password = "123456";
	
	static Connection conn = null;

	public DataConn() {
		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
			System.out.println("驱动类加载失败!");
		}
		try {
			conn = DriverManager.getConnection(url, user, password);
			
		} catch (SQLException e) {
            e.printStackTrace();
			System.out.println("连接数据库失败!");
		}
	}	

	public Connection getConn() {		
		return conn;
	}
	
	public void closeConn() {
	     try {
			conn.close();
		} catch (SQLException e) {
			System.out.println("和数据库断开连接失败!");
		}
	}
	
}