如何拆分值和更新查询

r1zk6ea1  于 2021-06-30  发布在  Java
关注(0)|答案(2)|浏览(286)
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()+"-->"+beanObj.getAppr2Id()+"-->"+beanObj.getAwaitingAppr()+"-->"+beanObj.getClaimStatus()+"-->"+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";

    }

现在stmt.setstring(3,claimdetailsbean.getducode());从动作方法值#1得到值我需要拆分此值(值#1)并只更新查询值。我不想#1如何分割和更新请任何人帮助???

jv2fixgn

jv2fixgn1#

您可以简单地在java中使用split函数

public String[] split(String regex, int limit)

public String[] split(String regex)
qv7cva1a

qv7cva1a2#

可以使用子字符串

claimDetailsBean.getDucode().substring(0, claimDetailsBean.getDucode().indexOf("#"))

您可以在单独的变量中取出claimdetailsbean.getducode(),并在ducode可以为null的情况下明确检查null。

相关问题