Code example for CallableStatement

Methods: registerOutParameterexecuteUpdatesetStringclose

0
			createdate = SDM.format(createDate);
		} 
		try { 
			conn = ConnectionFactory.getConnection();
			pscall = conn.prepareCall(sql.toString());
			pscall.setString(1, actType);
			pscall.setString(2, workAreaId);
			pscall.setString(3, localNetId);
			pscall.setString(4, areaId);
			pscall.setString(5, name);
			pscall.setString(6, dispatchLevel);
			pscall.setString(7, parentWorkAreaId);
			pscall.setString(8, standardCode);
			pscall.setString(9, sts);
			pscall.setString(10, stsdate);
			pscall.setString(11, createdate);
			pscall.setString(12, workMode);
			pscall.registerOutParameter(13, java.sql.Types.VARCHAR);
			pscall.registerOutParameter(14, java.sql.Types.VARCHAR);
			pscall.executeUpdate();
		} catch (Exception e) {
			throw new SysException("", "workSync errors", e);
		} finally { 
			try { 
				if (pscall != null) {
					pscall.close();
				} 
			} catch (SQLException e) {
				e.printStackTrace();
			} 
		} 
Contextual code suggestions in your IDE  Get Codota for Java