门户书籍类别查询

一、门户首页类别

1、直接调用CategoryDao的list方法

2、调用categoryAction的combobox方法

3、index.jsp

<input type="hidden" id="ctx" value="${pageContext.request.contextPath}">

4、index.js

$(function() {
	$.ajax({
		url:$("#ctx").val()+"/category.action?methodName=combobox",
		 success: function (data) {
			 var jsonArr=eval("("+data+")");
		    	var html='';
		    	for(var i in jsonArr){
		    		html+='<li class="list-group-item">'+jsonArr[i].name+'</li>';
		    	}
		    	$(".list-group").append(html);
		 }
	});
})

展示结果

 二、类别分类查询

添加点击事件

html+='<li class="list-group-item" οnclick="searchByType('+jsonArr[i].id+')">'+jsonArr[i].name+'</li>'

$(function() {
	$.ajax({
		url:$("#ctx").val()+"/category.action?methodName=combobox",
		 success: function (data) {
			 var jsonArr=eval("("+data+")");
		    	var html='';
		    	for(var i in jsonArr){
		    		html+='<li class="list-group-item" onclick="searchByType('+jsonArr[i].id+')">'+jsonArr[i].name+'</li>';
		    	}
		    	$(".list-group").append(html);
		 }
	});
})

index.jsp

<script type="text/javascript">

    function searchByType(cid){
        location.href='${pageContext.request.contextPath}/book.action?methodName=findByType&cid='+cid;
    };

</script>

bookAction

/**
	 * 目标：按照书籍的类别查询出对应的书籍信息
	 * 前端：
	 *  从首页index.jsp传递书籍类别id到后台来查询
	 *  不是发送ajax请求
	 * 后端：
	 *  通过类别id查询到对应书籍集合，到前台遍历
	 *  后台是有返回值
	 */
	//类别分类查询
	public String findByType(HttpServletRequest req, HttpServletResponse resp) {
		try {
			PageBean pageBean=new PageBean();
			pageBean.setRequest(req);
			List<Book> list = bd.list(book, pageBean);
			req.setAttribute("books", list);
			req.setAttribute("pageBean", pageBean);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return "findBook";
	}

bookDao

/**
	 * 查询
	 * @param book
	 * @param pageBean
	 * @return
	 * @throws Exception
	 */
	public List<Book> list(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);
	}

展示效果

 三、图片上传

listBook1.jsp

//图片上传表单提交
    function submitForm2() {
        var row = $('#dg').datagrid('getSelected');
        console.log(row);
        // if (row) {
        //     $('#ff2').attr("action", $('#ff2').attr("action") + "&id=" + row.id);
        // }
        $('#ff2').form('submit', {
            url: '${pageContext.request.contextPath}/book.action?methodName=upload&id=' + row.id,
            success: function (param) {
                $('#dd2').dialog('close');
                $('#dg').datagrid('reload');
                $('#ff2').form('clear');
            }
        })
    }

resource.properties

diskDir=E:/temp/2021/mvc/upload/
serverDir=/uploadImages/

 Dateutil

package com.zking.util;
import java.text.SimpleDateFormat;
import java.util.Date;
public class DateUtil {
 
	public static String getCurrentDateStr() {
		SimpleDateFormat sdf=new SimpleDateFormat("yyyyMMddHHmmss");
		
		return sdf.format(new Date());
	}
 
}

propertiesUtil

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("/resource.properties");
		p.load(in);
		return p.getProperty(key);
	}
 
}

bookDao

//上传图片（修改图片路径）
	public void editImgUrl(Book book) throws Exception {
		String sql="update t_easyui_book set image=? where id=?";
		super.executeUpdate(sql, book, new String[] {"image","id"});
	}

bookAction

//图片上传
	public String upload(HttpServletRequest request, HttpServletResponse response) {
		 try {
	            FileItemFactory factory = new DiskFileItemFactory();
	            ServletFileUpload upload = new ServletFileUpload(factory);
	            List<FileItem> items = upload.parseRequest(request);
	            Iterator<FileItem> 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();
	                    
	                    /**
	                     * serverDir=/uploadImages   浏览器映射地址
	                     * diskDir=E:/temp/2021/mvc/upload   真实存在地址
	                     */
	                    
	                    // 存入数据的的数据，以及浏览器访问图片的映射地址
	                    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.bd.editImgUrl(book);
	                    ResponseUtil.writeJson(response, 1);
	                }
	            }
 
	        } catch (Exception e) {
	            e.printStackTrace();
	        }
	        return null;
	    }

添加

 <Context path="/uploadImages" docBase="E:/temp/2021/mvc/upload/"/>    

展示效果