sq语句l同时修改国地税密码

最新推荐文章于 2020-08-11 21:44:32 发布

木槿开成万花町c

最新推荐文章于 2020-08-11 21:44:32 发布

阅读量758

点赞数 1

分类专栏： mysql

本文链接：https://blog.csdn.net/mchgogo/article/details/51489798

版权

mysql 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

   String password;
    String nsrsbh;
    String username;
    String djxh;
    String gssql ="";
    String dssql ="";
    for (int i = 0; i < pwdList.size(); i++)
    {
     JSONObject pwdJo = JSONObject.fromObject(pwdList.get(i));
     password = PasswordUtil.encryptPasswordMD5(pwdJo.getString("password"));
     nsrsbh = pwdJo.getString("nsrsbh");
     username = pwdJo.getString("userName");
     djxh = pwdJo.getString("djxh");

String ds="10126";//国税
     String gs="10116";//地税
     logger.info(djxh.substring(0, 5));
    if(djxh.substring(0, 5).equals(ds)){
     gssql= "update nd_dj_wbzcxx set pwd='"+password+"' where djxh=(select t.djxh_gs from nd_dj_gdsnsrdz t where t.djxh_ds like '"+djxh+"') and username='"+username+"'";

     dssql= "update nd_dj_wbzcxx set pwd='"+password+"' where djxh='"+djxh+"' and username='"+username+"'";
       }else {
       dssql= "update nd_dj_wbzcxx set pwd='"+password+"' where djxh=(select t.djxh_ds from nd_dj_gdsnsrdz t where t.djxh_gs like '"+djxh+"') and username='"+username+"'";
       gssql= "update nd_dj_wbzcxx set pwd='"+password+"' where djxh='"+djxh+"' and username='"+username+"'";
    }
     logger.info("========gssql000==========="+gssql);
     logger.info("========dssql001========="+dssql);
     pdao.execute(gssql, null, tx);
     pdao.execute(dssql, null, tx);

    }
    tx.commit();

    map.put("success", true);