dbmanager.java

老牌java开发的物流管理系统 详细的我也没有怎么看 好像是恒基的

/**
 * @author:joypen
 * 数据库连接
 */
package com.wl.dbconnection;

import java.io.IOException;
import java.io.InputStream;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class DBManager {
	public static Properties prop = new Properties();
	public Connection conn = null;
	public PreparedStatement ps = null;
	public CallableStatement cs = null;
	public ResultSet rs = null;

	public DBManager() {
	}
	
	//打开数据库
	public boolean openDB() {
		ClassLoader loader = Thread.currentThread().getContextClassLoader();// 得到当前执行线程的对象
		InputStream inputStream = loader.getResourceAsStream("config.properties");//将config.properties这个文件找到并导入
		try {
			prop.load(inputStream);// 导入inputStream这个流
			String host = prop.getProperty("host");
			String name = prop.getProperty("username");
			String pwd = prop.getProperty("userpwd");
			String db_name = prop.getProperty("databaseName");
			String driver_url = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
			String url = "jdbc:sqlserver://" + host + ":1433;databaseName="
					+ db_name;
			Class.forName(driver_url).newInstance();
			conn = DriverManager.getConnection(url, name, pwd);
		} catch (InstantiationException e) {
			e.printStackTrace();
			return false;
		} catch (IllegalAccessException e) {
			e.printStackTrace();
			return false;
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
			return false;
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		} catch (IOException e) {
			e.printStackTrace();
			return false;
		}
		return true;
	}
	//关闭数据库
	public boolean closeDB() {

		try {
			if (rs != null)
				rs.close();
			if (cs != null)
				cs.close();
			if (ps != null)
				ps.close();
			if (conn != null)
				conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
			return false;
		} finally {
			rs = null;
			cs = null;
			ps = null;
			conn = null;
		}

		return true;


	}	
	 public static void main(String[] args) {
		 DBManager db = new DBManager();
		 if(db.openDB())
			 System.out.println("ok");
		 else
			 System.out.println("no");
	 }

}