3-房产销售
首先是项目的构建
然后是数据库表
bean：
fangchanxinxi.java
package bean; public class fangchanxinxi { private String HouseID; private String RoomType; private String Address; private String Year; private String Area; private String Sales; private String Status; private String AgentID; private String UserID; public String getHouseID() { return HouseID; } public void setHouseID(String houseID) { HouseID = houseID; } public String getRoomType() { return RoomType; } public void setRoomType(String roomType) { RoomType = roomType; } public String getAddress() { return Address; } public void setAddress(String address) { Address = address; } public String getYear() { return Year; } public void setYear(String year) { Year = year; } public String getArea() { return Area; } public void setArea(String area) { Area = area; } public String getSales() { return Sales; } public void setSales(String sales) { Sales = sales; } public String getStatus() { return Status; } public void setStatus(String status) { Status = status; } public String getAgentID() { return AgentID; } public void setAgentID(String agentID) { AgentID = agentID; } public String getUserID() { return UserID; } public void setUserID(String userID) { UserID = userID; } public fangchanxinxi(String houseID,String roomType,String address,String year,String area,String sales,String status,String agentID,String userID) { HouseID = houseID; RoomType = roomType; Address = address; Year = year; Area = area; Sales = sales; Status = status; AgentID = agentID; UserID = userID; } }
gukexinxi.java
package bean; public class gukexinxi { private String UserID; private String UserName; private String sex; private String IdNumber; private String Phone; private String User; public String getUserID() { return UserID; } public void setUserID(String userID) { UserID = userID; } public String getUserName() { return UserName; } public void setUserName(String userName) { UserName = userName; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public String getIdNumber() { return IdNumber; } public void setIdNumber(String idNumber) { IdNumber = idNumber; } public String getPhone() { return Phone; } public void setPhone(String phone) { Phone = phone; } public String getUser() { return User; } public void setUser(String user) { User = user; } public gukexinxi(String userID,String userName,String sex,String idNumber,String phone,String user) { UserID = userID; UserName = userName; this.sex = sex; IdNumber = idNumber; Phone = phone; User = user; } }
jingjirenxinxi.java
package bean; public class jingjirenxinxi { private String AgentID; private String AgentName; private String AgentAddress; private String Phone; public String getAgentID() { return AgentID; } public void setAgentID(String agentID) { AgentID = agentID; } public String getAgentName() { return AgentName; } public void setAgentName(String agentName) { AgentName = agentName; } public String getAgentAddress() { return AgentAddress; } public void setAgentAddress(String agentAddress) { AgentAddress = agentAddress; } public String getPhone() { return Phone; } public void setPhone(String phone) { Phone = phone; } public jingjirenxinxi(String agentID,String agentName,String agentAddress,String phone) { AgentID = agentID; AgentName = agentName; AgentAddress = agentAddress; Phone = phone; } }
dao:
dao.java
package dao; import java.sql.Connection; import java.util.ArrayList; import java.util.List; import java.sql.ResultSet; import java.sql.Statement; import dbutil.DBUtil; import bean.*; public class dao { public int addyonghu(String number,String password,String user) { Connection conn = DBUtil.getConn();//这里就是从DBUtil类里面得到连接 Statement state =null; ResultSet rs = null; int flag=0; try { String sql = "insert into yonghu(number,password,user)values('"+number+"','"+password+"','"+user+"')"; state = conn.createStatement(); int count = state.executeUpdate(sql); if(count>0) { System.out.println("数据插入成功"); }else { System.out.println("数据插入失败了QAQ"); } } catch(Exception e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return flag; } public String login(String number,String password,String user) { Connection conn = DBUtil.getConn();//这里就是从DBUtil类里面得到连接 Statement state =null; ResultSet rs = null; int flag=0; String user2; try { String sql = "select * from yonghu"; state = conn.createStatement(); rs=state.executeQuery(sql); while(rs.next()) { String number1=rs.getString("number"); String password1=rs.getString("password"); String user1=rs.getString("user"); if(number1.equals(number)&&password1.equals(password)&&user1.equals(user)) { user2=user1; //System.out.println(user1); return user1; } } } catch(Exception e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return "错误"; } public int insertguke(String number,String UserName ,String sex,String IdNumber,String Phone,String User) { Connection conn = DBUtil.getConn();//这里就是从DBUtil类里面得到连接 Statement state =null; ResultSet rs = null; int flag=0; try { String sql = "insert into gukexinxi(UserID,UserName,sex,IdNumber,Phone,User)values('"+number+"','"+UserName+"','"+sex+"','"+IdNumber+"','"+Phone+"','"+User+"')"; state = conn.createStatement(); int count = state.executeUpdate(sql); if(count>0) { System.out.println("数据插入成功"); }else { System.out.println("数据插入失败了QAQ"); } } catch(Exception e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return flag; } public int addfangchanxinxi(String HouseID,String RoomType,String Address,String Year,String Area,String Sales,String Status) { Connection conn = DBUtil.getConn();//这里就是从DBUtil类里面得到连接 Statement state =null; ResultSet rs = null; int flag=0; try { String sql = "insert into fangchanxinxi(HouseID,RoomType,Address,Year,Area,Sales,Status)values('"+HouseID+"','"+RoomType+"','"+Address+"','"+Year+"','"+Area+"','"+Sales+"','"+Status+"')"; state = conn.createStatement(); int count = state.executeUpdate(sql); if(count>0) { System.out.println("数据插入成功"); }else { System.out.println("数据插入失败了QAQ"); } } catch(Exception e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return flag; } public int addjingjiren(String AgentID,String AgentName,String AgentAddress,String Phone) { Connection conn = DBUtil.getConn();//这里就是从DBUtil类里面得到连接 Statement state =null; ResultSet rs = null; int flag=0; try { String sql = "insert into jingjirenxinxi(AgentID,AgentName,AgentAddress,Phone)values('"+AgentID+"','"+AgentName+"','"+AgentAddress+"','"+Phone+"')"; state = conn.createStatement(); int count = state.executeUpdate(sql); if(count>0) { System.out.println("数据插入成功"); }else { System.out.println("数据插入失败了QAQ"); } } catch(Exception e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return flag; } public static List<gukexinxi> selectkecheng() { String sql = "select * from gukexinxi"; Connection conn = DBUtil.getConn();//这里就是从DBUtil类里面得到连接 Statement state =null; List<gukexinxi> list = new ArrayList<>(); ResultSet rs = null; int flag=0; try { state = conn.createStatement(); rs=state.executeQuery(sql); gukexinxi kc=null; while(rs.next()) { String UserID=rs.getString("UserID"); String UserName=rs.getString("UserName"); String sex=rs.getString("sex"); //System.out.println(rs.getString("ID")+"========="); String IdNumber=rs.getString("IdNumber"); String Phone=rs.getString("Phone"); String User=rs.getString("User"); kc =new gukexinxi(UserID,UserName,sex,IdNumber,Phone,User); //System.out.println(name+"========="); list.add(kc); } } catch(Exception e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return list; } public static List<jingjirenxinxi> selectfanghcanjingji() { String sql = "select * from jingjirenxinxi"; Connection conn = DBUtil.getConn();//这里就是从DBUtil类里面得到连接 Statement state =null; List<jingjirenxinxi> list = new ArrayList<>(); ResultSet rs = null; int flag=0; try { state = conn.createStatement(); rs=state.executeQuery(sql); jingjirenxinxi kc=null; while(rs.next()) { String AgentID=rs.getString("AgentID"); String AgentName=rs.getString("AgentName"); String AgentAddress=rs.getString("AgentAddress"); String Phone=rs.getString("Phone");; kc =new jingjirenxinxi(AgentID,AgentName,AgentAddress,Phone); //System.out.println(name+"========="); list.add(kc); } } catch(Exception e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return list; } public static List<fangchanxinxi> gukeselectfangchan() { String sql = "select * from fangchanxinxi where Status='在售'"; Connection conn = DBUtil.getConn();//这里就是从DBUtil类里面得到连接 Statement state =null; List<fangchanxinxi> list = new ArrayList<>(); ResultSet rs = null; int flag=0; try { state = conn.createStatement(); rs=state.executeQuery(sql); fangchanxinxi kc=null; while(rs.next()) { String HouseID=rs.getString("HouseID"); String RoomType=rs.getString("RoomType"); String Address=rs.getString("Address"); String Year=rs.getString("Year"); String Area=rs.getString("Area"); String Sales=rs.getString("Sales"); String Status=rs.getString("Status"); String AgentID=rs.getString("AgentID"); String UserID=rs.getString("UserID"); kc =new fangchanxinxi(HouseID,RoomType,Address,Year,Area,Sales,Status,AgentID,UserID); //System.out.println(name+"========="); list.add(kc); } } catch(Exception e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return list; } }
dbutil:
DBUtil.java
package dbutil; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DBUtil {//这个类就是套模板如果需要用的时候只需要改数据库(db)的名字即可******* //public static String db_url="jdbc:mysql://localhost:3306/database?uerUnicode=true&characterEncoding=UTF-8"; public static String db_url="jdbc:mysql://localhost:3306/database1?serverTimezone=GMT%2B8&serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=UTF-8";//db是数据库的名字 //这是连接数据库，servlet是数据库的名称，uerUnicode=true&characterEncoding=UTF-8是将字符集设置为utf-8，避免乱码。 public static String db_user="root";//数据的用户名 public static String db_password="UJuqCT-az5(f";//数据库的密码 public static Connection getConn()//获取连接，返回Connection类型，必须设置为static这样才能在其他类中使用 { Connection conn=null; try { Class.forName("com.mysql.cj.jdbc.Driver");//加载驱动 conn=DriverManager.getConnection(db_url,db_user,db_password);//连接数据库 } catch(Exception e) { e.printStackTrace(); } return conn; } public static void close(Statement state,Connection conn)//关闭函数 { if(state!=null)//只有状态和连接时，先关闭状态 { try { state.close(); } catch(SQLException e) { e.printStackTrace(); } } if(conn!=null) { try { conn.close(); } catch(SQLException e) { e.printStackTrace(); } } } public static void close(ResultSet rs,Statement state,Connection conn) { if(rs!=null)//有结果集，状态和连接时，先关闭结果集，在关闭状态，在关闭连接 { try { rs.close(); } catch(SQLException e) { e.printStackTrace(); } } if(state!=null) { try { state.close(); } catch(SQLException e) { e.printStackTrace(); } } if(conn!=null) { try { conn.close(); } catch(SQLException e) { e.printStackTrace(); } } } }
servlet:
Servlet.java
package servlet; import java.io.IOException; import java.util.List; import java.io.PrintWriter; 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 dao.*; import bean.*; import dao.*; @WebServlet("/r2") public class Servlet extends HttpServlet{ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, java.io.IOException { return; } protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8");// 设置字符集，避免乱码 // 获取jsp界面需要进行的操作， String method = req.getParameter("method"); //System.out.println("============"); if (method.equals("addyonghu"))// 转到login函数 { addyonghu(req,resp); // System.out.println("正在执行信息录入操作"); } if (method.equals("login"))// 转到login函数 { login(req,resp); } if (method.equals("addfangchanxinxi"))// 转到login函数 { addfangchanxinxi(req,resp); } if (method.equals("addjingjiren"))// 转到login函数 { addjingjiren(req,resp); } if (method.equals("selectguke"))// 转到login函数 { selectguke(req,resp); } if (method.equals("selectfanghcanjingji"))// 转到login函数 { selectfanghcanjingji(req,resp); } if (method.equals("gukeselectfangchan"))// 转到login函数 { gukeselectfangchan(req,resp); } } private void addyonghu(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); resp.setContentType("text/html;charset=utf-8"); String number=req.getParameter("number"); String password = req.getParameter("password"); String user="顾客"; String UserID = req.getParameter("UserID"); String UserName = req.getParameter("UserName"); String sex = req.getParameter("sex"); String IdNumber = req.getParameter("IdNumber"); String User = req.getParameter("User"); String Phone = req.getParameter("Phone"); //System.out.println(name); dao userdao = new dao(); userdao.addyonghu(number,password,user); userdao.insertguke(number,UserName,sex,IdNumber,Phone,User); req.getRequestDispatcher("/login.jsp").forward(req,resp); } private void login(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); resp.setContentType("text/html;charset=utf-8"); String number=req.getParameter("number"); String password = req.getParameter("password"); String user=req.getParameter("user"); //System.out.println(name); dao userdao = new dao(); String log=userdao.login(number,password,user); if(log.equals("管理员")) { req.getRequestDispatcher("/guanliyuandenglu.jsp").forward(req,resp); //System.out.println("select============"); } else if(log.equals("顾客")) { req.getRequestDispatcher("/gukedenglu.jsp").forward(req,resp); } else if(log.equals("房产经济")) { req.getRequestDispatcher("/fangchanjingji.jsp").forward(req,resp); } else req.getRequestDispatcher("/login.jsp").forward(req,resp); } private void addfangchanxinxi(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); resp.setContentType("text/html;charset=utf-8"); String HouseID=req.getParameter("HouseID"); String RoomType= req.getParameter("RoomType"); String Address = req.getParameter("Address"); String Year = req.getParameter("Year"); String Area = req.getParameter("Area"); String Sales= req.getParameter("Sales"); String Status = req.getParameter("Status"); //System.out.println(name); dao userdao = new dao(); userdao.addfangchanxinxi(HouseID,RoomType,Address,Year,Area,Sales,Status); req.getRequestDispatcher("/guanliyuandenglu.jsp").forward(req,resp); } private void addjingjiren(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); resp.setContentType("text/html;charset=utf-8"); String AgentID=req.getParameter("AgentIDAgentID"); String AgentName= req.getParameter("AgentName"); String AgentAddress = req.getParameter("AgentAddress"); String Phone = req.getParameter("Phone"); dao userdao = new dao(); userdao.addjingjiren(AgentID,AgentName,AgentAddress,Phone); req.getRequestDispatcher("/guanliyuandenglu.jsp").forward(req,resp); } private void selectguke(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); List<gukexinxi> kc=dao.selectkecheng(); req.setAttribute("kc", kc); req.getRequestDispatcher("gukeliulan.jsp").forward(req, resp); } private void selectfanghcanjingji(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); List<jingjirenxinxi> kc=dao.selectfanghcanjingji(); req.setAttribute("kc", kc); req.getRequestDispatcher("fangchanjingjiliulan.jsp").forward(req, resp); } private void gukeselectfangchan(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); List<fangchanxinxi> kc=dao.gukeselectfangchan(); req.setAttribute("kc", kc); req.getRequestDispatcher("gukeselectfangchan.jsp").forward(req, resp); } }
接下来是jsp界面的构建
webapp:
addfangchanxinxi.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> body{text-align:center} </style> </head> <body> <form action="/moniTest1/r2?method=addfangchanxinxi"method="post" onsubmit="return check();"> <h1>请输入信息</h1> 1.房产编号<input type="text" name="HouseID"> <br/> 2.户型 <input type="radio" name="RoomType" value="四室两厅"> 四室两厅 <input type="radio" name="RoomType" value="四室一厅"> 四室一厅 <input type="radio" name="RoomType" value="三室两厅"> 三室两厅 <input type="radio" name="RoomType" value="三室一厅"> 三室一厅 <input type="radio" name="RoomType" value="两室两厅"> 两室两厅 <input type="radio" name="RoomType" value="四室两厅"> 两室一厅 <br> 3.房产地址<input type="text" name="Address"><br/> 4.建造年份<input type="text" name="Year"><br/> 5.建造面积<input type="text" name="Area"><br/> 6.销售报价<input type="text" name="Sales"><br/> 7.销售状态<select name="Status"> <option value="在售">在售</option> <option value="代售">在售</option> <option value="意向">在售</option> <option value="售出">在售</option> <option value="停售">在售</option> <!-- 下拉框 --> </select> <br> <input type ="submit" value="提交" > </form> </body> </html>
addjingjiren.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> body{text-align:center} </style> </head> <body> <form action="/moniTest1/r2?method=addjingjiren"method="post" onsubmit="return check();"> <h1>请输入信息</h1> 1.工号<input type="text" name="AgentID"> <br/> 2.姓名<input type="text" name="AgentName"><br/> 3.家庭住址<input type="text" name="AgentAddress"><br/> 4.手机<input type="text" name="Phone"><br/> <br> <input type ="submit" value="提交" > </form> </body> </html>
creatyonghu.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> body{text-align:center} </style> </head> <body> <form action="/moniTest1/r2?method=addyonghu"method="post" onsubmit="return check();"> <h1>请输入信息</h1> 1.账号<input type="text" name="number"> <br/> 2.密码<input type="text" name="password"> <br/> 3.性别<input type="text" name="sex"><br/> 4.手机号码<input type="text" name="Phone"><br/> 5.家庭住址<input type="text" name="User"><br/> 6.姓名<input type="text" name="UserName"><br/> 7.身份证号<input type="text" name="IdNumber"><br/> <input type ="submit" value="提交" > </form> </body> </html>
fangchanjingji.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> body{text-align:center} </style> </head> <body> <p>请选择所需功能</p> <form action="/moniTest1/r2?method=selectfanghcanjingji" method="post" onsubmit="return check();"> <p> <input type="submit" value="浏览个人信息"> </p> </form> <a href=""> <button>浏览房产信息</button> </a> <br> <br> <a href=""> <button>房产交易</button> </a> <br> <br> <a href=""> <button>查询房产</button> </a> <br> <br> <a href=""> <button>修改个人密码</button> </a> </body> </html>
fangchanjingjiliulan.jsp
<%@page import="java.util.*"%> <%@page import="bean.*"%> <%@page import="dao.*"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> body{text-align:center} </style> </head> <body> <div align="center"> <h1 style="color: black;">课程详细信息</h1> <table class="tb" border=""> <tr> <tr> <th>工号</th> <th>房产经纪人姓名</th> <th>家庭住址</th> <th>手机</th> </tr> <%List<jingjirenxinxi> list=(List<jingjirenxinxi>)request.getAttribute("kc"); //String s="sd"; //request.getSession().setAttribute("ss",s); for(jingjirenxinxi kc : list){ %> <tr> <td><%=kc.getAgentID() %></td> <td><%=kc.getAgentName() %></td> <td><%=kc.getAgentAddress() %></td> <td><%=kc.getPhone() %></td> </tr> <% } %> </table> <!-- <input type="hidden" name="ID" id="ID" value="${kc[0]}"> <td><input type="hidden" name="name" id="name" value="${kc[1]}"></td> <tr> <td><input type="hidden" name="renshu" id="renshu" value="${kc[2]}"></td> </tr> <td><input type="hidden" name="jiaoshi" id="jiaoshi" value="${kc[4]}"></td> --> </body> </html>
guanliyuandenglu.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> body{text-align:center} </style> </head> <body> <p>请选择所需功能</p> <a href="addfangchanxinxi.jsp"> <button>新添房产信息</button> </a> <br> <br> <a href=""> <button>房产授权</button> </a> <br> <br> <a href=""> <button>停售房产</button> </a> <br> <br> <a href=""> <button>查询房产信息</button> </a> <br> <br> <a href=""> <button>顾客审核</button> </a> <br> <br> <a href="addjingjiren.jsp"> <button>新增房产经纪人</button> </a> <br> <br> <a href=""> <button>密码重置</button> </a> </body> </html>
gukedenglu.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> body{text-align:center} </style> </head> <body> <p>请选择所需功能</p> <form action="/moniTest1/r2?method=selectguke" method="post" onsubmit="return check();"> <p> <input type="submit" value="浏览个人信息"> </p> </form> <a href=""> <button>修改个人密码</button> </a> <br> <br> <form action="/moniTest1/r2?method=gukeselectfangchan" method="post" onsubmit="return check();"> <p> <input type="submit" value="浏览房产信息"> </p> </form> <a href=""> <button>查询房产</button> </a> <br> <br> <a href=""> <button>购买房产</button> </a> </body> </html>
gukeliulan.jsp
<%@page import="java.util.*"%> <%@page import="bean.*"%> <%@page import="dao.*"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> body{text-align:center} </style> </head> <body> <div align="center"> <h1 style="color: black;">课程详细信息</h1> <table class="tb" border=""> <tr> <tr> <th>顾客ID</th> <th>姓名</th> <th>性别</th> <th>身份证号</th> <th>手机</th> <th>家庭住址</th> </tr> <%List<gukexinxi> list=(List<gukexinxi>)request.getAttribute("kc"); //String s="sd"; //request.getSession().setAttribute("ss",s); for(gukexinxi kc : list){ %> <tr> <td><%=kc.getUserID() %></td> <td><%=kc.getUserName() %></td> <td><%=kc.getSex() %></td> <td><%=kc.getIdNumber() %></td> <td><%=kc.getPhone() %></td> <td><%=kc.getUser() %></td> </tr> <% } %> </table> <!-- <input type="hidden" name="ID" id="ID" value="${kc[0]}"> <td><input type="hidden" name="name" id="name" value="${kc[1]}"></td> <tr> <td><input type="hidden" name="renshu" id="renshu" value="${kc[2]}"></td> </tr> <td><input type="hidden" name="jiaoshi" id="jiaoshi" value="${kc[4]}"></td> --> </body> </html>
gukeselectfangchan.jsp
<%@page import="java.util.*"%> <%@page import="bean.*"%> <%@page import="dao.*"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> body{text-align:center} </style> </head> <body> <div align="center"> <h1 style="color: black;">课程详细信息</h1> <table class="tb" border=""> <tr> <tr> <th>房产编号</th> <th>户型</th> <th>房产地址</th> <th>建造年份</th> <th>建造面积</th> <th>销售报价</th> <th>销售状态</th> <th>房产经纪人ID</th> <th>顾客ID</th> </tr> <%List<fangchanxinxi> list=(List<fangchanxinxi>)request.getAttribute("kc"); //String s="sd"; //request.getSession().setAttribute("ss",s); for(fangchanxinxi kc : list){ %> <tr> <td><%=kc.getHouseID() %></td> <td><%=kc.getRoomType() %></td> <td><%=kc.getAddress() %></td> <td><%=kc.getYear() %></td> <td><%=kc.getArea() %></td> <td><%=kc.getSales() %></td> <td><%=kc.getStatus() %></td> <td><%=kc.getAgentID() %></td> <td><%=kc.getUserID() %></td> </tr> <% } %> </table> <!-- <input type="hidden" name="ID" id="ID" value="${kc[0]}"> <td><input type="hidden" name="name" id="name" value="${kc[1]}"></td> <tr> <td><input type="hidden" name="renshu" id="renshu" value="${kc[2]}"></td> </tr> <td><input type="hidden" name="jiaoshi" id="jiaoshi" value="${kc[4]}"></td> --> </body> </html>
login.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> <style> body{text-align:center} input{ font-size: 20px; text-align: center; } </style> </head> <body> <form action="/moniTest1/r2?method=login"method="post" onsubmit="return check();"> <div id="登录界面"> <h1>Login</h1> <table align="center"> <tr> <th>账号</th> <td> <input type="text" name="number"> </td> </tr> <tr> <th>密码</th> <td><input type="password" name = "password"> </td> </tr> <tr> <th>身份</th><td> <select name="user"> <option value="顾客">顾客</option> <option value="房产经济">房产经济</option> <option value="管理员">管理员</option> </select> </td> </tr> <tr> <td colspan="2"><input type="submit" name="submit" value="提交"> <input type="reset" value="重置"></td> </tr> </table> </form> <div><a href="createyonghu.jsp">创建用户</a> <a href="createyonghu.jsp"></a></div> </div> </body> </html>
浙公网安备 33010602011771号