Java修仙道路_JAVA修仙？？

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

pageEncoding="UTF-8" import="java.sql.*"%>

function Confirm() {

s = confirm("后台系统无需使用此方法！")

}

Connection conn=null;

Statement stmt=null;

ResultSet rs=null;

try{

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

String strConn="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=ShopSystem";

String User="sa";

String Password="123456";

conn=DriverManager.getConnection(strConn,User,Password);

String sqlSentence1="Select p_id,p_type,p_name,p_price,p_quantity,p_image from Product Order by p_id desc;";

stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

rs=stmt.executeQuery(sqlSentence1);

String str=request.getParameter("page");

if(str==null)

str="0";

int pageSize=10;

rs.last();

int recordNum=rs.getRow();

int maxPage=(recordNum%pageSize==0)?(recordNum/pageSize):(recordNum/pageSize+1);

int currentPage=Integer.parseInt(str);

if(currentPage<1)

currentPage=1;

if(currentPage>maxPage)

currentPage=maxPage;

rs.absolute((currentPage-1)*pageSize+1);

%>

产品编号	产品类别	产品名称	产品价格	产品数量	产品图片	更新|描述	插入|删除
					" width="80">	更改方式1 更改方式2	">删除

if(!rs.next())

break;

}

%>

JumpTo:

1){%>

FirstPage

PreviousPage

||

NextPage

LastPage

}catch(Exception e){

out.println(e.getMessage());

}

if(rs!=null)rs.close();

if(stmt!=null)stmt.close();

if(conn!=null)conn.close();

%>