src/com/dao/DB.java

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

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

package com.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.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
		{
			getDbConnProp();
		} catch (Exception e)
		{
			System.out.println("加载数据库驱动失败！");
			e.printStackTrace();
		}
	}
	
	private void getDbConnProp()
	{
		try{
			InputStream in = getClass().getClassLoader().getResourceAsStream("dbInfo.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:mysql://"+ip+":"+port+"/"+dbName+"?useUnicode=true&characterEncoding=utf-8";

		}catch(Exception e){
			e.printStackTrace();
		}