Day4-JDBC封装的小试牛刀

package cn.jdbc.one;

public class Emp {

    private int id;
    private String name;
    private int many;

    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 getMany() {
        return many;
    }

    public void setMany(int many) {
        this.many = many;
    }

    @Override
    public String toString() {
        return "Emp{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", many=" + many +
                '}';
    }
}

```java
package cn.jdbc.one;

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

public class JDBCdemo4 {

    public static void main(String[] args) {
        List<Emp> all = new JDBCdemo4().findAll();
        System.out.println(all);
    }


    /**
     * 查询所有Emp对象
     * @return
     */

    public List<Emp> findAll(){

        ResultSet res =null;
        Statement stat =null;
        Connection conn=null;
        Emp emp =new Emp();
        List<Emp> list =null;
        try {
            //1.注册驱动
            Class.forName("com.mysql.jdbc.Driver");
            //2.获取连接
            conn = DriverManager.getConnection("jdbc:mysql:///db", "root", "00056198");
            //3.定义SQL语句
            String sql = "select *from test0";
            //4.获取执行sql对象
            stat = conn.createStatement();
            //5.执行sql语句
            res = stat.executeQuery(sql);
            //6.遍历，封装
            list =new ArrayList<Emp>();

            while (res.next()){
                int id = res.getInt("id");
                String name = res.getString("name");
                int many = res.getInt("many");
                //
                emp =new Emp();
                emp.setId(id);
                emp.setMany(many);
                emp.setName(name);

                list.add(emp);
            }

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            if (res!=null){
                try {
                    res.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (stat!=null){
                try {
                    stat.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (conn!=null){
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }

        }
        return list;
    }



}