我的后台代码为:public class Test { public List main() throws ClassNotFoundException, SQLException {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Northwind";
Connection conn = DriverManager.getConnection(url, "sa", "123");
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT TOP 10 *\n" +
"FROM Orders\n" +
"WHERE (OrderID NOT IN\n" +
" (SELECT TOP 10 Orderid\n" +
" FROM Orders\n" +
" ORDER BY Orderid))\n" +
"ORDER BY OrderID");
int i;
List l = new ArrayList();
while (rs.next()) {
l.add(rs.getString("CustomerID"));
l.add(rs.getString("EmployeeID"));
}
return l;
}
}
我想把 红色数值写成一变量;怎么完成?前台才能得到
前台jsp代码 :
jsp:useBean id="userid" class="binhe.Test"/>
<head><title>Simple jsp page</title></head>
<body><% List l = userid.main();
for (int i= 0; i < l.size(); i++) {
out.println(l.get(i)); } %>
我还应怎样写才能实现分页 ? 各位大神教教 我 菜鸟+笨鸟虚心求教!!!!
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Northwind";
Connection conn = DriverManager.getConnection(url, "sa", "123");
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT TOP 10 *\n" +
"FROM Orders\n" +
"WHERE (OrderID NOT IN\n" +
" (SELECT TOP 10 Orderid\n" +
" FROM Orders\n" +
" ORDER BY Orderid))\n" +
"ORDER BY OrderID");
int i;
List l = new ArrayList();
while (rs.next()) {
l.add(rs.getString("CustomerID"));
l.add(rs.getString("EmployeeID"));
}
return l;
}
}
我想把 红色数值写成一变量;怎么完成?前台才能得到
前台jsp代码 :
jsp:useBean id="userid" class="binhe.Test"/>
<head><title>Simple jsp page</title></head>
<body><% List l = userid.main();
for (int i= 0; i < l.size(); i++) {
out.println(l.get(i)); } %>
我还应怎样写才能实现分页 ? 各位大神教教 我 菜鸟+笨鸟虚心求教!!!!
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Northwind";
Connection conn = DriverManager.getConnection(url, "sa", "123");
Statement st = conn.createStatement();
string pagesize="10"; --类似于这样
ResultSet rs = st.executeQuery("SELECT TOP ("+pagesize+") *\n" +
"FROM Orders\n" +
"WHERE (OrderID NOT IN\n" +
" (SELECT TOP 10 Orderid\n" +
" FROM Orders\n" +
" ORDER BY Orderid))\n" +
"ORDER BY OrderID");
int i;
List l = new ArrayList();
while (rs.next()) {
l.add(rs.getString("CustomerID"));
l.add(rs.getString("EmployeeID"));
}
return l;
}
}//建议直接使用分页存储过程。
declare @iCurrentPage int =2declare @sSql varchar(4000)=
'Select Top ' + convert(varchar,@iPageSize) + ' * from tblDiary where DiaryID
not in
(
select top ' + convert(varchar,@iPageSize * @iCurrentPage) + ' DiaryID from tblDiary order by DiaryID asc
) order by DiaryID asc'--PRINT @sSqlexec(@sSql)