Hbase实操练习——课程表

一、任务要求

        这是课程表。

        表中，id为学号，group number为组号，groupleader为组长，tel为电话（虚拟值） Mon中的ABCDE分别指周一的五堂课，A是上午第一堂课，B是上午第二堂课，CD分别是下午的两堂课，E是晚上的课。 比如，表中ZhangSan周一晚上有一门课是“rgzndl”（课程缩写） 请每个组将每个组员的信息和本周课表填在这个表里，注意保留张三的信息。（tel填一个虚假的，不要真实的） 以下内容使用java编程完成，将java代码和运行结果截图并写入doc文档里，上传到学习通分组活动。

        任务1：请将此表蓝色部分上传到hbase里，注意包含张三的信息。（比如：id是行键，info和Mon等等是列族，name和A等等是列，使用其他方式也可）

        任务2：请将此表黄色部分上传追加到hbase同一张表中（在原来的表上添加‘Sun’列族）

         任务3：请将ZhangSan的整行删除

        任务4：请展示某位同学的所有课表

         任务5：请展示某一天的所有课表

二、任务展示结果展示

填充表后，以此表编写代码

 

任务一：请将此表蓝色部分上传到hbase里，注意包含张三的信息。（比如：id是行键，info和Mon等等是列族，name和A等等是列，使用其他方式也可）

import org.apache.hadoop.conf.Configuration;

import org.apache.hadoop.hbase.*;

import org.apache.hadoop.hbase.client.*;

import org.apache.hadoop.hbase.util.Bytes;

import java.io.IOException;

public class Team {

    public static Configuration configuration;

    public static Connection connection;

    public static Admin admin;

    public static void main(String[] args)throws IOException{

        init();

         createTable("team",new String[] {"info","Mon","Tue","Wed","Thur","Fri"});

         insertData("team","20191209011999","info","name","ZhangSan");

         insertData("team","20201204012045","info","name","MengXiangru");

         insertData("team","20201204012006","info","name","DuanShanshan");

         insertData("team","20201204012020","info","name","LiangShan");

         insertData("team","20201204012033","info","name","HouCaiyue");

         insertData("team","20201204012011","info","name","YangXinyu");

         insertData("team","20201204012044","info","name","XiangRui");

         insertData("team","20191209011999","info","Groupnumber","0");

         insertData("team","20201204012045","info","Groupnumber","1");

         insertData("team","20201204012006","info","Groupnumber","1");

         insertData("team","20201204012020","info","Groupnumber","1");

         insertData("team","20201204012033","info","Groupnumber","1");

         insertData("team","20201204012011","info","Groupnumber","1");

         insertData("team","20201204012044","info","Groupnumber","1");

         insertData("team","20201204012045","info","Groupleader","MengXiangRu");

         insertData("team","20191209011999","info","Groupleader","ZhangSan");

         

         insertData("team","20191209011999","info","sex","male");

         insertData("team","20201204012045","info","sex","famale");

         insertData("team","20201204012006","info","sex","famale");

         insertData("team","20201204012020","info","sex","famale");

         insertData("team","20201204012033","info","sex","famale");

         insertData("team","20201204012011","info","sex","famale");

         insertData("team","20201204012044","info","sex","famale");

         insertData("team","20191209011999","info","tel","18888888888");

         insertData("team","20201204012045","info","tel","18888888889");

         insertData("team","20201204012006","info","tel","18888888890");

         insertData("team","20201204012020","info","tel","18888888891");

         insertData("team","20201204012033","info","tel","18888888892");

         insertData("team","20201204012011","info","tel","18888888893");

         insertData("team","20201204012044","info","tel","18888888894");

         

         insertData("team","20191209011999","Mon","E","rgzndl");

         insertData("team","20201204012045","Mon","A","yd");

         insertData("team","20201204012006","Mon","A","yd");

         insertData("team","20201204012020","Mon","A","yd");

         insertData("team","20201204012033","Mon","A","yd");

         insertData("team","20201204012011","Mon","A","yd");

         insertData("team","20201204012044","Mon","A","yd");

         insertData("team","20201204012045","Mon","B","jsjwl");

         insertData("team","20201204012006","Mon","B","jsjwl");

         insertData("team","20201204012020","Mon","B","jsjwl");

         insertData("team","20201204012033","Mon","B","jsjwl");

         insertData("team","20201204012011","Mon","B","jsjwl");

         insertData("team","20201204012044","Mon","B","jsjwl");

         insertData("team","20191209011999","Tue","A","zyfzyjycjzd");

         insertData("team","20201204012045","Tue","A","yd");

         insertData("team","20201204012006","Tue","A","yd");

         insertData("team","20201204