databasemanager.java

来自「一个简单的用java+flex写的投票系统」· Java 代码 · 共 86 行

package JspVoteSystem.DB;

import java.sql.*;
import JspVoteSystem.DB.DataBase;

/**
 * <p>Title: DataBaseManager</p>
 * <p>Description: 对DB进行操作的Class</p>
 * <p>Copyright: Copyright (c) 2006</p>
 * @author kenshin
 * @version 1.0
 */
public class DataBaseManager {
	  private Statement stmt;
	  private ResultSet res;
	  private int iResult;
	  private DataBase db = new DataBase();

	public DataBaseManager(){
		stmt = null;
		res = null;
		iResult = 0;
	}

	/**
	* <p>Title: Close</p>
	* <p>Description: 对DB进行进行select操作</p>
	* <p>Copyright: Copyright (c) 2006</p>
	* @param 得到的是传入的sql文
 	* @return 一个结果集
	* @author kenshin
	* @version 1.0
	*/
	public ResultSet exeute(String p_Sql){
		try{
			db.Connection();
			stmt = db.con.createStatement();
			res = stmt.executeQuery(p_Sql);
		}
		catch(Exception ex){
			System.err.println("Class Name:exeute" + ex.getStackTrace());
		}
		return res;
	}

   /**
	* <p>Title: exeuteUpdateOrInsertOrDelete</p>
	* <p>Description: 对DB进行exeuteUpdateOrInsertOrDelete</p>
	* <p>Copyright: Copyright (c) 2006</p>
	* @param p_Sql:得到的是传入的sql文
 	* @return insert or update or delete 是否成功，int <> 0 说明成功，反之则失败
	* @author kenshin
	* @version 1.0
	*/
	public int exeuteUpdateOrInsertOrDelete(String p_Sql){
		try{
			db.Connection();
			stmt = db.con.createStatement();
			iResult = stmt.executeUpdate(p_Sql);
		}
		catch(Exception ex){
			System.err.println("Class Name:exeuteUpdateOrInsertOrDelete" + ex.getStackTrace());
		}
		return iResult;
	}

	/**
	* <p>Title: Close</p>
	* <p>Description: 对DB进行进行关闭操作</p>
	* <p>Copyright: Copyright (c) 2006</p>
	* @param null
 	* @return null
	* @author kenshin
	* @version 1.0
	*/
	public void Close(){
		try{
			stmt.close();
			db.con.close();
			//db.con.commit();
		}
		catch(Exception ex){
			System.err.println("Class Name:Close" + ex.getStackTrace());
		}
	}
}