结构和效果
dao层
package dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import entity.Student;
import util.Utils;
public class StudentDao {
public List getStudentInfo() {
Connection conn = null;
PreparedStatement pst = null;
ResultSet rs = null;
List<Student> list = new ArrayList<Student>();//创建了一个空集合,集合的名称为list,此时list=[]
try {
conn = Utils.getConn();
String sql = "select * from student";
pst = conn.prepareStatement(sql);
rs = pst.executeQuery();
while (rs.next()) {
//随着循环次数增加,所有s对象会被add到list中
// 创建student对象 并且将数据set到student对象中
Student s = new Student();//第一次循环,创建一个s对象,给s对象赋值
s.setSage(rs.getInt("student_age"));
s.setSid(rs.getInt("student_id"));
s.setSsex(rs.getInt("student_sex"));
s.setSname(rs.