src/com/util/DBO.java

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

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

package com.util;

import java.sql.*;

import javax.activation.DataSource;
import java.sql.*;
import javax.naming.Context;
import javax.naming.InitialContext;

import java.util.*;

public class DBO {

	private Connection conn;
	private Statement stmt;
  	private DataSource ds;
	
	public DBO()
	{
		open();
	}

	/**
		打开数据库
	*/
	public void open() 
	{
		
		Properties prop = new Properties();
		 String driver = "com.mysql.jdbc.Driver"; 

		   
		    String url = "";

		    // MySQL配置时的用户名
		    String user = ""; 

		    // MySQL配置时的密码
		    String password = ""; 
		  
		    try {
		    	
		    	prop.load(this.getClass().getClassLoader().getResourceAsStream("db.properties"));
		    	driver = prop.getProperty("driver");
				url = prop.getProperty("url");
			//	System.out.println();
				user = prop.getProperty("user");
				password = prop.getProperty("password");
		    	 Class.forName(driver); 
		    	 conn = DriverManager.getConnection(url, user, password); 
	
			stmt=conn.createStatement();
			System.out.println("打开数据库连接");
		} 
		catch (Exception ex) 
		{
		System.err.println("打开数据库时出错: " + ex.getMessage());
		}
	}