package?com.ccunix.scm.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?com.ccunix.scm.util.DatabaseManager;
import?com.ccunix.scm.vo.CourseVO;

/**
?*?course表的操作類
?*?@author?jtt
?*
?*
?*??private?int?cno;
	private?String?cname;
	private?double?credit;
	private?String?cterm;
	private?String?ctea;
?*/
public?class?CourseDAO?{
	/**
	?*?插入
	?*?@param?c
	?*?@return
	?*/
	public?boolean?insert（CourseVO?s）{
		Connection?connection?=?DatabaseManager.CONN（）;
		PreparedStatement?statement?=?null;
		try?{
			String?sql=“insert?into?course（cnamecreditctermctea）?values?（????）“;
			statement?=?connection.prepareStatement（sql）;
			statement.setString（1?s.getCname（））;
			statement.setDouble（2?s.getCredit（））;
			statement.setString（3?s.getCterm（））;
			statement.setString（4?s.getCtea（））;
			
			int?x?=?statement.executeUpdate（）;
			if（x>0）{
				//System.out.println（“執行成功:“+x）;
				return?true;
			}		
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			DatabaseManager.close（connection?statement）;//釋放資源
		}
		return?false;
	}
	
	/**
	?*?修改
	?*?@param?cno
	?*?@param?c
	?*/
	public?boolean?update（CourseVO?sint?cno1）?{
		Connection?connection?=?DatabaseManager.CONN（）;
		PreparedStatement?statement?=?null;
		try?{
			String?sql=“update?course?set?cno=??cname=??credit=?cterm=?ctea=??where?cno=?“;
			statement?=?connection.prepareStatement（sql）;
			statement.setInt（1?s.getCno（））;
			statement.setString（2?s.getCname（））;
			statement.setDouble（3?s.getCredit（））;
			statement.setString（4?s.getCterm（））;
			statement.setString（5?s.getCtea（））;
			statement.setInt（6?cno1）;
			
			int?x?=?statement.executeUpdate（）;
			if（x>0）{
				return?true;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			DatabaseManager.close（connection?statement）;//釋放資源
		}
		return?false;
	}
	
	/**
	?*?按照課號刪除
	?*?@param?sno
	?*/
	public?boolean?delete（int?cno）?{
		Connection?connection?=?DatabaseManager.CONN（）;
		PreparedStatement?statement?=?null;
		try?{
			String?sql=“delete?from?course?where?cno=?“;
			statement?=?connection.prepareStatement（sql）;
			statement.setInt（1?cno）;
			int?x?=?statement.executeUpdate（）;
			if（x>0）{
				return?true;
			}	
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			DatabaseManager.close（connection?statement）;//釋放資源
		}
		return?false;
	}
	
	/**
	?*?查詢
	?*?@return
	?*/
	public?List?selectCno（int?cno）{
		List?courses?=?new?ArrayList（）;
		Connection?connection?=?DatabaseManager.CONN（）;
		PreparedStatement?statement?=?null;
		try?{
			String?sql=“select?cnocnamecreditctermctea?from?course?where?cno=?“;
			statement?=?connection.prepareStatement（sql）;
			statement.setInt（1?cno）;
			ResultSet?rs?=?statement.execut

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-07-12?18:31??scm-jtt\
?????文件?????????377??2017-07-08?22:29??scm-jtt\.classpath
?????文件?????????383??2017-07-08?21:40??scm-jtt\.project
?????目錄???????????0??2017-07-12?18:31??scm-jtt\.settings\
?????文件?????????598??2017-07-08?22:29??scm-jtt\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2017-07-12?18:31??scm-jtt\bin\
?????目錄???????????0??2017-07-12?18:31??scm-jtt\bin\com\
?????目錄???????????0??2017-07-12?18:31??scm-jtt\bin\com\ccunix\
?????目錄???????????0??2017-07-12?18:31??scm-jtt\bin\com\ccunix\scm\
?????目錄???????????0??2017-07-12?18:31??scm-jtt\bin\com\ccunix\scm\dao\
?????文件????????3581??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\dao\CourseDAO.class
?????文件????????4678??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\dao\SCDAO.class
?????文件????????3954??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\dao\StudentDAO.class
?????文件????????1936??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\dao\UserDAO.class
?????目錄???????????0??2017-07-12?18:31??scm-jtt\bin\com\ccunix\scm\service\
?????文件????????3425??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\AddCourse.class
?????文件????????4128??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\AddSC.class
?????文件????????4207??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\AddStudent.class
?????文件????????4172??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\DeleteCourse.class
?????文件????????4718??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\DeleteSC.class
?????文件????????4251??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\DeleteStudent.class
?????文件????????4334??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\SelectCourse.class
?????文件????????2678??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\SelectSC.class
?????文件????????2791??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\SelectScore.class
?????文件????????4347??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\SelectStudent.class
?????文件????????5312??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\UpdateCourse.class
?????文件????????3983??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\UpdatePassword.class
?????文件????????5471??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\UpdateSC.class
?????文件????????4870??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\UpdateScore.class
?????文件????????5907??2017-07-12?15:35??scm-jtt\bin\com\ccunix\scm\service\UpdateStudent.class
?????目錄???????????0??2017-07-12?18:31??scm-jtt\bin\com\ccunix\scm\ui\
............此處省略62個文件信息