am 使用SQL语句调用存诸过程

最新推荐文章于 2022-03-11 06:20:22 发布

sbtmbj2010

最新推荐文章于 2022-03-11 06:20:22 发布

阅读量494

点赞数

本文链接：https://blog.csdn.net/sbtmbj2010/article/details/41727379

版权

JAVA 专栏收录该内容

23 篇文章 0 订阅

订阅专栏

AppModuleImpl am=this.getAppModuleImpl();
DBTransaction trans = am.getDBTransaction();

                         String sql="SELECT QCS,HCS,BWDM,CBZC,JGHWZL FROM "+tableName.get("TABLENAME").toString()+" WHERE SQDZJ= '"+sqdzj+"'";
                         String sql2="SELECT SJSS,KBNL,BWCD FROM JC_BW WHERE BWBH=?";
                         PreparedStatement ps=trans.createPreparedStatement(sql,1);
                         PreparedStatement ps2=trans.createPreparedStatement(sql2,1);
                         ResultSet rs=null;
                         ResultSet rs2=null;
                         String resultback="";
                         try {
                             rs = ps.executeQuery();
                             if(rs.next()){

}

                DBTransaction trans = am.getDBTransaction();
                String sSql = "{call PRC_GETNEXTNODELIST(?,?,?,?,?,?,?,?)}";
                CallableStatement csmt=trans.createCallableStatement(sSql, 0);
                csmt.setString(1,businessNumber);
                csmt.setString(2,businessNumber);
                csmt.setString(3,businessNumber);
                csmt.setString(4,businessNumber);
                csmt.registerOutParameter(5,Types.INTEGER);
                csmt.registerOutParameter(6,Types.VARCHAR);
                csmt.registerOutParameter(7,Types.VARCHAR);
                csmt.registerOutParameter(8,Types.VARCHAR);
                csmt.execute();
                int serialNumer=csmt.getInt(5);
                String nextnodeCode=csmt.getString(6);
                String nextnodeName=csmt.getString(7);
                String displayName=csmt.getString(8);