java 調預存程序



String sql = "{call INIT_SORT()}";
     
     CallableStatement cs = null;
        Connection conn = null;
        ResultSet rs = null;
     try {
            conn = SessionFactoryUtils.getDataSource(getSessionFactory())
                    .getConnection();

            conn.commit();
            conn.setAutoCommit(true);

            cs = conn.prepareCall(sql);
            cs.execute();
     } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (null != rs) {
                    rs.close();
                }
                if (null != cs) {
                    cs.close();
                }
                if (null != conn) {
                    conn.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }