executedb.java

该系统对jsp进行了初级编程 实现了ajax下的部门人才管理

package commons;
import java.sql.*;

public class ExecuteDB extends ConnectDB{
    //数据库连接对象
	private Connection dbConn;
	private Statement stmt;
	private ResultSet rs;
	 //error 描述错误信息
	private String errMes;
	
	//初始化操作
	public ExecuteDB(){
		dbConn=super.getConn();
		stmt=null;
		rs=null;
		this.errMes=super.getErrmes();
	}

	//执行sql语句,主要是执行插入和删除的SQL语句 
	public boolean exeSql(String strSql){
		boolean isSuc=false;
		try
		{
			stmt=dbConn.createStatement();
			stmt.executeUpdate(strSql);
			stmt.close();
			isSuc=true;
		}
	    catch(Exception e)
	    {
	    	this.errMes=this.errMes+"<br>"+e.toString();
	    }
	    return isSuc;
	}
	
	//执行SQL查询语句
	public ResultSet exeQuery(String strSql){
		try
		{
			stmt=dbConn.createStatement();
			rs=stmt.executeQuery(strSql);
		}
		catch (Exception e)
		{
			this.errMes=this.errMes+"<br>"+e.toString();
		}
		return rs;
	}
	
}