JDBC-最简单实现-如何将mysql数据库表中的数据查询出来并存入集合中
-
展示数据库emp的数据:
-
创建员工类Emp:
package ALL_JDBC.day0115;
/**
* 将emp表中的数据封装成一个类
* */
public class Emp {
//员工id
private int id;
//员工姓名
private String name;
//员工职位名称
private int jobId;
//员工的领导
private int mgr;
//员工加入的时间
private String joinDate;
//员工薪水
private double salary;
//员工奖金
private double bonus;
//员工的部门id
private int deptId;
public Emp() {
}
public Emp(int id, String name, int jobId, int mgr, String joinDate, double salary, double bonus, int deptId) {
this.id = id;
this.name = name;
this.jobId = jobId;
this.mgr = mgr;
this.joinDate = joinDate;
this.salary = salary;
this.bonus = bonus;
this.deptId = deptId;
}
//get/set方法
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName()