JDBC操作数据库05

前一篇写了数据库查询操作，但是每打印一行游标就要向下移，再次重复获取操作，所以可以尝试将表中所有的数据封装为对象，然后装载集合，返回

package Jdbc_base05;

import java.util.Date;

/**
 * @ClassName: UserEmp
 * @Description: TODO
 * @author: Doge_fang
 * @date: 2020/2/12  14:35
 *
 * 封装表数据的javabean
 */
public class SysUser {

    private int id;
    private String username;
    private int phonenumber;
    private Date createtime;

    public int getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public int getPhonenumber() {
        return phonenumber;
    }

    public void setPhonenumber(int phonenumber) {
        this.phonenumber = phonenumber;
    }

    public Date getCreatetime() {
        return createtime;
    }

    public void setCreatetime(Date createtime) {
        this.createtime = createtime;
    }

    @Override
    public String toString() {
        return "UserEmp{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", phonenumber=" + phonenumber +
                ", createtime=" + createtime +
                '}';
    }
}

package Jdbc_base05;

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

/**
 * @ClassName: JdbcBase
 * @Description: TODO
 * @author: Doge_fang
 * @date: 2020/2/12  14:46
 *
 * 定义一个方法，查询t_sys_user表的数据将其封装为集合,返回
 */
public class JdbcBase {
    public static void main(String[] args) {
        List<SysUser> list = new JdbcBase().quaryAll();
        System.out.println(list);
    }


    public List<SysUser> quaryAll() {
        Connection conn = null;
        Statement statement = null;
        ResultSet rs = null;
        List<SysUser> list = null;

        try {
            //获取连接资源
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/user_info", "root", "123456");
            //定义sql
            String sql = "select * from t_sys_user;";
            //获取执行sql对象
            statement = conn.createStatement();
            //执行sql
            rs = statement.executeQuery(sql);
            //遍历结果集，封装对象，装载集合
            //获取数据
            list = new ArrayList();
            while (rs.next()) {
                int id = rs.getInt("id");
                String username = rs.getString("username");
                int phonenumber = rs.getInt("phonenumber");
                Date createdate = rs.getDate("createtime");
                //创建t_sys_user对象并赋值
                SysUser SysUser = new SysUser();
                SysUser.setId(id);
                SysUser.setUsername(username);
                SysUser.setPhonenumber(phonenumber);
                SysUser.setCreatetime(createdate);

                //装载集合
                list.add(SysUser);
            }

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (statement != null) {
                try {
                    statement.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
        return list;
    }
}