Everybody大家好!
今天给大家带来的是EL+JSTL的运用,这一期文字内容不多,主要是给大家带来一个上期学习内容的运用案例,代码段比较多,还请慢慢看,我们以商品的修改和分页为例:
主界面(index.jsp):
(其中需要查询全部&单个查询&修改&获取最大页面的dao方法)
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!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>
</head>
<body>
<!--
下拉框的模糊查询
<select name="xl">
<option value='gname'>商品名称</option>
<option value='ginfo'>商品描述</option>
</select>
-->
<form action="myload.jsp" method="post">
商品名:<input type="text" name="gname" value="${gname}">
<input type="submit" value="查询">
</form>
<br>
<table border="1px">
<tr>
<td>商品序号</td>
<td>商品名称</td>
<td>商品价格</td>
<td>操作</td>
</tr>
<!-- 如果集合为空 就转发到加载页面去加载数据 -->
<c:if test="${empty myls}">
<jsp:forward page="myload.jsp"></jsp:forward>
${1+1}
</c:if>
<!-- 展示数据 循环遍历集合 -->
<c:forEach items="${myls}" var="g">
<tr>
<td>${g.gid }</td>
<td>${g.gname }</td>
<td>${g.gprice }</td>
<td><a href="preupdate.jsp?gid=${g.gid}">修改</a></td>
</tr>
</c:forEach>
</table>
<div>
【${pageIndex}/${max}】
<a href="myload.jsp?pid=1&gname=${gname}">首页</a>
<a href="myload.jsp?pid=${pageIndex>1?pageIndex-1:1}&gname=${gname}">上一页</a>
<a href="myload.jsp?pid=${pageIndex<max?pageIndex+1:max}&gname=${gname}">下一页</a>
<a href="myload.jsp?pid=${max}&gname=${gname}">末页</a>
</div>
</body>
</html>
如果集合为空即跳转到myload.jsp界面调用查询全部方法加载数据
myload.jsp页面:
<%@page import="com.zking.entity.goods"%>
<%@page import="java.util.List"%>
<%@page import="com.zking.dao.GoodsDao"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
//调用业务逻辑层 biz
GoodsDao gb=new GoodsDao();
int pageIndex=1;
int pageSize=2;
//接收pid
String pid=request.getParameter("pid");
if(pid!=null){//说明点了x页
pageIndex=Integer.parseInt(pid);
}
//把pageIndex存起来 方便取
request.setAttribute("pageIndex", pageIndex);
//接收表单提交过来的关键字
String str=request.getParameter("gname");
if(str==null){
str="";//相当于查询全部
}
//把gname存起来
request.setAttribute("gname", str);
//获得最大页码
int max=gb.getMax("goods where gname like '%"+str+"%'", pageSize);
//把max存起来 方便取 ${max}
request.setAttribute("max", max);
//调用查询全部的方法
List<goods> ls=gb.getAllByPage(pageIndex, pageSize, str);
if(ls.size()!=0){//集合中有数据
//把集合存起来=request中
request.setAttribute("myls", ls);
//跳转到展示页面进行展示 只能转发
request.getRequestDispatcher("index.jsp").forward(request, response);
}
else{
System.out.print("meishuju");
System.out.print("集合为空-优先检查数据库中是否有数据 DBHelper以及dao/biz");
}
%>
其中包含分页的方法(获得最大页数):
当获取完值在主界面展示成功后,可点击修改跳转到纯java代码的逻辑页面preupdate.jsp页面获取该商品对象,将商品数据传递到update.jsp页面进行修改
preupdate.jsp:
<%@page import="com.zking.entity.goods"%>
<%@page import="com.zking.dao.GoodsDao"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
//接收gid
String gid=request.getParameter("gid");
//调用业务逻辑层
GoodsDao gd=new GoodsDao();
//查询单个的方法
goods goods=gd.getGoodsByGid(gid);
//存request中
request.setAttribute("goods", goods);//${goods}
//只能转发
if(goods!=null){
request.getRequestDispatcher("update.jsp").forward(request, response);
}
else{
System.out.print("对象为空");
}
%>
update.jsp:
<%@ 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>
</head>
<body>
<form action="doupdate.jsp" method="post">
<!-- name值跟实体类的属性名一致 -->
商品序号:<input type="text" name="gid" value="${goods.gid}" readonly="readonly"><br>
商品名称:<input type="text" name="gname" value="${goods.gname}"><br>
商品价格:<input type="text" name="gprice" value="${goods.gprice}"><br>
<input type="submit" value="修改">
<input type="reset" value="清空">
</form>
</body>
</html>
将数据更改之后点击修改调转到doupdate.jsp页面,如果修改成功就返回主界面:
doupdate.jsp:
<%@page import="com.zking.biz.GoodBiz"%>
<%@page import="com.zking.biz.IGoodBiz"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<jsp:useBean id="g" class="com.zking.entity.goods"></jsp:useBean>
<jsp:setProperty property="*" name="g"/>
<%
//设置编码方式
request.setCharacterEncoding("utf-8");
/* //接收表单的值
String gid=request.getParameter("gid");
String gname=request.getParameter("gname");
String gprice=request.getParameter("gprice");
//实例化一个商品对象
Goods goods=new Goods();
//给对象赋值
goods.setGname(gname);
goods.setGprice(Integer.parseInt(gprice)); */
//调用业务逻辑层
IGoodBiz igb=new GoodBiz();
if(igb.updateGoods(g, g.getGid())>0){
response.sendRedirect("index.jsp");
}
else{
out.print("<script>alert('修改失败');location.href='preupdate.jsp?gid="+g.getGid()+"';</script>");
}
%>
ok,以上就是我们大体的操作步骤,主要还是看代码一步一步慢慢的细心的来,如果做不到像我这么信息的话很可能出不来效果或者dao方法有问题,好了,咱们下期见!