package?com.student;
//代表學生的實體類
import?javax.servlet.ServletContext;
import?java.sql.*;
import?java.util.ArrayList;
import?java.util.List;
public?class?DBUser?{
	private?ServletContext?application;
	//定義構造方法，加載驅動程序，接收全局應用對象
	public?DBUser（）{
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}catch?（Exception?e）?{
				e.printStackTrace（）;
		}
		
	}
	
	//添加getStudent（）方法取出所有學生數據，每個學生的數據放在Student類型的一個對象中，所有學生存放一個list類型的對象中
	public?List?getStudent（）{
		List?sStudent=new?ArrayList（）;
		Connection?con=null;
		
		
		try{

			String?url=“jdbc:mysql://localhost:3306/studenttb“;
	?		con=DriverManager.getConnection（url?“root““root“）;
	
			Statement?stmt=con.createStatement（）;
			ResultSet?result=stmt.executeQuery（“select?*?from?studenttb?order?by?（ssno+0）?ASC“）;
			while（result.next（））
			{
				Student?student=new?Student（）;
				student.setSsno（result.getString（“ssno“））;
				student.setSsname（result.getString（“ssname“））;
				student.setSssex（result.getString（“sssex“））;
				student.setSsage（result.getInt（“ssage“））;
				student.setSsmajor（result.getString（“ssmajor“））;
				student.setSsfav（result.getString（“ssfav“））;
				student.setSsaddress（result.getString（“ssaddress“））;
				sStudent.add（student）;
				
			}
		}catch?（SQLException?e）?{
				//?TODO:?handle?exception
				e.printStackTrace（）;
			}catch（Exception?e）{
				e.printStackTrace（）;
			}finally?{
				if（con!=null）{
					try?{
						con.close（）;
					}?catch?（SQLException?e）?{
						//?TODO?Auto-generated?catch?block
						e.printStackTrace（）;
					}	
				}	
			}
				
				return?sStudent;
		}
?//根據名字查詢信息
	public?List?getStudentByName（String?ssname）{
		List?sStudent=new?ArrayList（）;
		Connection?con=null;
		Student?student=null;
		
		try{

			String?url=“jdbc:mysql://localhost:3306/studenttb“;
	?		con=DriverManager.getConnection（url?“root““root“）;
	
			Statement?stmt=con.createStatement（）;
			String?sql;
			if（ssname==null||ssname.equals（““））
			{
				sql=“select?*?from?studenttb?order?by?（ssno+0）?ASC“;
			}
			else
			{
				sql=“select?*?from?studenttb?where?ssname?like‘%“+ssname+“%‘?order?by?（ssno+0）?ASC“;
			}
			ResultSet?result=stmt.executeQuery（sql）;
			while（result.next（））
			{
				student=new?Student（sql?sql?sql?0?sql?sql?sql）;
				student.setSsno（result.getString（“ssno“））;
				student.setSsname（result.getString（“ssname“））;
				student.setSssex（result.getString（“sssex“））;
				student.setSsage（result.getInt（“ssage“））;
				student.setSsmajor（result.getString（“ssmajor“））;
				student.setSsfav（result.getString（“ssfav“））;
				student.setSsaddress（result.getString（“ssaddress“））;
				sStudent.add（student）;
				
			}
		}catch?（SQLException?e）?{
				//?TODO:?handle?exception
				e.printStackTrace（）;
			}catch（Exception?e）{
				e.printStackTrace（）;
			}finally?{
				if（con!=

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-03-05?17:17??student_3\
?????文件?????????838??2017-02-10?23:56??student_3\.classpath
?????文件?????????909??2017-02-10?23:56??student_3\.project
?????目錄???????????0??2017-03-05?17:17??student_3\.settings\
?????文件?????????567??2017-02-10?23:56??student_3\.settings\.jsdtscope
?????文件?????????364??2017-02-10?23:56??student_3\.settings\org.eclipse.jdt.core.prefs
?????文件?????????479??2017-02-10?23:56??student_3\.settings\org.eclipse.wst.common.component
?????文件?????????349??2017-02-10?23:56??student_3\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-02-10?23:56??student_3\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-02-10?23:56??student_3\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-02-10?23:56??student_3\build\
?????目錄???????????0??2017-03-05?17:17??student_3\build\classes\
?????目錄???????????0??2017-03-05?17:13??student_3\build\classes\com\
?????目錄???????????0??2017-03-05?17:17??student_3\build\classes\com\student\
?????文件????????8194??2017-03-05?15:13??student_3\build\classes\com\student\DBUser.class
?????文件????????2002??2017-03-05?16:11??student_3\build\classes\com\student\SetCharacterEncodingFilter.class
?????文件????????2257??2017-03-05?15:13??student_3\build\classes\com\student\Student.class
?????文件????????1788??2017-03-05?15:13??student_3\build\classes\com\student\StudentDeleteAction.class
?????文件????????1765??2017-03-05?15:13??student_3\build\classes\com\student\StudentListAction.class
?????文件????????1844??2017-03-05?15:13??student_3\build\classes\com\student\StudentListByNameAction.class
?????文件????????2052??2017-03-05?16:07??student_3\build\classes\com\student\StudentSaveAction.class
?????文件????????1870??2017-03-05?15:53??student_3\build\classes\struts.xml
?????目錄???????????0??2017-03-05?17:17??student_3\src\
?????目錄???????????0??2017-03-05?17:13??student_3\src\com\
?????目錄???????????0??2017-03-05?17:17??student_3\src\com\student\
?????文件????????8551??2017-03-04?15:57??student_3\src\com\student\DBUser.java
?????文件????????1889??2017-02-11?00:22??student_3\src\com\student\SetCharacterEncodingFilter.java
?????文件????????1656??2017-03-05?15:11??student_3\src\com\student\Student.java
?????文件????????1007??2017-03-05?10:52??student_3\src\com\student\StudentDeleteAction.java
?????文件????????1452??2017-03-04?15:26??student_3\src\com\student\StudentListAction.java
?????文件????????1049??2017-03-04?15:55??student_3\src\com\student\StudentListByNameAction.java
............此處省略32個文件信息