Pages,动态网页技术)技术,JSP页面通过JDBC(Java Database Connectivity,Java数据库连接)接口连接SQL Server 2000数据库,实现了浏览器端和服务器端的程序。系统经过测试,运行效果稳定、操作方便、快捷。能较好的为该系统的房屋出租、求租用户服务。
关键词 B/S结构;JDBC连接;SQL Server 2000;
Abstract
Along with the development of the computer science in 21 centuries, the database technique is more and more extensive in the application in the Internet, providing the more thoughtful and humanized service for the large network customer. Characteristic have already become gradually the current as the application of Wed nowadays. How to communicate on the web is a new topic facing us.
This paper describes how to struct a system to have set forth house to Let management adopt B/S structure's, the paper describes the B/S structure and SQL Server, JSP technology principles. The article complete the needs analysis of an system for the management applications for communication which on the web, functional modules division and database model analysis. The technology is in progress here to what be applied key on the basis, describe that. Final, comment that to procedure debugging with testing result being in progress.
The discourse according to the practical demand of some users, which is on the base of the situation of the domestic and international recorded at present. adopt currently comparatively popular B/S (Browser/Server) structure and JSP development Web page to develop a technology, 2000 data bases, adopt the JSP technology owing to Windows XP Professional OS and SQL Server, the function having designed and realizing one is comparatively perfect house to Let management system. Through a series of preparation such as requirement analization,design,coding,test through set forth house to Let management system. That is the system domestic consumer's turn to be able to register becoming the website member, landing website, browse,check building information,announce and then individual building information, can look up the press release that website waiting, administrative person can carry out administration on the website member, building information and the
website press release. The small advantages having designed process work to system describes priority, requires that the place improving has done a summary at the same time also to system.
Internet, application status, using a Web-based three-tier system structure, the browser Web application servers database servers. Through the teacher evaluation process needs to conduct a detailed analysis, establish a system of the model and data model. Identify the data model for relational data model for the analysis, design, which depicts the E-R charts. Selection of the background database SQL Server 2000 is to be achieved. Web develops using current popular JSP (Java Server Pages, Dynamic web technolo