mysqluserqueries.java

来自「jGossip是一个简单而功能强大的Java论坛软件（消息板）」· Java 代码 · 共 66 行

/*
 * $Id: MySqlUserQueries.java,v 1.1 2004/04/04 18:59:00 alexnet Exp $
 *
 * ***** BEGIN LICENSE BLOCK *****
 * The contents of this file are subject to the Mozilla Public License
 * Version 1.1 (the "License"); you may not use this file except in 
 * compliance with the License. You may obtain a copy of the License 
 * at http://www.mozilla.org/MPL/
 *
 * Software distributed under the License is distributed on an "AS IS"
 * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See
 * the License for the specific language governing rights and 
 * limitations under the License.
 *
 * The Original Code is JGossip forum code.
 *
 * The Initial Developer of the Original Code is the JResearch, Org. 
 * Portions created by the Initial Developer are Copyright (C) 2004 
 * the Initial Developer. All Rights Reserved. 
 * 
 * Contributor(s): 
 *              Alexey Pavlov <[e-mail]>
 *        
 * ***** END LICENSE BLOCK ***** */
package org.jresearch.gossip.dao.drivers.mysql;

import org.jresearch.gossip.dao.drivers.UserQueries;


/**
 * MySqlUserQueries
 * 
 * @author <a href="[e-mail]">A. Pavlov</a>
 * @version $version$ 21.03.2004
 */
class MySqlUserQueries extends UserQueries {

	private static final String GET_USER_INFO =
				"SELECT user_signature, user_name, user_city, user_status, count(jrf_message.id) as tot_mes" +
				" FROM jrf_user, jrf_message WHERE user_name =?  AND user_name = jrf_message.sender GROUP BY user_name";
	private static final String GET_USERS = "SELECT user_name, id, user_status FROM jrf_user ORDER BY user_name LIMIT ?,?"; //block, user_toshow
	private final static String SET_LAST_INTIME = "UPDATE jrf_user SET last_intime=NOW() WHERE user_name = ?";

	/**
	 * @see org.jresearch.gossip.dao.drivers.UserQueries#getSql_GET_USER_INFO()
	 */
	public String getSql_GET_USER_INFO() {
		return GET_USER_INFO;
	}

	/**
	 * @see org.jresearch.gossip.dao.drivers.UserQueries#getSql_GET_USERS()
	 */
	public String getSql_GET_USERS() {
		return GET_USERS;
	}

	/**
	 * @see org.jresearch.gossip.dao.drivers.UserQueries#getSql_SET_LAST_INTIME()
	 */
	public String getSql_SET_LAST_INTIME() {
		return SET_LAST_INTIME;
	}

}