62,615
社区成员
发帖
与我相关
我的任务
分享
String sql =
" Select * from tbOrgnization Where ParentId = :ParentId";
OraclePreparedStatement cmd = null;
OracleResultSet rs = null;
try{
cmd = (OraclePreparedStatement)DataContext.getCurrent().getPreparedStatement(sql);
// int p = 1;
// cmd.setInt(p++, parentId);
// cmd.setInt(p++, parentId);
cmd.setIntAtName("ParentId", parentId);
rs = (OracleResultSet)cmd.executeQuery();
while(rs.next()){
Orgnization item = new Orgnization();
this.readFields(item, rs, true);
result.add(item);
}
}catch(Throwable ex){
ex.printStacktrace();
}finally{
try{ if(cmd != null) cmd.close(); }catch(Throwable ex1){}
try{ if(rs != null) rs.close(); }catch(Throwable ex2){}
}