用容器存储表格数据用容器存储表格数据

了解ORM思想，为以后操作表数据提前打下基础
表格模板

文章图片

|---表格数据存储_map和list结合存储整张表
|------表格数据存储_Map和_List结合
|--------每一行数使用一个Map；整个表格使用一个List
ORM思想：对象关系映射

1 package boom.collection; 2 3 import java.util.ArrayList; 4 import java.util.Collections; 5 import java.util.HashMap; 6 import java.util.Iterator; 7 import java.util.List; 8 import java.util.Map; 9 import java.util.Set; 10 11 /** 12* 测试用容器表格数据的存储 13* @author Administrator 14* 15*/ 16 public class TestStoreData { 17 18public static void main(String[] args) { 19 20Map row1 = new HashMap<>(); 21 22row1.put("id", "1001"); 23row1.put("姓名", "张三"); 24row1.put("薪水", "20000"); 25row1.put("入职日期", "2018.9.6"); 26 27Map row2 = new HashMap<>(); 28row2.put("id", "1002"); 29row2.put("姓名", "李四"); 30row2.put("薪水", "5000"); 31row2.put("入职日期", "2019.5.9"); 32 33Map row3 = new HashMap<>(); 34row3.put("id", "1003"); 35row3.put("姓名", "王五"); 36row3.put("薪水", "30000"); 37row3.put("入职日期", "2010.8.3"); 38 39List table1 = new ArrayList<>(); 40table1.add(row1); 41table1.add(row2); 42table1.add(row3); 43for (Map row : table1) { 44Set keyset = row.keySet(); 45for (String key : keyset) { 46System.out.print(key + ":" + row.get(key) + "\t"); 47} 48System.out.println(); 49} 50} 51 52 }

文章图片

|----表格数据存储_javabean和list结合存储整张表
|------每一行数据使用一个：javabean对象；整个表格用一个Map / List
用户类：javabean

1 /** 2* 完整的javabean[setter和getter方法，无参构造器] 3 */ 4 class User{ 5private int id; 6private String name; 7private double salary; 8private String data; 9 10public User() { 11} 12 13public User(int id, String name, double salary, String data) { 14super(); 15this.id = id; 16this.name = name; 17this.salary = salary; 18this.data = https://www.it610.com/article/data; 19} 20 21public int getId() { 22return id; 23} 24 25public void setId(int id) { 26this.id = id; 27} 28 29public String getName() { 30return name; 31} 32 33public void setName(String name) { 34this.name = name; 35} 36 37public double getSalary() { 38return salary; 39} 40 41public void setSalary(double salary) { 42this.salary = salary; 43} 44 45public String getData() { 46return data; 47} 48 49public void setData(String data) { 50this.data = data; 51} 52@Override 53public String toString() { 54return"id:" + id + "name:" + name + "salary:" + salary + "data:" + data; 55} 56 }

测试类：

1 User user1 = new User(1001, "张三", 50000, "2018.2.5"); 2 User user2 = new User(1002, "李四", 18000, "2018.9.5"); 3 User user3 = new User(1003, "王五", 15000, "2018.5.5"); 4 5 List list = new ArrayList<>(); 6 list.add(user1); 7 list.add(user2); 8 list.add(user3); 9 10 for (User u : list) { 11System.out.println(u); 12 } 13 14 System.out.println("------------------------------------------------"); 15 16 Map map = new HashMap<>(); 17 map.put(1001, user1); 18 map.put(1002, user2); 19 map.put(1003, user3); 20 Set keyset = map.keySet(); 21 for (Integer key : keyset) { 22System.out.println(key + ":" + map.get(key)); 23 }

【用容器存储表格数据】效果图：