亚洲AV无码AV男人的天堂,亚洲精品综合一二三区在线,在线观看亚洲免费视频

檢索功能一般步驟：

1 .????檢索功能一般步驟：

2 .???? public ?Vector?getNewItemCodeRequest(CatalogRegistrationRequestInfo?cinfo,? int ?iStartRow,? int ?iPageSize) throws ?GenneralFallureException,RemoteException {

connection?con? = ? null ;

preparedStatement?ps? = ? null ;

ResultSet?rs? = ? null ;

Vector?vt? = ? new ?Vector();

Vector?vtInfo? = ? new ?Vector();

StringBuffer?sqlWhere? = ? new ?StringBuffer();

CatalogRegistrationRequestInfo?cataInfo? = ? null ;

String?a? = ?cinfo.getA(); // 獲得條件傳遞查詢信息

String?sRequestNo? = ?cinfo.getRequestNo?();

…………….

String?c? = ?cinfo.getC()? == ? null ? ?“”:cinfo.getC();

Try {

Con? = ?Dbutil.getConnection(DBNames.DB_NAME);

// ?DataSource?ds?=?null;?

???????????????InitialContext?ctx? = ? new ?InitialContext();??????????????

???????????????Object?obj? = ?ctx.lookup( " mroJNDI " );??????????????????????

???????????????ds? = ?(DataSource)?obj;??????????????????????????????????

???????????????conn? = ?ds.getConnection();?????

ctx.close();????

return ?conn; // 獲得連結(jié)的過程

String?sql? = ?“select?nvl(a.mmmm,b.nnnnnn)QQQQQQ,”? // 選擇a,b中不為空字段

????????????? + “m.asd_adsf,c.asdf_adsfa,”

????????sqlWhere.append(“from?fasdf?f,?asdfas?a,?fasdfasd?m”);

?????sqlWher.append(“where?a.mp_flag = ’N’”

????????????? + ”and?f.fasdf._dfsdf = e.oopp_tesx”

???????????????? + ? " ???and?e.item_code=g.imc_item_code(+) " // 表示右連結(jié)

);

if (?sRequestNo? != ? null ? && ?sRequestNo.length()? > ? 0 ?)? {

????????????????sqlWhere.append( " ?AND?a.request_no?=?? " );

????????????????vtInfo.addElement(sRequestNo);

if ?(?sItemCodeName? != ? null ? && ?sItemCodeName.length()? > ? 0 ?) {

????????????????sqlWhere.append( " ?AND?(?((b.buyer_status='C'?OR?b.buyer_status='G'?OR?b.buyer_status='R')?AND?upper(A.ITEM_CODE_NAME)?LIKE?upper(?)?)?OR?upper(e.ITEM_CODE_NAME)?LIKE?upper(?)?) " );

????????????????vtInfo.addElement( " % " ? + ?sItemCodeName? + ? " % " );

????????????????vtInfo.addElement( " % " ? + ?sItemCodeName? + ? " % " ); // %不完全匹配

????????????}

…………………………………………………

ps? = ?con.prepareStatement(sql + sqlWhere.toString(),ResultSet.TYPE_SCROLL_INSENSTIVE);

for ( int ?i? = ? 1 ;?I? <= ?vtInfo.size();i ++ ) {

????????ps.setString(i,(String)vtInfor.elementAt(i - 1 ))

}

rs? = ?ps.executeQuery();

rs.last(); // 由標(biāo)指向最后一行

????? int ????iRowCount? = ?rs.getRow();

????vt.addElement(String.valueOf(iRowCount));

???? if (iRowCount? > ? 0 ) {

rs.beforeFirst();

for ( int ?I = 0 ;I? < ?ipagesize;I ++ ) {

???? while (rs.next()) {

????cataInfo? = ? new ?CatalogRegistrationRequestInfo();

????cataInfo.setRequestNoFr(rs.getString( 1 ).trim());

????cataInfo.setRequestDate(rs.getString( 2 ));

????cataInfo.setItemCode(rs.getString( 3 ));

????cataInfo.setItemCode(rs.getString( 5 ));

cataInfo.setItemLocationType(rs.getString( 4 ));

if (?(rs.getString( 15 ).trim()).equals( " C " )?)? {

cataInfo.setStatusName(? " 申請 " ?);

}

vt.addElementInfo(cataInfo);

}

} ;

long ?endTime? = ?System.currentTimemillis();

????????????}

}

catch ?(SQLException?sqe)? {

????????????sqe.printStackTrace();

???????????? throw ? new ?EJBException(sqe);

????????}

???????? catch ?(Exception?e)? {

????????????e.printStackTrace();

???????????? throw ? new ?EJBException(e);

????????}

finally {

DBUtil.clearup(con,ps,rs);

}

return ?vt;

}

posted on 2007-03-08 14:41 youngturk 閱讀(263) 評論(0) 編輯收藏所屬分類: 數(shù)據(jù)庫方面

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發(fā)表評論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關(guān)文章: web頁面檢索數(shù)據(jù)庫中的字段是亂碼問題主鍵的設(shè)置方式可以是這樣,有待學(xué)習(xí)啊在本數(shù)據(jù)庫中創(chuàng)建DBlink解決同一網(wǎng)段不同數(shù)據(jù)庫間訪問 oracle新表的建立(理解表空間含義) spring中的繼承HibernateDaosupport方法 ORACLE編程，存儲過程，自學(xué)筆記（備份）轉(zhuǎn) js讀取XML文件 JS讀寫XML文件外網(wǎng)訪問虛擬機(jī)MYSQL 框架搭建好后,沒有詳細(xì)的錯誤信息,主頁無法訪問.用tomcat去調(diào)試,沒有詳細(xì)log.. oracle創(chuàng)建自增長序列

檢索功能一般步驟：

導(dǎo)航

統(tǒng)計(jì)

公告

常用鏈接

留言簿(6)

隨筆分類

隨筆檔案

文章分類

文章檔案

相冊

EJB學(xué)習(xí)

Flex學(xué)習(xí)

learn English

oracle

spring MVC web service

SQL

Struts

生活保健

解析文件

搜索

最新評論

閱讀排行榜

評論排行榜