querytablestore.java

编程之道--java程序设计入门源代码

/**
 * 查询数据库学生记录
 */
 
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();//储存学生对象
		HashMap map = new HashMap();//储存关键字/值对
		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("学号");
				String sex = rs.getString("性别");
				Date date = rs.getDate("出生日期");
				String speciality = rs.getString("专业");
				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;		
	}	
}