/**
 * 查詢數(shù)據(jù)庫學(xué)生記錄
 */
 
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet; 
import java.sql.Date;
import java.util.Vector;
import java.util.HashMap;

public class QueryTableStore
{
	/**
	 * 從表中查詢出所有記錄
	 */
	public HashMap getStudent(Connection con)
	{
		Vector vector = new Vector();//儲存學(xué)生對象
		HashMap map = new HashMap();//儲存關(guān)鍵字/值對
		StudentStore store = new StudentStore();
		
		try
		{
			Statement st = con.createStatement();
			String sql = "select * from student";
			ResultSet rs = st.executeQuery(sql);
			
			while(rs.next())
			{
				String name =rs.getString("姓名");
				String number = rs.getString("學(xué)號");
				String sex = rs.getString("性別");
				Date date = rs.getDate("出生日期");
				String speciality = rs.getString("專業(yè)");
				String address = rs.getString("籍貫");
				
				Student one = new Student(name, number);
				one.setStudentSex(sex);
				one.setStudentSpeciality(speciality);
				one.setStudentAddress(address);
				one.setStudentBirthday(date.toString());
				
				vector.add(one);	
			}
			
			st.close();
			con.close();			
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		store.setStudentVec(vector);
		map.put("student", store);
		return map;		
	}	
}