Java毕业设计:物业管理系统附毕业论文,Java小程序Applet;应用程序Application;数据库;数据库实现;JDBC/ODBC桥;JDBC驱动程序,本物业管理系统界面比较实用,系统稳定性好,在不同的计算机上都可以很平稳的运行。运行时在服务器上先安装Windows NT操作系统,并在NT系统下安装数据库系统SQL Server 7.0和建立人员、住房、房产、收费四个数据库。然后在NT操作系统下用Java编写不同的系统用户界面,后用JDBC/ODBC桥实现服务器上数据库和前端界面的连接。连接成功后,将Java编写的用户界面移植到客户端的Linux操作系统下,并用这个界面试图实现与服务器上NT系统下的数据库SQL连接。以达到在不同的操作系统下可以互相调用的目的,实现Java的重要特性:可移植性。
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001291s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.067902s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001000s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001226s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001008s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003238s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000842s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003813s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014661s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001209s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 52940 [ RunTime:0.019850s ]