目标
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>