package?com.sai.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.text.DateFormat;
import?java.text.SimpleDateFormat;
import?java.util.ArrayList;
import?java.util.Date;
import?java.util.List;

import?com.sai.dto.Friend;
import?com.sai.dto.Message;
import?com.sai.global.ConnTool;


public?class?MakeFriendDao?{
	
	private?int?NUM?=?18;
	
	public?void?setSendtome（Message?msg）{
		
		try?{
			Connection?conn?=?ConnTool.getConn（）;
			String?sql?=?“insert?into?receive?values（receiveseq.nextval??????????）“;
			PreparedStatement?ppt?=?conn.prepareStatement（sql）;
			ppt.setString（1?msg.getSender（））;
			ppt.setString（2?msg.getReceiver（））;
			ppt.setString（3?msg.getMessage（））;
			ppt.setString（4?“false“）;
			Date?date?=?new?Date（）;
			DateFormat?df?=?new?SimpleDateFormat（“yyyy-MM-dd?HH:mm:ss“）;
			String?dateStr?=?df.format（date）;
			ppt.setString（5?dateStr）;
			ppt.execute（）;
			ConnTool.closeConn（null?ppt?conn）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}
	
	public?void?setMysend（Message?msg）{
		
		try?{
			Connection?conn?=?ConnTool.getConn（）;
			String?sql?=?“insert?into?send?values（sendseq.nextval??????????）“;
			PreparedStatement?ppt?=?conn.prepareStatement（sql）;
			ppt.setString（1?msg.getSender（））;
			ppt.setString（2?msg.getReceiver（））;
			ppt.setString（3?msg.getMessage（））;
			ppt.setString（4?“false“）;
			Date?date?=?new?Date（）;
			DateFormat?df?=?new?SimpleDateFormat（“yyyy-MM-dd?HH:mm:ss“）;
			String?dateStr?=?df.format（date）;
			ppt.setString（5?dateStr）;
			ppt.execute（）;
			ConnTool.closeConn（null?ppt?conn）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}
	
	public?List?getSendtome（String?receive?int?pageIndex）{
		
		List?list?=?new?ArrayList（）;
		try?{
			Connection?conn?=?ConnTool.getConn（）;
			String?sql?=?“select?id?sender?receiver?message?readstate?time?from（select?rownum?as?r?id?sender?receiver?message?readstate?time?from（select?id?sender?receiver?message?readstate?time?from?receive?where?receiver?=???order?by?id?desc））?where?r?>?（??*??）?and?r?<=?（??*??）“;
			PreparedStatement?ppt?=?conn.prepareStatement（sql）;
			ppt.setString（1?receive）;
			ppt.setInt（2?pageIndex?-?1）;
			ppt.setInt（3?NUM）;
			ppt.setInt（4?pageIndex）;
			ppt.setInt（5?NUM）;
			ResultSet?rs?=?ppt.executeQuery（）;
			while（rs.next（））{
				int?id?=?rs.getInt（1）;
				String?sender?=?rs.getString（2）;
				String?receiver?=?rs.getString（3）;
				String?message?=?rs.getString（4）;
				String?readstate?=?rs.getString（5）;
				String?time?=?rs.getString（6）;
				Message?msg?=?new?Message（id?sender?receiver?message?readstate?time）;
				list.add（msg）;
			}
			ConnTool.closeConn（rs?ppt?conn）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		return?list;
	}
	
	public?List?getMysend（String?send?int?pageIndex）{
		List?list

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1246??2015-06-16?10:49??MakeFriend\.classpath

?????文件????????303??2015-06-15?08:33??MakeFriend\.mymetadata

?????文件???????1753??2014-10-08?10:38??MakeFriend\.project

?????文件????????500??2014-10-08?10:38??MakeFriend\.settings\.jsdtscope

?????文件?????????98??2014-10-09?19:02??MakeFriend\.settings\com.genuitec.eclipse.core.prefs

?????文件????????364??2014-10-08?10:38??MakeFriend\.settings\org.eclipse.jdt.core.prefs

?????文件????????468??2014-10-08?10:38??MakeFriend\.settings\org.eclipse.wst.common.component

?????文件????????252??2014-10-08?10:38??MakeFriend\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2014-10-08?10:38??MakeFriend\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-10-08?10:38??MakeFriend\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件??????????6??2015-06-15?17:41??MakeFriend\makeFriend.sql

?????文件???????8667??2015-06-16?10:51??MakeFriend\src\com\sai\dao\MakeFriendDao.java

?????文件??????15516??2015-06-16?10:57??MakeFriend\src\com\sai\dao\QueryDao.java

?????文件???????4422??2015-06-16?10:57??MakeFriend\src\com\sai\dao\UserInfoDao.java

?????文件????????943??2015-06-15?17:05??MakeFriend\src\com\sai\dto\Attention.java

?????文件???????2081??2014-10-08?21:21??MakeFriend\src\com\sai\dto\Friend.java

?????文件???????1005??2014-10-08?21:21??MakeFriend\src\com\sai\dto\Message.java

?????文件???????3360??2015-06-16?10:58??MakeFriend\src\com\sai\dto\Userinfo.java

?????文件????????766??2015-06-15?17:17??MakeFriend\src\com\sai\filter\EncodeFilter.java

?????文件???????1078??2015-06-15?17:17??MakeFriend\src\com\sai\filter\LoginFilter.java

?????文件???????1094??2015-06-16?10:51??MakeFriend\src\com\sai\global\ConnTool.java

?????文件????????184??2014-10-08?21:22??MakeFriend\src\com\sai\global\DaoFactory.java

?????文件????????213??2014-10-08?21:22??MakeFriend\src\com\sai\global\QueryServiceFactory.java

?????文件????????208??2014-10-08?21:22??MakeFriend\src\com\sai\global\ServiceFactory.java

?????文件????????229??2014-10-08?10:38??MakeFriend\src\com\sai\global\UserServiceFactory.java

?????文件???????1479??2014-10-08?21:22??MakeFriend\src\com\sai\service\MakeFriendService.java

?????文件???????2967??2015-06-15?17:33??MakeFriend\src\com\sai\service\QueryService.java

?????文件????????797??2014-10-09?19:16??MakeFriend\src\com\sai\service\UserinfoService.java

?????文件???????1270??2015-06-15?17:34??MakeFriend\src\com\sai\servlet\AjaxServlet.java

?????文件???????1388??2015-06-15?17:35??MakeFriend\src\com\sai\servlet\CheckPassword.java

............此處省略205個文件信息