检索功能一般步骤：

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; // 获得连结的过程

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(+) " // 表示右连结

);

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(); // 由标指向最后一行

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 阅读(255) 评论(0) 编辑收藏所属分类: 数据库方面

新用户注册刷新评论列表


只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻知识库 C++博客博问管理
相关文章: web页面检索数据库中的字段是乱码问题主键的设置方式可以是这样,有待学习啊在本数据库中创建DBlink解决同一网段不同数据库间访问 oracle新表的建立(理解表空间含义) spring中的继承HibernateDaosupport方法 ORACLE编程，存储过程，自学笔记（备份）转 js读取XML文件 JS读写XML文件外网访问虚拟机MYSQL 框架搭建好后,没有详细的错误信息,主页无法访问.用tomcat去调试,没有详细log.. oracle创建自增长序列

2007年3月

日

一

二

三

四

五

六

统计

随笔 - 391
文章 - 15
评论 - 113
引用 - 0

公告

this year :
1 jQuery
2 freemarker
3 框架结构
4 口语英语

常用链接

留言簿(6)

随笔分类

随笔档案

文章分类

文章档案

相册

PICTURE(sk.lee)

EJB学习

Flex学习

adobe,samples..
http://flexsamples.blogspot.com/search/label/Flex%20Controls%20Samples
flex (rss)
http://hi.baidu.com/wenke%5Fwang/blog/item/0407b93ebea5d6e454e723df.html
flex example2
http://flexsamples.blogspot.com/search/label/Flex%20Controls%20Samples
flex 网站收集
http://www.adobe.com/devnet/flex/samples.html
flex3 all component example
http://www.adobe.com/devnet/flex/samples.html
FlexGoodViewSource (rss)
http://hi.baidu.com/wenke%5Fwang/blog/item/0407b93ebea5d6e454e723df.html
Flex专区 (rss)
flex专区
Flex学习 (rss)
Flex高级编程download (rss)
Flex高级编程download
http://blog.csdn.net/meteorlWJ/archive/2008/05/01/2358154.aspx (rss)
http://www.blogjava.net/youngturk/admin/EditLinks.aspx
MyEclipse6.0+Tomcat6.0+Flex Builder3+sqlserver2000 (rss)
MyEclipse6.0+Tomcat6.0+Flex Builder3+sqlserver2000
supper Flex learning example
http://blog.flexexamples.com/category/basecolor/ http://blog.flexexamples.com/
冰树之家 (rss)
奥多比 (rss)
http://www.riameeting.com
最好的源码下载地

learn English

general speaking English (rss)
理财 (rss)
http://www.chinafpn.com/xzb/diary.php http://media.ccidnet.com/art/2993/20060516/553985_1.html http://30boxes.com/index.php http://www.chinafpn.com http://www.a-hospital.com/%C8%CB%CC%E5%D1%A8%CE%BB%CD%BC.html http://cache.baidu.com/c?m=9f65cb4a8c8507ed4fece763105e8d3b4501cb382bd7a7147491ce08cd324c413037bee43a664b5396d8786403a94e5bfdf04128715c7ea3de95c81cd2ace42c38fe2523061c913164c418dfdc3026d6549a4d99a50e96cde733e3b9a2d1c82455dd22036df3f4&p=8b2a94128fdb5ae808e2977b5f55&user=baidu
英语目录 (rss)