本项目是javaWeb和email结合的项目,模拟网站必须要激活邮箱账号才可以使用,
创建数据库
create table user(
id varchar(32) primary key,
name varchar(30),
pwd varchar(20),
email varchar(20),
active char(1),
acode varchar(32)
)
User.java值对象
package cn.hncu.reg.domain;
import javax.persistence.Table;
public class User {
private String id;
private String name;
private String pwd;
private String acode;
private String active;
private String email;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public String getAcode() {
return acode;
}
public void setAcode(String acode) {
this.acode = acode;
}
public String getActive() {
return active;
}
public void setActive(String active) {
this.active = active;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
@Override
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result + ((id == null) ? 0 : id.hashCode());
return result;
}
@Override
public boolean equals(Object obj) {
if (this == obj)
return true;
if (obj == null)
return false;
if (getClass() != obj.getClass())
return false;
User other = (User) obj;
if (id == null) {
if (other.id != null)
return false;
} else if (!id.equals(other.id))
return false;
return true;
}
}
C3p0Pool.java
package cn.hncu.pubs;
import java.sql.Connection;
import java.sql.SQLException;
import javax.sql.DataSource;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class C3p0Pool {
private static DataSource ds=new ComboPooledDataSource();;
private static ThreadLocal<Connection> tl=new ThreadLocal<Connection>();
public static Connection getCon() throws SQLException { Connection con = (Connection)tl.get();
if (con == null) {
con = ds.getConnection();
tl.set(con);
}
return con; }
public static DataSource getPool() {
return ds; }
public static ThreadLocal<Connection> getTl() {
return tl;
}
}
C3p0-config.xml
<c3p0-config>
<!-- 默认配置,如果没有指定则使用这个配置 -->
<default-config>
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">
<![CDATA[jdbc:mysql://127.0.0.1:3306/sstud?useUnicode=true&characterEncoding=UTF-8]]>
</property>
<property name="user">root</property>
<property name="password">1234</property>
<!-- 初始化池大小 -->
<property name="initialPoolSize">2</property>
<!-- 最大空闲时间 -->
<property name="maxIdleTime">30</property>
<!-- 最多有多少个连接 -->
<property name="maxPoolSize">10</property>
<!-- 最少几个连接 -->
<property name="minPoolSize">2</property>
<!-- 每次最多可以执行多少个批处理语句 -->
<property name="maxStatements">50</property>
</default-config>
<!-- 命名的配置 -->
<named-config name="hncu">
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://127.0.0.1:3306/sstud</property>
<property name="user">root</property>
<property name="password">1234</property>
<property name="acquireIncrement">5</property><!-- 如果池中数据连接不够时一次增长多少个 -->
<property name="initialPoolSize">100</property>
<property name="minPoolSize">50</property>
<property name="maxPoolSize">1000</property>
<property name="maxStatements">0</property>
<property name="maxStatementsPerConnection">5</property> <!-- he's important, but there's only one of him -->
</named-config>
</c3p0-config>
RegDAO.java
package cn.hncu.reg.dao;
import cn.hncu.reg.domain.User;
public interface RegDAO {
public User reg(User user);
public User active(String acode);
}
RegDaoJdbc.java
package cn.hncu.reg.dao;
import java.sql.SQLException;
import java.util.UUID;
import javax.sql.DataSource;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import cn.hncu.pool.C3p0Pool;
import cn.hncu.reg.domain.User;
public class RegDaoJdbc implements RegDAO{
@Override
public User reg(User user) {
DataSource ds=C3p0Pool.getPool();
QueryRunner qr=new QueryRunner(ds);
String sql="insert into user(id,name,pwd,email,active,acode) values(?,?,?,?,?,?)";
try {
String id=UUID.randomUUID().toString().replaceAll("-", "");
String acode=UUID.randomUUID().toString().replaceAll("-", "");
qr.update(sql,id,user.getName(),user.getPwd(),user.getEmail(),"0",acode);
user.setAcode(acode);
user.setId(id);
user.setActive("0");
} catch (SQLException e) {
// e.printStackTrace();
System.out.println("注册失败");
return null;
}
return user;
}
@Override
public User active(String acode) {
DataSource ds=C3p0Pool.getPool();
QueryRunner qr=new QueryRunner(ds);
String sql="select * from user where acode=?";
User user=null;
try {
user=qr.query(sql, new BeanHandler(User.class),acode);
if(user!=null){
sql="update user set active='1' ,acode=''where acode=?";
qr.update(sql,acode);
return user;
}
} catch (SQLException e) {
user=null;
e.printStackTrace();
}
return null;
}
}
IRegService.java
package cn.hncu.reg.service;
import cn.hncu.reg.domain.User;
public interface IRegService {
public User reg(User user);
public User active(String acode);
}
RegService.java
package cn.hncu.reg.service;
import cn.hncu.reg.dao.RegDAO;
import cn.hncu.reg.dao.RegDaoJdbc;
import cn.hncu.reg.domain.User;
public class RegService implements IRegService {
private RegDAO dao=new RegDaoJdbc();
@Override
public User reg(User user) {
return dao.reg(user);
}
@Override
public User active(String acode) {
return dao.active(acode);
}
}
RegServlet.java
package cn.hncu.reg.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import cn.hncu.reg.domain.User;
import cn.hncu.reg.sendMail.SendEMailThread;
import cn.hncu.reg.service.IRegService;
import cn.hncu.reg.service.RegService;
public class RegServlet extends HttpServlet {
private IRegService service=new RegService();
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.println("请按要求填写");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
PrintWriter out = response.getWriter();
String name=request.getParameter("name");
String pwd=request.getParameter("pwd");
String email=request.getParameter("email");
User user=new User();
user.setName(name);
user.setPwd(pwd);
user.setEmail(email);
user=service.reg(user);
if (user!=null) {
out.print("注册成功,请到邮箱验证");
new SendEMailThread(user.getAcode()).start();
}else{
out.print("注册失败");
}
}
}
SendEMailThread.java
package cn.hncu.reg.sendMail;
import java.util.Properties;
import javax.mail.Authenticator;
import javax.mail.Message.RecipientType;
import javax.mail.MessagingException;
import javax.mail.PasswordAuthentication;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.internet.AddressException;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeMessage;
import org.apache.log4j.Logger;
public class SendEMailThread extends Thread {
private String acode;
private Logger log=Logger.getLogger(SendEMailThread.class);
public SendEMailThread(String acode) {
this.acode = acode;
}
@Override
public void run() {
Properties p=new Properties();
p.setProperty("mail.host", "smtp.sina.com");
p.setProperty("mail.smtp.auth", "true");
Session session=Session.getDefaultInstance(p, new Authenticator() {
@Override
protected PasswordAuthentication getPasswordAuthentication() {
PasswordAuthentication pa=new PasswordAuthentication("hncujava", "1234567");
return pa;
}
});
session.setDebug(true);
MimeMessage msg=new MimeMessage(session);
try {
msg.setFrom( new InternetAddress("hncujava@sina.com") );
msg.setRecipient(RecipientType.TO, new InternetAddress("747205398@qq.com"));
msg.setSubject("激活hncu账号");
StringBuilder sb=new StringBuilder();
sb.append("请激活邮箱:<a href='http://127.0.0.1:8080/mailWeb/ActiveServlet");
sb.append("?acode="+acode+" '>点击激活</a>");
sb.append("<br/>如果激活未成功,请复制下面地址到浏览器地址栏进行手动激活:");
sb.append("http://www.hncu.cn/mailWeb/ActiveServlet?acode="+acode);
msg.setContent(sb.toString(),"text/html;charset=utf-8");
Transport.send(msg);
log.info("邮件发送成功");
} catch (AddressException e) {
log.error("邮箱地址错误,邮件发送失败");
e.printStackTrace();
} catch (MessagingException e) {
e.printStackTrace();
log.error("邮箱信息格式错误,邮件发送失败");
}
}
}
ActiveServlet.java
package cn.hncu.reg.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import cn.hncu.reg.domain.User;
import cn.hncu.reg.service.IRegService;
import cn.hncu.reg.service.RegService;
public class ActiveServlet extends HttpServlet {
private IRegService service=new RegService();
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
PrintWriter out = response.getWriter();
String acode=request.getParameter("acode");
User user=service.active(acode);
request.setAttribute("user", user);
System.out.println("user:"+user);
request.getRequestDispatcher("/jsps/result.jsp").forward(request, response);
}
}
index.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>邮箱登录</title>
<script type="text/javascript">
function reg(){
document.forms[0].action='<c:url value="/jsps/reg.jsp"/>';
document.forms[0].submit();
}
function login(){
document.forms[0].action='<c:url value="/LoginServlet"/>';
document.forms[0].submit();
}
</script>
</head>
<body>
<c:if test="${!empty error }">
登录失败
<c:remove var="error" scope="session"/>
</c:if>
<c:if test="${empty sessionScope.user }" var="boo">
<h3>用户注册</h3>
<form action="" method="post" >
姓名:<input type="text" name="name" value="wang"/><br/>
密码:<input type="text" name="pwd" value="1234"/><br/>
<input type="button" value="登录" onclick="login();"/>
<input type="button" value="注册" onclick="reg();"/><br/>
</form>
</c:if>
<c:if test="${!boo }">
欢迎回来,${ sessionScope.user.name}
</c:if>
</body>
</html>
reg.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>邮箱注册系统</title>
<script type="text/javascript">
function reg(){
document.forms[0].action='<c:url value="/RegServlet"/>';
document.forms[0].submit();
}
function login(){
document.forms[0].action='<c:url value="/LoginServlet"/>';
document.forms[0].submit();
}
</script>
</head>
<body>
<c:if test="${empty sessionScope.user }" var=" boo">
<h3>用户注册</h3>
<form action="" method="post" >
姓名:<input type="text" name="name" value="wang"/><br/>
密码:<input type="text" name="pwd" value="1234"/><br/>
邮箱:<input type="text" name="email" value="747205398@qq.com"/> <br/>
<input type="button" value="注册" onclick="reg();"/><br/>
</form>
</c:if>
</body>
</html>
result.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<script type="text/javascript">
var tm;
var time=5;
function start(){
div1.innerHTML="将在"+time+"秒跳转";
time--;
if(time<=1){
window.clearInterval(tm);
window.location.href="<c:url value='/index.jsp'/>";
}
}
onload=function(){
tm=window.setInterval(start, 1000);
};
</script>
</head>
<body>
<c:if test="${!empty requestScope.user }" var=" boo">
恭喜注册成功!请登录
<a href='<c:url value="/index.jsp" />'>登录</a><br/><br/>
<div id ="div1">
</div>
</c:if>
<c:if test="${boo}">
注册失败,请重新激活
</c:if>
</body>
</html>
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.0"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
<display-name></display-name>
<filter>
<filter-name>charset</filter-name>
<filter-class>cn.hncu.filter.CharacterFilter</filter-class>
<init-param>
<param-name>charset</param-name>
<param-value>utf-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>charset</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<servlet>
<description>This is the description of my J2EE component</description>
<display-name>This is the display name of my J2EE component</display-name>
<servlet-name>RegServlet</servlet-name>
<servlet-class>cn.hncu.reg.servlet.RegServlet</servlet-class>
</servlet>
<servlet>
<description>This is the description of my J2EE component</description>
<display-name>This is the display name of my J2EE component</display-name>
<servlet-name>ActiveServlet</servlet-name>
<servlet-class>cn.hncu.reg.servlet.ActiveServlet</servlet-class>
</servlet>
<servlet>
<description>This is the description of my J2EE component</description>
<display-name>This is the display name of my J2EE component</display-name>
<servlet-name>LoginServlet</servlet-name>
<servlet-class>cn.hncu.login.LoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>RegServlet</servlet-name>
<url-pattern>/RegServlet</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>ActiveServlet</servlet-name>
<url-pattern>/ActiveServlet</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>LoginServlet</servlet-name>
<url-pattern>/LoginServlet</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
需要的jar包
c3p0-0.9.1.2.jar
commons-dbutils-1.4.jar
java-mail-1.4.4.jar
mysql-connector-java-5.1.34-bin.jar
myConUtil.jar