Connection conn = getSession().connection();
//返回标志,0:执行成功,否则执行失败
int flag = 1;
CallableStatement stmt = null;
try
{
stmt = conn.prepareCall("{call " + funcName + "(?,?,?)}");
if (stmt != null)
{
stmt.setString(1, name);
stmt.setString(2, user);
stmt.setInt(3, 0);
//第3个参数作为输出参数
stmt.registerOutParameter(3, Types.INTEGER);
stmt.execute();
if (StringUtils.isNotEmpty(stmt.getString(5)))
flag = Integer.parseInt(stmt.getString(5));
}
}
catch (Exception e)
{
flag = 1;
}
finally
{
if (stmt != null)
try
{
stmt.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
JAVA调用DB2过程
最新推荐文章于 2021-03-22 18:58:17 发布