1.user.jsp（顾客总功能选择页面）
<%--
Created by IntelliJ IDEA.
User: 22466
Date: 2022/11/19
Time: 19:28
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>user.jsp</title>
</head>
<%--顾客功能页--%>
<body>
<%
String uname=(String) request.getSession().getAttribute("uname");
%>
<table align="center" width="400">
<a href="usinfo.jsp?usname=<%=uname%>">查看个人信息</a><br>
<a href="uspwd.jsp?usname=<%=uname%>">修改个人密码</a><br>
<a href="usliulan.jsp?usname=<%=uname%>">浏览房产信息</a><br>
<a href="usliulan.jsp?usname=<%=uname%>">购买房产</a><br>
</table>
</body>
</html>
2.usinfo.jsp（顾客查看个人信息页面）
<%@ page import="org.apache.ibatis.session.SqlSession" %>
<%@ page import="com.xxxx.util.GetSqlSession" %>
<%@ page import="com.xxxx.mapper.UserMapper" %>
<%@ page import="com.xxxx.entity.User" %><%--
Created by IntelliJ IDEA.
User: 22466
Date: 2022/11/28
Time: 21:53
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>usinfo.jsp</title>
</head>
<%--顾客功能：查看个人信息页面--%>
<body>
<%
String usname=request.getParameter("usname");
SqlSession sqlSession= GetSqlSession.CreateSqlSession();
UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
User user=userMapper.selectByusname(usname);
%>
<table align="center" width="800">
<tr>
<td>顾客ID</td><td>姓名</td><td>性别</td><td>身份证号</td><td>手机</td><td>家庭住址</td>
</tr>
<tr><td><%=user.getUsid()%></td>
<td><%=user.getUsname()%></td><td><%=user.getUssex()%></td><td><%=user.getUsidnum()%></td><td><%=user.getUsphone()%></td><td><%=user.getUsaddress()%></td>
</tr>
</table>
</body>
</html>
3.uspwd.jsp（顾客修改个人密码页面）
<%@ page import="org.apache.ibatis.session.SqlSession" %>
<%@ page import="com.xxxx.util.GetSqlSession" %>
<%@ page import="com.xxxx.mapper.LoginMapper" %>
<%@ page import="com.xxxx.entity.Login" %><%--
Created by IntelliJ IDEA.
User: 22466
Date: 2022/11/28
Time: 22:00
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>uspwd.jsp</title>
</head>
<%--顾客修改个人密码页面，要判断：输入的密码是否和旧密码相同--%>
<body>
<%
String usname=request.getParameter("usname");
request.getSession().setAttribute("usname",usname);
SqlSession sqlSession= GetSqlSession.CreateSqlSession();
LoginMapper loginMapper=sqlSession.getMapper(LoginMapper.class);
Login login=loginMapper.selectByusname(usname);
%>
<form action="uspwdServlet" method="post" id="uspwdForm">
输入旧密码：<input type="password" name="uspwd1" id="uspwd1"><br>
输入新密码：<input type="password" name="uspwd2" id="uspwd2"><br>
确认新密码：<input type="password" name="uspwd3" id="uspwd3"><br>
<button type="button" id="uspwdBtn">修改</button>
</form>
<script type="text/javascript" src="js/jquery-3.6.1.js"></script>
<script type="text/javascript">
$("#uspwdBtn").click(function (){
var uspwd1=$("#uspwd1").val();
var uspwd2=$("#uspwd2").val();
var uspwd3=$("#uspwd3").val();
if(uspwd1 != <%=login.getUpwd()%>)alert("旧密码有误");
else {
if(uspwd2 != uspwd3) alert("两次输入的新密码不相同");
else $("#uspwdForm").submit();
}
})
</script>
</body>
</html>
4.uspwdServlet（顾客修改个人密码Servlet）
package com.xxxx.servlet;
import com.mysql.cj.log.Log;
import com.xxxx.entity.Login;
import com.xxxx.mapper.LoginMapper;
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("/uspwdServlet")
public class uspwdServlet 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 usname= (String) request.getSession().getAttribute("uname");
String uspwd=request.getParameter("uspwd2");
SqlSession sqlSession=GetSqlSession.CreateSqlSession();
LoginMapper loginMapper=sqlSession.getMapper(LoginMapper.class);
loginMapper.updateByusname(usname,uspwd);
response.getWriter().write("修改成功");
response.getWriter().close();
sqlSession.close();
}
}
5.usliulan.jsp（顾客浏览房产信息页面）
<%@ page import="org.apache.ibatis.session.SqlSession" %>
<%@ page import="com.xxxx.util.GetSqlSession" %>
<%@ page import="com.xxxx.mapper.HouseMapper" %>
<%@ page import="com.xxxx.entity.House" %>
<%@ page import="com.xxxx.mapper.UserMapper" %>
<%@ page import="com.xxxx.entity.User" %><%--
Created by IntelliJ IDEA.
User: 22466
Date: 2022/11/29
Time: 13:05
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>usliulan.jsp</title>
</head>
<%--顾客浏览房产信息--%>
<body>
<table align="center" width="800">
<tr>
<td>房产编号</td><td>户型</td><td>房产地址</td><td>建造年份</td><td>建造面积</td><td>销售报价</td><td>销售状态</td><td>操作</td>
</tr>
<%
SqlSession sqlSession= GetSqlSession.CreateSqlSession();
UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
User user=userMapper.selectByusname(request.getParameter("usname"));
HouseMapper houseMapper=sqlSession.getMapper(HouseMapper.class);
House[] houses=houseMapper.selectAllus();
for (House house:houses) {
%>
<tr>
<td><%=house.getHoid()%></td><td><%=house.getHotype()%></td><td><%=house.getHoaddress()%></td><td><%=house.getHoyear()%></td><td><%=house.getHoarea()%></td><td><%=house.getHosale()%></td><td><%=house.getHostatus()%></td>
<td><a href="usliulanServlet?hoid=<%=house.getHoid()%>&uid=<%=user.getUsid()%>">交易</a></td>
</tr>
<%
}
%>
</table>
</body>
</html>
6.usliulanServlet（顾客购买房产Servlet）
package com.xxxx.servlet;
import com.xxxx.mapper.HouseMapper;
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("/usliulanServlet")
public class usliulanServlet 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 uid= request.getParameter("uid");
String hoid= request.getParameter("hoid");
SqlSession sqlSession= GetSqlSession.CreateSqlSession();
HouseMapper houseMapper=sqlSession.getMapper(HouseMapper.class);
houseMapper.updateStaByhoid(hoid,uid);
response.getWriter().write("交易提交成功");
response.getWriter().close();
sqlSession.close();
}
}
7.HouseMapper .java（接口类）
package com.xxxx.mapper;
import com.xxxx.entity.House;
import org.apache.ibatis.annotations.Param;
public interface HouseMapper {
void add(House house);
House[] selectBy(House house);
House selectByhoid(String hoid);
House[] selectAll();
void updateByhoidagid(@Param("hoid") String hoid,@Param("aid") String aid);
void updateByhoid(String hoid);
House[] selectAllus();
void updateStaByhoid(@Param("hoid") String hoid, @Param("uid") String uid);
}
8.HouseMapper.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.HouseMapper">
<insert id="add">
insert into house (hoid,hotype,hoaddress,hoyear,hoarea,hosale,hostatus)
values (#{hoid},#{hotype},#{hoaddress},#{hoyear},#{hoarea},#{hosale},#{hostatus});
</insert>
<update id="updateByhoidagid">
update house
set aid =#{aid},hostatus="待售"
where hoid=#{hoid};
</update>
<update id="updateByhoid">
update house set hostatus="停售" where hoid=#{hoid};
</update>
<update id="updateStaByhoid">
update house
set hostatus ="意向",uid=#{uid}
where hoid=#{hoid};
</update>
<select id="selectBy" resultType="com.xxxx.entity.House">
select * from house
<where>
<if test="hotype !=null and hosale!=''">
and hotype=#{hotype}
</if>
<if test="hoaddress!=null and hoaddress!=''">
and hoaddress=#{hoaddress}
</if>
<if test="hoyear!=null and hoyear!=''">
and hoyear=#{hoyear}
</if>
<if test="hoarea!=null and hoarea!=''">
and hoarea=#{hoarea}
</if>
<if test="hosale!=null and hosale!=''">
and hosale=#{hosale}
</if>
</where>
</select>
<select id="selectByhoid" resultType="com.xxxx.entity.House">
select * from house where hoid=#{hoid};
</select>
<select id="selectAll" resultType="com.xxxx.entity.House">
select * from house;
</select>
<select id="selectAllus" resultType="com.xxxx.entity.House">
select * from house where hostatus="在售";
</select>
</mapper>
9.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);
User selectByusname(String usname);
}
10.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>
<select id="selectByusname" resultType="com.xxxx.entity.User">
select *
from user where usname=#{usname};
</select>
</mapper>
11.LoginMapper.java（接口类）
package com.xxxx.mapper;
import com.xxxx.entity.Login;
import org.apache.ibatis.annotations.Param;
public interface LoginMapper {
Login selectByunametype(@Param("uname") String uname, @Param("type") String type);
void updateByuname(String uname);
Login selectByusname(String usname);
void updateByusname(@Param("usname") String usname,@Param("uspwd") String uspwd);
}
12.LoginMapper.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.LoginMapper">
<update id="updateByuname">
update login01
set upwd = "123456"
where uname=#{uname};
</update>
<update id="updateByusname">
update login01
set upwd =#{uspwd}
where uname=#{usname} and type="顾客";
</update>
<select id="selectByunametype" resultType="com.xxxx.entity.Login">
select * from login01 where type=#{type} and uname=#{uname};
</select>
<select id="selectByusname" resultType="com.xxxx.entity.Login">
select * from login01 where type="顾客" and uname=#{usname};
</select>
</mapper>
