根據' SPMCH '(商品名稱),模糊查詢和分頁,PageBean類是壹個分頁javabean:
妳需要重點關註的是:“from spkfk where SPM chlike“%”這個。sp mch " % ' order by spid)a order by spid c)b order by spid "
這壹段!
公共列表& ltGoodsBean & gtgetInfo(PageBean頁面,String spmch)
引發ClassNotFoundException,SQLException {
int onepagesize
int max
連接連接=空;
PreparedStatement ps = null
string URL = " JDBC:SQL server://localhost:1433;databaseName = ST _ ccerp ";
String username = " sa
字符串密碼= " ";
string driver = " com . Microsoft . JDBC . SQL server . SQL server driver ";列表& ltGoodsBean & gtlist = new ArrayList & ltGoodsBean & gt();
one pagesize = page . getone pagesize();
int offset = page . get offset();
max = offset+one pagesize;
結果集rs = null
嘗試{
Class.forName(驅動程序);
conn = driver manager . getconnection(URL,用戶名,密碼);
String sql = " spid,spmch,shpchd,shpgg,shiyzh,chuffl,lei bie ";
字符串sql2 = null
this . SPM ch = SPM ch;
如果(spmch!= null & amp& ampspmch.length()!= 0)
sql2 = (new StringBuilder("SELECT "))
。追加(sql)
。append(" FROM(選擇頂部")
。追加(onepagesize)
。追加(sql)
。append(" FROM(選擇頂部")
。追加(最大)
。追加(sql)
。append(" FROM spkfk where spmch like ' % ")
。追加(this.spmch)
。追加(
“% '按spid排序)a按spid排序desc) b按spid排序”)
。toString();
其他
sql2 = (new StringBuilder("SELECT "))
。追加(sql)
。append(" FROM(選擇頂部")
。追加(onepagesize)
。追加(sql)
。append(" FROM(選擇頂部")
。追加(最大)
。追加(sql)
。append(" FROM spkfk ")
。追加(
“按spid排序)a按spid排序desc) b按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
。獲取字符串(3),遠程獲取字符串(4),遠程獲取字符串(5),遠程獲取字符串
。getString(6),RS . getString(7)));
}
}最後{
如果(ps!=空)
PS . close();
如果(conn!=空)
conn . close();
}
退貨單;
}