/*
?*?System?Abbrev?：
?*?system?Name??:
?*?Component?No??：
?*?Component?Name：
?*?File?name?????：ChatLogsDbManager.java
?*?Author????????：Peter.Qiu
?*?Date??????????：2016年12月12日
?*?Description???:??ription>
?*/

/*?Updation?record?1：
?*?Updation?date????????:??2016年12月12日
?*?Updator??????????:??Peter.Qiu
?*?Trace?No:??
?*?Updation?No:??
?*?Updation?Content:??
?*/
package?com.qiuzhping.openfire.plugin;

import?java.sql.Connection;
import?java.sql.PreparedStatement;

import?org.jivesoftware.database.DbConnectionManager;

import?com.qiuzhping.openfire.plugin.entity.ChatLogs;

public?class?ChatLogsDbManager?{

	private?static?final?ChatLogsDbManager?CHAT_LOGS_MANAGER?=?new?ChatLogsDbManager（）;

	private?ChatLogsDbManager（）?{

	}

	public?static?ChatLogsDbManager?getInstance（）?{
		return?CHAT_LOGS_MANAGER;
	}

	private?static?final?String?LOGS_INSERT?=?“INSERT?INTO?ofChatLogs（messageId?sessionJID?sender?receiver?createDate?length?content?detail?statemessage_type）?VALUES（??????????）“;



	/**?ription?functions?in?a?word>
	?*?添加聊天記錄信息
	?*?ription>
	?*?@author?Peter.Qiu
	?*?@param?logs
	?*?@return?[Parameters?description]
	?*?@return?boolean?[Return?type?description]
	?*?@exception?throws?[Exception]?[Exception?description]
	?*?@see?[Related?classes#Related?methods#Related?properties]
	?*/
	public?boolean?add（ChatLogs?logs）?{
		Connection?con?=?null;
		PreparedStatement?pstmt?=?null;
		try?{
			if?（logs?==?null）?{
				return?false;
			}
			con?=?DbConnectionManager.getConnection（）;
			pstmt?=?con.prepareStatement（LOGS_INSERT）;
			int?i?=?1;
			pstmt.setLong（i++?logs.getMessageId（））;
			pstmt.setString（i++?logs.getSessionJID（））;
			pstmt.setString（i++?logs.getSender（））;
			pstmt.setString（i++?logs.getReceiver（））;
			pstmt.setTimestamp（i++?logs.getCreateDate（））;
			pstmt.setInt（i++?logs.getLength（））;
			pstmt.setString（i++?logs.getContent（））;
			pstmt.setString（i++?logs.getDetail（））;
			pstmt.setInt（i++?logs.getState（））;
			pstmt.setString（i++?logs.getMessageType（）?!=?null???logs.getMessageType（）?:?“0“）;
			return?pstmt.execute（）;
		}?catch?（Exception?e）?{
			System.out.println（“添加聊天記錄信息出錯“?+?e）;
			return?false;
		}?finally?{
			DbConnectionManager.closeConnection（pstmt?con）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-12-22?17:15??src\
?????目錄???????????0??2016-12-22?17:15??src\plugins\
?????目錄???????????0??2016-12-22?17:15??src\plugins\ChatPlugin\
?????目錄???????????0??2016-12-22?17:15??src\plugins\ChatPlugin\com\
?????目錄???????????0??2016-12-22?17:15??src\plugins\ChatPlugin\com\qiuzhping\
?????目錄???????????0??2016-12-22?17:15??src\plugins\ChatPlugin\com\qiuzhping\openfire\
?????目錄???????????0??2016-12-22?17:15??src\plugins\ChatPlugin\com\qiuzhping\openfire\plugin\
?????文件????????2488??2016-12-22?15:49??src\plugins\ChatPlugin\com\qiuzhping\openfire\plugin\ChatLogsDbManager.java
?????文件????????8819??2016-12-22?15:50??src\plugins\ChatPlugin\com\qiuzhping\openfire\plugin\ChatLogsInterceptor.java
?????文件????????1138??2016-12-22?15:48??src\plugins\ChatPlugin\com\qiuzhping\openfire\plugin\ChatLogsPlugin.java
?????目錄???????????0??2016-12-22?17:15??src\plugins\ChatPlugin\com\qiuzhping\openfire\plugin\entity\
?????文件????????3490??2016-12-22?15:49??src\plugins\ChatPlugin\com\qiuzhping\openfire\plugin\entity\ChatLogs.java
?????文件?????????521??2016-12-22?15:50??src\plugins\ChatPlugin\plugin.xml
?????文件????????1073??2016-12-22?15:46??.classpath
?????文件?????????390??2016-12-12?14:27??.project
?????文件????????9278??2016-12-22?17:06??ChatPlugin.jar
?????目錄???????????0??2016-12-22?17:15??.settings\
?????文件?????????598??2016-12-12?14:27??.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2016-12-22?17:15??bin\
?????目錄???????????0??2016-12-22?17:15??bin\com\
?????目錄???????????0??2016-12-22?17:15??bin\com\qiuzhping\
?????目錄???????????0??2016-12-22?17:15??bin\com\qiuzhping\openfire\
?????目錄???????????0??2016-12-22?17:15??bin\com\qiuzhping\openfire\plugin\
?????文件????????2847??2016-12-22?15:49??bin\com\qiuzhping\openfire\plugin\ChatLogsDbManager.class
?????文件????????7549??2016-12-22?15:50??bin\com\qiuzhping\openfire\plugin\ChatLogsInterceptor.class
?????文件????????1606??2016-12-22?15:48??bin\com\qiuzhping\openfire\plugin\ChatLogsPlugin.class
?????目錄???????????0??2016-12-22?17:15??bin\com\qiuzhping\openfire\plugin\entity\
?????文件?????????709??2016-12-22?15:49??bin\com\qiuzhping\openfire\plugin\entity\ChatLogs$ChatLogsConstants.class
?????文件?????????314??2016-12-22?15:49??bin\com\qiuzhping\openfire\plugin\entity\ChatLogs$LogState.class
?????文件????????3165??2016-12-22?15:49??bin\com\qiuzhping\openfire\plugin\entity\ChatLogs.class
?????文件?????????521??2016-12-22?15:50??bin\plugin.xml
............此處省略16個文件信息