dbconn.java

用jsp实现的大型商城源代码

package myshop;

import java.sql.*;

public class DBconn {
	Config config = new Config();

	private String DBdriver = config.DBdriver;
	private String DBurl = config.DBurl;

	Statement stmt = null;
	Connection conn = null;
	ResultSet rs = null;

	//--- 注册数据库驱动程序 ---
	public DBconn() throws Exception {
		try {
			Class.forName(DBdriver).newInstance();
		}
		catch(java.lang.ClassNotFoundException e) {
			System.err.println("DBconn (): " + e.getMessage());
		}
	}

	//--- 执行查询和返回结果 ---
	public ResultSet ExeQuery(String sql) {
		try {
			conn = DriverManager.getConnection(DBurl);
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			rs = stmt.executeQuery(sql);
			conn.close();
		}
		catch(SQLException ex) {
			System.err.println("ExeQuery:"+ex.getMessage());
		}
		return rs;
	}
	
	//--- 执行更新操作 ---
	public void ExeUpdate(String sql) {
		try {
			conn = DriverManager.getConnection(DBurl);
			stmt = conn.createStatement();
			stmt.executeUpdate(sql);
			conn.close();
		}
		catch(SQLException ex) {
			System.err.println("ExeUpdate:"+ex.getMessage());
		}
	}

	public void CloseConn() throws Exception {
		if (rs != null) rs.close();
		if (stmt != null) stmt.close();
		if (conn != null) conn.close();
	}

}