ORM思想:对象关系映射
第一种
每一行数据使用一个Map来存储
整个表格使用一个List
public static void main(String[] args) {
Map<String,Object> row1 = new HashMap<>();
row1.put("id", 1002);
row1.put("姓名", "张三");
row1.put("薪水", 30000);
row1.put("入职日期", "2005.4.4");
Map<String,Object> row2 = new HashMap<>();
row2.put("id", 1003);
row2.put("姓名", "李四");
row2.put("薪水", 20000);
row2.put("入职日期", "2055.3.14");
Map<String,Object> row3 = new HashMap<>();
row3.put("id", 1003);
row3.put("姓名", "王五");
row3.put("薪水", 3000);
row3.put("入职日期", "2405.2.1");
List<Map<String,Object>> table1=new ArrayList<>();
table1.add(row1);
table1.add(row2);
table1.add(row3);
//遍历表格
for(Map<String,Object> row:table1) {
Set<String> keyset = row.keySet();
for(String key:keyset) {
System.out.print(key+":"+row.get(key)+"\t");
}
System.out.println();
}
}
与操作数据库的思路是一样的,操作jdbc
第二种
每一行数据使用一个:javabean对象
整个表格使用一个Map/List
public class TestStoreData2 {
public static void main(String[] args) {
User user1 = new User(1001,"张三",30000,"2018.5.5");
User user2 = new User(1002,"李四",20200,"2004.3.2");
User user3 = new User(1003,"王五",40230,"2030.4.26");
List<User> list = new ArrayList<>();
list.add(user1);
list.add(user2);
list.add(user3);
for(User u:list) {
System.out.println(u);
}
}
}
class User{
private int id;
private String name;
private double salary;
private String hiredate;
//一个完整的javabeen,要有set和get方法,以及无参构造器
public User() {
}
@Override
public String toString() {
return "id=" + id + ", name=" + name + ", salary=" + salary + ", hiredate=" + hiredate;
}
public User(int id, String name, double salary, String hiredate) {
super();
this.id = id;
this.name = name;
this.salary = salary;
this.hiredate = hiredate;
}
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 double getSalary() {
return salary;
}
public void setSalary(double salary) {
this.salary = salary;
}
public String getHiredate() {
return hiredate;
}
public void setHiredate(String hiredate) {
this.hiredate = hiredate;
}
}