package?control;
import?java.sql.*;
import?java.text.SimpleDateFormat;
import?java.util.*;
import?java.util.Date;
public?class?MyBean?{
	Connection?conn;
	public?MyBean（）?{
		this.conn?=?con（）;
	}
	public?Connection?con（）?{//鏈接數(shù)據(jù)庫(kù)
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}
		//后面進(jìn)行了編碼聲明，防止中文亂碼
		String?sqlcon?=?“jdbc:mysql://localhost:3306/blog?useUnicode=true&characterEncoding=UTF-8“;
		try?{
			conn?=?DriverManager.getConnection（sqlcon?“root“?““）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?conn;
	}
	public?ResultSet?selectalluser（）{//無(wú)參數(shù)，查詢所有用戶信息
		ResultSet?a?=?null;
		String?sql=“select?*?from?user?order?by?uid“;
		Statement?st;
		try?{
			st=conn.createStatement（）;
			a=st.executeQuery（sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?a;
	}
	public?ResultSet?selectoneuser（String?uid）{//帶參數(shù)，通過(guò)uid查詢用戶信息
		ResultSet?a?=?null;
		String?sql=“select?*?from?user?where?uid=‘“+uid+“‘?order?by?uid“;
		Statement?st;
		try?{
			st=conn.createStatement（）;
			a=st.executeQuery（sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?a;
	}
	public?ResultSet?selectallusernopwd（）{//無(wú)參數(shù)，查詢所有用戶信息
		ResultSet?a?=?null;
		String?sql=“select?uidNAMEuserimg?from?user?order?by?uid“;
		Statement?st;
		try?{
			st=conn.createStatement（）;
			a=st.executeQuery（sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?a;
	}
	public?ResultSet?SelectUserMessage（String?gid）{//查詢?cè)撚脩羲辛粞杂涗洠磿r(shí)間排序
		ResultSet?rt=null;
		String?sql=“select?*?from?usermessage?where?guid=“+gid+“?order?by?writetime?DESC“;
		try?{
			Statement?st=conn.createStatement（）;
			rt=st.executeQuery（sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}		
		return?rt;
	}
	public?Map?selectUserReplyMessage（String?gid）{//查詢留言回復(fù)信息
		ResultSet?rs=SelectUserMessage（gid）;
		ResultSet?userinfo=null;
		String?replymessage=null;
		String?onereply=null;
		int?be?=?0enrbe?=?0ren;
		int?i=1j=1;
		int?alllengthnow=0;
		int?lengthnow=0;
		String?messageid=null;
		boolean?check1=truecheck2=true;
		Map?map=new?HashMap（）;
		try?{
			while（rs.next（））{
			replymessage=rs.getString（“ReplyMessage“）;
			if（replymessage!=null）{
				messageid=rs.getString（“MessageId“）;
				alllengthnow?=?replymessage.length（）;
				j=1;
				en=0;be=0;
				ren=0;rbe=0;
				check1=true;
				check2=true;
				while（check1）{
					i=1;
					rbe=0;
					be=be+0;
					en=replymessage.indexOf（“>“be+1）;
					if（en==-1）?check1=false;
					if（be==0）
						onereply=replymessage.substring（been+1）;
					else
						onereply=replymessage.substring（be+1en+1）;
					lengthnow=onereply.length（）;
					check2=true;
					while（check2）{
						rbe=rbe+0;
						ren=onereply.indexOf（“<“rbe+1）;
						if（ren==-1&&ren!=lengthnow-1）
							ren=lengthnow-1;
						if（ren==-1）check2=false;
						if（rbe=

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????446??2018-09-28?09:52??csdnmessage\.classpath

?????文件????????306??2018-09-28?09:54??csdnmessage\.mymetadata

?????文件???????1284??2018-09-28?09:52??csdnmessage\.project

?????文件?????754075??2018-09-28?09:52??csdnmessage\.settings\mysql-connector-java-5.1.13-bin.jar

?????文件????????143??2018-09-28?09:52??csdnmessage\.settings\org.eclipse.core.resources.prefs

?????文件????????633??2018-09-28?09:52??csdnmessage\.settings\org.eclipse.jdt.core.prefs

?????文件???????6016??2018-10-02?15:18??csdnmessage\src\control\MyBean.java

?????文件???????2539??2018-10-02?15:16??csdnmessage\src\servlet\AddMessageBy.java

?????文件???????1983??2018-10-02?15:26??csdnmessage\src\servlet\MessageUserReply.java

?????文件???????1927??2018-10-02?15:19??csdnmessage\src\servlet\SelectMessageServlet.java

?????文件??????15576??2018-10-02?08:57??csdnmessage\WebRoot\cache\zhangsan.jpg

?????文件?????121200??2018-09-28?09:52??csdnmessage\WebRoot\css\bootstrap.min.css

?????文件????????253??2018-09-28?12:30??csdnmessage\WebRoot\css\index.css

?????文件???????4596??2018-10-02?10:35??csdnmessage\WebRoot\css\message.css

?????文件??????20127??2018-09-28?09:52??csdnmessage\WebRoot\fonts\glyphicons-halflings-regular.eot

?????文件?????108738??2018-09-28?09:52??csdnmessage\WebRoot\fonts\glyphicons-halflings-regular.svg

?????文件??????45404??2018-09-28?09:52??csdnmessage\WebRoot\fonts\glyphicons-halflings-regular.ttf

?????文件??????23424??2018-09-28?09:52??csdnmessage\WebRoot\fonts\glyphicons-halflings-regular.woff

?????文件??????18028??2018-09-28?09:52??csdnmessage\WebRoot\fonts\glyphicons-halflings-regular.woff2

?????文件????1254272??2018-09-28?09:52??csdnmessage\WebRoot\img\back.jpg

?????文件????????774??2018-09-28?12:29??csdnmessage\WebRoot\index.jsp

?????文件??????37045??2018-09-28?09:52??csdnmessage\WebRoot\js\bootstrap.min.js

?????文件??????95786??2018-09-28?09:52??csdnmessage\WebRoot\js\jquery1111.min.js

?????文件???????7046??2018-10-02?16:46??csdnmessage\WebRoot\message.jsp

?????文件?????????36??2018-09-28?09:52??csdnmessage\WebRoot\meta-INF\MANIFEST.MF

?????文件???????6727??2018-10-02?15:18??csdnmessage\WebRoot\WEB-INF\classes\control\MyBean.class

?????文件???????2717??2018-10-02?15:16??csdnmessage\WebRoot\WEB-INF\classes\servlet\AddMessageBy.class

?????文件???????2618??2018-10-02?15:26??csdnmessage\WebRoot\WEB-INF\classes\servlet\MessageUserReply.class

?????文件???????2329??2018-10-02?15:19??csdnmessage\WebRoot\WEB-INF\classes\servlet\SelectMessageServlet.class

?????文件???????1697??2018-09-28?09:52??csdnmessage\WebRoot\WEB-INF\web.xml

............此處省略21個(gè)文件信息