房产信息管理系统--注册功能实现
房产信息管理系统--注册功能实现
总实现:test房产信息管理系统 - yuanse - 博客园 (cnblogs.com)
注册功能需要注意身份证和手机号的验证,我没有对输入的地址进行判断是否合理。
1.yemian.jsp(登录页面,可以选择注册)
<%-- Created by IntelliJ IDEA. User: 22466 Date: 2022/11/19 Time: 18:53 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>yemian.jsp</title> </head> <%--用户登录页面:选择登录身份,账户密码校验,跳转指定的功能页面--%> <body> <h2 align="center" >用户登录页面</h2> <table align="center" width="400" > <form id="yemianForm" method="post" action="yemianServlet"> <tr> <td> 账号:<input type="text" name="uname"> </td> </tr> <tr> <td>密码:<input type="password" name="upwd"></td> </tr> <tr> <td>身份:<input type="radio" name="type" value="顾客" checked>顾客 <input name="type" type="radio" value="房产经理">房产经理 <input name="type" type="radio" value="系统管理员">系统管理员</tr></td><tr> <td><span style="font-size: 16px;color: red" >${msg}</span></td></tr> <tr> <td> <button>登录</button> <button type="button" onclick="register()">注册</button> </td> </tr> </form> </table> <script type="text/javascript" src="js/jquery-3.6.1.js"></script> <script type="text/javascript"> function register(){ window.location="register.jsp"; } </script> </body> </html>
2.register.jsp(用户注册页面)
<%-- Created by IntelliJ IDEA. User: 22466 Date: 2022/11/27 Time: 17:20 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>register.jsp</title> </head> <%--用户注册页面--%> <body> <table align="center" width="800"> <form method="post" action="registerServlet" name="registerForm" id="registerForm"> <tr> <td>身份证号</td> <td><input type="text" name="usidnum" id="usidnum"> </td> </tr> <tr> <td>姓名</td> <td><input type="text" name="usname" id="usname"></td> </tr> <tr> <td>性别</td> <td><input type="radio" name="ussex" value="男">男 <input type="radio" name="ussex" value="女">女 </td> </tr> <tr> <td>手机号</td> <td><input type="text" name="usphone" id="usphone"> </td> </tr> <tr> <td>家庭住址</td> <td><input type="text" name="usaddress" id="usaddress"></td> </tr> <tr align="center"> <td colspan="2"><button type="button" id="tijiao">提交</button> </td> </tr> </form> </table> <script type="text/javascript" src="js/jquery-3.6.1.js"></script> <script type="text/javascript"> $("#tijiao").click(function (){ // 身份证验证18位+手机号验证11位 var usidnum=$("#usidnum").val(); var usphone=$("#usphone").val(); var reg = /(^\d{15}$)|(^\d{18}$)|(^\d{17}(\d|X|x)$)/ ; var find=0; if(isNaN(usphone)||usphone.length!=11) { alert("手机号有误");find=1; } if(!reg.test(usidnum)) { alert("身份证有误");find=1; } if(find==0) $("#registerForm").submit(); }) </script> </body> </html>
3.registerServlet(注册Servlet)
package com.xxxx.servlet; import com.xxxx.entity.User; import com.xxxx.mapper.UserMapper; import com.xxxx.util.GetSqlSession; import org.apache.ibatis.session.SqlSession; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; @WebServlet("/registerServlet") public class registerServlet extends HttpServlet { @Override protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); response.setContentType("text/html;charset=utf-8"); String usidnum=request.getParameter("usidnum"); String usname=request.getParameter("usname"); String ussex=request.getParameter("ussex"); String usphone=request.getParameter("usphone"); String usaddress=request.getParameter("usaddress"); User user=new User(); user.setUsidnum(usidnum);user.setUsname(usname);user.setUssex(ussex);user.setUsphone(usphone);user.setUsaddress(usaddress); SqlSession sqlSession = GetSqlSession.CreateSqlSession(); UserMapper userMapper =sqlSession.getMapper(UserMapper.class); userMapper.register(user); response.getWriter().write("注册成功,等待审核"); response.getWriter().close(); sqlSession.close(); } }
4.UserMapper.java
package com.xxxx.mapper; import com.xxxx.entity.User; public interface UserMapper { User[] selectusstatus(String usstatus); User selectByusidnum(String usidnum); void updateusstatus(String usidnum); void register(User user); }
5.UserMapper.xml
<?xml version="1.0" encoding="UTF-8"?> <!--<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"--> <!-- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"--> <!-- xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"--> <!-- version="4.0">--> <!--</web-app>--> <!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!--namespace:命名空间--> <mapper namespace = "com.xxxx.mapper.UserMapper"> <insert id="register"> insert into user(usidnum,usname,ussex,usphone,usaddress,usstatus) values (#{usidnum},#{usname},#{ussex},#{usphone},#{usaddress},"0"); </insert> <update id="updateusstatus"> update user set usstatus = "1" where usidnum=#{usidnum}; </update> <select id="selectusstatus" resultType="com.xxxx.entity.User"> select * from user where usstatus=#{usstatus}; </select> <select id="selectByusidnum" resultType="com.xxxx.entity.User"> select * from user where usidnum=#{usidnum}; </select> </mapper>