规律是:listsize:每页总条数, ipage:当前页数,
起始:listsize *(ipage-1) + 1
再去循环 listsize次循环 i++
切记: 保证 ipage,listsize 都 >= 1
具体JSP语法,不会。。。,但思路是一样的
<%@ page import="java.text.*" %><%
String time = ""
SimpleDateFormat dformat = new SimpleDateFormat("yyyy-MM-dd HH-mm-ss")
time = dformat.format(new java.util.Date())
time = time.replaceAll("-","")
time = time.replaceAll(" ","")
time = time.substring(0,4)
String ReportType=request.getParameter("ReportType")
Statement stmt = null
ResultSet rs = null
Connection conn = null
SQLBean_JDBC so = new SQLBean_JDBC()
String stringSql=""
String serial4=""
stringSql = "select max(convert(int,substring(yewubaogaodanhao,9,4)))+1 as yewubaogaodanhao "
+" from tuoyun where substring(yewubaogaodanhao,1,4)='"+time+"'"
String serial= ""
try{
conn = so.getConnection()
stmt = conn.createStatement()
rs = stmt.executeQuery(stringSql)
}
catch (Exception ex) {
System.out.println("nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn")
}
while (rs.next()){
try {
serial4 = rs.getString("yewubaogaodanhao")
%>
<%
} catch (Exception ex) {
System.out.println("qqqqqqqqqqqqqqqqqqqqqqqqqqq"
+ ex.getMessage())
%>
<%
}
}
rs.close()
stmt.close()
conn.close()
if(serial4==null){serial4="0001"}
if(serial4.length()==1){serial4="000"+serial4}
if(serial4.length()==2){serial4="00"+serial4}
if(serial4.length()==3){serial4="0"+serial4}
serial = time+"RLMD"+serial4
%>
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)