src/com/bdglxt/dao/DB.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.bdglxt.dao;

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

public class DB
{
	private Connection con;

	private PreparedStatement pstm;

	private String user;

	private String password;
	
	private String ip;
	
	private String port;
	
	private String dbName;

	private String url;

	public DB()
	{
		try
		{
			setConnProp();
			//Class.forName(className);
		} catch (Exception e)
		{
			System.out.println("加载数据库驱动失败！");
			e.printStackTrace();
		}
	}

	private void setConnProp()
	{
		try{
			InputStream in = getClass().getClassLoader().getResourceAsStream("dbConfig.properties"); 
			Properties proHelper = new Properties();
			proHelper.load(in);
	        in.close();
	        
	        ip=proHelper.getProperty("dburl");
	        port=proHelper.getProperty("dbport");
	        user=proHelper.getProperty("dbuser");
	        password=proHelper.getProperty("dbpass");
	        dbName=proHelper.getProperty("dbName");
	        
	        //url = "jdbc:microsoft:sqlserver://"+ip+":"+port+";databaseName="+dbName; 
	        url = "jdbc:sqlserver://"+ip+":"+port+";databasename="+dbName+";user="+user+";password="+password;
		}catch(Exception e){
			e.printStackTrace();