|
|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。如果您注册时有任何问题请联系客服QQ: 83569622 。
您需要 登录 才可以下载或查看,没有帐号?注册
x
如题!
我的新增是通过在plsql中写的insert插进去的,
if ("Save".equals(pageContext.getParameter(EVENT_PARAM)))
{
OAViewObject vo = (OAViewObject)am.findViewObject("OrgVO1");
PartyOrgVORowImpl row = (PartyOrgVORowImpl)vo.getRowAtRangeIndex(0);
//row.setOrgName("ss");
String org_name = row.getOrgName();
String org_type = row.getOrgType();
String org_sort = row.getOrgSort();
String patent_org = row.getPatentOrg();
Number number_of_person_f = row.getNumberOfPersonF();
Number number_of_person_m = row.getNumberOfPersonM();
Number child_org_number1 = row.getChildOrgNumber1();
Number child_org_number2 = row.getChildOrgNumber2();
Date election_date = row.getElectionDate();
Date due_date = row.getDueDate();
Date start_date = row.getStartDate();
Date end_date = row.getEndDate();
String s =
"begin cux__pkg.org_insert(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12); end; ";
OracleCallableStatement cs =
(OracleCallableStatement)oadbtransactionimpl.createCallableStatement(s,
0);
try
{
cs.setString(1, org_name);
cs.setString(2, org_type);
cs.setString(3, org_sort);
cs.setString(4, patent_org);
cs.setNUMBER(5, number_of_person_f);
cs.setNUMBER(6, number_of_person_m);
cs.setNUMBER(7, child_org_number1);
cs.setNUMBER(8, child_org_number2);
cs.setDATE(9, election_date);
cs.setDATE(10, due_date);
cs.setDATE(11, start_date);
cs.setDATE(12, end_date);
cs.execute();
cs.close();
} catch (SQLException sqlexception)
{
throw OAException.wrapperException(sqlexception);
} catch (Exception exception)
{
throw OAException.wrapperException(exception);
}
//throw new OAException("due_date=" + due_date + "start_date=" +
// start_date + "end_date=" + end_date,
// OAException.INFORMATION);
pageContext.forwardImmediatelyToCurrentPage(null, true,
OAWebBeanConstants.ADD_BREAD_CRUMB_NO); //使数据插入后,从新查询页面信息;
},
现在想做删除就比较迷糊了,比如怎么获得id。
|
|