..................................................
3)Add.jsp代码:
..................................................
? ">
..................................................
4)Update.jsp代码:
..................................................
? ">
..................................................
5)Delete.jsp代码:
..................................................
? ">
..................................................
6)Result.jsp代码:
..................................................
<%
intcurrentPage=1;
intfirstCount=1;
intendCount=1;
Listlist=null;
list=(ArrayList)session.getAttribute("list");
inteveryPage=2;
inttotalCount=list.size();
inttotalPage=totalCount/everyPage+1;
StringpageNum=request.getParameter("pageNum");
if(pageNum==null||pageNum.equals("")){
currentPage=1;
}else{
currentPage=Integer.parseInt(pageNum);
if(currentPage<=0){
currentPage=1;
}elseif(currentPage>totalPage){
currentPage=totalPage;
}
}
if(currentPage>0&¤tPage<=totalPage){
firstCount=(currentPage-1)*everyPage+1;
}
if(currentPage>0&¤tPage<=(totalPage-1)){
endCount=firstCount+everyPage;
}elseif((currentPage)>0&&(currentPage==totalPage)){
endCount=firstCount+totalCount%everyPage;
}
%>
id
?
?
?
?
?
?
?
?
<%
for(inti=firstCount;i %> <%=((MyPackage.Product)list.get(i-1)).getId()%> <%=((MyPackage.Product)list.get(i-1)).getName()%> <%=((MyPackage.Product)list.get(i-1)).getNum()%> <% } %>
pageNum=<%=currentPage-1%>">?
?
?
pageNum=<%=currentPage+1%>">?
?
?
..................................................
2、Servlet源代码
1)AddServlet代码:
(仅列出关键部分)
..................................................
//关键变量:
Stringid=newString();
Stringname=newString();
intnum;
Stringa=newString();
Stringsql1=newString();
Stringsql2=newString();
Connectionconn=null;
Statementstmt=null;
ResultSetrs=null;
PreparedStatementps=null;
//关键函数
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException
{
id=request.getParameter("id");
name=request.getParameter("name");
a=request.getParameter("num");
if(a==null||a.equals(""))
{
num=0;
}
elsenum=Integer.parseInt(a);
if(id!
=null&&!
id.equals(""))
{
Add(request,response,id,name,num);
}
else
ShowAll(request,re
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1