5.14 表格数据存储

map和list结合存储整张表

1. 表格数据

id	姓名	薪水	入职日期
1001	张三	20000	2018.5.5
1002	李四	10000	2019.5.5
1003	王五	15000	2018.10.10

每一行数据使用一个：Map。
整个表格使用一个：List。

2. 代码

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;

/**
 * 测试表格数据的存储：map和list结合存储整张表
 * @author dxt
 *
 */
public class TestStoreTable {
	public static void main(String[] args){
		//声明map对象
		Map<String, Object> map1 = new HashMap<String, Object>();
		map1.put("id", 1001);
		map1.put("姓名", "张三");
		map1.put("薪水", 20000);
		map1.put("入职日期", "2018.5.5");
		
		Map<String, Object> map2 = new HashMap<String, Object>();
		map2.put("id", 1002);
		map2.put("姓名", "李四");
		map2.put("薪水", 10000);
		map2.put("入职日期", "2019.5.5");
		
		Map<String, Object> map3 = new HashMap<String, Object>();
		map3.put("id", 1003);
		map3.put("姓名", "王五");
		map3.put("薪水", 15000);
		map3.put("入职日期", "2018.10.10");
		
		//声明一个list存储表格
		List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
		list.add(map1);
		list.add(map2);
		list.add(map3);
		
		//打印整张表格
		for(Iterator<Map<String, Object>> iter = list.iterator(); iter.hasNext();){
			//System.out.println(iter.next());
			Map<String, Object> temp = iter.next();
			Set<String> keySet = temp.keySet();
			for(String key : keySet){
				System.out.print(key + temp.get(key) + "\t");
			}
			System.out.println();
		}
	}
}

结果

javabean和list结合存储整张表

1. 表格数据

id	姓名	薪水	入职日期
1001	张三	20000	2018.5.5
1002	李四	10000	2019.5.5
1003	王五	15000	2018.10.10

每一行数据使用一个：javabean对象。
整个表格使用一个：Map或List。

2. 代码

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

/**
 * 测试表格数据的存储:javabean和list结合存储整张表
 * @author dxt
 *
 */
public class TestStoreTable2 {
	public static void main(String[] args){
		User user1 = new User(1001, "张三", 20000, "2018.5.5");
		User user2 = new User(1002, "李四", 10000, "2019.5.5");
		User user3 = new User(1003, "王五", 15000, "2018.10.10");
		
		List<User> list = new ArrayList<User>();
		list.add(user1);
		list.add(user2);
		list.add(user3);
		for(Iterator<User> iter = list.iterator(); iter.hasNext();){
			User u = iter.next();
			System.out.println(u);
		}
	}
}
class User{
	private int id;
	private String name;
	private double salary;
	private String hiredate;
	
	public User(){}
	public User(int id, String name, double salary, String date){
		super();
		this.id = id;
		this.name = name;
		this.salary = salary;
		this.hiredate = date;
	}
	//javabean
	public int getId(){
		return this.id;
	}
	public void setId(int id){
		this.id = id;
	}
	public String getName(){
		return this.name;
	}
	public void setName(String name){
		this.name = name;
	}
	public double getSalary(){
		return this.salary;
	}
	public void setSalary(double salary){
		this.salary = salary;
	}
	public String getHiredate(){
		return this.hiredate;
	}
	public void setHiredate(String hiredate){
		this.hiredate = hiredate;
	}
	/*
	 * 重写toString()方法
	 */
	public String toString(){
		StringBuilder sb = new StringBuilder();
		sb.append("{ ");
		sb.append("id="+ id + ",\t");
		sb.append("name=" + name + ",\t");
		sb.append("salary=" + salary + ",\t");
		sb.append("hiredate=" + hiredate + " }");
		return sb.toString();
	}
}

结果