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如何分割和更新请任何人帮助???
2条答案
按热度按时间jv2fixgn1#
您可以简单地在java中使用split函数
或
qv7cva1a2#
可以使用子字符串
您可以在单独的变量中取出claimdetailsbean.getducode(),并在ducode可以为null的情况下明确检查null。