100 seeking classification query code

Category: Web Develop
 
mj11011
2013-08-20 04:51:41

Sponsored Links
For instance by name and student number, etc. and queries, you can display paging, who sent a reference, the 100 full-sent him, first thank you.
tank: [email protected]

Sponsored Links

patton1218
2013-08-20 04:54:16
stem = conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
rs = stem.executeQuery (sql);
if (start! = 0) rs.absolute (start);
use absolute positioning can be well tag reading problem solving. . . . And then to (the number of pages, page parameters to handle it when solved .... located in jsp show on themselves, and there are many ready-made pagination tag library.
hbxgyczj
2013-08-20 05:02:12
sql statement added where several different conditions, when the user selects different conditions, where conditions on the corresponding + up.
execute sql
query result is then paged.
paulzsp
2013-08-20 05:08:58
Search in
String sql = "";
String sql1 = "select * from table1 t1 where";
String sql2 = "t1.xuehao = '" + parameter variables + "'";
String sql3 = "t1.xingming = '" + parameters Variables + "'";

if (xxx = Student ID)
sql = sql1 + sql2;

............
............
lijinying103
2013-08-20 05:16:21
Paging much, I use you not take it, a lot of online , you find yourself right now
lylianying
2013-08-20 05:25:33
sql add where conditions on the line, and all of the pages, like
ptyzjxm
2013-08-20 05:39:11
Halo.. LZ really lazy..
shuiyezi20
2013-08-20 05:56:20
usually no written java code in the page, this is really not
QQHOT163
2013-08-20 06:03:45
do not know, probably not the first two conditional statements executed it, less likely
davisroan
2013-08-20 06:11:16
I am part of the code,
if (searchtype! = null && searchkey! = null && searchtype.equals ("name"))
strSQL = "select * from user where userName like '% "+ searchkey +"%' ";
else
if (searchtype! = null && searchkey ! = null && searchtype.equals ("Sex"))
strSQL = "select * from user where sex like '%" + searchkey + "% '";
else strSQL = "select * from user";
sqlRst = ; sqlStmt.executeQuery (strSQL);

first <% = intPage%> Total <% = intPageCount%> page
<% if (intPage == 1) {
%>
first page & ; nbsp; Previous
<%}
else
{
%>
<a href = " ; query1.jsp? page = <% = 1%> "> First </a>
<a href =" query1.jsp ? page = <% = intPage-1%> "> Previous </a>
<%
}
if (intPage == intPageCount)
{
%>
Next
last page
<%
}
else
{
%>
<a href = "query1.jsp? page = <% = intPage + 1%> "> Next </a>
<a href =" query1.jsp? page = <% = intPageCount%> "> Last page </a>
<%
}
%>

able to get the correct query results, but there is a problem is that such investigations by sex, you can get the correct results Page 1 of 2; however point Next, they will put the data extracted from the entire database, not only two, Is this what the reason!

duqilu007
2013-08-20 06:19:08
To KYO_vs_IORI (domestic small Pig) just want to refer to someone else's Program
Domain and server ip had changed since 8/23/2013. Suspend the user registration and posts for program maintenance.