title: How to split value and update query
body: <pre><code> public static String DuStatusinactiveanddeactive(EmpBean empBeanObj,
                                                  ClaimDetailsBean claimDetailsBean,
                                                   HttpServletRequest request) throws SQLException {
          // To get Employee Details from cdm master
  
  
  
  
          String query = "update GEMS_DELIVERY_UNIT  set isActive=? , TRANS_USER=? where DU_ID=?";
          Connection conn = null;
          conn = DAO.getMsSqlConnection();
          PreparedStatement stmt = null;
          //System.out.println("came into upgradeClaim"+beanObj.getAppr1Id()+"--&gt;"+beanObj.getAppr2Id()+"--&gt;"+beanObj.getAwaitingAppr()+"--&gt;"+beanObj.getClaimStatus()+"--&gt;"+beanObj.getClaimId());
          try{
               stmt = (PreparedStatement) conn.prepareStatement(query);
               stmt.setString(1,claimDetailsBean.getDustatus());
               System.out.println("ss"+claimDetailsBean.getDustatus());
               stmt.setString(2,empBeanObj.getEmpId());
                System.out.println("emp"+empBeanObj.getEmpId());
  
               stmt.setString(3,claimDetailsBean.getDucode());
                 System.out.println("ducode"+claimDetailsBean.getDucode());
  
  
  
  
  
  
  
  
  
  //where du_id=arr[0];
  
  
              System.out.println(query);
              stmt.executeUpdate();
          }catch(Exception e){
              e.printStackTrace();
              return "fail";
          }
          return "Success";
  
  
  
  
  
      }
  </code></pre>
  
  <p>now  stmt.setString(3,claimDetailsBean.getDucode()); come to value from action method  value#1 i need split this (value#1) and update query value only. i dont want #1
  how to split and update please any one help???</p>