81,094
社区成员
发帖
与我相关
我的任务
分享
commonDAO的executeSql方法
public int executeSql(String sql) throws SqlOperationException {
try {
Session session = getSession();
session.beginTransaction();
return session.createSQLQuery(sql).executeUpdate();
} catch (Exception e) {
e.printStackTrace();
throw new SqlOperationException(e.getMessage());
}
// return 0;
}
sql语句
String sql =
"insert into ia_generalledger\n" +
" select ia_generalledger_seq.nextval, --id\n" +
" a.stockorgid, " +
" a.styleid, " +
" a.fiscal_year, " +
" a.fiscal_month, " +
" a.innum, " +
" a.inamount, " +
" a.outnum, " +
" a.outamount, " +
" a.num, " +
" a.price, " +
" a.amount, " +
" null,\n" +
" null,\n" +
" null,\n" +
" null,\n" +
" null,\n" +
" null,\n" +
" null,\n" +
" null,\n" +
" null,\n" +
" null,\n" +
" null,\n" +
" null,\n" +
" null,\n" +
" null,\n" +
" null,\n" +
" a.orgid,\n" +
" null,\n" +
" null,\n" +
" null,\n" +
" a.ornacode\n" +
"\n" +
" from (select h.org_id orgid,\n" +
"\n" +
"\n" +
" h.fiscal_year fiscal_year,\n" +
" h.fiscal_month fiscal_month,\n" +
"\n" +
" h.stock_org_id stockorgid,\n" +
"\n" +
" l.style_id styleid,\n" +
"\n" +
" l.num as innum,\n" +
" l.amount inamount,\n" +
" 0.0 outnum,\n" +
" 0.0 outamount,\n" +
" l.num as num,\n" +
" l.price as price,\n" +
" l.amount as amount,\n" +
" l.orna_code ornacode\n" +
" from ia_ia_bill_head h\n" +
"\n" +
" inner join ia_ia_bill_line l on h.id = l.head_id\n" +
"\n" +
" where l.approvaluserid is null\n" +
"\n" +
" and h.fiscal_year = '2010'\n" +
" and h.fiscal_month = '7'\n" +
" and h.stock_org_id = " +stockOrgId+
" and h.org_id = " + Common.getLoginOrg().getOrgId()+
" and h.transceiver_flag='1'\n" +
" order by h.CREATEDATE, l.id\n" +
" ) a;";
;
this.commonDAO.executeSql(sql);