JAVA邮件发送系统项目

package DAO; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; import java.util.Properties; import javax.mail.Message; import javax.mail.MessagingException; import javax.mail.Session; import javax.mail.Transport; import javax.mail.internet.AddressException; import javax.mail.internet.InternetAddress; import javax.mail.internet.MimeMessage; import Sendmail.suiji; public class SendqqDAO { Connection con = null; Statement stmt = null; String oracleURL = "jdbc:oracle:thin:@192.168.1.103:1521:zxora"; //数据库的库名 密码等 String ousername = "qiubo"; String opassword = "qiubo"; String host = "smtp.126.com"; //定义发送用户帐号密码 String from ="qb888_0451@126.com"; String user = "qb888_0451@126.com"; String password = "7802421901"; public boolean send(int startq,int stopq){ boolean ioke = false; suiji sui = new suiji(); try { Class.forName("oracle.jdbc.driver.OracleDriver"); //取得数据库的连接 con = DriverManager.getConnection(oracleURL, ousername, opassword); stmt = con.createStatement(); System.out.println("连接数据库"); Properties pro = new Properties(); pro.put("mail.smtp.host", host); pro.put("mail.smtp.auth", "true"); Session session = Session.getDefaultInstance(pro); session.setDebug(true); for (int i = startq; i <= stopq; i++) { //循环重JSP页面的开始到最后的结束 String to = i + "@qq.com"; //定义QQ邮箱 MimeMessage message = new MimeMessage(session); //定义重哪个邮箱到哪个邮箱的地址和内容 message.setFrom(new InternetAddress(from)); message.addRecipient(Message.RecipientType.TO, new InternetAddress(to)); message.setSubject("西恩邀请你加盟"+sui.random()); message.setText("让你听说西恩的网站"); message.saveChanges(); Transport tran = session.getTransport("smtp"); //通过SMTP效验用户，密码等进行连接 tran.connect(host, user, password); tran.sendMessage(message, message.getAllRecipients()); tran.close(); String query = "insert into email values(seq_emailid.nextval, '" //定义UPDATE语句 + from + "', '"+to+"')"; int res = stmt.executeUpdate(query); if(res == 1){ ioke = true; } System.out.println(query); } } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (AddressException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (MessagingException e) { // TODO Auto-generated catch block e.printStackTrace(); } return ioke; } }