java实现邮件验证实现程序代码

Transact-SQL
create database if not exists mail;
use mail;
drop table if exists student;
create table student(
stu_name varchar(20) primary key,
stu_password varchar(50) not null,
stu_email varchar(50) not null
);
use mail;
drop table if exists verify;
create table verify(
stu_name varchar(20) primary key,
stu_nameMd5 varchar(50) not null,
randMd5 varchar(50) not null
);

op con Java
package bean;
import java.sql.*;
public class ConDB {
 private Connection con;
 private Statement sta;
 private ResultSet res;
 private PreparedStatement pres;
 public ConDB() throws SQLException,ClassNotFoundException{
  Class.forName("com.mysql.jdbc.Driver");
   con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mail",
     "root","123456");
   sta=con.createStatement();
 }
    public void addStudentTemp(String stu_name,String stu_password,String stu_email)
    throws SQLException{
     String sql="insert into studentTemp values(?,?,?)";
     pres=con.prepareStatement(sql);
     pres.setString(1,stu_name);
     pres.setString(2,stu_password);
     pres.setString(3,stu_email);
     pres.executeUpdate();
    }
    public void addVerify(String stu_name,String stu_nameMd5,String randMd5)
    throws SQLException{
     String sql="insert into verify values(?,?,?)";
     pres=con.prepareStatement(sql);
     pres.setString(1,stu_name);
     pres.setString(2,stu_nameMd5);
     pres.setString(3,randMd5);
     pres.executeUpdate();
    }
    public void delVerify(String stu_name)
    throws SQLException{
     String sql="delete from verify where stu_name='"+stu_name+"'";
     sta.executeUpdate(sql);
    }
    public String getVerify(String stu_nameMd5,String randMd5)
    throws SQLException{
     String stu_name=null;
     String sql="select stu_name from verify where stu_nameMd5=? and randMd5=?";
     pres=con.prepareStatement(sql);
     pres.setString(1,stu_nameMd5);
     pres.setString(2,randMd5);
     res=pres.executeQuery();
     while(res.next()){
      stu_name=res.getString("stu_name");
     }
     return stu_name;
    }
    public void addStudent(String stu_name)
    throws SQLException{
     String sql="insert into student select * from studentTemp where stu_name='"+stu_name+"'";
     sta.executeUpdate(sql);
    }
    public String getStu_name(String stu_email)
    throws SQLException{
     String sql="select stu_name from student where stu_email='"+stu_email+"'";
     String stu_name=null;
     res=sta.executeQuery(sql);
     while(res.next()){
      stu_name=res.getString("stu_name");
     }
    return stu_name;
    }
    public void resetPassword(String stu_name,String stu_password)
    throws SQLException{
     String sql="update student set stu_password=? where stu_name=?";
     pres=con.prepareStatement(sql);
     pres.setString(1,stu_password);
     pres.setString(2,stu_name);
     pres.executeUpdate();
    }
    public boolean existStudent(String stu_name,String stu_password)
    throws SQLException{
     boolean exist=false;
     String sql="select * from student where stu_name=? and stu_password=?";
     pres=con.prepareStatement(sql);
     pres.setString(1,stu_name);
     pres.setString(2,stu_password);
     res=pres.executeQuery();
     if(res.next()){
      exist=true;
     }
     return exist;
    }
    public void addReset(String stu_name,String stu_nameMd5,
      String randMd5)
    throws SQLException {
     String sql="insert into reset(stu_name,stu_nameMd5,randMd5) values(?,?,?)";
      pres=con.prepareStatement(sql);
     pres.setString(1,stu_name);
     pres.setString(2,stu_nameMd5);
     pres.setString(3,randMd5);
     pres.executeUpdate();
    }
    public void delReset(String stu_name)
    throws SQLException {
     String sql="delete from reset where stu_name='"+stu_name+"'";
     sta.execute(sql);
    }
    public String getLegalReset(String stu_nameMd5,String randMd5)
    throws SQLException {
     String stu_name=null;
     String sql="select stu_name, timestampdiff(hour,sent_time,now()) as hours from reset where stu_nameMd5=? and randMd5=?";
     pres=con.prepareStatement(sql);
     pres.setString(1,stu_nameMd5);
     pres.setString(2,randMd5);
     res=pres.executeQuery();
     if(res.next()){
      stu_name=res.getString("stu_name");
      int h=res.getInt("hours");
      if(h<=24){
       return stu_name;
      }
     }
     return stu_name;
    }
 public void close()
 throws SQLException {
 {
  if (res != null) {
    res.close();
  }
  if (sta != null) {
    sta.close();
  }
  if (con != null) {
    con.close();
    con = null;
  }
 }
 }
}

sendVerifyMail Java
package bean;
import java.util.*;
import javax.mail.Session;
import javax.mail.Message;
import javax.mail.internet.MimeMessage;
import javax.mail.internet.InternetAddress;
import javax.mail.Message.RecipientType;
import javax.mail.Transport;
import javax.mail.MessagingException;
public class sendMail {
 String username="[email protected]";
 private Message getMessage(){
  Properties p=new Properties();
  p.put("mail.transport.protocol","smtp");
  p.put("mail.smtp.host","smtp.163.com");
  p.put("mail.smtp.port","25");
  p.put("mail.smtp.auth","true");
  String password="20083111tian";
  MyAuthor auth=new MyAuthor(username,password);
  Session session=Session.getDefaultInstance(p,auth);
  Message message=new MimeMessage(session);
  return message;
 }
 public void sendVerify(String stu_email,String stu_nameMd5,String randMd5)
 throws MessagingException {
  Message message=getMessage();
   message.setFrom(new InternetAddress(username));
   message.setRecipient(RecipientType.TO,new InternetAddress(stu_email));
   message.setSentDate(new Date());
   message.setSubject("MailVerify");
   String m="" +
     "http:/127.0.01:8080/Mail/mailVerify?stu_nameMd5="+stu_nameMd5+"&randMd5="+randMd5+"";
   message.setContent(m,"text/html;charset=gb2312");
   Transport.send(message);
  }
 public void sendReset(String stu_email,String stu_nameMd5,String randMd5)
 throws MessagingException {
  Message message=getMessage();
  message.setFrom(new InternetAddress(username));
  message.setRecipient(RecipientType.TO,new InternetAddress(stu_email));
  message.setSentDate(new Date());
  message.setSubject("MailVerify");
  String m="" +
    "http://127.0.01:8080/Mail/mailReset?stu_nameMd5="+stu_nameMd5+"&randMd5="+randMd5+"";
  message.setContent(m,"text/html;charset=gb2312");
  Transport.send(message);
 }
}

mailVerify Java
package servlet;
import java.io.IOException;
import javax.servlet.http.*;
import javax.servlet.ServletException;
import java.sql.SQLException;
import bean.*;
public class mailVerify extends HttpServlet {
 public void doGet(HttpServletRequest request,
   HttpServletResponse response)
 throws ServletException,IOException {
  doPost(request,response);
 }
 public void doPost(HttpServletRequest request,
   HttpServletResponse response)
 throws ServletException,IOException {
  ConDB con;
  String stu_name;
  String msg;
  HttpSession session=request.getSession();
  String stu_nameMd5=request.getParameter("stu_nameMd5");
  String randMd5=request.getParameter("randMd5");
  try {
   con=new ConDB();
   stu_name=con.getVerify(stu_nameMd5,randMd5);
   if(stu_name!=null){
    msg="注册成功,请返回登录页面";
    con.addStudent(stu_name);
    con.delStudentTemp(stu_name);
    con.delVerify(stu_name);
   }else{msg="错误";}
   con.close();
   session.setAttribute("msg",msg);
   response.sendRedirect("result.jsp");
  }catch(ClassNotFoundException e){
   throw new ServletException(e.fillInStackTrace());
  }catch(SQLException e){
   throw new ServletException(e.fillInStackTrace());
  }
 }
}

resetInfo Java
public void delVerify(String stu_name)
    throws SQLException{
     String sql="delete from verify where stu_name='"+stu_name+"'";
     sta.executeUpdate(sql);
    }
    public String getVerify(String stu_nameMd5,String randMd5)
    throws SQLException{
     String stu_name=null;
     String sql="select stu_name from verify where stu_nameMd5=? and randMd5=?";
     pres=con.prepareStatement(sql);
     pres.setString(1,stu_nameMd5);
     pres.setString(2,randMd5);
     res=pres.executeQuery();
     while(res.next()){
      stu_name=res.getString("stu_name");
     }
     return stu_name;
    }
    public void addStudent(String stu_name)
    throws SQLException{
     String sql="insert into student select * from studentTemp where stu_name='"+stu_name+"'";
     sta.executeUpdate(sql);
    }
    public String getStu_name(String stu_email)
    throws SQLException{
     String sql="select stu_name from student where stu_email='"+stu_email+"'";
     String stu_name=null;
     res=sta.executeQuery(sql);
     while(res.next()){
      stu_name=res.getString("stu_name");
     }
    return stu_name;
    }
    public void resetPassword(String stu_name,String stu_password)
    throws SQLException{
     String sql="update student set stu_password=? where stu_name=?";
     pres=con.prepareStatement(sql);
     pres.setString(1,stu_password);
     pres.setString(2,stu_name);
     pres.executeUpdate();
    }
    public boolean existStudent(String stu_name,String stu_password)
    throws SQLException{
     boolean exist=false;
     String sql="select * from student where stu_name=? and stu_password=?";
     pres=con.prepareStatement(sql);
     pres.setString(1,stu_name);
     pres.setString(2,stu_password);
     res=pres.executeQuery();
     if(res.next()){
      exist=true;
     }
     return exist;
    }