网上书城(功能模块二)

目标

1.使用自定义mvc编写模式
2.通过编码实现页面与数据库进行数据绑定
3.动态绑定下拉框数据(combox组件)


表结构(设计)

1.下拉框类别结构表
在这里插入图片描述

步骤

entity类

package com.houzhihong.entity;

public class Category {
    private long id;
    private String name;
	public long getId() {
		return id;
	}
	public void setId(long id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	@Override
	public String toString() {
		return "Category [id=" + id + ", name=" + name + "]";
	}
	public Category(long id, String name) {
		super();
		this.id = id;
		this.name = name;
	}
	public Category() {
		super();
	}
    
}


dao层

1.查询书籍分类方法:

package com.houzhihong.dao;

import java.util.List;

import com.houzhihong.entity.Category;
import com.houzhihong.util.BaseDao;
import com.houzhihong.util.PageBean;

public class CategoryDao extends BaseDao<Category> {
//    查询书籍分类
    public List<Category> list(Category category, PageBean pageBean) throws Exception {
        String sql = "select * from t_easyui_category where true ";
        return super.executeQuery(sql,pageBean,Category.class);
    }
}



web层

1.处理数据访问业务逻辑action

package com.houzhihong.web;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.houzhihong.dao.CategoryDao;
import com.houzhihong.entity.Category;
import com.houzhihong.framework.ActionSupport;
import com.houzhihong.framework.ModelDriven;
import com.houzhihong.util.ResponseUtil;

import java.util.List;

public class CategoryAction extends ActionSupport implements ModelDriven<Category> {
    private Category category = new Category();
    private CategoryDao categoryDao = new CategoryDao();

    public String list(HttpServletRequest request, HttpServletResponse response){
        try {
            List<Category> list = categoryDao.list(category, null);
            ResponseUtil.writeJson(response,list);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }

    @Override
    public Category getModel() {
        return category;
    }
}


页面

1.书籍类别下拉框
在这里插入图片描述

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<link rel="stylesheet" type="text/css"
	href="${pageContext.request.contextPath }/static/css/themes/gray/easyui.css">
<link rel="stylesheet" type="text/css"
	href="${pageContext.request.contextPath }/static/css/themes/icon.css">
<link rel="stylesheet" type="text/css"
	href="${pageContext.request.contextPath }/static/css/bootstrap.css">
<script type="text/javascript"
	src="${pageContext.request.contextPath }/static/js/jquery.min.js"></script>
<script type="text/javascript"
	src="${pageContext.request.contextPath }/static/js/jquery.easyui.min.js"></script>
<script type="text/javascript"
	src="${pageContext.request.contextPath }/static/js/addbook.js"></script>
</head>
<body>
	<input type="hidden" id='ctx'
		value="${pageContext.request.contextPath }">
	<form id='ff' style="margin-top: 100px" class="form-horizontal" method="post">
		<div class="form-group">
			<label for="inputEmail3" class="col-sm-2 control-label">书名</label>
			<div class="col-sm-6">
				<input type="text" class="form-control" id="name" name="name"
					placeholder="书名">
			</div>
		</div>
		<!-- 下拉菜单 -->
		<div class="form-group">
			<label for="inputEmail3" class="col-sm-2 control-label">类别</label>
			<div class="col-sm-6">
				<input id="cc" name="cid" value="请选择">
			</div>
		</div>
		<div class="form-group">
			<label for="inputPassword3" class="col-sm-2 control-label">作者</label>
			<div class="col-sm-6">
				<input type="text" class="form-control" id="author" name="author"
					placeholder="作者">
			</div>
		</div>
		<div class="form-group">
			<label for="inputPassword3" class="col-sm-2 control-label">价格</label>
			<div class="col-sm-6">
				<input type="text" class="form-control" id="price" name="price"
					placeholder="价格">
			</div>
		</div>
		<div class="form-group">
			<label for="inputPassword3" class="col-sm-2 control-label">出版社</label>
			<div class="col-sm-6">
				<input type="text" class="form-control" id="publishing" name="publishing"
					placeholder="出版社">
			</div>
		</div>
		<div class="form-group">
			<label for="inputPassword3" class="col-sm-2 control-label">简介</label>
			<div class="col-sm-6">
				<input type="text" class="form-control" id="description" name="description"
					placeholder="简介">
			</div>
		</div>
		<div class="form-group">
			<div class="col-sm-offset-3 col-sm-10">
				<button type="submit" class="btn btn-default" id="my_form" >提交</button>
				<button type="reset" class="btn btn-default">清空</button>
			</div>
		</div>

	</form>
</body>
</html>


  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值