房屋管理系統(tǒng)課程設(shè)計(jì)報(bào)告

1、<p><b>　　一、設(shè)計(jì)目的 </b></p><p>　　基于SQL Server數(shù)據(jù)庫(kù)并以Java為編程語(yǔ)言，結(jié)合Java的Web技術(shù),設(shè)計(jì)一個(gè)房屋信息管理系統(tǒng)。</p><p><b>　　二、系統(tǒng)的功能分析</b></p><p>　　三、系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)</p><p>　

2、　用戶表TBL_USER</p><p><b>　　區(qū)縣表TBL_QX</b></p><p><b>　　街道表TBL_JD</b></p><p>　　房屋信息表TBL_FWXX</p><p>　　房屋類型TBL_FWLX</p><p>　　);四、系統(tǒng)的程序設(shè)計(jì)與

3、實(shí)現(xiàn)</p><p>　　程序的運(yùn)行環(huán)境：Windows</p><p>　　開(kāi)發(fā)環(huán)境：Java、myEclipse、SQL</p><p><b>　　程序的詳細(xì)設(shè)計(jì)</b></p><p>　　五、系統(tǒng)的運(yùn)行結(jié)果與分析</p><p>　　房屋信息刪除修改頁(yè)面效果</p><

4、;p>　　房屋信息查詢頁(yè)面效果 </p><p>　　My.htm頁(yè)面效果 </p><p>　　還有比較多的內(nèi)容，由于篇幅有限，不便詳述。</p><p><b>　　附錄：</b></p><p>　　一、Servlet類的實(shí)現(xiàn)的核心代碼</p><p>　　實(shí)現(xiàn)刪除信息的Servl

5、et類</p><p>　　package myweb.hncu.control;</p><p>　　import java.io.IOException;</p><p>　　import java.io.PrintWriter;</p><p>　　import javax.servlet.ServletException;</p

6、><p>　　import javax.servlet.http.HttpServlet;</p><p>　　import javax.servlet.http.HttpServletRequest;</p><p>　　import javax.servlet.http.HttpServletResponse;</p><p>　　impor

7、t myweb.hncu.model.dao.HouseDao;</p><p>　　public class DelServlet extends HttpServlet {</p><p><b>　　/**</b></p><p>　　* The doGet method of the servlet. <br></p&

8、gt;<p><b>　　*</b></p><p>　　* This method is called when a form has its tag value method equals to get.</p><p><b>　　* </b></p><p>　　* @param request th

9、e request send by the client to the server</p><p>　　* @param response the response send by the server to the client</p><p>　　* @throws ServletException if an error occurred</p><p>　

10、　* @throws IOException if an error occurred</p><p><b>　　*/</b></p><p>　　public void doGet(HttpServletRequest request, HttpServletResponse response)</p><p>　　throws Servl

11、etException, IOException {</p><p>　　doPost(request, response);</p><p><b>　　}</b></p><p><b>　　/**</b></p><p>　　* The doPost method of the servlet

12、. <br></p><p><b>　　*</b></p><p>　　* This method is called when a form has its tag value method equals to post.</p><p><b>　　* </b></p><p>　

13、　* @param request the request send by the client to the server</p><p>　　* @param response the response send by the server to the client</p><p>　　* @throws ServletException if an error occurred&l

14、t;/p><p>　　* @throws IOException if an error occurred</p><p><b>　　*/</b></p><p>　　public void doPost(HttpServletRequest request, HttpServletResponse response)</p>&l

15、t;p>　　throws ServletException, IOException {</p><p>　　int fwid=Integer.parseInt(request.getParameter("fwid"));</p><p>　　boolean flag=HouseDao.delHouserInfoByID(fwid);</p><

16、;p><b>　　if(flag)</b></p><p><b>　　{</b></p><p>　　request.getRequestDispatcher("queryHouse").forward(request,response);</p><p><b>　　}</b&

17、gt;</p><p><b>　　}</b></p><p><b>　　}</b></p><p>　　實(shí)現(xiàn)房屋信息查詢的Servlet類</p><p>　　package myweb.hncu.control;</p><p>　　import java.io.IOE

18、xception;</p><p>　　import java.util.List;</p><p>　　import javax.servlet.ServletException;</p><p>　　import javax.servlet.http.HttpServlet;</p><p>　　import javax.servlet.

19、http.HttpServletRequest;</p><p>　　import javax.servlet.http.HttpServletResponse;</p><p>　　import myweb.hncu.model.dao.HouseDao;</p><p>　　import myweb.hncu.vo.TblHouseVO;</p>

20、<p>　　public class QueryHouseServlet extends HttpServlet {</p><p>　　public void doGet(HttpServletRequest request, HttpServletResponse response)</p><p>　　throws ServletException, IOException

21、 {</p><p>　　doPost(request, response);</p><p><b>　　}</b></p><p>　　public void doPost(HttpServletRequest request, HttpServletResponse response)</p><p>　　thro

22、ws ServletException, IOException {</p><p>　　int uid=(Integer)request.getSession().getAttribute("uid");</p><p>　　List<TblHouseVO> lstHouse=HouseDao.queryHouseByUid(uid);</p>

23、<p>　　request.setAttribute("lstInfo", lstHouse);</p><p>　　request.getRequestDispatcher("my.jsp").forward(request, response);</p><p><b>　　}</b></p>&