www.pudn.com > exam.rar > QuestionDAO.java

package kaoshi.tool; 
 
import java.util.Vector; 
import java.sql.*; 
 
public class QuestionDAO{ 
	Connection con; 
	String studentvector="select * from student"; 
	 
	public Vector getStudentVector(){ 
		Vector sv=new Vector(); 
		try{ 
			con=DatabaseConnection.getConnection(); 
			Statement stmt=con.createStatement(); 
			ResultSet rs=stmt.executeQuery(studentvector); 
			while(rs.next()){ 
				StudentBean sb=new StudentBean(); 
				sb.setName(rs.getString("name")); 
				sb.setSex(rs.getString("sex")); 
				sb.setAge(rs.getInt("age")); 
				sb.setPhone(rs.getString("phone")); 
				System.out.println(sb.getName()); 
				sv.add(sb); 
			} 
			 
			con.close(); 
		}catch(Exception ex){System.out.println(ex);} 
		return sv; 
	} 
	 
}