java执行存储过程

最新推荐文章于 2021-12-23 19:31:27 发布

apache-bbccb

最新推荐文章于 2021-12-23 19:31:27 发布

阅读量524

点赞数

分类专栏： JAVA

本文链接：https://blog.csdn.net/xgskj/article/details/8968223

版权

JAVA 专栏收录该内容

38 篇文章 0 订阅

订阅专栏

Session s = this.getSession();
		Connection con = s.connection();
		CallableStatement cstm = null;
		try {
			cstm = con
					.prepareCall("{call EVS_GENERATION_NUMBER_PKG.get_generation_number(?,?,?,?,?,?,?)}");

			cstm.setString(1, companyCode);
			cstm.setString(2, deptCode);
			cstm.setString(3, docTypeCode);
			cstm.setString(4, subDocTypeCode);
			cstm.setString(5, periodNameCode);
			cstm.setString(6, numberCode);
			cstm.registerOutParameter(7, Types.VARCHAR);
			cstm.execute();
			rtnStr = cstm.getString(7);
			cstm.close();
			con.close();

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (cstm != null) {
					cstm.close();
					cstm = null;
				}
				if (con != null) {
					con.close();
					con = null;
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
		}