登 录
mybook.jsp
对于原始session.currentPage可以再jsp种实现 也可以在 事件消息 HttpSessionListener中实现
<%@ page language="java" contentType="text/html; charset=UTF-8"<br /> pageEncoding="UTF-8"%><br /> <%@taglib uri="/WEB-INF/why.tld" prefix="myExample"%><br /> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><br /> <html><br /> <head><br /> <mce:script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" mce_src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></mce:script><br /> <mce:script type="text/javascript" src="http://localhost/show/js/you.js" mce_src="http://localhost/show/js/you.js"></mce:script><br /> <link rel="stylesheet"<br /> href="http://localhost/show/css/you.css" mce_href="http://localhost/show/css/you.css"<br /> type="text/css"/><br /> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><br /> <title>Insert title here</title><br /> </head><br /> <body><br /> <myExample:to here="do i "/><br /> <div class="change"><br /> <myExample:query table="book" page="${sessionScope.currentPage==null?1:sessionScope.currentPage}"/><br /> </div><br /> </body><br /> </html>
you.js
$(document).ready(function(){<br /> $("span.click").click(function(){<br /> var xmlhttp;<br /> if (window.XMLHttpRequest)<br /> {// code for IE7+, Firefox, Chrome, Opera, Safari<br /> xmlhttp=new XMLHttpRequest();<br /> }<br /> else<br /> {// code for IE6, IE5<br /> xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");<br /> }<br /> xmlhttp.onreadystatechange=function()<br /> {<br /> if (xmlhttp.readyState==4 && xmlhttp.status==200)<br /> {<br /> location.reload();<br /> }<br /> };<br /> xmlhttp.open("GET","./change?page="+$(this).html(),true);<br /> xmlhttp.send();</p> <p> });<br /> });<br />
我使用自定义标签实现的，
标签
package my;<br /> import java.io.IOException;<br /> import java.sql.*;<br /> import javax.servlet.jsp.tagext.*;<br /> public class Query extends SimpleTagSupport {<br /> private Statement statement ;<br /> private String table=null;<br /> private int page,number=2;<br /> private ResultSet resultSet;<br /> private String follow="";<br /> public void doTag(){<br /> String querySql="SELECT name,price FROM "+table;<br /> try {<br /> statement =MySql.getStatement("why", "root", "root");<br /> resultSet=statement.executeQuery(querySql);<br /> this.getJspContext().getOut().println("<br/>"+"<br/>"+getResult());<br /> } catch (Exception e){<br /> // TODO Auto-generated catch block<br /> e.printStackTrace();<br /> }<br /> }<br /> private String getResult() throws Exception{<br /> int totalRow,totalPage;<br /> String str = null;<br /> if(((page-1)==0||resultSet.absolute((page-1)*number))&&resultSet.last()){<br /> totalRow=resultSet.getRow();<br /> totalPage=totalRow/number+(totalRow%number==0?0:1);<br /> if(page-1>0)<br /> resultSet.absolute((page-1)*number);<br /> else<br /> resultSet.beforeFirst();<br /> }else{<br /> follow+="null";<br /> return null;<br /> }</p> <p> for(int i=0;i<number&&resultSet.next();++i){<br /> str+="<div class=/"red/">"+resultSet.getString("name")+"<br/>"+resultSet.getDouble("price")+"</div><br/>";<br /> follow+=resultSet.getString("name")+resultSet.getDouble("price");<br /> }<br /> for(int i=1;i<=totalPage;++i){<br /> if(i==page){<br /> str+="<span style="/" mce_style="/""color:red/">"+i+"</span>";<br /> continue;<br /> }<br /> str+="<span class=/"click/">"+i+"</span>";<br /> }<br /> return str;<br /> }<br /> public void setTable(String table){<br /> this.table=table;<br /> }<br /> public void setPage(int page){<br /> this.page=page;<br /> }<br /> public void setNumber(int number){<br /> this.number=number;<br /> }<br /> }
why.tld
<?xml version="1.0" encoding="UTF-8" ?><br /> <taglib xmlns="http://java.sun.com/xml/ns/j2ee"<br /> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"<br /> xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee<br /> http://java.sun.com/xml/ns/j2ee/web-jsptaglibrary_2_0.xsd"<br /> version="2.0"></p> <p> <tlib-version>1.0</tlib-version><br /> <short-name>why</short-name><!--my.Example 声明name example--><br /> <tag><br /> <name>to</name><br /> <tag-class>my.Example</tag-class><br /> <body-content>empty</body-content><br /> <attribute><br /> <name>here</name><br /> </attribute><br /> </tag><br /> <tag><br /> <name>query</name><br /> <tag-class>my.Query</tag-class><br /> <body-content>empty</body-content><br /> <attribute><br /> <name>table</name><br /> <required>true</required><br /> </attribute><br /> <attribute><br /> <name>page</name><br /> <required>true</required><br /> <rtexprvalue>true</rtexprvalue><br /> </attribute><br /> <attribute><br /> <name>number</name><br /> </attribute><br /> </tag></p> <p></taglib>
抱歉!评论已关闭.