1.entity类别实体类
package com.zking.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 + "]";
}
}
2.CategoryDao
package com.zking.dao; import java.util.List; import com.zking.entity.Category; import com.zking.util.baseDao; import com.zking.util.PageBean; public class CategoryDao extends baseDao{ // 查询书籍分类 public List list(Category category,PageBean pageBean) throws Exception { String sql = "select * from t_easyui_category where 1=1"; long id=category.getId(); if(id!=0) { sql+=" and id = "+id; } return super.executeQuery(sql,Category.class, pageBean); } }
3.CategoryAction
package com.zking.web; import com.zking.dao.CategoryDao; import com.zking.entity.Category; import com.zking.framework.ActionSupport; import com.zking.framework.ModelDriver; import com.zking.util.ResponseUtil; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.util.List; public class CategoryAction extends ActionSupport implements ModelDriver{ private Category category = new Category(); private CategoryDao categoryDao = new CategoryDao(); public String combobox(HttpServletRequest req, HttpServletResponse resp){ try { List list = categoryDao.list(category, null); ResponseUtil.writeJson(resp,list); } catch (Exception e) { e.printStackTrace(); } return null; } public String load(HttpServletRequest req, HttpServletResponse resp){ try { //传递id到后台，只会查出一个类别 Category c= categoryDao.list(category, null).get(0); ResponseUtil.writeJson(resp,c); } catch (Exception e) { e.printStackTrace(); } return null; } @Override public Category getModel() { return category; } }
4.配置mvc.xml
5.js拼接
//门户首页类别
$(function(){
$.ajax({
url:$("#ctx").val()+"/Category.action?methodName=combobox",
success:function(data){
// var jsonstr='[{"id":1,"name":"文艺"},{"id":2,"name":"小说"},{"id":3,"name":"生活"}]'
alert(data);
var jsonArr=eval("("+data+")");
var html='';
for(var i in jsonArr){
html+='展示效果：
二.书籍类别查询效果：点击左菜单栏，出现对应的书籍
1.在index.js中要给对应的方法添加点击事件，并附带id传到index.jsp界面
2.当点击左侧菜单栏时要附带改类别的id传到搜索书籍的方法
3.最后查询出改类别所有的书籍，先是在bookdao加上cid的条件，最后在bookAction中调用
BookDao
public Listlist(Book book, PageBean pageBean) throws Exception { String sql="select * from t_easyui_book where 1=1"; String name=book.getName(); int state = book.getState(); long cid=book.getCid(); if(StringUtils.isNotBlank(name)) { sql+=" and name like '%"+name+"%'"; } if(state!=0) { sql+=" and state="+state; } if(cid!=0) { sql+=" and cid="+cid; } return super.executeQuery(sql,Book.class, pageBean); }
bookAction
public String findByType(HttpServletRequest req, HttpServletResponse resp) {
try {
PageBean pageBean =new PageBean();
pageBean.setRequest(req);
Listlist=bookDao.list(book, pageBean);
req.setAttribute("books",list);
req.setAttribute("pagebean",pageBean);
} catch (Exception e) {
e.printStackTrace();
}
return "findBook";
}
配置mvc.xml
书籍界面展示：
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>
网上书城首页
您好，欢迎来到飞凡网上书店！
登录 |
注册 |
我的购物车 |
网站首页
- 书籍分类 <%--
- 999999999999999999999999999999999999 --%>
小说名字
--%> <%--价格--%> <%--小说名字
--%> <%--价格--%> <%--展示效果：
三.图片上传
思路：
1.导入图片上传需要的jar包
2.BookDao中写好修改image路径的方法
3.BookAction中写好上传图片的方法
4.到eclipse内部服务器中配置好图片映射
bookAction
public String upload(HttpServletRequest request, HttpServletResponse response) {
try {
FileItemFactory factory = new DiskFileItemFactory();
ServletFileUpload upload = new ServletFileUpload(factory);
List items = upload.parseRequest(request);
Iterator itr = items.iterator();
HttpSession session = request.getSession();
while (itr.hasNext()) {
FileItem item = (FileItem) itr.next();
if (item.isFormField()) {
System.out.println("普通字段处理");
book.setId(Long.valueOf(request.getParameter("id")));
} else if (!"".equals(item.getName())) {
String imageName = DateUtil.getCurrentDateStr();
// 存入数据的的数据，以及浏览器访问图片的映射地址
String serverDir = PropertiesUtil.getValue("serverDir");
// 图片真实的存放位置
String diskDir = PropertiesUtil.getValue("diskDir");
// 图片的后缀名
String subfix = item.getName().split("\.")[1];
book.setImage(serverDir + imageName + "." + subfix);
item.write(new File(diskDir + imageName + "." + subfix));
this.bookDao.editImgUrl(book);
ResponseUtil.writeJson(response, 1);
}
}
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
工具类
package com.zking.util;
import java.text.SimpleDateFormat;
import java.util.Date;
public class DateUtil {
*/
public static String getCurrentDateStr()throws Exception{
Date date=new Date();
SimpleDateFormat sdf=new SimpleDateFormat("yyyyMMddHHmmss");
return sdf.format(date);
}
}
文件解析类
package com.zking.util;
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;
public class PropertiesUtil {
public static String getValue(String key) throws IOException{
Properties p=new Properties();
InputStream in=PropertiesUtil.class.getResourceAsStream("/resources.properties");
p.load(in);
return p.getProperty(key);
}
}
配置resource.properties文件内容
diskDir=E:/temp/2021/mvc/upload/
serverDir=/uploadImages/
到server服务里调路径
展示效果：
