dbsqlmanager.java

利用JSP来实现网站的各种功能

package bookshop;

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;
     }
}