src/main/java/com/util/DBO.java

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

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

package com.util;

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

import javax.activation.DataSource;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


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("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());
		}
	}

	/**
	 关闭数据库，将连接返还给连接池