package cn.itcast.jdbc;

public class Stu2 {
    private int id;
    private String name;
    private int age;
    private String sex;
    private String address;
    private int math;
    private int english;

    public Stu2() {
    }

    public Stu2(int id, String name, int age, String sex, String address, int math, int english) {
        this.id = id;
        this.name = name;
        this.age = age;
        this.sex = sex;
        this.address = address;
        this.math = math;
        this.english = english;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public int getMath() {
        return math;
    }

    public void setMath(int math) {
        this.math = math;
    }

    public int getEnglish() {
        return english;
    }

    public void setEnglish(int english) {
        this.english = english;
    }

    @Override
    public String toString() {
        return "Stu2{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                ", sex='" + sex + '\'' +
                ", address='" + address + '\'' +
                ", math=" + math +
                ", english=" + english +
                '}';
    }
}

package cn.itcast.jdbc;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class JDBCDemo5 {
    //定义一个方法，查询stu2表里的数据，将其封装为对象，装载至集合里，返回
    public static void main(String[] args) {
        List<Stu2> result = findAll();
        System.out.println(result);
    }
    //定义方法
    public static List<Stu2> findAll(){
        Connection conn=null;
        Statement stmt=null;
        ResultSet rs=null;
        List<Stu2> array=new ArrayList<Stu2>();

        try {
            //注册驱动
            Class.forName("com.mysql.jdbc.Driver");
            //定义sql语句
            String sql="select * from stu2";
            //连接数据库，获取Connection
            conn = DriverManager.getConnection("jdbc:mysql:///db1", "root", "root");
            //获取sql对象
            stmt = conn.createStatement();
            //执行sql语句
            rs = stmt.executeQuery(sql);
            //获取表中数据
            //复用引用
            Stu2 stu2=null;
            while (rs.next()){
                int id = rs.getInt("id");
                String name= rs.getString("name");
                String sex = rs.getString("sex");
                String address= rs.getString("address");
                int math = rs.getInt("math");
                int english= rs.getInt("english");
                stu2 =new Stu2();
                stu2.setId(id);
                stu2.setName(name);
                stu2.setSex(sex);
                stu2.setAddress(address);
                stu2.setMath(math);
                stu2.setEnglish(english);
                array.add(stu2);
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            if (rs!=null){
                try {
                    rs.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (stmt!=null){
                try {
                    stmt.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (conn!=null){
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
        return array;
    }

}