turn.jsp

jsp连接样例!详细说明了jsp的连接方法!新手值得一看!

<%@page contentType="text/html; charset=gb2312" language = "java"%>
<%!
//分页用到的变量
int intRowCount;  //记录总数
int intPageCount; //总页数
int intPage;      //待显示页码
%>
<%!
public void countPage(String strPage,ResultSet rs){
	try{
		if(strPage == null || strPage == ""){//表明在QueryString中没有page这一个参数，此时显示第一页数据
			intPage = 1;
		}else{//将字符串转换成整型
			intPage = Integer.parseInt(strPage);
			if(intPage<1) intPage = 1;
		}
		//获取记录总数
		result.last();
		intRowCount = rs.getRow();
		//记算总页数
		intPageCount = (intRowCount + intPageSize - 1) / intPageSize;
		//调整待显示的页码
		if(intPage > intPageCount) 
			intPage = intPageCount;
		rs.absolute((intPage-1) * intPageSize + 1);		
	}catch(Exception e){
		System.out.println(e);
	}
}
%>
<%!
public void splitPage(JspWriter outs,String strInfo){
	try{
		outs.println("<table width=100% border=0 cellpadding=1 cellspacing=1>");
		outs.println("<tr> ");
		outs.println("<td width='42%'  ><font color=#FF6600><strong>共" + intRowCount + "项" + intPageCount + "页 当前第" + intPage + "页</strong></font></td>");
		outs.println("<td width='58%' align=right>");
		if(intPage ==1){
			outs.println(" 首页 | 上一页 ");
		}else{
			outs.println("<a href=\"?page=1&"+strInfo+"\">首页</a> |");
			outs.println("<a href=\"?page="+(intPage-1)+"&"+strInfo+"\">上一页</a>");
		}
		outs.println(" |");
		for(int j = 1; j <= intPageCount ; j ++){
			if(j == intPage){
				outs.println(" <B>"+j+"</B> ");
			}else{
				outs.println("<a href=?page="+j+"&"+strInfo+">"+j+"</a> ");
			}
		}
		outs.println(" |");
		if(intPage == intPageCount){
			outs.println(" 下一页 | 末页 ");
		}else{
		    outs.println("<a href=?page="+(intPage+1)+"&"+strInfo+">下一页</a> |");
			outs.println("<a href=?page="+intPageCount+"&"+strInfo+">尾页</a>");
		}		
		outs.println("</td>");
		outs.println("</tr>");
		outs.println("</table>");
	}catch(Exception e){
		System.out.println(e);
	}
}
%>