querydatamanagedao.java

公司自己开发的工作流引擎

package cn.com.iaspec.workflow.manage.dao;

import java.sql.*;
import java.util.*;
import cn.com.iaspec.workflow.db.*;
import cn.com.iaspec.workflow.manage.*;
import cn.com.iaspec.workflow.vo.workflow.*;

/**
 * <p>Title:条件查询DAO </p>
 *
 * <p>Description: 深圳市劳动仲裁信息管理系统</p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: 永泰软件工程有限公司</p>
 *
 * @author syj
 * @version 1.0
 */
public class QueryDataManageDAO{
  public ArrayList getDataUserInfo(String sql)
      throws QueryDataManageException{
    ArrayList list=new ArrayList();
    PreparedStatement prep=null;
    Connection conn=null;
    ResultSet rs=null;
    int i=0;
    System.out.println("sql="+sql);
    try{
      conn=WorkflowDBConnectionManager.getInstance().getConnection();
      prep=conn.prepareStatement(sql);
      rs=prep.executeQuery();
      while(rs.next()){
        i++;
        UserInfo userinfo=new UserInfo();
        userinfo.setId(i);
        userinfo.setUserId(rs.getString("user_id"));
        userinfo.setUserName(rs.getString("user_name"));
        userinfo.setDescription(rs.getString("description"));
        userinfo.setUserPosition(rs.getString("user_position"));
        userinfo.setRela_phone(rs.getString("rela_phone"));
        list.add(userinfo);

      }
    }
    catch(Exception e){
      throw new QueryDataManageException("--根据条件查询用户信息异常--");
    }
    finally{
      WorkflowDBConnectionManager.getInstance().close(rs);
      WorkflowDBConnectionManager.getInstance().close(prep,false);
      WorkflowDBConnectionManager.getInstance().close(conn);
    }

    return list;
  }

  /**
   *查询用户信息
   * @param type int
   * @param queryname String
   * @return ArrayList
   */
  public ArrayList queryUserInfo(String select1,String select2,String queryname)
      throws QueryDataManageException{
    ArrayList list=new ArrayList();
    String sq1="select t.* from wf_user t where t.user_name='"+queryname+"'";
    String sq2="select t.* from wf_user t where t.user_name like'%"+queryname+
        "%'";
    String sq3="select t.* from wf_user t where t.user_position='"+queryname+
        "'";
    String sq4="select t.* from wf_user t where t.user_position like'%"+
        queryname+"%'";
    if(select1.equals("1")){
      if(select2.equals("1")){
        list=getDataUserInfo(sq1);
      }
      else if(select2.equals("2")){
        list=getDataUserInfo(sq2);
      }

    }
    else if(select1.equals("2")){
      if(select2.equals("1")){
        list=getDataUserInfo(sq3);
      }
      else if(select2.equals("2")){
        list=getDataUserInfo(sq4);
      }

    }
    return list;
  }

  /**
   * 根据条件查询活动信息信息
   * @param sql String
   * @return ArrayList
   * @throws QueryDataManageException
   */
  public ArrayList getDataActivityInfo(String sql)
      throws QueryDataManageException{
    ArrayList list=new ArrayList();
    PreparedStatement prep=null;
    Connection conn=null;
    ResultSet rs=null;
    System.out.println("sql="+sql);
    try{
      conn=WorkflowDBConnectionManager.getInstance().getConnection();
      prep=conn.prepareStatement(sql);
      rs=prep.executeQuery();
      while(rs.next()){
        ActivityInfo activityInfo=new ActivityInfo();
        activityInfo.setATD_ID(rs.getLong("ATD_ID"));
        activityInfo.setATD_NAME(rs.getString("ATD_NAME"));
        activityInfo.setATD_UID(rs.getString("ATD_UID"));
        activityInfo.setATD_PRDID(rs.getLong("ATD_PRDID"));
        activityInfo.setATD_DESC(rs.getString("ATD_DESC"));
        activityInfo.setATD_PRDENAME(rs.getString("ATD_PRDENAME"));
        activityInfo.setPRD_UID(rs.getString("PRD_UID"));
        activityInfo.setPrd_description(rs.getString("PRD_DESCRIPTION"));
        list.add(activityInfo);

      }
    }
    catch(Exception e){
      e.printStackTrace();
      throw new QueryDataManageException("--根据条件查询活动信息信息异常--");
    }
    finally{
      WorkflowDBConnectionManager.getInstance().close(rs);
      WorkflowDBConnectionManager.getInstance().close(prep,false);
      WorkflowDBConnectionManager.getInstance().close(conn);
    }

    return list;
  }

  /**
   * 查询
   * @param select1 String
   * @param select2 String
   * @param queryname String
   * @return ArrayList
   * @throws QueryDataManageException
   */
  public ArrayList queryActivityInfo(String select1,String select2,
      String queryname)
      throws QueryDataManageException{
    ArrayList list=new ArrayList();
    String sq1="select t.* from wf_actidefinition t where t.atd_name='"+
        queryname+"'";
    String sq2="select t.* from wf_actidefinition t where t.atd_name like'%"+
        queryname+"%'";
    String sq3="select t.* from wf_actidefinition t where t.atd_prdename='"+
        queryname+"'";
    String sq4=
        "select t.* from wf_actidefinition t where t.atd_prdename like'%"+
        queryname+"%'";
    if(select1.equals("1")){
      if(select2.equals("1")){
        list=getDataActivityInfo(sq1);
      }
      else if(select2.equals("2")){
        list=getDataActivityInfo(sq2);
      }

    }
    else if(select1.equals("2")){
      if(select2.equals("1")){
        list=getDataActivityInfo(sq3);
      }
      else if(select2.equals("2")){
        list=getDataActivityInfo(sq4);
      }

    }
    return list;

  }
}