java结合email实现自动推送功能
作者:关凯华 时间:2023-07-09 00:16:43
1、获取表中最后一条数据
public static String demo() throws SQLException {
String sql = "select * FROM baoxiu ORDER BY id DESC LIMIT 0,1;";
PreparedStatement ptmt = conn.prepareStatement(sql);
ResultSet rs = ptmt.executeQuery();
String str=null;
if(rs.next()) {
str= rs.getString("bt");
}
return str;
}
2、使用模糊查询,获取符合条件的所有数据
public static List<DuibiModel> getBaoX(String bt) throws SQLException {
String sql = "select bt,`user`.cardid,phone FROM baoxiu,`user` WHERE baoxiu.cardid=`user`.cardid AND bt LIKE '%"+bt+"%'";
PreparedStatement ptmt = conn.prepareStatement(sql);
ResultSet rs = ptmt.executeQuery();
List<DuibiModel> list = new ArrayList<>() ;
while(rs.next()) {
DuibiModel duibi=new DuibiModel();
duibi.setBt(rs.getString("bt"));
duibi.setCardid(rs.getString("cardid"));
duibi.setPhone(rs.getString("phone"));
list.add(duibi);
}
return list;
}
3、Java 发送邮件
import javax.mail.Authenticator;
import javax.mail.PasswordAuthentication;
public class Auth extends Authenticator {
private String username = "";
private String password = "";
public Auth(String username, String password) {
this.username = username;
this.password = password;
}
public PasswordAuthentication getPasswordAuthentication() {
return new PasswordAuthentication(username, password);
}
}
import java.util.Properties;
import javax.mail.Message;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeMessage;
public class SendMail {
private Properties props; //系统属性
private Session mailSession; //邮件会话对象
private MimeMessage mimeMsg; //MIME邮件对象
public SendMail(String SMTPHost, String Port, String MailUsername, String MailPassword) {
Auth au = new Auth(MailUsername, MailPassword);
//设置系统属性
props=java.lang.System.getProperties(); //获得系统属性对象
props.put("mail.smtp.host", SMTPHost); //设置SMTP主机
props.put("mail.smtp.port", Port); //设置服务端口号
props.put("mail.smtp.auth", "true"); //同时通过验证
//获得邮件会话对象
mailSession = Session.getInstance(props, au);
}
public boolean sendingMimeMail(String MailFrom, String MailTo,
String MailCopyTo, String MailBCopyTo, String MailSubject,
String MailBody) {
try {
//创建MIME邮件对象
mimeMsg=new MimeMessage(mailSession);
//设置发信人
mimeMsg.setFrom(new InternetAddress(MailFrom));
//设置收信人
if(MailTo!=null){
mimeMsg.setRecipients(Message.RecipientType.TO, InternetAddress.parse(MailTo));
}
//设置抄送人
if(MailCopyTo!=null){
mimeMsg.setRecipients(javax.mail.Message.RecipientType.CC,InternetAddress.parse(MailCopyTo));
}
//设置暗送人
if(MailBCopyTo!=null){
mimeMsg.setRecipients(javax.mail.Message.RecipientType.BCC,InternetAddress.parse(MailBCopyTo));
}
//设置邮件主题
mimeMsg.setSubject(MailSubject,"utf-8");
//设置邮件内容,将邮件body部分转化为HTML格式
mimeMsg.setContent(MailBody,"text/html;charset=utf-8");
//发送邮件
Transport.send(mimeMsg);
return true;
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
}
public static boolean email(String email,String str) {
String SMTPHost="smtp.qq.com";
String Port="25";
String MailUsername="gkh35@foxmail.com"; //直接用我的邮件进行发送测试
String MailPassword="wggddlvcrqfubhde"; //密码请勿修改
SendMail sendMail=new SendMail(SMTPHost,Port,MailUsername,MailPassword);
String MailFrom="gkh35@foxmail.com"; //发件人
String MailTo=email; //收件人
String MailCopyTo=null; //抄送人
String MailBCopyTo=null; //暗送人
String MailSubject="发现类似商品"; //邮件主题
String MailBody=str; //邮件内容
//发送邮件
boolean isSend=sendMail.sendingMimeMail(MailFrom, MailTo, MailCopyTo, MailBCopyTo, MailSubject, MailBody);
return isSend;
}
4、main方法
public static void main(String[] args) throws SQLException {
boolean flag = false;
String str=demo();
for(DuibiModel duibiModel : getBaoX(str)) {
System.out.println("名称为:"+duibiModel.getBt()+","+"身份证号:"+duibiModel.getCardid()+","+"电话号码为:"+duibiModel.getPhone());
flag=email("gkh8299@gmail.com", duibiModel.getBt());
}
if(flag) {
System.out.println("邮件发送成功");
}else {
System.out.println("邮件发送失败");
}
}
来源:https://www.cnblogs.com/gkh35/archive/2020/03/30/12564286.html
标签:java,email,推送
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
Spring中propagation的7种事务配置及说明
2023-01-02 09:47:26
![](https://img.aspxhome.com/file/2023/9/70539_0s.jpg)
lambda表达式解决java后台分组排序过程解析
2023-11-29 06:03:39
MySQL+SSM+Ajax上传图片问题
2023-01-26 04:22:52
![](https://img.aspxhome.com/file/2023/4/62974_0s.png)
Android自定义单选多选下拉列表的实例代码
2022-06-08 15:53:33
![](https://img.aspxhome.com/file/2023/9/102589_0s.gif)
RxJava+Retrofit+OkHttp实现多文件下载之断点续传
2023-07-19 22:32:35
![](https://img.aspxhome.com/file/2023/5/137465_0s.gif)
MyBatis resultMap id标签的错误使用方式
2022-02-01 05:25:37
![](https://img.aspxhome.com/file/2023/6/128916_0s.jpg)
java 中http请求为了防止乱码解决方案
2023-08-09 07:59:33
C语言深入浅出解析二叉树
2022-05-12 11:28:21
![](https://img.aspxhome.com/file/2023/1/117761_0s.png)
Java中 ? extends T 和 ? super T的理解
2022-06-26 19:50:23
详解C# Socket异步通信实例
2022-08-27 14:27:22
java将一个目录下的所有数据复制到另一个目录下
2023-01-08 15:11:44
Java接口DAO模式代码原理及应用详解
2023-06-21 05:29:04
![](https://img.aspxhome.com/file/2023/0/72570_0s.png)
Java string类型转换成map代码实例
2021-06-07 12:19:29
![](https://img.aspxhome.com/file/2023/3/88753_0s.png)
Android中基于XMPP协议实现IM聊天程序与多人聊天室
2022-05-06 07:37:51
![](https://img.aspxhome.com/file/2023/6/123366_0s.jpg)
android实现可自由移动、监听点击事件的悬浮窗
2022-04-12 14:15:31
UE4 Unlua 调用异步蓝图节点AIMoveTo函数示例详解
2022-04-12 05:35:41
C# 9.0新特性——扩展方法GetEnumerator支持foreach循环
2021-08-27 22:38:09
Springcloud seata分布式事务实现代码解析
2022-12-27 20:14:01
![](https://img.aspxhome.com/file/2023/0/66050_0s.png)
Java数据结构之线索化二叉树的实现
2022-03-16 15:25:34
![](https://img.aspxhome.com/file/2023/1/75021_0s.png)
java 获取日期的几天前,几个月前和几年前的实例
2023-05-20 15:29:53