1 25 package org.jresearch.gossip.dao.drivers.generic; 26 27 import org.jresearch.gossip.dao.drivers.UserQueries; 28 29 35 class GenericSqlUserQueries extends UserQueries { 36 37 40 public String getSql_GET_USER_INFO() { 41 return GET_USER_INFO; 42 } 43 44 47 public String getSql_GET_USERS() { 48 return GET_USERS; 49 } 50 51 54 public String getSql_SET_LAST_INTIME() { 55 return SET_LAST_INTIME; 56 } 57 58 private static final String GET_USER_INFO = "SELECT user_signature, user_name, user_city, user_status, count(jrf_message.id) as tot_mes" 59 + " FROM jrf_user, jrf_message WHERE user_name =? AND user_name = jrf_message.sender GROUP BY user_name, user_signature, user_city, user_status"; 60 61 private static final String GET_USERS = "SELECT * FROM " 62 + " (SELECT user_name, id, user_status, " 63 + " ROW_NUMBER() OVER(ORDER BY user_name) AS R" 64 + " FROM jrf_user " + " ORDER BY user_name" 65 + ") WHERE R BETWEEN ? AND ?"; 67 private final static String SET_LAST_INTIME = "UPDATE jrf_user SET last_intime=sysdate WHERE user_name = ?"; 68 69 } 70 | Popular Tags |