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;

public class DBO {

	private Connection conn;
	private Statement stmt;
	private DataSource ds;

	public DBO() {
	}

	/**
	 * 打开数据库
	 */
	public void open() {
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			conn = DriverManager.getConnection(
					"jdbc:sqlserver://localhost:1433;databaseName=dxslc", "sa",
					"welcome");
			// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			// conn=DriverManager.getConnection("jdbc:odbc:netbank");
			stmt = conn.createStatement();
			System.out.println("打开数据库连接");
		} catch (Exception ex) {
			System.err.println("打开数据库时出错: " + ex.getMessage());
		}
	}

	/**
	 * 关闭数据库，将连接返还给连接池
	 */
	public void close() {
		try {

			// connMgr.freeConnection("java", conn);
			conn.close();
			System.out.println("释放连接");
		} catch (SQLException ex) {
			System.err.println("返还连接池出错: " + ex.getMessage());
		}
	}

	/**
	 * 执行查询
	 */
	public ResultSet executeQuery(String sql) throws SQLException {
		ResultSet rs = null;

		rs = stmt.executeQuery(sql);
		System.out.println("执行查询");
		return rs;