According to' SPMCH' (trade name), fuzzy query and paging, PageBean class is a paging javabean:
What you need to focus on is: "from spkfk where spmchlike"% ". sp mch " % ' order by spid)a order by spid c)b order by spid "
This paragraph!
Public list & ltgoodbean & gt getinfo (Pagebean page, String spmch)
Raises ClassNotFoundException, SQLException {
int onepagesize
int max
Connection Connection = empty;
PreparedStatement ps = null
string URL = " JDBC:SQL server://localhost: 1433； databaseName = ST _ ccerp "；
String username = " sa
String password = "";
string driver = " com . Microsoft . JDBC . SQL server . SQL server driver "； List & ltgoodbean & gt list = new ArrayList & ltgoodbean & gt ();
one pagesize = page . getone pagesize()；
int offset = page . get offset()；
max = offset+one pagesize；
Result set rs = null
Try {
Class.forName (driver);
Conn = drivermanager.getconnection (URL, username, password);
String sql = " spid，spmch，shpchd，shpgg，shiyzh，chuffl，lei bie "；
String sql2 = null
this . SPM ch = SPM ch；
If (spmch! = null & amp& ampspmch.length()！ = 0)
sql2 = (new StringBuilder("SELECT "))
. Append (sql)
. Append(" FROM ")
. Onepagesize
. Append (sql)
. Append(" FROM ")
. Additional (maximum)
. Append (sql)
. append(" FROM spkfk where spmch like ' % ")
. Add (this.spmch)
. Append (
"%'sorted by spid) a sorted by spid desc) b sorted by spid")
. toString()；
other
sql2 = (new StringBuilder("SELECT "))
. Append (sql)
. Append(" FROM ")
. Onepagesize
. Append (sql)
. Append(" FROM ")
. Additional (maximum)
. Append (sql)
. append(" FROM spkfk ")
. Append (
"sort by spid) a sort by spid desc) b sort by spid")
. toString()；
PS = conn . prepare statement(SQL 2)；
RS = PS . execute query()；
while (rs.next()) {
list . add(new goods bean(rs . getstring( 1)，rs.getString(2)，RS
. Obtain a character string (3), remotely obtain a character string (4), remotely obtain a character string (5), and remotely obtain a character string.
. getString(6)，RS . getString(7)))；
}
} Finally {
If (ps! = empty)
PS . close()；
If (conn! = empty)
conn . close()；
}
Return order;
}