questiondao.java

来自「这个是jsp编写的考试系统代码」· Java 代码 · 共 31 行

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;
	}
	
}