1 25 package org.jresearch.gossip.dao.drivers.mssql; 26 27 import org.jresearch.gossip.dao.drivers.UserQueries; 28 29 35 class MSSqlUserQueries extends UserQueries { 36 37 private static final String GET_USER_INFO = "SELECT user_name, user_city, user_signature, count(jrf_message.id) as tot_mes, user_status" 38 + " FROM jrf_user, jrf_message WHERE user_name =? AND user_name = jrf_message.sender GROUP BY user_name, user_signature, user_city, user_status"; 39 40 private static final String GET_USERS = "EXEC sp_GET_USERS ?,?"; 43 private final static String SET_LAST_INTIME = "UPDATE jrf_user SET last_intime=GETDATE() WHERE user_name = ?"; 44 45 48 public String getSql_GET_USER_INFO() { 49 return GET_USER_INFO; 50 } 51 52 55 public String getSql_GET_USERS() { 56 return GET_USERS; 57 } 58 59 62 public String getSql_SET_LAST_INTIME() { 63 return SET_LAST_INTIME; 64 } 65 66 } 67 | Popular Tags |