向已经创建好的表添加和删除指定的列族或列。

import java.io.IOException;

import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.hbase.HBaseConfiguration;
import org.apache.hadoop.hbase.TableName;
import org.apache.hadoop.hbase.client.Admin;
import org.apache.hadoop.hbase.client.Connection;
import org.apache.hadoop.hbase.client.ConnectionFactory;
import org.apache.hadoop.hbase.client.Put;
import org.apache.hadoop.hbase.client.Table;


public class C_insertRows {
    public static Configuration configuration;
    public static Connection connection;
    public static Admin admin;
    
    /**
     * @param args
     * @throws IOException 
     */
    public static void main(String[] args) throws IOException {
        // TODO Auto-generated method stub
        insertRow("student", "2015001", "info", "S_name", "Zhangsan");
        insertRow("student", "2015001", "info", "S_sex", "male");
        insertRow("student", "2015001", "info", "S_age", "23");
        insertRow("student", "2015002", "info", "S_name", "Mary");
        insertRow("student", "2015002", "info", "S_sex", "female");
        insertRow("student", "2015002", "info", "S_age", "22");
        insertRow("student", "2015003", "info", "S_name", "Lisi");
        insertRow("student", "2015003", "info", "S_sex", "male");
        insertRow("student", "2015003", "info", "S_age", "20");
        insertRow("SC", "2015001_123001", "SC_score", "", "86");
        insertRow("SC", "2015001_123003", "SC_score", "", "69");
        insertRow("SC", "2015002_123002", "SC_score", "", "77");
        insertRow("SC", "2015002_123003", "SC_score", "", "99");
        insertRow("SC", "2015003_123001", "SC_score", "", "98");
        insertRow("SC", "2015003_123002", "SC_score", "", "95");
        insertRow("Course", "123001", "info", "C_Name", "Math");
        insertRow("Course", "123001", "info", "C_Credit", "2.0");
        insertRow("Course", "123002", "info", "C_Name", "Computer Science");
        insertRow("Course", "123002", "info", "C_Credit", "5.0");
        insertRow("Course", "123003", "info", "C_Name", "English");
        insertRow("Course", "123003", "info", "C_Credit", "3.0");
        B_getAllData show = new B_getAllData();
        show.getTableData("student");
    }
    //建立连接
    public static void init(){
        configuration  = HBaseConfiguration.create();
        configuration.set("hbase.rootdir","hdfs://localhost:9000/hbase");
        try{
            connection = ConnectionFactory.createConnection(configuration);
            admin = connection.getAdmin();
        }catch (IOException e){
            e.printStackTrace();
        }
    }
    //关闭连接
    public static void close(){
        try{
            if(admin != null){
                admin.close();
            }
            if(null != connection){
                connection.close();
            }
        }catch (IOException e){
            e.printStackTrace();
        }
    }

    //C_
    public static void insertRow(String tableName,String rowKey,String colFamily,String col,String val) throws IOException {
        init();
        Table table = connection.getTable(TableName.valueOf(tableName));
        Put put = new Put(rowKey.getBytes());
        put.addColumn(colFamily.getBytes(), col.getBytes(), val.getBytes());
        table.put(put);
        table.close();
        close();
    }
}

 

posted @ 2020-11-11 12:40  Miraculous_B  阅读(491)  评论(0编辑  收藏  举报