exedb.java

CEBI电子商务网站 基于JSP+javaBean结构

package cn.aiqinzhe;
import java.sql.*;

public class ExeDB extends OpenDB {

//	数据库连接对象
	private Connection dbConn;
	private Statement stmt;
	private ResultSet rs;	
	
	//初始化操作
	public ExeDB()
	{
		dbConn = super.getDB();
		stmt = null;
		rs = null;
	}
	
	 //执行sql 执行语句，主要是执行插入和删除的SQL语句
	public boolean exeSql(String strSql)
	{
		try
		{
   			stmt=dbConn.createStatement();
			stmt.executeUpdate(strSql);	
			stmt.close();	
			return true;            
		}
		catch(Exception ex)
		{
			return false;
		}	
	}
	
	//执行sql 查询语句    
    public ResultSet exeSqlQuery(String strSql)
	{
		
		try
		{
   			stmt=dbConn.createStatement();
			rs =stmt.executeQuery(strSql);			            
		}
		catch(Exception ex)
		{	
			rs = null;
		}	
		return rs;
	}	
}