src/com/util/DBO.java

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

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

package com.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.activation.DataSource;


import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.datasource.DataSourceUtils;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

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

	/**
		打开数据库
	*/
	public void open() 
	{
	

		   
		    String url = "";

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

		    // MySQL配置时的密码
		    String password = ""; 
			 ApplicationContext ac = new ClassPathXmlApplicationContext("config/ApplicationContext.xml");
		    try {
		    	// Class.forName(driver); 
		    	
		    	DriverManagerDataSource ds=(DriverManagerDataSource)ac.getBean("dataSource");
		    	
		    	
		    	conn=ds.getConnection();
		    	// conn = DataSourceUtils.getConnection((DataSource)ac.getBean("dataSource"));
;//DriverManager.getConnection(url, user, password); 
	
			stmt=conn.createStatement();
			System.out.println("打开数据库连接");
		} 
		catch (Exception ex) 
		{
		System.err.println("打开数据库时出错: " + ex.getMessage());
		}
	}