monitorbean.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.statana;

import com.doone.data.DacClient;
import com.doone.data.ConnectionLocator;
import com.doone.data.DataTable;
import com.doone.util.FileLogger;


public class MonitorBean {
  private DacClient _dac = null;
  private DataTable _datatable = null;
  public int pageSize =15; // 默认每页15条
   

 

  public MonitorBean() {
    try {
      _dac = new DacClient();

    }
    catch (Exception ex) {
      FileLogger.getLogger("数据库连接出错！" + ex.getMessage().toString());
    }
  }
/**
 * 删除记录
 */
  public int delete(String tablename,String id,String idvalue) {//参数说明：表名，主键名，主键值
    int doExp = 0;
    try {
      String sql = "delete from "+tablename+" where "+id+"=?";
      Object[] _object = new Object[1];
      _object[0] = idvalue;
      _dac.beginTransaction(10000);
      doExp = _dac.executeUpdate(sql, 10000, _object);
      _dac.endTransaction(true);
     }
     catch (Exception ex) {
        FileLogger.getLogger().error("数据库删除出错！" + ex.getMessage().toString());
        try{_dac.endTransaction(false);}
        catch(Exception ex1){}
     }
    return doExp;
  }

/**
 * 获得某页的要显示的记录
 * @param sql  sql语句
 * @param pageNo 要显示的页面
 * @return
 */
  public DataTable getPageMsg(String sql,int pageNo){
     DataTable dt=null;
     try{
       String str = "select * from (" + sql + ") where num>" +
           (pageNo - 1) * pageSize + " and num<=" + pageNo * pageSize;
       _dac.beginTransaction(10000);
       dt=_dac.executeQuery(str);
       _dac.endTransaction(true);
     }
     catch(Exception ex){
       FileLogger.getLogger().error(ex.getMessage().toString());
       try{_dac.endTransaction(false);}
       catch(Exception ex1){}
     }
     return dt;

   }
  /**
   * 
   * @param 
   * @param 
   * @return
   */
  public DataTable getMOdel(){
	     DataTable dt=null;
	     try{
	       String str = "select distinct(ENTITYNAME) from tl_interfacesubmit" ;
	          
	       _dac.beginTransaction(10000);
	       dt=_dac.executeQuery(str);
	       _dac.endTransaction(true);
	     }
	     catch(Exception ex){
	       FileLogger.getLogger().error(ex.getMessage().toString());
	       try{_dac.endTransaction(false);}
	       catch(Exception ex1){}
	     }
	     return dt;

	   }
  /**
   * 
   * @param sql
   * @param pageNo
   * @return
   */
  public DataTable _getPageMsg(String sql,String time,String time_end,String appealmode,int pageNo){
	     DataTable dt=null;
	     try{
	       String str = "select * from (" + sql +  " where to_char(CREATETIME,'YYYY-MM-DD') Between " + "'" +time+
	       		"' and  '" +time_end+
	       		"' and ENTITYNAME=? " +")"+
	       		" where num>" 
	       		+(pageNo - 1) * pageSize + " and num<=" + pageNo * pageSize;
	   	       Object[] _object = new Object[1];
	       _object[0] = appealmode;
	       _dac.beginTransaction(10000);
	       dt=_dac.executeQuery(str,_object);
	       _dac.endTransaction(true);
	     }
	     catch(Exception ex){
	       FileLogger.getLogger().error(ex.getMessage().toString());
	       try{_dac.endTransaction(false);}
	       catch(Exception ex1){}
	     }
	     return dt;

	   }
  /**
   * 
   */
  public int _getPageCount(String tablename,String time,String time_end,String appealmode){
	  	int _pageCount=0;
	     DataTable dt=null;
	     try{
	       String str = "select count(*) count from "+tablename ;
	       str+=" where to_char(CREATETIME,'YYYY-MM-DD') Between '" +time+
	       		"' and '" +time_end+
	       		"' and ENTITYNAME=?";
	       Object[] _object = new Object[1];
	       _object[0] = appealmode;
	       _dac.beginTransaction(10000);
	       dt=_dac.executeQuery(str,_object);
	       _pageCount=dt.getRow(0).getInt("count");
	       if (_pageCount % pageSize == 0)
	                          _pageCount = _pageCount / pageSize;
	                  else
	                          _pageCount = _pageCount / pageSize + 1;

	       _dac.endTransaction(true);
	     }
	     catch(Exception ex){
	       FileLogger.getLogger().error(ex.getMessage().toString());
	         try{_dac.endTransaction(false);}
	         catch(Exception ex1){}
	     }
	     return _pageCount;
	   }


    
  /**
   * 获得页数 参数：表名
   */
   public int getPageCount(String tablename){
	   int pageCount=0;
     DataTable dt=null;
     try{
       String str = "select count(*) count from "+tablename ;
       _dac.beginTransaction(10000);
       dt=_dac.executeQuery(str);
       pageCount=dt.getRow(0).getInt("count");
       if (pageCount % pageSize == 0)
    	   	pageCount = pageCount / pageSize;
                  else
                	  pageCount = pageCount / pageSize + 1;

       _dac.endTransaction(true);
     }
     catch(Exception ex){
       FileLogger.getLogger().error(ex.getMessage().toString());
         try{_dac.endTransaction(false);}
         catch(Exception ex1){}
     }
     return pageCount;
   }
   
   /**
    * 获取下拉框中的数据
    */
   public String buildPageOptions(int pageCount,int pageNo) {
                  String optionHTML = "";
                  for (int i = 1; i <= pageCount; i++) {
                          if (pageNo == i || pageNo==0)
                                  optionHTML += "<option value='" + i + "' selected/>"
                                                  + i;
                          else
                                  optionHTML += "<option value='" + i + "'/>" + i;
                  }
                  return optionHTML;
          }

}