package?server;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.Date;

public?class?DMS?{

	String?result?=?“OK“;
	String?DBDriver?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	//?加載驅動器表達式
	String?connectionStr?=?“jdbc:sqlserver://localhost:1433;DatabaseName=ZTalk“;
	//?連接數據庫表達式
	Connection?con/*?=null?*/;
	//?數據庫連接對象
	Statement?stmt/*?=null?*/;
	//?語句對象
	ResultSet?rs/*?=null?*/;
	//?結果集對象
	PreparedStatement?ps;
	String?selectfromOnline?=?“select?*?from?online“;
	String?selectfromUserLogin?=?“select?PassWords?from?UserLogin?where?UserName=?“;
	String?insertintoOnline=“insert?into?OnLine（UserName）?values?（?）“;
	String?insertintoUserLogin?=?“insert?into?UserLogin（UserNamePassWords）?values?（??）“;
	String?insertintomessages=“insert?into?messages（UserNameFromUsermDatemessages）?values（????）“;
	String?dropfromOnline=“delete?from?OnLine?where?UserName=?“;
	String?selectfrommessages=“select?*?from?messages?where?UserName=?“;
	String?insertintorecord=“insert?into?record（UserNameDateStatus）?values（???）“;

	DMS（）?{

		try?{
			Class.forName（DBDriver）;//?加載驅動器
		}?catch?（ClassNotFoundException?e1）?{
			e1.printStackTrace（）;
		}
		try?{
			con?=?DriverManager.getConnection（connectionStr?“ZTalk“?“ZTalk“）;
			System.out.println（“正確建立數據庫連接！“）;//?建立數據庫連接
			stmt?=?con.createStatement（）;//?創建statement對象
		}?catch?（SQLException?e2）?{
			e2.printStackTrace（）;
		}
	}
	public?void?insertintorecord（String?usernameDate?dateString?status）{
		try?{
			ps?=?con.prepareStatement（insertintorecord）;
			ps.setString（1?username）;
			ps.setDate（2?（java.sql.Date）?date）;
			ps.setString（3?status）;
			ps.execute（）;
			ps.close（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	public?String?insertintomessages（String?usernameString?touserDate?dateString?message）{
		result?=?“OK“;
		try?{
			ps?=?con.prepareStatement（insertintomessages）;
			ps.setString（1?username）;
			ps.setString（2?touser）;
			ps.setDate（3?（java.sql.Date）?date）;
			ps.setString（4?message）;
			ps.executeUpdate（）;
			ps.close（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			result=“fails“;
			return?result;
		}
		return?result;
	}
	public?ResultSet?selectfrommessages（String?username）{
		try?{
			ps?=?con.prepareStatement（selectfrommessages）;
			ps.setString（1?username）;
			rs=ps.executeQuery（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		System.out.println（“讀取用戶歷史記錄“）;
		return?rs;
	}

	public?ResultSet?selectfromOnline（）?{
		try?{
			ps?=?con.prepareStatement（selectfromOnline）;
			rs=ps.executeQuery（）;
			System.out.println（“讀取線上用戶“）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTra

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-06-16?20:29??ZTalk\
?????文件?????????398??2014-06-12?10:52??ZTalk\.classpath
?????文件?????????381??2014-05-31?19:50??ZTalk\.project
?????目錄???????????0??2014-05-31?19:50??ZTalk\.settings\
?????文件?????????629??2014-05-31?19:50??ZTalk\.settings\org.eclipse.jdt.core.prefs
?????文件??????????99??2014-06-16?22:14??ZTalk\AutoLogin.ini
?????目錄???????????0??2014-06-12?20:47??ZTalk\bin\
?????目錄???????????0??2014-06-16?16:04??ZTalk\bin\server\
?????文件????????5250??2014-06-16?20:04??ZTalk\bin\server\DMS.class
?????文件????????1503??2014-06-16?16:12??ZTalk\bin\server\Server.class
?????文件????????6190??2014-06-16?22:46??ZTalk\bin\server\ServerThread.class
?????文件?????????536??2014-06-16?16:04??ZTalk\bin\server\User.class
?????文件????????1509??2014-06-16?16:04??ZTalk\bin\server\UserlinkList.class
?????目錄???????????0??2014-06-16?20:21??ZTalk\bin\talk\
?????文件????????2712??2014-06-16?22:19??ZTalk\bin\talk\ClientAutoLoad.class
?????文件????????3617??2014-06-17?08:51??ZTalk\bin\talk\ClientRegister.class
?????文件?????????714??2014-06-17?08:49??ZTalk\bin\talk\Clientupload$1.class
?????文件????????1281??2014-06-17?08:49??ZTalk\bin\talk\Clientupload$2.class
?????文件????????1669??2014-06-17?08:49??ZTalk\bin\talk\Clientupload$3.class
?????文件????????2155??2014-06-17?08:49??ZTalk\bin\talk\Clientupload$4.class
?????文件????????9051??2014-06-17?08:49??ZTalk\bin\talk\Clientupload.class
?????文件????????5474??2014-06-16?22:49??ZTalk\bin\talk\ClientView.class
?????目錄???????????0??2014-06-16?21:00??ZTalk\bin\tools\
?????文件????????1883??2014-06-16?21:28??ZTalk\bin\tools\AutoLogin.class
?????文件????????1836??2014-06-16?21:07??ZTalk\bin\tools\Encrypt.class
?????文件????????2643??2014-06-16?15:57??ZTalk\bin\tools\HistoryLogin.class
?????文件??????????89??2014-06-16?22:14??ZTalk\HistoryUser.ini
?????目錄???????????0??2014-06-12?19:33??ZTalk\src\
?????目錄???????????0??2014-06-16?16:04??ZTalk\src\server\
?????文件????????4870??2014-06-16?20:04??ZTalk\src\server\DMS.java
?????文件?????????911??2014-06-16?16:12??ZTalk\src\server\Server.java
............此處省略12個文件信息