JDBC学习（2）

一个小练习

        定义一个方法，查询student将其封装为对象，然后装载集合，返回。

                1.定义Student类

                2.定义方法 public List findAll(){}

                3.实现方法 select * from student;

        school数据库中的student表

id	name	age
0001	aaa	19
0002	bbb	20
0003	ccc	20
0004	ddd	21
0005	eee	20

        Student类

package cn.itcast.domain;
/**
* 封装student表里数据的JavaBean
 */
public class Student
{
    private String id;
    private String name;
    private int age;

    //getter、setter
    public String getId() { return id; }
    public void setId(String 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; }

    //toString
    @Override
    public String toString() {
        return "Student{" +
                "id='" + id + '\'' +
                ", name='" + name + '\'' +
                ", age=" + age +
                '}';
    }
}

其中getter、setter、toString可以用快捷键Alt+Insert（如果Insert在F12上就Alt+Fn+F12）完成

        jdbcDemo03类

package cn.itcast.jdbc;

import cn.itcast.domain.Student;

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

/**
*   定义一个方法，查询student表的数据将其封装为对象
 *  然后装载集合，返回
 */
public class jdbcDemo03
{
    public static void main(String[] args)
    {
        List<Student> list = new jdbcDemo03().findAll();
        System.out.println(list);
        System.out.println(list.size());
    }
    /**
     * 查询所有student对象
     */
    public List<Student> findAll()
    {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        List<Student> list = null;

        try {
            //1.注册驱动
            Class.forName("com.mysql.cj.jdbc.Driver");
            //2.获取连接
            conn = DriverManager.getConnection("jdbc:mysql:///school?serverTimezone=UTC", "root", "123456");
            //3.定义sql
            String sql = "select * from student";
            //4.获取执行sql的对象
            stmt = conn.createStatement();
            //5.执行sql
            rs = stmt.executeQuery(sql);
            //6.遍历结果集，封装对象，装载集合
            Student stu = null;
            list = new ArrayList<Student>();
            while(rs.next())
            {
                //获取数据
                String id = rs.getString("id");
                String name = rs.getString("name");
                int age = rs.getInt("age");

                //封装对象
                stu = new Student();
                stu.setId(id);
                stu.setName(name);
                stu.setAge(age);

                //装载集合
                list.add(stu);
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            //7.释放资源：后申请要先释放
            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 list;
    }
}