package?biz;
import?dao.*;
import?entity.*;
import?java.util.*;

public?class?stuBiz?{
	/**
	?*?修改學員信息方法
	?*?@param?stu
	?*?@return
	?*/
	public?static?int?modifyStu（Student?stu）{
		String?sql=“update?stu?set?name=?enrolTime=??where?ID=?“;
		object[]?params=new?object[]{stu.getName（）stu.getEnrolTime（）stu.getID（）};
		return?stuDao.updateStu（sql?params）;
	}
	/**
	?*?添加學員信息方法
	?*?@param?stu
	?*?@return
	?*/
	public?static?int?insertStu（Student?stu）{
		String?sql=“insert?into?stu?values（??）“;
		object[]?params=new?object[]{stu.getName（）stu.getEnrolTime（）};
		return?stuDao.updateStu（sql?params）;
	}
	/**
	?*?根據學員Id刪除學員信息方法
	?*?@param?stuId
	?*?@return
	?*/
	public?static?int?deleteStu（int?stuId）{
		String?sql=“delete?stu?where?ID=?“;
		object[]?params=new?object[]{stuId};
		return?stuDao.updateStu（sql?params）;
	}
	/**
	?*?獲取所有學員信息
	?*?@param?stuId
	?*?@return
	?*/
	public?static?List?selectStudent（）{
		String?sql=“select?*?from?stu“;
		object[]?params=new?object[]{};
		return?stuDao.selectStu（sql?params）;
	}
	/**
	?*?通過學員Id獲取學員信息
	?*?@param?stuId
	?*?@return
	?*/
	public?static?Student?findStudent（int?stuId）{
		Student?stu=null;
		String?sql=“select?*?from?stu?where?ID=?“;
		object[]?params=new?object[]{stuId};		
		List?stus=?stuDao.selectStu（sql?params）;
		if（stus.size（）>0）
			stu=stus.get（0）;
		return?stu;
	}
}

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

?????文件????????433??2008-07-28?10:34??jsp實現對數據庫的增刪改查（-）\student\.classpath

?????文件????????294??2009-08-15?09:40??jsp實現對數據庫的增刪改查（-）\student\.mymetadata

?????文件???????1225??2008-07-28?11:08??jsp實現對數據庫的增刪改查（-）\student\.project

?????文件???????1980??2008-07-28?16:14??jsp實現對數據庫的增刪改查（-）\student\WebRoot\addAndUpdate.jsp

?????文件???????1654??2008-07-28?16:09??jsp實現對數據庫的增刪改查（-）\student\WebRoot\index.jsp

?????文件???????1000??2008-07-28?16:23??jsp實現對數據庫的增刪改查（-）\student\WebRoot\stuManager.jsp

?????文件????????375??2008-07-28?08:46??jsp實現對數據庫的增刪改查（-）\student\WebRoot\WEB-INF\web.xml

?????文件???????1828??2008-07-28?11:24??jsp實現對數據庫的增刪改查（-）\student\WebRoot\WEB-INF\classes\test\stuTest.class

?????文件???????1109??2008-07-28?12:28??jsp實現對數據庫的增刪改查（-）\student\WebRoot\WEB-INF\classes\entity\Student.class

?????文件???????3457??2008-07-28?10:34??jsp實現對數據庫的增刪改查（-）\student\WebRoot\WEB-INF\classes\dao\stuDao.class

?????文件???????1898??2008-07-28?11:03??jsp實現對數據庫的增刪改查（-）\student\WebRoot\WEB-INF\classes\biz\stuBiz.class

?????文件?????????39??2008-07-28?08:46??jsp實現對數據庫的增刪改查（-）\student\WebRoot\meta-INF\MANIFEST.MF

?????文件????????837??2008-07-28?11:24??jsp實現對數據庫的增刪改查（-）\student\src\test\stuTest.java

?????文件????????802??2008-07-28?12:28??jsp實現對數據庫的增刪改查（-）\student\src\entity\Student.java

?????文件???????2513??2008-07-28?10:33??jsp實現對數據庫的增刪改查（-）\student\src\dao\stuDao.java

?????文件???????1465??2008-07-28?11:03??jsp實現對數據庫的增刪改查（-）\student\src\biz\stuBiz.java

?????文件????????629??2008-07-28?09:52??jsp實現對數據庫的增刪改查（-）\student\.settings\org.eclipse.jdt.core.prefs

?????文件?????????99??2008-07-28?09:52??jsp實現對數據庫的增刪改查（-）\student\.settings\org.eclipse.jdt.ui.prefs

?????文件????3145728??2008-07-28?16:28??jsp實現對數據庫的增刪改查（-）\stuDB\stuDB_data.mdf

?????文件????1048576??2008-07-28?16:28??jsp實現對數據庫的增刪改查（-）\stuDB\stuDB_log.ldf

?????文件????????930??2008-07-28?16:27??jsp實現對數據庫的增刪改查（-）\stuDB\student.sql

?????目錄??????????0??2009-08-15?09:32??jsp實現對數據庫的增刪改查（-）\student\WebRoot\WEB-INF\classes\test

?????目錄??????????0??2009-08-15?09:32??jsp實現對數據庫的增刪改查（-）\student\WebRoot\WEB-INF\classes\entity

?????目錄??????????0??2009-08-15?09:32??jsp實現對數據庫的增刪改查（-）\student\WebRoot\WEB-INF\classes\dao

?????目錄??????????0??2009-08-15?09:32??jsp實現對數據庫的增刪改查（-）\student\WebRoot\WEB-INF\classes\biz

?????目錄??????????0??2009-08-15?09:32??jsp實現對數據庫的增刪改查（-）\student\WebRoot\WEB-INF\lib

?????目錄??????????0??2009-08-15?09:32??jsp實現對數據庫的增刪改查（-）\student\WebRoot\WEB-INF\classes

?????目錄??????????0??2009-08-15?09:32??jsp實現對數據庫的增刪改查（-）\student\WebRoot\WEB-INF

?????目錄??????????0??2009-08-15?09:32??jsp實現對數據庫的增刪改查（-）\student\WebRoot\meta-INF

?????目錄??????????0??2009-08-15?09:32??jsp實現對數據庫的增刪改查（-）\student\src\test

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