dbtools.java

来自「这是JAVA报表系统,如需要的请下载...QQ:398260301」· Java 代码 · 共 41 行

package com.JFreeChat.DB;
import java.sql.*;
public class DBTools {
	//private static String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
	//private static String url = "jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=pubs";
	private static String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
	
	private static String url = "jdbc:odbc:test";
	
	private static String userName = "sa";
	private static String password = "";
	
	
	/**
	 * 加载驱动程序
	 */
	static{
		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	
	
	/**
	 * 动态连接数据库
	 * @return
	 */
	public static Connection getConnection()
	{
		try {
			return DriverManager.getConnection(url,userName,password);
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		}
	}
	
}