后台的action

 

ZXCtrl zc=new ZXCtrl();

 

 if(7==iFlag) {
     //按纳税人税号查询信息
     
    List list=zc.searchxx(form, request, iFlag);
       if(list.size()!=0){
        
        ZXForm tous = (ZXForm)list.get(0);
        request.setAttribute("selectByxx", tous);
        list.add(tous);
        request.setAttribute("listdata", list);    
        forward_string = "nsquery";
      }
       else{
        forward_string="zixundj";
        request.setAttribute("listdata", "没有查到相应的信息"); 
       }
   }

、、、、、、、、、、、、、、、、、ZXCtrl 、、、、、、、、、、、、、、

/**
  * 按照纳税人税号查询纳税基本信息
  * @param form
  * @param request
  * @param iFlag
  */
 
 public List searchxx(ZXForm form,HttpServletRequest request,int iFlag){
  dbConnect db = new dbConnect();
  db.getConnectionNew();
  List list = new ArrayList();
  String sWhereSQL = "";
  

  
  String SQLSelect = "";
 
  SQLSelect="select * from shenai_client_info where 1=1";
  if (!"".equals(form.getYHSH())&&!(form.getYHSH()==null))//纳税人税号
      sWhereSQL+=" and code = '"+form.getYHSH()+"'";
  
  SQLSelect+=sWhereSQL;
  try {
   rs = db.runQueryNew(SQLSelect);
   while (rs.moveNext()) {
    ZXForm temp = new ZXForm();
    temp.setCorpcoding(rs.fieldByIndex(0));
    temp.setCode(rs.fieldByName("code")!=null?rs.fieldByName("code"):" ");//纳税人税号
     temp.setName(rs.fieldByName("name")!=null?rs.fieldByName("name"):" ");//用户名称
                temp.setLinkman_fax(rs.fieldByName("linkman_fax")!=null?rs.fieldByName("linkman_fax"):" ");//联系人固定电话
    temp.setCreationDate(rs.fieldByName("creationDate")!=null?rs.fieldByName("creationDate"):" ");//采集日期
     temp.setAddress(rs.fieldByName("address")!=null?rs.fieldByName("address"):" ");//地址
    
     temp.setRideWay(rs.fieldByName("rideWay")!=null?rs.fieldByName("rideWay"):"");//乘车路线
    temp.setAroundConsumer(rs.fieldByName("aroundConsumer")!=null?rs.fieldByName("aroundConsumer"):"");//附近企业
    temp.setLinkman_name(rs.fieldByName("linkman_name")!=null?rs.fieldByName("linkman_name"):"");//联系人名称
    temp.setLinkman_mobile(rs.fieldByName("linkman_mobile")!=null?rs.fieldByName("linkman_mobile"):"");//联系人手机
    
    
    
    String xingbie=(rs.fieldByName("linkman_sex")!=null?rs.fieldByName("linkman_sex"):"").trim();
    if("1".equals(xingbie)){
     xingbie="男";
    }else if("2".equals(xingbie)){
     xingbie="女";
    }
    temp.setLinkman_sex(xingbie);//联系人性别
    
    
    temp.setTrainerName(rs.fieldByName("trainerName")!=null?rs.fieldByName("trainerName"):"");//培训人名称
    temp.setTrainerPhone(rs.fieldByName("trainerPhone")!=null?rs.fieldByName("trainerPhone"):"");//培训人电话
    
    String txingbie=(rs.fieldByName("trainerSex")!=null?rs.fieldByName("trainerSex"):"").trim();
    if("1".equals(txingbie)){
     txingbie="男";
    }else if("2".equals(txingbie)){
     txingbie="女";
    }
    
    temp.setTrainerSex(txingbie);//培训人性别
    
    String state=(rs.fieldByName("state")!=null?rs.fieldByName("state"):"").trim();
    if("0".equals(state)){
     state="正常";
    }else if("9".equals(state)){
     state="注销";
    }
    temp.setState(state);//用户状态
    //是(137030300代表张店区，137030600代表周村区，137030500代表临淄区，137032100代表桓台县，137030200代表淄川区，137030400代表博山区，137032200代表高青县，137032300代表沂源县，137039200代表高新区。)
    String onServiceArea=(rs.fieldByName("onServiceArea")!=null?rs.fieldByName("onServiceArea"):"").trim();
    if("137030300".equals(onServiceArea)){
     onServiceArea="张店区";
    }else if("137030600".equals(onServiceArea)){
     onServiceArea="周村区";
    }else if("137030500".equals(onServiceArea)){
     onServiceArea="临淄区";
    }
    else if("137032100".equals(onServiceArea)){
     onServiceArea="桓台县";
    }else if("137030200".equals(onServiceArea)){
     onServiceArea="淄川区";
    }
    else if("137030400".equals(onServiceArea)){
     onServiceArea="博山区";
    }else if("137032200".equals(onServiceArea)){
     onServiceArea="高青县";
    }
    else if("137032300".equals(onServiceArea)){
     onServiceArea="沂源县";
    }else if("137039200".equals(onServiceArea)){
     onServiceArea="高新区";
    }
    
    temp.setOnServiceArea(onServiceArea);//区限
    
    String man=(rs.fieldByName("onServiceMan")!=null?rs.fieldByName("onServiceMan"):"").trim();
    String m[]=man.split("@");
    List l=searchzr(m[0],request);
    if(l.size()!=0){
     ZXForm fw = (ZXForm)l.get(0);
     temp.setOnServiceMan(fw.getName());//责任人
    }
    
    
    
    String c=(rs.fieldByName("consumerCharacter")!=null?rs.fieldByName("consumerCharacter"):"").trim();
    if("1".equals(c)){
     c="单机单片";
    }else if("2".equals(c)){
     c="主机共享";
    }
    temp.setConsumerCharacter(c);//用户性质
    
    list.add(temp);
   }
  } catch (Exception e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  finally {
   try {
    db.closeConn();
   } catch (Exception e) {
   }
  }
  return list;
 }
 /**
  * 责任人的查询
  * @param form
  * @param request
  * @param iFlag
  */
 
 public List searchzr(String id,HttpServletRequest request){
  dbConnect db = new dbConnect();
  db.getConnectionNew();
  List list = new ArrayList();
  String sWhereSQL = "";
  

  
  String SQLSelect = "";
 
 
 
  SQLSelect="select name  from  user_member  where 1=1";
  if (!"".equals(id)&&!(id==null))//责任表中的id
      sWhereSQL+=" and id = '"+id+"'";
  
  SQLSelect+=sWhereSQL;
  try {
   rs = db.runQueryNew(SQLSelect);
   while (rs.moveNext()) {
    ZXForm temp = new ZXForm();
    temp.setName(rs.fieldByName("name")!=null?rs.fieldByName("name"):"");//责任人名字
    list.add(temp);
   }
  } catch (Exception e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  finally {
   try {
    db.closeConn();
   } catch (Exception e) {
   }
  }
  return list;
 }