古詩詞大全網 - 團隊口號 - Sqlserver接口號

Sqlserver接口號

我這裏有壹個分頁模糊查詢的例子,給妳看看。

根據' 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();

}

退貨單;

}