dbconnection.java

一个KTV管理系统

package common.dbconnection;

import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class DbConnection {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		DbConnection db = new DbConnection();
		if (db.getConnection() != null) {
			System.out.println("数据库连接成功");
		} else {
			System.out.println("数据库连接失败");
		}

	}

	public static Connection getConnection() {
		Connection con = null;
		try {
			Properties pro = getProperties();
			String driver = pro.getProperty("driver");
			String url = pro.getProperty("url");
			String user = pro.getProperty("user");
			String pwd = pro.getProperty("pwd");
			// 加载驱动程序

			Class.forName(driver);
//		测试语句	System.out.println("zhuobin");
			con = DriverManager.getConnection(url, user, pwd);
//			System.out.println("zhuobin");
		} catch (SQLException e) {
			System.out.println(e.getMessage());
		} catch (ClassNotFoundException e) {
			System.out.println(e.getMessage());
		}
		return con;
	}

	public static Properties getProperties() {
		Properties pro = new Properties();
		try {
			pro.load(new FileInputStream(new File("db1.properties")));
		} catch (Exception e) {
			System.out.println("db1.properties:=" + e.getMessage());
		}
		return pro;
	}
}