在登录页面中js进行正则验证电话号码和邮箱地址，并使用ajax进行用户ID的数据库验证

本文说的是在登录页面中使用js进行正则验证并使用ajax进行用户ID的数据库验证，另外也加入键盘监听。

先看一下登录的jsp页面代码

package org.ml.drp.sysmgr.manager;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Timestamp;import java.util.Date;import org.ml.drp.sysmgr.domain.User;import org.ml.drp.util.DbUtil;public class UserManager {private static UserManager instance = null;/** * 私有化的无参构造方法 */private UserManager(){}/** * 取得UserManager实例化对象 * @return */public static UserManager getInstance(){if(instance==null){instance = new UserManager();}return instance;}/** * 添加用户信息 * @param user * @return */public boolean addUser(User user){boolean flag = false; Connection conn = null;PreparedStatement pstmt = null;String sql = "insert into t_user(user_id,user_name,password,contact_tel,email,create_date) values(?,?,?,?,?,?)"; try {conn = DbUtil.getConnection();pstmt = conn.prepareStatement(sql);pstmt.setString(1, user.getUserId());pstmt.setString(2, user.getUserName());pstmt.setString(3, user.getPassword());pstmt.setString(4, user.getContactTel());pstmt.setString(5, user.getEmail());pstmt.setTimestamp(6, new Timestamp(new Date().getTime()));if(pstmt.executeUpdate()>0){flag = true;//添加成功}} catch (SQLException e) { // TODO Auto-generated catch blocke.printStackTrace();}finally{DbUtil.close(conn);//关闭数据库连接DbUtil.close(pstmt);//关闭prepareStatementd对象} return flag;}/** * 根据用户ID查找用户 * @param userId * @return */public User findUserById(String userId){User user = null;String sql = "select user_name,password,contact_tel,email,create_date from t_user where user_id=?";Connection conn = null;PreparedStatement pstmt = null;ResultSet rs = null;try {conn = DbUtil.getConnection();pstmt = conn.prepareStatement(sql);pstmt.setString(1, userId);rs = pstmt.executeQuery();if(rs.next()){user = new User();user.setUserId(userId);user.setUserName(rs.getString(1));user.setPassword(rs.getString(2));user.setContactTel(rs.getString(3));user.setEmail(rs.getString(4));user.setCreateDate(rs.getTimestamp(5));}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{DbUtil.close(conn);//关闭数据库连接DbUtil.close(pstmt);//关闭prepareStatementd对象}   return user;}}

这里只是进行了简单的记录，只粘贴了代码，没做过多说明，有兴趣的可以慢慢看吧，还有如果要看数据库实现数据库连接操作类的代码的可以看看这篇http://blog.csdn.net/cselmu9/article/details/7844235文章，这里面有完整数据库连接操作代码，这里就不贴出来了。