dbsqlmanager.java

自己写的基于JSP+servlet+Javabean的bookshop源代码

package beans;


import java.sql.*;


public class DBSQLManager{

	protected Connection conn = null;	
	protected Statement stmt = null;	
	protected ResultSet rs = null;		
	protected String sqlStr;		
	
	public DBSQLManager() {
		try
		{
			sqlStr = "";
			DBConnectionManager dcm = new DBConnectionManager();
			conn = dcm.getConnection();
			stmt = conn.createStatement();
		}
		catch (Exception e) {
			System.out.println(e);
		}
		
	}

	public Statement getStmt() {
		return stmt;
	}

	public Connection getConn() {
		return conn;
	}

	public ResultSet getRs() {
		return rs;
	}

	public void setSqlStr(String newSqlStr) {
		this.sqlStr=newSqlStr;
	}


	public String getSqlStr() {
		return sqlStr;
	}

	public void executeQuery() throws Exception  {
		rs = stmt.executeQuery(sqlStr);
	}

	
	public void executeUpdate() throws Exception  {
		stmt.executeUpdate(sqlStr);
	}
	
	public void close() throws SQLException {
		if ( stmt != null ) {
			stmt.close();
			stmt = null;
		}
		conn.close();
		conn = null;
	}

};