Package org.springframework.jdbc.core

Examples of org.springframework.jdbc.core.BeanPropertyRowMapper

63
64
65
66
67
68
69
70
71
72
73

    @Override
    public Organization findOne(Long organizationId) {
        final String sql = "select id, name, parent_id, parent_ids, available from sys_organization where id=?";
        List<Organization> organizationList = jdbcTemplate.query(sql, new BeanPropertyRowMapper(Organization.class), organizationId);
        if(organizationList.size() == 0) {
            return null;
        }
        return organizationList.get(0);
    }
View Full Code Here
73
74
75
76
77
78
79
    }

    @Override
    public List<Organization> findAll() {
        final String sql = "select id, name, parent_id, parent_ids, available from sys_organization";
        return jdbcTemplate.query(sql, new BeanPropertyRowMapper(Organization.class));
    }
View Full Code Here
80
81
82
83
84
85
86
    @Override
    public List<Organization> findAllWithExclude(Organization excludeOraganization) {
        //TODO 改成not exists 利用索引
        final String sql = "select id, name, parent_id, parent_ids, available from sys_organization where id!=? and parent_ids not like ?";
        return jdbcTemplate.query(sql, new BeanPropertyRowMapper(Organization.class), excludeOraganization.getId(), excludeOraganization.makeSelfAsParentIds() + "%");
    }
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75

    @Override
    public Resource findOne(Long resourceId) {
        final String sql = "select id, name, type, url, permission, parent_id, parent_ids, available from sys_resource where id=?";
        List<Resource> resourceList = jdbcTemplate.query(sql, new BeanPropertyRowMapper(Resource.class), resourceId);
        if(resourceList.size() == 0) {
            return null;
        }
        return resourceList.get(0);
    }
View Full Code Here
75
76
77
78
79
80
81
    }

    @Override
    public List<Resource> findAll() {
        final String sql = "select id, name, type, url, permission, parent_id, parent_ids, available from sys_resource order by concat(parent_ids, id) asc";
        return jdbcTemplate.query(sql, new BeanPropertyRowMapper(Resource.class));
    }
View Full Code Here
70
71
72
73
74
75
76
    }

    @Override
    public List<Authorization> findAll() {
        final String sql = "select id, user_id, app_id, role_ids as roleIdsStr from sys_user_app_roles";
        return jdbcTemplate.query(sql, new BeanPropertyRowMapper(Authorization.class));
    }
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
    }

    @Override
    public Client findOne(Long clientId) {
        String sql = "select id, client_name, client_id, client_secret from oauth2_client where id=?";
        List<Client> clientList = jdbcTemplate.query(sql, new BeanPropertyRowMapper(Client.class), clientId);
        if(clientList.size() == 0) {
            return null;
        }
        return clientList.get(0);
    }
View Full Code Here
68
69
70
71
72
73
74
    }

    @Override
    public List<Client> findAll() {
        String sql = "select id, client_name, client_id, client_secret from oauth2_client";
        return jdbcTemplate.query(sql, new BeanPropertyRowMapper(Client.class));
    }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85

    @Override
    public Client findByClientId(String clientId) {
        String sql = "select id, client_name, client_id, client_secret from oauth2_client where client_id=?";
        List<Client> clientList = jdbcTemplate.query(sql, new BeanPropertyRowMapper(Client.class), clientId);
        if(clientList.size() == 0) {
            return null;
        }
        return clientList.get(0);
    }
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96

    @Override
    public Client findByClientSecret(String clientSecret) {
        String sql = "select id, client_name, client_id, client_secret from oauth2_client where client_secret=?";
        List<Client> clientList = jdbcTemplate.query(sql, new BeanPropertyRowMapper(Client.class), clientSecret);
        if(clientList.size() == 0) {
            return null;
        }
        return clientList.get(0);
    }
View Full Code Here
TOP

Related Classes of org.springframework.jdbc.core.BeanPropertyRowMapper

  • com.github.zhangkaitao.shiro.chapter11.dao.UserDaoImpl
  • com.github.zhangkaitao.shiro.chapter12.dao.UserDaoImpl
  • com.github.zhangkaitao.shiro.chapter13.dao.UserDaoImpl
  • com.github.zhangkaitao.shiro.chapter14.dao.UserDaoImpl
  • com.github.zhangkaitao.shiro.chapter15.dao.UserDaoImpl
  • com.github.zhangkaitao.shiro.chapter16.dao.OrganizationDaoImpl
  • com.github.zhangkaitao.shiro.chapter16.dao.ResourceDaoImpl
  • com.github.zhangkaitao.shiro.chapter16.dao.RoleDaoImpl
  • com.github.zhangkaitao.shiro.chapter16.dao.UserDaoImpl
  • com.github.zhangkaitao.shiro.chapter17.dao.ClientDaoImpl
    • Copyright © 2018 www.massapicom. 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.