81,092
社区成员
发帖
与我相关
我的任务
分享
String sqlStr = "{execute Journalx2AspWKByQi ?,?,?,?,?,?,?,?,?,?,?,?,?,?}";
Boolean ret = Boolean.FALSE;
try {
PreparedStatement pstmt = session.connection().prepareStatement(sqlStr);
pstmt.setString(1, mag_id);
pstmt.setString(2, aspWk_ZaZhiID);
pstmt.setString(3, aspWk_Dbname);
pstmt.setString(4, ZaZhiMC);
pstmt.setString(5, ZaZhiMC_E);
pstmt.setString(6, FaBuLX);
pstmt.setString(7, NianDu);
pstmt.setString(8, QiHao);
pstmt.setString(9, FaBuLeiXing);
pstmt.setString(10, ShouFeiLX);
pstmt.setString(11, ShouFeiJG);
pstmt.setString(12, QiShiYe);
pstmt.setString(13, JieShuYe);
pstmt.setString(14, FaBuRQ);
pstmt.execute();
pstmt.close();
ret = Boolean.TRUE;
} catch (Exception e) {
log.warn("调用存储过程出错:", e);
System.out.println("Journalx2AspWKByQi出错");
ret = Boolean.FALSE;
}
DELIMITER $$
DROP PROCEDURE IF EXISTS `journalx_standard`.`Journalx2AspWKByQi`$$
CREATE PROCEDURE `Journalx2AspWKByQi`(
mag_id varchar(10),
aspWk_ZaZhiID varchar(50) charset gbk,
aspWk_Dbname varchar(50) charset gbk,
ZaZhiMC varchar(50) charset gbk,
ZaZhiMC_E varchar(200) charset gbk,
FaBuLX varchar(10) charset gbk,
NianDu varchar(50) charset gbk,
QiHao varchar(50) charset gbk,
FaBuLeiXing varchar(50) charset gbk,
ShouFeiLX varchar(10) charset gbk,
ShouFeiJG varchar(10) charset gbk,
QiShiYe varchar(20) charset gbk,
JieShuYe varchar(20) charset gbk,
FaBuRQ varchar(20) charset gbk
)
sp:BEGIN
if 1=1 then
select 'hao';
leave sp;
end if;
END$$
DELIMITER ;