Guest User

Untitled

a guest
Dec 14th, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. //查找网点负责人的邮箱 单独发送核查指令
  2. String qryPrincipal = "select su.EMAIL from SYS_ORG_PRINCIPAL sop left join SYS_USER su on sop.USER_NO=su.NO where sop.ORG_NO=? and sop.PRINCIPAL_TYPE = '1'";
  3. sqlParas =new ArrayList<SQLPara>();
  4. sqlParas.add(new SQLPara("ORG_NO", Types.VARCHAR, checkObject));
  5. CachedRowSet principalResult = DbOperate.executeQueryByParamName(qryPrincipal, sqlParas, conn, logger);
  6. String principal = "";
  7. while(principalResult.next()) {
  8. principal = principalResult.getString("EMAIL");
  9. }
  10. logger.debug("principal:"+principal);
  11.  
  12. String[] accessory = {};
  13.  
  14. String cont = "于"+checkDate+",将有人核查贵机构,请先自行核查";
  15.  
  16. SendmailUtil sendmailUtil = new SendmailUtil(charSet, isHtml);
  17.  
  18.  
  19. sendmailUtil.connect("mail.zjft.com", logger);
  20.  
  21. logger.debug("NoticeMailSndOpstep->连接创建完成...");
  22.  
  23. sendmailUtil.send("xuhe02@zjft.com", principal, ADDTO, HIDETO, "核查指令", cont, accessory, logger);
Add Comment
Please, Sign In to add comment