JDBC 查询一个表的数据将其封装为对象，然后打印

JDBC查询admin表

对象类

package cn.abc.test;

//封装数据的javabean
public class FindAll {
    private int id;
    private String name;
    private int salary;

    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 getSalary() {
        return salary;
    }

    public void setSalary(int salary) {
        this.salary = salary;
    }

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

main类

package cn.abc.jdbc;

import cn.abc.test.FindAll;

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

public class JdbcDemo4 {


    public static void main(String[] args) {
        List<FindAll> list = new JdbcDemo4().find();
        for (FindAll f:list) {
            System.out.println(f);
        }
    }

    //查询所有admin表对象
    public List<FindAll> find(){
        Connection conn=null;
        Statement statm=null;
        ResultSet rs=null;
        List<FindAll> rsfa = new ArrayList<FindAll>();
        
        try {
        //jdbc连接
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql:///test", "root", "123456");
            statm = conn.createStatement();
            String sql = "select * from admin";
            rs = statm.executeQuery(sql);
			
            rsfa = new ArrayList<FindAll>();
            //取数据
            while(rs.next()){
                int id = rs.getInt("id");
                String name = rs.getString("name");
                int salary = rs.getInt("salary");

                FindAll fa = new FindAll();
                fa.setId(id);
                fa.setName(name);
                fa.setSalary(salary);

                rsfa.add(fa);
            }

        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }finally {
        	//避免空指针异常
            if (rs!=null){
                try {
                    rs.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (conn!=null){
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (statm!=null){
                try {
                    statm.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
        return rsfa;
    }
}