Changes from Version 1 of egov/Security/JdbcDaoImpl.java

차이점 주위로
다음 차이점은 무시하기:
작성자:
anonymous (IP: 221.150.127.103)
날짜/시간:
2013-12-01 PM 10:49:51 (12 년 전)
설명:

--

Legend:

변경되지 않음
추가됨
제거됨
변경됨

  • egov/Security/JdbcDaoImpl.java

    v0 v1  
     1 
     2 
     3{{{ 
     4    public static final String DEF_USERS_BY_USERNAME_QUERY = 
     5            "SELECT username,password,enabled " + 
     6            "FROM users " + 
     7            "WHERE username = ?"; 
     8    public static final String DEF_AUTHORITIES_BY_USERNAME_QUERY = 
     9            "SELECT username,authority " + 
     10            "FROM authorities " + 
     11            "WHERE username = ?"; 
     12    public static final String DEF_GROUP_AUTHORITIES_BY_USERNAME_QUERY = 
     13            "SELECT g.id, g.group_name, ga.authority " + 
     14            "FROM groups g, group_members gm, group_authorities ga " + 
     15            "WHERE gm.username = ? " + 
     16            "AND g.id = ga.group_id " + 
     17            "AND g.id = gm.group_id"; 
     18}}}