系统采用SpringMVC+MyBatis技术,前端使用jquery、css、html、bootstrap等技术,功能完善,界面美观,数据库共涉及13张表。
**
- 这是登录页面,输入用户名和密码即可登录,这里有两个角色
**
**
- 查看房源
**
**
- 首页
**
**
- 房屋合同
**
**
- 缴费
**
**
- 我的收租
**
还有其他功能这里就不截图了。
部分表结构 -- ---------------------------- -- Table structure for apply -- ---------------------------- DROP TABLE IF EXISTS `apply`; CREATE TABLE `apply` ( `apply_id` int(11) NOT NULL auto_increment, `house_id` varchar(255) NOT NULL, `address` varchar(255) default NULL, `area` double(255,0) default NULL, `price` double(10,2) default NULL, `status` varchar(255) default NULL, `userlist_id` int(255) NOT NULL, PRIMARY KEY (`apply_id`,`house_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for applyout -- ---------------------------- DROP TABLE IF EXISTS `applyout`; CREATE TABLE `applyout` ( `aoid` int(11) NOT NULL auto_increment, `house_id` varchar(255) default NULL, `address` varchar(255) default NULL, `status` varchar(255) default NULL, `userlist_id` int(11) default NULL, PRIMARY KEY (`aoid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for checkout -- ---------------------------- DROP TABLE IF EXISTS `checkout`; CREATE TABLE `checkout` ( `cid` int(11) NOT NULL auto_increment, `house_id` varchar(255) default NULL, `address` varchar(255) default NULL, `status` varchar(255) default NULL, `userlist_id` int(11) default NULL, PRIMARY KEY (`cid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for hetong -- ---------------------------- DROP TABLE IF EXISTS `hetong`; CREATE TABLE `hetong` ( `id` int(11) NOT NULL auto_increment, `chuzu` varchar(255) default NULL, `chuzu_idcard` varchar(255) default NULL, `zuke` varchar(255) default NULL, `zuke_idcard` varchar(255) default NULL, `fromdate` varchar(255) default NULL, `todate` varchar(255) default NULL, `price` double(10,2) default NULL, `address` varchar(255) default NULL, `house_id` varchar(255) default NULL, `payday` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -------------------------- -- Table structure for houselist -- ---------------------------- DROP TABLE IF EXISTS `houselist`; CREATE TABLE `houselist` ( `id` int(11) NOT NULL auto_increment, `houseid` varchar(255) NOT NULL, `address` varchar(255) NOT NULL, `area` double default NULL, `price` double(10,2) default NULL, `status` varchar(255) default NULL, PRIMARY KEY (`id`,`houseid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for paid -- ---------------------------- DROP TABLE IF EXISTS `paid`; CREATE TABLE `paid` ( `id` int(11) NOT NULL auto_increment, `house_id` varchar(255) default NULL, `address` varchar(255) default NULL, `price` double(10,2) default NULL, `date` date default NULL, `paydate` date default NULL, `name` varchar(255) default NULL, `userlist_id` int(11) default NULL, `status` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
分页查看:
@RequestMapping("/ahouselist") public String ahouselist(Model model ,@RequestParam(required=false,defaultValue="1") Integer page,@RequestParam(required=false,defaultValue="2") Integer pageSize){ PageHelper.startPage(page, pageSize); List<Houselist> houselist=houselistService.selectAll(); PageInfo<Houselist> p=new PageInfo<Houselist>(houselist); model.addAttribute("p", p); model.addAttribute("houselist",houselist); model.addAttribute("mainPage","ahouselist.jsp"); return "admin/main1"; }
mybatis查询:
<select id="findhouselistByVoCount" parameterType="Pojo.QueryVo" resultType="int"> select count(*) from houselist <where> <if test="houseid!=null and houseid!=''"> and username=#{houseid} </if> <if test="address!=null and address!=''"> and address=#{address} </if> <if test="area!=null and area!=''"> and area=#{area} </if> <if test="price!=null and price!=''"> and price=#{price} </if> <if test="status!=null and status!=''"> and status=#{status} </if> </where> </select>
好了,以上就是系统的实现过程,更多文章,点击左上角头像,查看更多相关系统的分享。