JDBC--读取数据库数据，将其数据封装

主代码：

public class JdbcTest3 {

    public static void main(String[] args){
        List<emp> all = new JdbcTest3().findAll();
        System.out.println(all);
    }
    
    public List<emp> findAll() {
        Connection connection = null;
        Statement statement = null;
        List<emp> list=null;
        try {
            //1，导入驱动jar包
            //2，注册驱动
            Class.forName("com.mysql.jdbc.Driver");
            //4，定义sql语句
            String sql = "select * from bank_one";
            //3，获取数据库
            connection = DriverManager.getConnection("jdbc:mysql:///school", "root", "root");
            //5，获取执行sql的对象 Statement
            statement = connection.createStatement();
            //6，执行方法
            ResultSet rs = statement.executeQuery(sql);
            //7，处理结果

            emp e = null;
            list = new ArrayList<emp>();

            while (rs.next()) {
                String name = rs.getString("name");
                int account = rs.getInt("account");

                e = new emp();
                e.setName(name);
                e.setAccount(account);

                list.add(e);

            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {

            //8，释放资源
            if (statement != null) {
                try {
                    statement.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (connection != null) {
                try {
                    connection.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
        return list;
    }
}

将数据封装类：

public class emp {
    private String name;
    private int account;


    @Override
    public String toString() {
        return "emp{" +
                "name='" + name + '\'' +
                ", account=" + account +
                '}';
    }

    public String getName() {
        return name;
    }

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

    public int getAccount() {
        return account;
    }

    public void setAccount(int account) {
        this.account = account;
    }
}

思路：…创建类，私有属性对应数据库的属列。然后遍历数据库，将每次一行的数据用emp类封装好，然后装进list里面（思路很简单，避免忘记…)