package?com.Dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?com.DMModel.Room;
import?com.DMUtil.StringUtil;


public?class?RoomDao?{
??public?int?roomAdd（Connection?conRoom?room）?throws?Exception{
	??String?sql?=?“insert?into?room_message?values（null??）“;
	??PreparedStatement?pstmt?=?con.prepareStatement（sql）;
	??pstmt.setString（1room.getMember（））;
	??pstmt.setString（2?room.getLeader（））;
	??return?pstmt.executeUpdate（）;
??}
??public?ResultSet?roomList（Connection?conRoom?room）?throws?Exception{
	??StringBuffer?sb?=new?StringBuffer（“select?*?from?room_message“）;
	??if（StringUtil.isNotEmpty（room.getMember（）））{
		??String?member?=room.getMember（）;
		???sb.append（“?and?member?like?‘%“+?room.getMember（）+“%‘“）;
	??}
	??PreparedStatement?pstmt?=?con.prepareStatement（sb.toString（）.replaceFirst（“and“?“where“））;
	??return?pstmt.executeQuery（）;
??}
??public?int?roomModify（Connection?conRoom?room）throws?Exception{
	??String?sql?=?“update?room_message?set?member=?leader=??where?id=?“;
	??PreparedStatement?pstmt?=?con.prepareStatement（sql）;
	??pstmt.setString（1room.getMember（））;
	??pstmt.setString（2room.getLeader（））;
	??pstmt.setString（3room.getId（））;
	??return?pstmt.executeUpdate（）;??
	??}
??public?int?roomDelete（Connection?con?Room?room）throws?Exception{
	??String?sql?=?“delete?from?room_message?where?member=?“;
	??PreparedStatement?pstmt?=?con.prepareStatement（sql）;
	??pstmt.setString（1room.getMember（））;
	??return?pstmt.executeUpdate（）;
??}
}

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

?????文件????????513??2013-09-15?11:03??dormitory\.classpath

?????文件????????385??2013-09-15?10:15??dormitory\.project

?????文件????????598??2013-09-15?10:15??dormitory\.settings\org.eclipse.jdt.core.prefs

?????文件???????2401??2013-09-16?18:59??dormitory\bin\com\Dao\RoomDao.class

?????文件???????3106??2013-09-17?22:25??dormitory\bin\com\Dao\StudentDao.class

?????文件???????1495??2013-09-15?20:23??dormitory\bin\com\Dao\UserDao.class

?????文件???????1378??2013-09-17?14:17??dormitory\bin\com\DMModel\Room.class

?????文件???????2584??2013-09-17?22:28??dormitory\bin\com\DMModel\Student.class

?????文件???????1136??2013-09-18?08:30??dormitory\bin\com\DMModel\User.class

?????文件???????1891??2013-09-15?20:23??dormitory\bin\com\DMUtil\DMUtil.class

?????文件????????615??2013-09-16?14:45??dormitory\bin\com\DMUtil\StringUtil.class

?????文件????????749??2013-09-18?10:58??dormitory\bin\com\DMView\LoginFrm$1.class

?????文件????????749??2013-09-18?10:58??dormitory\bin\com\DMView\LoginFrm$2.class

?????文件????????749??2013-09-18?10:58??dormitory\bin\com\DMView\LoginFrm$3.class

?????文件????????539??2013-09-18?10:58??dormitory\bin\com\DMView\LoginFrm$4.class

?????文件???????9047??2013-09-18?10:58??dormitory\bin\com\DMView\LoginFrm.class

?????文件???????9939??2013-09-18?10:58??dormitory\bin\com\DMView\LoginFrm.form

?????文件????????742??2013-09-18?11:10??dormitory\bin\com\DMView\MainFrm$1.class

?????文件????????537??2013-09-18?11:10??dormitory\bin\com\DMView\MainFrm$10.class

?????文件????????742??2013-09-18?11:10??dormitory\bin\com\DMView\MainFrm$2.class

?????文件????????742??2013-09-18?11:10??dormitory\bin\com\DMView\MainFrm$3.class

?????文件????????742??2013-09-18?11:10??dormitory\bin\com\DMView\MainFrm$4.class

?????文件????????742??2013-09-18?11:10??dormitory\bin\com\DMView\MainFrm$5.class

?????文件????????742??2013-09-18?11:10??dormitory\bin\com\DMView\MainFrm$6.class

?????文件????????742??2013-09-18?11:10??dormitory\bin\com\DMView\MainFrm$7.class

?????文件????????742??2013-09-18?11:10??dormitory\bin\com\DMView\MainFrm$8.class

?????文件????????742??2013-09-18?11:10??dormitory\bin\com\DMView\MainFrm$9.class

?????文件???????8737??2013-09-18?11:10??dormitory\bin\com\DMView\MainFrm.class

?????文件??????12694??2013-09-18?11:10??dormitory\bin\com\DMView\MainFrm.form

?????文件????????749??2013-09-18?11:11??dormitory\bin\com\DMView\MainFrm2$1.class

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