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 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="";
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="";
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;
}