房屋管理系统课程设计报告.doc

一、设计目的 基于SQL Server数据库并以Java为编程语言，结合Java的Web技术,设计一个房屋信息管理系统。二、系统的功能分析房屋信息管理系统登录验证发布租房信息房屋信息的删除房屋信息的更新查询特定房屋信息查询房屋详细信息查询所有房屋信息 三、系统的数据库设计用户表TBL_USER字段名字段类型约束描述Uidsnchar(15)主键用户编号Unamenchar(10)非空用户姓名UpasssNchar(15)非空用户密码区县表TBL_QX字段名字段类型约束描述QXIDnchar(15)主键区县编号QXnchar(50)空值区县名称街道表TBL_JD字段名字段类型约束描述JDIDnchar(15)主键街道编号JDnchar(50)空值街道名称QUJDnchar(15)非空区县街道名称房屋信息表TBL_FWXX字段名字段类型约束描述FWIDnchar(10)主键房屋编号UIDSnchar(15)非空用户编号JDIDnchar(15)非空街道编号LXIDnchar(15)非空联系人编号SHInchar(15)非空室TINGnchar(15)非空厅FWXXnchar(200)空值房屋信息ZJnchar(15)空值租金TITLEnchar(15)非空标题PUBDATEDatetime空值发布日期TELEPHONEnchar(15)空值联系电话LXRnchar(20)空值联系人QXIDnchar(15)非空区县编号房屋类型TBL_FWLX字段名字段类型约束描述FWIDnchar(15)主键区县编号FWLXnchar(50)空值区县名称);四、系统的程序设计与实现程序的运行环境：Windows开发环境：Java、myEclipse、SQL程序的详细设计五、系统的运行结果与分析 房屋信息删除修改页面效果 房屋信息查询页面效果 My.htm页面效果 还有比较多的内容，由于篇幅有限，不便详述。附录：一、Servlet类的实现的核心代码实现删除信息的Servlet类package myweb.hncu.control;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import myweb.hncu.model.dao.HouseDao;public class DelServlet extends HttpServlet /* * The doGet method of the servlet. * * This method is called when a form has its tag value method equals to get. * * param request the request send by the client to the server * param response the response send by the server to the client * throws ServletException if an error occurred * throws IOException if an error occurred */public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPost(request, response);/* * The doPost method of the servlet. * * This method is called when a form has its tag value method equals to post. * * param request the request send by the client to the server * param response the response send by the server to the client * throws ServletException if an error occurred * throws IOException if an error occurred */public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException int fwid=Integer.parseInt(request.getParameter(fwid);boolean flag=HouseDao.delHouserInfoByID(fwid);if(flag)request.getRequestDispatcher(queryHouse).forward(request,response);实现房屋信息查询的Servlet类package myweb.hncu.control;import java.io.IOException;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import myweb.hncu.model.dao.HouseDao;import myweb.hncu.vo.TblHouseVO;public class QueryHouseServlet extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException int uid=(Integer)request.getSession().getAttribute(uid);List lstHouse=HouseDao.queryHouseByUid(uid);request.setAttribute(lstInfo, lstHouse);request.getRequestDispatcher(my.jsp).forward(request, response);课程设计任务分工情况说明我组的课程设计项目是：房屋信息管理系统其分工如下：组长：刘组员：收集信息、查询资料，登陆、注册页面设计。: 房屋信息查询模块的实现以及数据库的管理；管理房屋信息页面设计。：前期的初步规划以及对项目增、删、改、查，界面的整合；房屋发布信息页面设计。共同设计：页面跳转、相关servlet。自评意见在本次课程设计中，我主要负责房屋信息查询模块的实现以及数据库的管理，管理