package?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?entity.Grade;
import?util.JDBCUtilProperties;

public?class?GradeDAO?{
	
	//插入數據
		public?boolean?insertGrade（List?li）?{
			//?1.獲取數據連接?
			Connection??conn??=?null;
			PreparedStatement?ps?=?null;
			conn?=?JDBCUtilProperties.getConnection（）;
			//?2.?獲取執行環境
			try?{
				ps?=?conn.prepareStatement
					（“insert?into?grade?values（grade_id_seq.nextval???????）“）;
				//?3.?設置值?執行?
				
				
				ps.setString（1?li.get（0））;
				ps.setString（2?li.get（1））;
				ps.setString（3?li.get（2））;
				ps.setString（4?li.get（3））;
				ps.setString（5?li.get（4））;
				ps.setString（6?li.get（5））;
				ps.setString（7?li.get（6））;
				
				int??rows?=?ps.executeUpdate（）;
				if（rows?>?0）?{
					return??true;
				}
			}?catch?（SQLException?e）?{
			
				e.printStackTrace（）;
			}finally{
				//?4.?釋放資源?
				JDBCUtilProperties.releaseResource（conn?ps?null）;
			}
			
			return?false;
		}
		//查詢所有考試成績（按時間降序排列）
	public?List?listAll（）?{
		//?1.獲取連接
				Connection???conn??=?null;
				PreparedStatement??ps?=?null;
				ResultSet????rs??=?null;
				List?li?=null;
				conn?=?JDBCUtilProperties.getConnection（）;
				try?{
					ps?=?conn.prepareStatement
							（“select?*?from?Grade??order?by?id?desc“）;
					rs?=?ps.executeQuery（）;
					Grade??grade?=?null;
					li=?new?ArrayList（）;
					//?如果next?成立?就代表?有對應的用戶?
					while（rs.next（））{
						grade?=?new?Grade（）;
						grade.setID（rs.getInt（“ID“））;
						grade.setGrade1（rs.getString（“grade1“））;
						grade.setGrade2（rs.getString（“grade2“））;
						grade.setGrade3（rs.getString（“grade3“））;
						grade.setGrade4（rs.getString（“grade4“））;
						grade.setGrade5（rs.getString（“grade5“））;
						grade.setSum（rs.getString（“sum“））;
						grade.setRatio（rs.getString（“ratio“））;
						li.add（grade）;
					}
					
				}?catch?（SQLException?e）?{
					//?TODO?Auto-generated?catch?block
					e.printStackTrace（）;
				}
				return?li;
				
	
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-11-01?15:28??theonlinetest\
?????文件?????????377??2017-07-05?08:11??theonlinetest\.classpath
?????文件?????????389??2017-07-05?08:11??theonlinetest\.project
?????目錄???????????0??2017-08-29?18:46??theonlinetest\.settings\
?????文件?????????598??2017-07-05?08:11??theonlinetest\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2017-11-01?15:28??theonlinetest\bin\
?????目錄???????????0??2017-11-01?15:28??theonlinetest\bin\Dao\
?????文件????????2945??2017-07-05?08:11??theonlinetest\bin\Dao\GradeDAO.class
?????文件?????????395??2017-07-05?08:11??theonlinetest\bin\Dao\ManagerDao.class
?????文件????????4400??2017-07-05?08:11??theonlinetest\bin\Dao\ManagerDaoImp.class
?????文件????????2545??2017-07-05?08:11??theonlinetest\bin\Dao\ManagerDAOMi.class
?????文件????????3150??2017-07-05?08:11??theonlinetest\bin\Dao\OracleQuestionDaoImp.class
?????文件?????????284??2017-07-05?08:11??theonlinetest\bin\Dao\QuestionDao.class
?????文件????????6435??2017-07-05?08:11??theonlinetest\bin\Dao\QuestionsDAO1.class
?????文件????????3333??2017-07-05?08:11??theonlinetest\bin\Dao\UserDao.class
?????目錄???????????0??2017-11-01?15:28??theonlinetest\bin\entity\
?????文件????????2749??2017-07-05?08:11??theonlinetest\bin\entity\Grade.class
?????文件????????1449??2017-07-05?08:11??theonlinetest\bin\entity\Manager.class
?????文件????????3902??2017-07-05?08:11??theonlinetest\bin\entity\Question.class
?????文件????????3122??2017-07-05?08:11??theonlinetest\bin\entity\User.class
?????目錄???????????0??2017-11-01?15:28??theonlinetest\bin\service\
?????文件????????8758??2017-07-05?08:11??theonlinetest\bin\service\Client.class
?????文件????????1446??2017-07-05?08:11??theonlinetest\bin\service\ManagerService.class
?????文件????????2786??2017-07-05?08:11??theonlinetest\bin\service\ProcessExam.class
?????文件????????1568??2017-07-05?08:11??theonlinetest\bin\service\Server.class
?????文件????????8483??2017-07-05?08:11??theonlinetest\bin\service\ServerThread.class
?????目錄???????????0??2017-08-29?18:46??theonlinetest\bin\test\
?????文件????????1335??2017-07-05?08:11??theonlinetest\bin\test\ManagerServiceTest.class
?????目錄???????????0??2017-11-01?15:28??theonlinetest\bin\util\
?????文件?????????120??2017-07-05?08:11??theonlinetest\bin\util\db.properties
?????文件????????2453??2017-07-05?08:11??theonlinetest\bin\util\JDBCUtilProperties.class
............此處省略27個文件信息