package?dao;

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

import?utils.DBUtils;
import?entity.Student;

public?class?AddStudentDao?{
	public?void?addStudent（Student?student）throws?Exception?{
		Connection?conn?=null;
		PreparedStatement?ps?=?null;
		try?{
			conn?=?DBUtils.getConnection（）;
			String?sql?=?“INSERT?INTO?score（sidsnamesexagecidcnamescore）?VALUES?（???????）“;
			ps?=?conn.prepareStatement（sql）;
			ps.setString（1?student.getSid（））;
			ps.setString（2?student.getSname（））;
			ps.setString（3?student.getSex（））;
			ps.setString（4?student.getAge（））;
			ps.setString（5?student.getCid（））;
			ps.setString（6?student.getCname（））;
			ps.setString（7?student.getScore（））;
			ps.executeUpdate（）;
		}?catch?（

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

?????文件???????1434??2016-11-07?23:01??Management?System\.classpath

?????文件???????1337??2016-11-07?18:06??Management?System\.project

?????文件????????522??2016-11-07?18:05??Management?System\.settings\.jsdtscope

?????文件????????428??2016-11-07?18:05??Management?System\.settings\org.eclipse.jdt.core.prefs

?????文件????????495??2016-11-07?18:05??Management?System\.settings\org.eclipse.wst.common.component

?????文件????????414??2016-11-07?18:05??Management?System\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2016-11-07?18:05??Management?System\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2016-11-07?18:05??Management?System\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1962??2016-11-28?16:48??Management?System\src\dao\AddStudentDao.java

?????文件???????1066??2016-11-11?22:10??Management?System\src\dao\Dao.java

?????文件????????555??2016-11-12?13:53??Management?System\src\dao\RemoveDao.java

?????文件???????1853??2016-11-24?09:28??Management?System\src\dao\ScoreDao.java

?????文件????????954??2016-11-12?13:52??Management?System\src\dao\SelectDao.java

?????文件????????777??2016-11-13?16:51??Management?System\src\dao\UpdateScoreDao.java

?????文件????????785??2016-11-13?18:35??Management?System\src\dao\UpdateStudentDao.java

?????文件????????818??2016-11-07?20:17??Management?System\src\dao\UserDao.java

?????文件?????????95??2016-11-07?18:30??Management?System\src\dbinfo.properties

?????文件?????????84??2016-11-11?22:07??Management?System\src\dbinfo1.properties

?????文件????????845??2016-11-13?14:24??Management?System\src\entity\Score.java

?????文件???????1727??2016-11-13?18:55??Management?System\src\entity\Student.java

?????文件????????432??2016-11-07?20:52??Management?System\src\entity\User.java

?????文件????????792??2016-11-12?16:19??Management?System\src\Exception\StudentExistException.java

?????文件???????2183??2016-11-13?19:01??Management?System\src\form\StudentForm.java

?????文件???????1178??2016-11-13?16:06??Management?System\src\form\UpdateScoreForm.java

?????文件???????1100??2016-11-13?18:16??Management?System\src\form\UpdateStudentForm.java

?????文件????????301??2016-11-07?19:56??Management?System\src\service\UserService.java

?????文件???????1897??2016-11-12?16:48??Management?System\src\servlet\AddServlet.java

?????文件???????1713??2016-11-25?08:16??Management?System\src\servlet\LoginServlet.java

?????文件????????944??2016-11-12?10:20??Management?System\src\servlet\RemoveServlet.java

?????文件???????1479??2016-11-24?09:01??Management?System\src\servlet\ScoreServlet.java

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