房产信息管理系统--房产授权

最新推荐文章于 2023-11-01 09:54:57 发布

mendianyu

最新推荐文章于 2023-11-01 09:54:57 发布

阅读量33

点赞数

文章标签： python 网络开发语言

本文链接：https://blog.csdn.net/qq_62768655/article/details/134513202

版权

房产授权：系统管理员登录后可以浏览所有的在售房产信息，显示结果信息包括序号、地址、销售报价，点击地址，可以查看该套房产的详细信息，输入房产经纪人ID，如果房产经纪人信息不存在，提示错误信息，不允许授权；如果正确，点击“授权”按钮，该房产状态信息改为“待售”状态。(3分)

此功能涉及的功能主要还是改，点击授权按钮后，借助Dao方法，将房产信息状态改为“待售”，另外还有一点题目要起没写，还需要将房产基本表中的房产经纪人ID一列修改为输入的房产经纪人ID。

代码

Admin_AuthorizeHouse.jsp

<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<%@ page import="com.Util.util" %>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>基本信息浏览</title>
</head>
<body>


<table border="1" cellspacing="0" style="text-align:center;">
    <tr>
        <td align="center" width=6%>房产编号</td>
        <td align="center" width=10%>房产地址</td>
        <td align="center" width=6%>销售报价</td>
    </tr>
    <%
        Connection connection = util.getConnection();
        PreparedStatement preparedStatement=null;
        ResultSet rs=null;
        try {
            String sql = "select * from 房产基本信息表";
            preparedStatement=connection.prepareStatement(sql);
            rs=preparedStatement.executeQuery();
            while(rs.next()){

    %>
    <tr>
        <td align="center"><%=rs.getObject(1) %></td>
        <td align="center"><a href='Admin_AuthorizeHouse_back1.jsp?Address=<%=rs.getObject(3)%>'><%=rs.getObject(3) %></a></td>
        <td align="center"><%=rs.getObject(6) %></td>
    </tr>
    <%

            }
        } catch (SQLException  e) {
            e.printStackTrace();
        }finally{
            util.close(rs);
            util.close(preparedStatement);
            util.close(connection);
        }
    %>
</table>
<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
    <input type="button" name="back" onclick="javascript:window.history.back();" value=返回上一页>

    <input type="button" value="返回菜单" onclick="location.href='menu.jsp'" /> <br>

</p>
</body>
</html>

Admin_AuthorizeHouse_back1.jsp

<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<%@ page import="com.Util.util" %>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>详细房产信息</title>
</head>
<body>

<%
    String Address = (String)request.getParameter("Address");
    Connection connection = util.getConnection();
    PreparedStatement preparedStatement=null;
    ResultSet rs=null;
    try {
        String sql = "select * from 房产基本信息表";
        preparedStatement=connection.prepareStatement(sql);
        rs=preparedStatement.executeQuery();
        while(rs.next()){
            if(Address.equals(rs.getObject(3)))
            {
                //重要
                String HouseID= (String) rs.getObject(1);
                session.setAttribute("HouseID",HouseID);
%>
<table border="1"cellspacing="0"style="text-align:center;">
    <tr>
        <td align="center" width=5%>房产编号</td>
        <td align="center" width=5%>户型</td>
        <td align="center" width=10%>房产地址</td>
        <td align="center" width=5%>建造年份</td>
        <td align="center" width=5%>建造面积</td>
        <td align="center" width=5%>销售报价</td>
        <td align="center" width=5%>销售状态</td>
        <td align="center" width=5%>房产经纪人ID</td>
        <td align="center" width=5%>顾客ID</td>
    </tr>
    <tr>
        <td align="center"><%=rs.getObject(1) %></td>
        <td align="center"><%=rs.getObject(2) %></td>
        <td align="center"><%=rs.getObject(3) %></td>
        <td align="center"><%=rs.getObject(4) %></td>
        <td align="center"><%=rs.getObject(5) %></td>
        <td align="center"><%=rs.getObject(6) %></td>
        <td align="center"><%=rs.getObject(7) %></td>
        <td align="center"><%=rs.getObject(8) %></td>
        <td align="center"><%=rs.getObject(9) %></td>
    </tr>
    <%
                }
            }
        } catch (SQLException  e) {
            e.printStackTrace();
        }finally{
            util.close(rs);
            util.close(preparedStatement);
            util.close(connection);
        }
    %>
</table>
<form action="Admin_AuthorizeHouse_back2.jsp" method="get">
    <p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
        <br>
        请输入被授权房产经纪人的工号
        <br>
        <input type="text" name="AgentID" >
        <br>
        <input type="submit" value="授权" >
    </p>
</form>
<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
    <input type="button" name="back" onclick="javascript:window.history.back();" value=返回上一页>
    <input type="button" value="返回菜单" onclick="location.href='User_Menu.jsp'" /> <br>
</p>
</body>
</html>

Admin_AuthorizeHouse_back2.jsp

<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="com.Util.util" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.SQLException" %>
<%@ page import="com.Dao.dao" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title></title>
</head>
<body>
<%

    String AgentID=(String)request.getParameter("AgentID");

    if(AgentID=="")
    {
        out.print("<script language='javaScript'> alert('房产经纪人姓名输入为空'); window.history.back(); </script>");
    }
    else
    {

        int i=0;
        Connection connection = util.getConnection();
        PreparedStatement preparedStatement=null;
        ResultSet rs=null;
        try {
            String sql= " select * from 房产经纪人基本信息表 ";
            preparedStatement=connection.prepareStatement(sql);
            rs=preparedStatement.executeQuery();
            while(rs.next())
            {
                if(AgentID.equals(rs.getObject(1)))
                {i++;}
            }
            if(i==0)
            {
                out.print("<script language='javaScript'> alert('该房产经纪人不存在'); window.history.back(); </script>");
            }
            else
            {
                String HouseID= (String) session.getAttribute("HouseID");
                String Status="待售";
                dao dao=new dao();
                dao.AuthorizeHouse(AgentID,Status,HouseID);
                out.print("<script language='javaScript'> alert('授权成功');</script>");
                response.setHeader("refresh", "0;url=Admin_Menu.jsp");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }finally{
            util.close(rs);
            util.close(preparedStatement);
            util.close(connection);
        }
    }
%>
</table>
</body>
</html>

 Dao方法

public void AuthorizeHouse(String AgentID,String Status,String HouseID)
{
    Connection connection =util.getConnection();
    PreparedStatement preparedStatement=null;
    try {
        String sql = "update 房产基本信息表 set 房产经纪人ID=?,销售状态=? where 房产编号=?";
        preparedStatement=connection.prepareStatement(sql);
        preparedStatement.setString(1,AgentID);
        preparedStatement.setString(2,Status);
        preparedStatement.setString(3,HouseID);
        preparedStatement.executeUpdate();

    } catch (SQLException  e) {
        e.printStackTrace();
    }finally{
        util.close(preparedStatement);
        util.close(connection);
    }
}