Examples of RowMapper


Examples of org.springframework.jdbc.core.RowMapper

    "SELECT defid, parentfolder, name, objtype, prodver FROM bpm_procdef ").append(
    "WHERE (isdeleted='0') AND (objtype = 'folder') ").toString();
   
    final AclManager aclManager = AclManager.getInstance();
   
    return this.jdbcTemplate.query(sql, new RowMapper() {
      public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
        Item item = null;
       
        int defid = rs.getInt("defid");
       
View Full Code Here

Examples of org.springframework.jdbc.core.RowMapper

    "SELECT defid, parentfolder, name, objtype, prodver FROM bpm_procdef ").append(
    "WHERE (isdeleted='0') AND ((objtype = 'process' AND prodver <> 0) OR (objtype = 'folder') )").toString();
   
    final AclManager aclManager = AclManager.getInstance();
   
    return this.jdbcTemplate.query(sql, new RowMapper() {
      public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
        Item item = null;
       
        int defid = rs.getInt("defid");
       
View Full Code Here

Examples of org.springframework.jdbc.core.RowMapper

  @SuppressWarnings("unchecked")
  public List<Item> findAllProcessDefinitions(final String endpoint) {
   
    String sql = "SELECT defid, parentfolder, name, objtype, prodver FROM bpm_procdef WHERE isdeleted='0'";
   
    return this.jdbcTemplate.query(sql, new RowMapper() {

      public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
        Item item = null;
       
        int defid = rs.getInt("defid");
View Full Code Here

Examples of org.springframework.jdbc.core.RowMapper

   
    String sql = "SELECT defid, parentfolder, name, objtype, prodver FROM bpm_procdef WHERE isdeleted='0' AND comcode = '" + comCode + "'";
   
    final AclManager aclManager = AclManager.getInstance();
   
    return this.jdbcTemplate.query(sql, new RowMapper() {
      public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
        Item item = null;
       
        int defid = rs.getInt("defid");
        Map<Character, Boolean> permission = aclManager.getPermission(defid, endpoint, true);
View Full Code Here

Examples of org.springframework.jdbc.core.RowMapper

       .append("   AND  comcode = '").append(comCode).append("'").append("\n");
   
   
    final AclManager aclManager = AclManager.getInstance();
   
    return this.jdbcTemplate.query(sql.toString(), new RowMapper() {
      public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
        Item item = null;
       
        int defid = rs.getInt("defid");
        //Map<Character, Boolean> permission = aclManager.getPermission(defid, endpoint);
View Full Code Here

Examples of org.springframework.jdbc.core.RowMapper

 
  @SuppressWarnings("unchecked")
  public List<Form> findAllFormVersions(int defId) {
    String sql = "SELECT defverid, ver FROM bpm_procdefver WHERE defid=? AND isdeleted=0";
    return this.jdbcTemplate.query(sql, new Object[] { defId },
        new RowMapper() {
          public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
            Form form = new Form();
            form.setDefVerId(rs.getInt("defVerId"));
            form.setVer(rs.getString("ver"));
            return form;
View Full Code Here

Examples of org.springframework.jdbc.core.RowMapper

        " WHERE (isdeleted='0') AND (objtype = 'form' AND prodver <> 0) OR (objtype = 'folder')").toString();
   
    final AclManager aclManager = AclManager.getInstance();
   
    return this.jdbcTemplate.query(sql,
        new RowMapper() {
          public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
            Item item = null;
           
            int defid = rs.getInt("defid");
           
View Full Code Here

Examples of org.springframework.jdbc.core.RowMapper

       .append("  FROM  bpm_procdef       ").append("\n")
       .append(" WHERE  isdeleted = 0     ").append("\n")
       .append("   AND  objtype = 'folder'").append("\n")
       .append("   AND  comcode = '").append(comCode).append("'").append("\n");
   
    final List<Item> itemList = this.jdbcTemplate.query(sql.toString(), new RowMapper() {
      public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
        Item item = null;
       
        int defid = rs.getInt("defid");
        String name = rs.getString("name");
View Full Code Here

Examples of org.springframework.jdbc.core.RowMapper

  @SuppressWarnings("unchecked")
  public List<Integer> getInstanceIdListById(Serializable id) {
    StringBuilder sql = new StringBuilder("");
    sql.append(" select * from BPM_PROCINST WHERE STRATEGYID = ? ");
   
    return this.jdbcTemplate.query(sql.toString(), new Object[] { id }, new RowMapper() {
      public Object mapRow(ResultSet rs, int arg1) throws SQLException {
        int instanceId = rs.getInt("INSTID");
        return instanceId;
      }
    });
View Full Code Here

Examples of org.springframework.jdbc.core.RowMapper

      ss.append(String.valueOf(ids.get(i)));
    }
   
    sql.append(" select * from BPM_PROCINST WHERE STRATEGYID in ("+ss+") ");
   
    return this.jdbcTemplate.query(sql.toString(), new Object[] {}, new RowMapper() {
      public Object mapRow(ResultSet rs, int arg1) throws SQLException {
        Instance instance = new Instance();
        instance.setId(""+ rs.getInt("INSTID") );
        instance.setStatus(rs.getString("STATUS"));
        return instance;
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.