package?cn.edu.cczu.dormitory.dao;

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

import?cn.edu.cczu.dormitory.dto.Dormitory;
import?cn.edu.cczu.dormitory.util.DBConnection;

public?class?DormitoryDAO?{
	
	private?Connection?conn?=?null;
	private?ResultSet?rs?=?null;
	private?PreparedStatement?ps?=?null;
	
	public?DormitoryDAO（）{
		conn?=?DBConnection.getConnection（）;
	}
	
	public?int?add（Dormitory?dormitory）{
		int?r?=?-1;
		try?{
			String?sql?=?“insert?into?dormitory（didbuildingNumroomNumaddresstotalBunkremainBunktype）?values（???????）“;
			ps?=?conn.prepareStatement（sql）;
			ps.setString（1dormitory.getdId（）?）;
			ps.setStr

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

?????文件????????602??2011-01-12?21:13??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\.classpath

?????文件????????309??2011-01-06?20:50??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\.mymetadata

?????文件???????1418??2011-01-06?21:52??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\.project

?????文件????????500??2011-01-06?20:50??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\.settings\.jsdtscope

?????文件????????330??2011-01-06?20:50??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2011-01-06?20:50??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-01-06?20:50??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????8600??2011-01-14?10:54??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\dao\DormitoryDAO.java

?????文件???????7612??2011-01-14?10:52??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\dao\StudentDAO.java

?????文件???????1455??2011-01-08?15:28??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\dao\UserDAO.java

?????文件???????1582??2011-01-08?15:35??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\dto\Dormitory.java

?????文件????????941??2011-01-07?22:34??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\dto\Student.java

?????文件???????1063??2011-01-07?22:34??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\dto\User.java

?????文件???????1892??2011-01-08?16:03??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\AddDormitoryServlet.java

?????文件???????1713??2011-01-08?21:45??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\AddStudentServlet.java

?????文件???????1223??2011-01-09?10:59??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\DeleteStudentServlet.java

?????文件???????1282??2011-01-10?22:34??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\LoginServlet.java

?????文件???????2449??2011-01-08?20:27??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\ModifyDormitoryServlet.java

?????文件???????2487??2011-01-09?00:12??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\ModifyStudentServlet.java

?????文件???????1607??2011-01-09?16:15??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\MoveIntoDormitoryServlet.java

?????文件???????1552??2011-01-11?23:56??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\MoveOutDormitoryServlet.java

?????文件???????1590??2011-01-09?16:27??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\QueryDormitoryServlet.java

?????文件???????1150??2011-01-09?14:38??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\QueryOccupiedDormitoryServlet.java

?????文件???????1760??2011-01-09?16:05??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\QueryOccupiedStudentServlet.java

?????文件???????1139??2011-01-09?12:12??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\QueryRemainDormitoryServlet.java

?????文件???????1956??2011-01-09?16:05??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\QueryRemainStudentServlet.java

?????文件???????1511??2011-01-09?11:37??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\QueryStudentDormitoryInfoServlet.java

?????文件???????1447??2011-01-08?22:58??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\QueryStudentServlet.java

?????文件???????1444??2011-01-07?22:49??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\manager\RegisterServlet.java

?????文件????????441??2011-01-12?21:45??學(xué)生宿舍管理系統(tǒng)的設(shè)計(jì)\源代碼\代碼\dormitorySys\src\cn\edu\cczu\dormitory\test\StudentDAOTest.java

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