从数据库查出一个list,显示在JSP页面上,如何加序号?

从数据库查出一个list,显示在JSP页面上,如何加序号?,第1张

根据当前页的序号,做 *** 作

规律是: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

%>


欢迎分享,转载请注明来源:内存溢出

原文地址: http://outofmemory.cn/bake/11264590.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2023-05-14
下一篇 2023-05-14

发表评论

登录后才能评论

评论列表(0条)

保存