package?com.myflt.dao;

import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;

import?com.myflt.util.Bus;
import?com.myflt.util.FindFriends;
import?com.myflt.util.User;
import?com.myflt.db.DbHelper;


public?class?BusDao?{
	public?int?insertBus（String?usernameString?username2String?timeString?contentString?sexString?ageint?ruidint?rqidString?state）{
		String?sql=“insert?into?friend_request（usernameusername2timecontentsexageruidrqidstate）?values?（‘“+username+“‘‘“+username2+“‘‘“+time+“‘‘“+content+“‘‘“+sex+“‘‘“+age+“‘‘“+ruid+“‘‘“+rqid+“‘‘“+state+“‘）“;
		return?DbHelper.executeSql（sql）;
	}
	
	public?int?updateFriend（int?ridString?state）{
		String?sql=“update?friend_request?set?state=‘“+state+“‘?where?rid=‘“+rid+“‘“;
		return?DbHelper.executeSql（sql）;
	}
	
	public?int?delFriend（int?rid）{
		String?sql=“delete?from?friend_request?where?rid=‘“+rid+“‘“;
		return?DbHelper.executeSql（sql）;
	}
	
			
			

			
			/**獲取所有用戶信息*/
			public?List?getallFriend（）{
				String?sql=“select?*?from?friend_request“;
				Connection?con=null;
				Statement?st=null;
				ResultSet?rs=null;
				List?list?=?new?ArrayList（）;
				try?{
					con?=?DbHelper.getconnection（）;
					st?=?con.createStatement（）;
					rs=st.executeQuery（sql）;
					if?（rs?!=?null）
						while?（rs.next（））?{
							FindFriends?us=new?FindFriends（）;
							us.setRid（rs.getInt（“rid“））;
							us.setUsername（rs.getString（“username“））;
							us.setUsername2（rs.getString（“username2“））;
							us.setTime（rs.getString（“time“））;
							us.setContent（rs.getString（“content“））;
							us.setSex（rs.getString（“sex“））;
							us.setAge（rs.getString（“age“））;
							us.setRuid（rs.getInt（“ruid“））;
							us.setRqid（rs.getInt（“rqid“））;
							us.setState（rs.getString（“state“））;
							list.add（us）;
						}
				}?catch?（Exception?e）?{
				}
				return?list;
			}
			
			/**查找公交線路*/
			public?List?getFindBus（String?tiaojian）{
				String?sql=“select?*?from?bus?“+tiaojian;
				Connection?con=null;
				Statement?st=null;
				ResultSet?rs=null;
				List?list?=?new?ArrayList（）;
				try?{
					con?=?DbHelper.getconnection（）;
					st?=?con.createStatement（）;
					rs=st.executeQuery（sql）;
					if?（rs?!=?null）
						while?（rs.next（））?{
							Bus?us=new?Bus（）;
							us.setXid（rs.getInt（“xid“））;
							us.setBus（rs.getString（“bus“））;
							us.setXianlu（rs.getString（“xianlu“））;
							us.setStopzhan（rs.getString（“stopzhan“））;
							us.setMoney（rs.getString（“money“））;
							us.setTime（rs.getString（“time“））;
							us.setPhone（rs.getString（“phone“））;
							list.add（us）;
						}
				}?catch?（Exception?e）?{
				}
				return?list;
			}
			
}

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

?????文件???????1571??2016-03-30?19:35??旅游系統\My_Flight\.classpath

?????文件????????300??2016-05-10?21:16??旅游系統\My_Flight\.mymetadata

?????文件???????1415??2016-03-30?20:02??旅游系統\My_Flight\.project

?????文件????????500??2016-03-30?19:17??旅游系統\My_Flight\.settings\.jsdtscope

?????文件????????330??2016-03-30?19:17??旅游系統\My_Flight\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2016-03-30?19:17??旅游系統\My_Flight\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2016-03-30?19:17??旅游系統\My_Flight\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2873??2016-05-11?11:01??旅游系統\My_Flight\src\com\myflt\dao\BusDao.java

?????文件???????6479??2016-04-21?12:49??旅游系統\My_Flight\src\com\myflt\dao\CJPDao.java

?????文件???????1377??2016-05-06?18:30??旅游系統\My_Flight\src\com\myflt\dao\FeelBackDao.java

?????文件???????3032??2016-05-10?10:29??旅游系統\My_Flight\src\com\myflt\dao\FindFriendsDao.java

?????文件???????1979??2016-04-05?09:06??旅游系統\My_Flight\src\com\myflt\dao\FltAdminDao.java

?????文件???????4842??2016-05-10?21:45??旅游系統\My_Flight\src\com\myflt\dao\FltUserDao.java

?????文件???????2510??2016-05-11?19:32??旅游系統\My_Flight\src\com\myflt\dao\HotelDao.java

?????文件???????5077??2016-04-19?21:57??旅游系統\My_Flight\src\com\myflt\dao\objectFltInfoDao.java

?????文件???????1835??2016-05-10?09:32??旅游系統\My_Flight\src\com\myflt\dao\TakingDao.java

?????文件???????1111??2016-05-10?21:46??旅游系統\My_Flight\src\com\myflt\db\DbHelper.java

?????文件???????2595??2016-04-01?20:35??旅游系統\My_Flight\src\com\myflt\servlet\AdminLoginServlet.java

?????文件???????2377??2016-04-18?18:24??旅游系統\My_Flight\src\com\myflt\servlet\DeleteCJRInfoServlet.java

?????文件???????2408??2016-04-02?11:31??旅游系統\My_Flight\src\com\myflt\servlet\DeletePlaneServlet.java

?????文件???????2373??2016-04-21?00:03??旅游系統\My_Flight\src\com\myflt\servlet\DeleteShopInfoServlet.java

?????文件???????2378??2016-04-01?21:54??旅游系統\My_Flight\src\com\myflt\servlet\DeleteUserServlet.java

?????文件???????2399??2016-05-06?23:08??旅游系統\My_Flight\src\com\myflt\servlet\FindUserServlet.java

?????文件???????2564??2016-05-10?21:25??旅游系統\My_Flight\src\com\myflt\servlet\GetAllFltInfoServlet.java

?????文件???????2417??2016-04-01?16:58??旅游系統\My_Flight\src\com\myflt\servlet\GetAllUserServlet.java

?????文件???????2470??2016-04-18?16:09??旅游系統\My_Flight\src\com\myflt\servlet\GetCJRInfoServlet.java

?????文件???????2564??2016-04-20?11:14??旅游系統\My_Flight\src\com\myflt\servlet\GetShopCarInfoServlet.java

?????文件???????2444??2016-04-01?15:36??旅游系統\My_Flight\src\com\myflt\servlet\GetUser.java

?????文件???????2842??2016-04-18?15:46??旅游系統\My_Flight\src\com\myflt\servlet\InsertCJPeopleInfoServlet.java

?????文件???????2556??2016-05-06?18:31??旅游系統\My_Flight\src\com\myflt\servlet\InsertFeelBackServlet.java

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