Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //查找网点负责人的邮箱 单独发送核查指令
- 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'";
- sqlParas =new ArrayList<SQLPara>();
- sqlParas.add(new SQLPara("ORG_NO", Types.VARCHAR, checkObject));
- CachedRowSet principalResult = DbOperate.executeQueryByParamName(qryPrincipal, sqlParas, conn, logger);
- String principal = "";
- while(principalResult.next()) {
- principal = principalResult.getString("EMAIL");
- }
- logger.debug("principal:"+principal);
- String[] accessory = {};
- String cont = "于"+checkDate+",将有人核查贵机构,请先自行核查";
- SendmailUtil sendmailUtil = new SendmailUtil(charSet, isHtml);
- sendmailUtil.connect("mail.zjft.com", logger);
- logger.debug("NoticeMailSndOpstep->连接创建完成...");
- sendmailUtil.send("xuhe02@zjft.com", principal, ADDTO, HIDETO, "核查指令", cont, accessory, logger);
Add Comment
Please, Sign In to add comment