package?com.neusoft.dao;

import?java.sql.*;
import?java.util.ArrayList;
import?java.util.List;

import?com.neusoft.jdbcUtil.SingletonUtil;

public?abstract?class?AbstractDao?{

	public?Listject>?find（String?sqlobject[]?args）?{
		Connection?connection?=?null;
		PreparedStatement?ps?=?null;
		ResultSet?rs?=?null;?
		Listject>?list?=?new?ArrayListject>（）;
		try{
			connection?=?SingletonUtil.getSingletonUtil（）.getConnction（）;
			ps?=?connection.prepareStatement（sql）;
			for（int?i=0;?i				ps.setobject（i+1?args[i]）;
			}
			rs?=?ps.executeQuery（）;
			object?obj?=?null;
			while（rs.next（））?{
				obj?=?rowMapper（rs）;//交給繼承的類自己實現其所需求的rowMapper（）
				list.add（obj）;
			}
			return?list;
		}?catch（SQLException?e）?{
			throw?new?DaoException（e.getMessage（）?e）;?
		}?finally?{
			SingletonUtil.getSingletonUtil（）.freeConn（rs?ps?connection）;
		}
	}

	abstract?protected?object?rowMapper（ResultSet?rs）?throws?SQLException;
	
	public?int?modify（String?sql?object[]?args）?{
		Connection?connection?=?null;
		PreparedStatement?ps?=?null;
		ResultSet?rs?=?null;
		//this.find（sql?args）;
		try{
			connection?=?SingletonUtil.getSingletonUtil（）.getConnction（）;
			ps?=?connection.prepareStatement（sql）;
			for（int?i=0;?i				ps.setobject（i+1?args[i]）;
			}
			return?ps.executeUpdate（）;
		}?catch（SQLException?e）?{
			throw?new?DaoException（e.getMessage（）e）;
		}?finally?{
			SingletonUtil.getSingletonUtil（）.freeConn（rs?ps?connection）;
		}
	}
	
	public?void?add（String?sql?object[]?args）?{
		Connection?connection?=?null;
		PreparedStatement?ps?=?null;
		ResultSet?rs?=?null;
		try?{
			connection?=?SingletonUtil.getSingletonUtil（）.getConnction（）;
			ps?=?connection.prepareStatement（sql）;
			for（int?i=0;?i				ps.setobject（i+1?args[i]）;
			}
			ps.executeUpdate（）;
		}?catch（SQLException?e）?{
			throw?new?DaoException（e.getMessage（）e）;
			//e.printStackTrace（）;
		}?finally{
			SingletonUtil.getSingletonUtil（）.freeConn（rs?ps?connection）;
		}
	}
	public?int?delete（String?sql?object?args[]）?{
		Connection?connection?=?null;
		PreparedStatement?ps?=?null;
		ResultSet?rs?=?null;
		try?{
			connection?=?SingletonUtil.getSingletonUtil（）.getConnction（）;
			ps?=?connection.prepareStatement（sql）;
			for（int?i=0;?i				ps.setobject（i+1?args[i]）;
			}
			return?ps.executeUpdate（）;
		}?catch（SQLException?e）?{
			throw?new?DaoException（e.getMessage（）e）;
		}?finally?{
			SingletonUtil.getSingletonUtil（）.freeConn（rs?ps?connection）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-06-01?18:43??swing+jdbc學生選課系統\
?????文件??????537303??2010-04-19?10:12??swing+jdbc學生選課系統\sqljdbc4.jar
?????文件????????2149??2011-05-07?17:39??swing+jdbc學生選課系統\student.sql
?????目錄???????????0??2011-06-01?18:42??swing+jdbc學生選課系統\StudentManage\
?????文件?????????387??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\.classpath
?????文件?????????389??2011-05-06?20:30??swing+jdbc學生選課系統\StudentManage\.project
?????目錄???????????0??2011-06-01?18:42??swing+jdbc學生選課系統\StudentManage\bin\
?????目錄???????????0??2011-06-01?18:42??swing+jdbc學生選課系統\StudentManage\bin\com\
?????目錄???????????0??2011-06-01?18:42??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\
?????目錄???????????0??2011-06-01?18:42??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\dao\
?????文件????????3168??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\dao\AbstractDao.class
?????文件?????????799??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\dao\DaoException.class
?????目錄???????????0??2011-06-01?18:42??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\dao\impl\
?????文件????????3797??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\dao\impl\CourseDaoImpl.class
?????文件????????1782??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\dao\impl\LoginDaoImpl.class
?????文件????????3697??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\dao\impl\SelectDaoImpl.class
?????文件????????3563??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\dao\impl\UserDaoImpl.class
?????目錄???????????0??2011-06-01?18:42??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\domain\
?????文件????????1391??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\domain\CourseInfo.class
?????文件?????????982??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\domain\SelectedInfo.class
?????文件????????1158??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\domain\UserInfo.class
?????目錄???????????0??2011-06-01?18:42??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\frame\
?????目錄???????????0??2011-06-01?18:42??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\frame\course\
?????文件????????4068??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\frame\course\AddCourse.class
?????文件????????2516??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\frame\course\DeleteCourse.class
?????文件????????3322??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\frame\course\DisplayCourse.class
?????文件????????3790??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\frame\course\QueryCourse.class
?????文件????????4319??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\frame\course\SelectCourse.class
?????文件????????4156??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\frame\course\UpdateCourse.class
?????目錄???????????0??2011-06-01?18:42??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\frame\grade\
?????文件????????3631??2011-05-26?08:02??swing+jdbc學生選課系統\StudentManage\bin\com\neusoft\frame\grade\DisplayGrade.class
............此處省略61個文件信息