dbconnect.java

java实现数据库数据浏览工具源码

package jwin;

import java.sql.*;
import java.util.Properties;

public class DBConnect {
	static Connection conn;
	static Statement stmt;

	public static synchronized Connection SqlServerConnect(String server,
			String database, String user, String pass) {
		String connectionUrl = "jdbc:sqlserver://" + server + ";databaseName="
				+ database + ";user=" + user + ";password=" + pass;
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		} catch (ClassNotFoundException nof) {
			System.out
					.println("--------------------------------SqlServer2005Driver not found 驱动类没有找到-----------------------------");
			nof.printStackTrace();
		}

		try {
			conn = DriverManager.getConnection(connectionUrl);
		} catch (SQLException ex) {
			System.out.println("");
			System.out
					.println("--------------------------------SQL 连接异常-----------------------------");
			ex.printStackTrace();
		}
		return conn;
	}

	public static synchronized Connection OracleConnect(String url,
			String user, String password) {
		String Url = "jdbc:oracle:thin:@" + url;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		} catch (ClassNotFoundException nof) {
			System.out
					.println("--------------------------------OracleDriver not found 驱动类没有找到-----------------------------");
			nof.printStackTrace();
		}

		try {
			conn = DriverManager.getConnection(Url, user, password);
			// stmt =conn.createStatement();
		} catch (SQLException ex) {
			System.out
					.println("--------------------------------SQL 连接异常-----------------------------");
			ex.printStackTrace();
		}

		return conn;

	}

	public Connection ConnectionByProperty(String path) {
		PropertiesFiles pf = new PropertiesFiles();
		Properties p = pf.getPropertiesFile(path);
		String driverClass = p.getProperty("driverClassName");
		try {
			Class.forName(p.getProperty("driverClassName"));
		} catch (ClassNotFoundException nof) {
			System.out
					.println("-----驱动程序没有找到,请加载数据库驱动程序包!或者是属性文件的属性名与'driverClassName'不符合!请更正!----");
			nof.printStackTrace();
		}

		try {
			if (driverClass.indexOf("SqlServerDriver") > 0) {
				conn = DriverManager.getConnection(p.getProperty("url")
						+ ";user=" + p.getProperty("username") + ";password="
						+ p.getProperty("password"));
			} else {
				conn = DriverManager.getConnection(p.getProperty("url"), p
						.getProperty("username"), p.getProperty("password"));
			}
		} catch (SQLException ex) {
			try {
				conn = DriverManager.getConnection(p.getProperty("url")
						+ ";user=" + p.getProperty("username") + ";password="
						+ p.getProperty("password"));
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				ex.printStackTrace();
				System.out.println("");
				System.out
						.println("----------SQL 连接异常--请检查属性文件的属性名是否与'url','username','password'相符合!--------------------");
				ex.printStackTrace();
			} catch (Exception e) {
				System.out
						.println("-----------请检查属性文件的属性名是否与'url','username','password'相符合!---------");
			}
		}
		return conn;
	}
}