package?cn.nyxy.yxh;

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

import?cn.nyxy.yxh.DBUtil;

public?class?Adddao?{
	DBUtil?dbu=new?DBUtil（）;
	Connection?ct?=?null;
	PreparedStatement?ps?=?null;
	ResultSet?rs?=?null;
	String?sql?=?““;
	
	public?void?Add_Friend（String?u_nameString?f_nameString?add_message）{

		try{
			ct?=?dbu.getCon（）;
			
			sql=“insert?into?add_friend（u_namef_nameadd_message）?values（???）“;
		ps?=?ct.prepareStatement（sql）;	
		ps.setString（1u_name）;
		ps.setString（2f_name）;
		ps.setString（3add_message）;
		ps.executeUpdate（）;
		
		
		
		}catch（Exception?e）{
			System.out.println（“連接數據庫失敗“）;
		}finally{
			dbu.close（rs?ps?ct）;
		}
		
	}
	
	
	public?List?Select_Qingqiu（String?u_namea）{
		List?addf?=?new?ArrayList（）;	
		try{
			ct?=?dbu.getCon（）;
			
			sql=“select?*?from?add_friend?where?f_name=‘“+u_namea+“‘“;			
			ps?=?ct.prepareStatement（sql）;	
			rs?=?ps.executeQuery（）;
			while（rs.next（））{		
				String?u_name?=?rs.getString（“u_name“）;
				String?add_message?=?rs.getString（“add_message“）;
				AddFriends?fir?=?new?AddFriends（u_nameadd_message）;
				
				addf.add（fir）;
				
			}
			
			
		}catch（Exception?e）{
			System.out.println（“連接數據庫失敗“）;
		}finally{
			dbu.close（rs?ps?ct）;
		}
		return?addf;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-09-19?12:07??AddFriends\
?????文件?????????901??2017-09-18?21:47??AddFriends\.classpath
?????文件?????????910??2017-09-18?15:13??AddFriends\.project
?????目錄???????????0??2017-09-19?12:07??AddFriends\.settings\
?????文件?????????567??2017-09-18?15:13??AddFriends\.settings\.jsdtscope
?????文件?????????364??2017-09-18?15:13??AddFriends\.settings\org.eclipse.jdt.core.prefs
?????文件?????????482??2017-09-18?15:13??AddFriends\.settings\org.eclipse.wst.common.component
?????文件?????????345??2017-09-18?15:13??AddFriends\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-09-18?15:13??AddFriends\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-09-18?15:13??AddFriends\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件?????????162??2017-09-18?15:23??AddFriends\.tern-project
?????目錄???????????0??2017-09-19?12:07??AddFriends\build\
?????目錄???????????0??2017-09-19?12:07??AddFriends\build\classes\
?????目錄???????????0??2017-09-19?12:07??AddFriends\build\classes\cn\
?????目錄???????????0??2017-09-19?12:07??AddFriends\build\classes\cn\nyxy\
?????目錄???????????0??2017-09-19?12:07??AddFriends\build\classes\cn\nyxy\yxh\
?????文件????????2960??2017-09-18?21:57??AddFriends\build\classes\cn\nyxy\yxh\Adddao.class
?????文件????????1282??2017-09-18?21:57??AddFriends\build\classes\cn\nyxy\yxh\AddFriends.class
?????文件????????1802??2017-09-18?21:57??AddFriends\build\classes\cn\nyxy\yxh\AddFriendServlet.class
?????文件????????1982??2017-09-18?21:57??AddFriends\build\classes\cn\nyxy\yxh\AddfriServlet.class
?????文件?????????101??2017-09-18?18:00??AddFriends\build\classes\cn\nyxy\yxh\dbinfo.properties
?????文件????????2286??2017-09-18?21:57??AddFriends\build\classes\cn\nyxy\yxh\DBUtil.class
?????文件?????????708??2017-09-18?21:57??AddFriends\build\classes\cn\nyxy\yxh\Finfo.class
?????文件????????1428??2017-09-18?21:57??AddFriends\build\classes\cn\nyxy\yxh\LoginServlet.class
?????文件?????????702??2017-09-18?21:57??AddFriends\build\classes\cn\nyxy\yxh\User.class
?????目錄???????????0??2017-09-19?12:07??AddFriends\src\
?????目錄???????????0??2017-09-19?12:07??AddFriends\src\cn\
?????目錄???????????0??2017-09-19?12:07??AddFriends\src\cn\nyxy\
?????目錄???????????0??2017-09-19?12:07??AddFriends\src\cn\nyxy\yxh\
?????文件????????1477??2017-09-18?21:56??AddFriends\src\cn\nyxy\yxh\Adddao.java
?????文件?????????789??2017-09-18?21:38??AddFriends\src\cn\nyxy\yxh\AddFriends.java
............此處省略20個文件信息