dbutil.java

来自「用java开发的QQ管理系统」· Java 代码 · 共 122 行

package com.zlf.dao;

/**
 * 数据库连接
 * @author zlf
 */
import java.awt.Color;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JOptionPane;
import javax.swing.JTextField;

import com.zlf.qqserver.Public;
import com.zlf.qqserver.utils.QQUtils;
public class DBUtil {
	public static Connection getConnection(){
		String url=QQUtils.properties.getProperty("DatabaseURL");
		Connection conn = null;
		try {
			
			Class.forName(QQUtils.properties.getProperty("DatabaseDriver"));
			String dataBaseUserName=QQUtils.properties.getProperty("DatabaseUserName");
			String DatabaseUserPwd=QQUtils.properties.getProperty("DatabaseUserPwd");
			
			
			conn = DriverManager.getConnection(url,dataBaseUserName,DatabaseUserPwd); 
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
			JOptionPane.showMessageDialog(null, "配置文件DatabaseDriver出错，请配置为oracle.jdbc.driver.OracleDriver!", "提示框",
					JOptionPane.WARNING_MESSAGE);
		}catch(SQLException e){
			e.printStackTrace();
			JOptionPane.showMessageDialog(null, "Oracle 连接错误!", "提示框",
					JOptionPane.WARNING_MESSAGE);
			QQUtils.properties.setProperty("noshow", "no");
			QQUtils.saveProperties();
			Public.serverClose();
			System.exit(0);
			
		}
		return conn;
	}
	
	public static Connection getConnection(JTextField tf){
		String url=QQUtils.properties.getProperty("DatabaseURL");
		Connection conn = null;
		try {

			Class.forName(QQUtils.properties.getProperty("DatabaseDriver"));
			String dataBaseUserName=QQUtils.properties.getProperty("DatabaseUserName");
			String DatabaseUserPwd=QQUtils.properties.getProperty("DatabaseUserPwd");
			
			System.out.println(url);
			System.out.println(dataBaseUserName);
			System.out.println(DatabaseUserPwd);
			
			
			conn = DriverManager.getConnection(url,dataBaseUserName,DatabaseUserPwd); 
			tf.setText("Oracle测试连接成功，请连接!");
			tf.setSize(200,30);
			tf.setBackground(Color.white);
		
		}catch(SQLException e){
			e.printStackTrace();
			tf.setText("Oracle连接失败!请检查");
			tf.setSize(200,30);
			tf.setBackground(Color.white);
			
		} catch (ClassNotFoundException e) {

			e.printStackTrace();
			JOptionPane.showMessageDialog(null, "配置文件DatabaseDriver出错，请将配置文件serverConfig.properties删除或请配置为oracle.jdbc.driver.OracleDriver!", "提示框",
					JOptionPane.WARNING_MESSAGE);
		}
		return conn;
	}
	
	/**
	 * 
	 * 关闭连接
	 * @param conn
	 */
	public static void close(Connection conn){
		try {
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	/**
	 * 
	 * @param rs
	 */
	public static void close(ResultSet rs) {
		try {
			rs.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	/**
	 * 
	 * 
	 * @param statement
	 */
	public static void close(Statement statement) {
		try {
			statement.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	

}