sealadminmanager.java

OA典型例子

package com.sure.oa.dict;

import com.sure.businessmodel.Page;
import com.sure.businessmodel.UpdateException;
import com.sure.businesslogic.AlreadyExistsException;
import com.sure.businesslogic.NotFoundException;
import com.sure.dataabstraction.DBManager;
import com.sure.dataabstraction.DBPoolException;
import com.sure.util.StringUtils;

import java.sql.SQLException;
import java.sql.Connection;
import java.util.Vector;
/**
 * <p>Title: OA</p>
 * <p>Description: 国办项目</p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: sure</p>
 * @author mengzy
 * @version 1.0
 */

public class sealAdminManager {

  public sealAdminManager() {
  }

  /**
   * 根据docnoId获得签发人详情
   * @throws SQLException
   * @throws DBPoolException
   * @throws NotFoundException
   */
  public sealAdmin getSealAdmin(int sId) throws SQLException,
          DBPoolException, NotFoundException {
      Connection cn = DBManager.getConnection();
      try {
          String where = "Where sId = " + sId;
          Vector beans = sealAdminPersistent.load(cn, where);
          sealAdmin bean = (sealAdmin)beans.firstElement();
          return bean;
      }catch (SQLException sqle) {
          throw new NotFoundException();
      } finally {
          cn.close();
      }
  }



  public Page getSealAdminList(int start,int unitId) throws SQLException,DBPoolException {
      Connection cn = DBManager.getConnection();
      try{
          String where = "where  unitId=" + unitId + "  order by sId";
          Page p = sealAdminPersistent.load(cn, start, 10, where);
          return p;
      }finally {
          cn.close();
      }
  }


  /**
   * 显示某个单位的所有签发人（不是分页形式）
   * @param unitId
   * @return
   * @throws SQLException
   * @throws DBPoolException
   */
  public Vector getSealAdminList(int unitId) throws SQLException,
          DBPoolException {
      Connection cn = DBManager.getConnection();
      try{
          String where = "where  unitId=" + unitId + "";
          Vector v = sealAdminPersistent.load(cn, where);
          return v;
      }finally {
          cn.close();
      }
  }

  /**
   * 保存签发人信息
   */
  public int saveSealAdmin(sealAdmin p) throws SQLException,DBPoolException, UpdateException, NotFoundException {
      Connection cn = DBManager.getConnection();
      String sealAdminName = StringUtils.getSQLencode(p.getSealAdminName() );
      String where = "Where sealAdminName = '" + sealAdminName + "'  and unitId=" +
                     p.getUnitId() + " and SId<>" + p.getSId() ;
      int intResult = sealAdminPersistent.getCount(cn, where);
      if (intResult > 0){
          throw new UpdateException("本单位中已经存在" + sealAdminName + "这个签发人");
      }
      int pId = p.getSId().intValue();
      int retval = 0;
      try{
          sealAdminPersistent pb = new sealAdminPersistent(p);
          if (pId == 0){
            retval = 2;
          }else{
            pb.setRecordExists(true);
            retval = 3;
          }
          pb.persist(cn);
      }finally {
          cn.close();
      }
    return retval;
  }
  /**
   * 删除签发人
   */
  public void delSealAdmin(int sId) throws SQLException,DBPoolException, NotFoundException {
        Connection cn = DBManager.getConnection();
        try {
            String where = "Where sId = " + sId;
            sealAdminPersistent.delete(cn, where);
        }catch (SQLException sqle) {
            throw new  NotFoundException();
        } finally {
            cn.close();
        }
    }

}