一、RDBMS
1.Maven工程添加依赖
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
2.配置properties文件
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://192.168.72.130:3306/mysqltest?useUnicode=true&characterEncoding=utf8&useSSL=true
username=root
password=javakb10
3.BaseConfig类
package cn.kb10.jdbc2;
import java.io.FileReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
class BaseConfig {
private class Config{
String driver;
String url;
String username;
String password;
public Config(String driver, String url, String username, String password) {
this.driver = driver;
this.url = url;
this.username = username;
this.password = password;
}
}
private Config config;
{
try {
init();
Class.forName(config.driver);
} catch (Exception e) {
System.err.println(e.getMessage());
}
}
private void init() throws Exception {
String path = Thread.currentThread().getContextClassLoader().getResource("datasource.properties").getPath();
Properties pro = new Properties();
pro.load(new FileReader(path));
String url = pro.getProperty("url");
if (null==url){
throw new Exception("缺少url配置项异常");
}
String driver = pro.getProperty("driver","com.mysql.jdbc.Driver");
String username = pro.getProperty("username","root");
String password = pro.getProperty("password","root");
this.config = new Config(driver,url,username,password);
}
protected Connection getCon() throws SQLException {
return DriverManager.getConnection(config.url,config.username,config.password);
}
protected void close(AutoCloseable...acs){
for (AutoCloseable ac : acs) {
if (null!=ac){
try {
ac.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
}
4.BaseDao类
package cn.kb10.jdbc2;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public final class BaseDao extends BaseConfig{
private PreparedStatement getPst(Connection con,String sql, Object...params) throws SQLException {
PreparedStatement pst = con.prepareStatement(sql);
if (params.length>0){
for (int i = 0; i < params.length; i++) {
pst.setObject(i+1,params[i]);
}
}
return pst;
}
public Result exeNonQuery(String sql,Object...params){
Connection con = null;
PreparedStatement pst = null;
try {
con = getCon();
pst = getPst(con,sql,params);
return Result.succeed(pst.executeUpdate());
} catch (SQLException e) {
return Result.fail();
}finally {
close(pst,con);
}
}
public Result exeQuery(String sql,Object...params){
Connection con =null;
PreparedStatement pst = null;
ResultSet rst = null;
try {
con = getCon();
pst = getPst(con,sql,params);
rst = pst.executeQuery();
List<List<String>> data = new ArrayList<>();
if (null!=rst&&rst.next()){
final int CC = rst.getMetaData().getColumnCount();
do{
List<String> row = new ArrayList<>(CC);
for (int i = 1; i <=CC ; i++) {
row.add(rst.getObject(i).toString());
}
data.add(row);
}while (rst.next());
}
return Result.succeed(data);
}catch (Exception e){
return Result.fail();
}finally {
close(rst,pst,con);
}
}
}
5.Result类
package cn.kb10.jdbc2;
public final class Result<T> {
private boolean err;
private T data;
//方法级泛型
public static <T> Result succeed(T data){
return new Result(false,data);
}
public static Result fail(){
return new Result(true,null);
}
private Result(boolean err, T data) {
this.err = err;
this.data = data;
}
public boolean isErr() {
return err;
}
public T getData() {
return data;
}
}
6.Test类
package cn.kb10.jdbc2;
import java.sql.Types;
import java.util.Arrays;
import java.util.List;
import java.util.Map;
public class Test {
public static void main(String[] args) {
BaseDao dao = new BaseDao();
Result<List<List<String>>> result = dao.exeQuery("select * from student");
if (!result.isErr()) {
List<List<String>> data = result.getData();
for (List<String> row : data) {
for (String col : row) {
System.out.print(col+"\t");
}
System.out.println();
}
}else{
System.out.println("查询异常");
}
}
}
二、Hive
1.Maven工程添加依赖
<dependency>
<groupId>org.apache.hive</groupId>
<artifactId>hive-jdbc</artifactId>
<version>${hive.version}</version>
</dependency>
<dependency>
<groupId>org.apache.hadoop</groupId>
<artifactId>hadoop-auth</artifactId>
<version>${hadoop.version}</version>
<exclusions>
<exclusion>
<artifactId>jdk.tools</artifactId>
<groupId>jdk.tools</groupId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.apache.hadoop</groupId>
<artifactId>hadoop-common</artifactId>
<version>${hadoop.version}</version>
<exclusions>
<exclusion>
<artifactId>jdk.tools</artifactId>
<groupId>jdk.tools</groupId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.apache.hadoop</groupId>
<artifactId>hadoop-hdfs</artifactId>
<version>${hadoop.version}</version>
<exclusions>
<exclusion>
<artifactId>jdk.tools</artifactId>
<groupId>jdk.tools</groupId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.apache.hadoop</groupId>
<artifactId>hadoop-client</artifactId>
<version>${hadoop.version}</version>
<exclusions>
<exclusion>
<artifactId>jdk.tools</artifactId>
<groupId>jdk.tools</groupId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.apache.hadoop</groupId>
<artifactId>hadoop-mapreduce-client-core</artifactId>
<version>${hadoop.version}</version>
</dependency>
2.配置properties文件
- datasource.properties
driver=org.apache.hive.jdbc.HiveDriver url=jdbc:hive2://192.168.72.130:10000/default username=root
- log4j.properties
log4j.rootLogger=INFO, stdout log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n log4j.appender.logfile=org.apache.log4j.FileAppender log4j.appender.logfile.File=target/hadoop.log log4j.appender.logfile.layout=org.apache.log4j.PatternLayout log4j.appender.logfile.layout.ConversionPattern=%d %p [%c] - %m%n
3.BaseConfig类
package cn.kgc.hive.jdbc.hdbc; import java.io.FileReader; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.util.Properties; import java.util.regex.Matcher; import java.util.regex.Pattern; public class BaseConfig { private class Config{ private String driver; private String url; private String username; private String password; } private Config config; private boolean valid(String url){ Pattern p = Pattern.compile("jdbc:\\w+://((\\d{1,3}\\.){3}\\d{1,3}|\\w+):\\d{1,5}/\\w+"); Matcher m = p.matcher(url); return m.matches(); } private void init() throws Exception { String path = Thread.currentThread().getContextClassLoader().getResource("datasource.properties").getPath(); Properties pro = new Properties(); pro.load(new FileReader(path)); String url = pro.getProperty("url"); if (null == url || !valid(url)) { throw new Exception("no or invalid url exception"); } config = new Config(); config.url = url; config.driver = pro.getProperty("driver","com.mysql.jdbc.Driver"); config.username = pro.getProperty("username","root"); config.password = pro.getProperty("password",""); } { try { init(); Class.forName(config.driver); } catch (Exception e) { e.printStackTrace(); } } Connection getCon() throws SQLException { return DriverManager.getConnection( config.url, config.username, config.password ); } void close(AutoCloseable...closeables){ for (AutoCloseable closeable : closeables) { if (closeable != null) { try { closeable.close(); } catch (Exception e) { e.printStackTrace(); } } } } }
4.BaseDao类
package cn.kgc.hive.jdbc.hdbc; import java.io.BufferedReader; import java.io.FileReader; import java.io.IOException; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; public class BaseDao extends BaseConfig { private PreparedStatement getPst(Connection con,String sql,Object...params) throws SQLException { PreparedStatement pst = con.prepareStatement(sql); if (params.length>0) { for (int i = 0; i < params.length; i++) { pst.setObject(i+1,params[i]); } } return pst; } public Result exeNonQuery(String sql,Object...params){ Connection con = null; PreparedStatement pst = null; try { con = getCon(); pst = getPst(con,sql,params); pst.execute(); return Result.succeed(); } catch (SQLException e) { e.printStackTrace(); return Result.fail(); }finally { close(pst,con); } } public Result exeQuery(String sql,Object...params){ Connection con = null; PreparedStatement pst = null; ResultSet rst = null; try { con = getCon(); pst = getPst(con,sql,params); rst = pst.executeQuery(); List<List<String>> table = null; if (null != rst && rst.next()) { table = new ArrayList<>(); final int COL = rst.getMetaData().getColumnCount(); do { List<String> row = new ArrayList<>(COL); for (int i = 1; i <= COL; i++) { row.add(rst.getObject(i).toString()); } table.add(row); }while (rst.next()); } return Result.succeed(table); } catch (SQLException e) { e.printStackTrace(); return Result.fail(); }finally { close(rst,pst,con); } } public String readSql(String...paths) throws IOException { String path = paths.length==0 ? "sql/sql.sql" : paths[0]; StringBuilder builder = new StringBuilder(); BufferedReader reader = new BufferedReader(new FileReader(path)); String line = null; while (null != (line = reader.readLine())) { builder.append(line.trim()+" "); } return builder.toString(); } }
5.Result类
package cn.kgc.hive.jdbc.hdbc; public abstract class Result<T> { private boolean err; private T data; public Result(boolean err,T...data){ this.err = err; this.data = data.length>0 ? data[0] : null; } public static Result fail(){ return new Result(true) {}; } public static <T> Result succeed(T...t){ return new Result(false,t) {}; } public boolean isErr() { return err; } public T getData() { return data; } }
6.App类
import java.io.IOException; import java.util.List; public class App { public static void main( String[] args ) throws IOException{ BaseDao dao = new BaseDao(); Result<List<List<String>>> tables = dao.exeQuery(dao.readSql()); tables.getData().forEach(row->{ row.forEach(cell->{ System.out.print(cell+"\t"); }); System.out.println(); }); } }
7.Sql语句文件
with score as( select stuname,classname,subname,score, last_value(subname) over(distribute by stuname sort by score rows between unbounded preceding and unbounded following) subname2, max(score) over(distribute by stuname sort by score rows between unbounded preceding and unbounded following) maxscore, row_number() over(distribute by stuname sort by score rows between unbounded preceding and unbounded following) rownum from mysql_school ), diff as( select stuname, classname, subname subname1, score minScore, subname2, maxscore, (maxscore-score) diff from score where rownum=1 ), level as( select stuname,classname,subname1,minscore,subname2,maxscore,diff, case when diff>=30 then 'A' when diff>=20 then 'B' when diff>=10 then 'C' else 'D' end rank from diff ) select stuname,classname,subname1,minscore,subname2,maxscore,diff,rank from level where rank like '%A%' or rank like '%B%'
8.查询结果
丁聪 KB08 KB JavaOOP 60 KB MySql 100 40 A 丰笛 KW06 EasyUI 46 KW JQuery 90 44 A 何健 KB07 KB HTML 48 KB CSS 100 52 A 余杰 KW05 KW HTML 48 ElementUI 88 40 A 关敬元 KB05 Scala 49 Hive 100 51 A 凌宇翔 KB07 KB JSP 53 KB MySql 92 39 A 刘用兵 KB08 KB HTML 56 KB Java逻辑 100 44 A 刘青青 KW06 KW JS 53 KW JQuery 94 41 A 吴凡 KW05 KW JS 59 KW HTML 94 35 A 吴凯 KW06 KW CSS+BootStrap 48 EasyUI 75 27 B 吴彦祥 KW05 KW CSS+BootStrap 47 ElementUI 96 49 A 吴志远 KW05 KW JS 62 KW JQuery 96 34 A 吴悠 KB05 KB JavaOOP 46 HBase 100 54 A 吴涛 KW03 KB JDBC 48 KB JQuery 97 49 A 吴衍文 KB07 KB JS 48 KB JQuery 96 48 A 周炜 KW06 KW JS 45 KW JQuery 84 39 A 周璟 KW06 KW CSS+BootStrap 57 KW JQuery 100 43 A 周继伟 KW03 KB MySql 51 KB JavaOOP 94 43 A 唐宇飞 KB08 KB Java逻辑 51 KB JQuery 80 29 B 唐明汉 KB07 KB MySql 47 KB CSS 96 49 A 姚成耀 KW05 KW CSS+BootStrap 52 ElementUI 100 48 A 孙亚洲 KB05 KB JDBC 45 KB MySql 100 55 A 孟涛涛 KW06 EasyUI 48 KW JS 96 48 A 庄俊伟 KB07 KB JavaOOP 50 KB Java逻辑 100 50 A 应春雨 KW05 KW CSS+BootStrap 52 EasyUI 88 36 A 张全根 KB05 KB MySql 50 Hive 100 50 A 张刘留 KW06 KW CSS+BootStrap 54 KW JQuery 96 42 A 张啸尘 KB07 KB Java高级特性 51 KB JDBC 100 49 A 张小港 KW06 EasyUI 45 KW HTML 92 47 A 张志强 KW05 KW JS 49 KW JQuery 93 44 A 张梓尧 KW05 KW CSS+BootStrap 60 EasyUI 100 40 A 张琪 KB07 KB CSS 49 KB MySql 100 51 A 张超 KW05 ElementUI 52 KW CSS+BootStrap 93 41 A 徐凯强 KW05 KW HTML 45 KW CSS+BootStrap 87 42 A 徐磊 KW03 KB HTML 46 KB JS 100 54 A 戴媛媛 KB05 KB CSS 46 KB MySql 97 51 A 戴彬 KB07 KB JS 61 KB MySql 97 36 A 李佛光 KB05 KB JQuery 45 KB Spring 100 55 A 李刚 KW05 KW JS 45 KW CSS+BootStrap 99 54 A 李国旗 KB05 Spark+SparkStreaming 45 Hadoop+MapReduce 91 46 A 李志杰 KW06 KW CSS+BootStrap 61 KW JS 99 38 A 李楚鸿 KB08 KB JQuery 48 KB JavaOOP 99 51 A 殷狄 KB07 KB JavaOOP 45 KB JDBC 92 47 A 江文涛 KB08 KB JavaOOP 54 KB HTML 97 43 A 江玉 KB05 KB Java高级特性 46 KB MySql 100 54 A 汤伟杰 KB05 KB JavaOOP 45 KB HTML 100 55 A 汪小天 KW06 KW JS 58 KW CSS+BootStrap 84 26 B 王亮 KB08 KB MySql 49 KB Java逻辑 87 38 A 王伟 KW03 KB JDBC 54 KB HTML 100 46 A 王家能 KB05 KB JDBC 46 KB Spring 100 54 A 王志远 KW05 ElementUI 50 KW JQuery 92 42 A 王春雷 KB08 KB JS 47 KB HTML 91 44 A 王波 KB08 KB JavaOOP 47 KB JS 84 37 A 王纪文 KW06 KW JQuery 55 EasyUI 88 33 A 王跃 KW03 KB CSS 57 KB JDBC 98 41 A 相羽 KW05 KW HTML 49 KW JS 80 31 A 秦超 KW03 KB MySql 51 KB Java逻辑 100 49 A 管若涵 KB08 KB HTML 45 KB JS 89 44 A 胡妙妙 KB07 KB JS 47 KB JSP 97 50 A 胡正双 KB08 KB Java高级特性 45 KB JQuery 99 54 A 花磊 KW06 KW JQuery 56 KW HTML 100 44 A 苏郑梓梵 KB08 KB JS 46 KB JQuery 95 49 A 苏金峰 KW06 KW CSS+BootStrap 63 EasyUI 94 31 A 范新宇 KB07 KB CSS 67 KB Java高级特性 98 31 A 葛优 KB05 Hive 52 KB SpringMVC 100 48 A 蔡志远 KW03 KB HTML 46 KB CSS 83 37 A 袁潇凯 KW03 KB CSS 51 KB Java逻辑 88 37 A 许梦娟 KB07 KB JS 49 KB JavaOOP 77 28 B 谢武阳 KW03 KB JQuery 45 KB JS 80 35 A 贾仲羽 KB07 KB MySql 45 KB Java逻辑 95 50 A 赵伟伟 KB05 KB SpringMVC 47 Hadoop+MapReduce 93 46 A 赵杰 KB05 ELK 45 KB SpringBoot 96 51 A 邢慧斌 KW03 KB CSS 48 KB JS 98 50 A 邵娅 KW03 KB JDBC 54 KB Java高级特性 100 46 A 郑朋 KB07 KB HTML 51 KB JavaOOP 93 42 A 钱一鸣 KB08 KB CSS 45 KB Java逻辑 100 55 A 陈元生 KW06 KW CSS+BootStrap 46 KW HTML 97 51 A 陈军华 KW03 KB Java高级特性 48 KB JS 100 52 A 陈明秋 KB05 KB CSS 49 Scala 98 49 A 陈涛 KB08 KB MySql 45 KB HTML 99 54 A 陈玉莹 KB08 KB CSS 52 KB JQuery 94 42 A 陈真 KB08 KB CSS 53 KB Java逻辑 99 46 A 陈稼轩 KW03 KB JQuery 46 KB Java高级特性 90 44 A 陈立志 KB07 KB HTML 50 KB Java逻辑 98 48 A 雷兵 KB08 KB MySql 45 KB HTML 89 44 A 韩睿刘洋 KB05 KB JSP 45 KB JavaOOP 100 55 A 黄超杰 KW05 KW JS 47 ElementUI 98 51 A 黄鑫 KB07 KB JS 51 KB CSS 100 49 A 黄雄 KW03 KB MySql 48 KB JDBC 94 46 A
三、HBase
1.配置Windows主机映射
-
进入以下路径
C:\Windows\System32\drivers\etc
-
修改hosts文件,添加需要映射的虚拟机地址和主机名
192.168.72.130 single 192.168.72.140 master
2.pom.xml文件
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>cn.kgc.kb10.wxj.hbase</groupId> <artifactId>hbasejdbc</artifactId> <version>1.0-SNAPSHOT</version> <name>hbasejdbc</name> <!-- FIXME change it to the project's website --> <url>http://www.example.com</url> <properties> <maven.compiler.source>1.8</maven.compiler.source> <maven.compiler.target>1.8</maven.compiler.target> <hadoop.version>2.6.0-cdh5.14.2</hadoop.version> <hive.version>1.1.0-cdh5.14.2</hive.version> <hbase.version>1.2.0-cdh5.14.2</hbase.version> </properties> <repositories> <repository> <id>cloudera</id> <url>https://repository.cloudera.com/artifactory/cloudera-repos/</url> </repository> </repositories> <dependencies> <!--hadoop--> <dependency> <groupId>org.apache.hadoop</groupId> <artifactId>hadoop-common</artifactId> <version>${hadoop.version}</version> </dependency> <dependency> <groupId>org.apache.hadoop</groupId> <artifactId>hadoop-client</artifactId> <version>${hadoop.version}</version> </dependency> <dependency> <groupId>org.apache.hadoop</groupId> <artifactId>hadoop-hdfs</artifactId> <version>${hadoop.version}</version> </dependency> <!--日志--> <dependency> <groupId>commons-logging</groupId> <artifactId>commons-logging</artifactId> <version>1.2</version> </dependency> <!--MapReduce--> <dependency> <groupId>org.apache.hadoop</groupId> <artifactId>hadoop-auth</artifactId> <version>${hadoop.version}</version> </dependency> <dependency> <groupId>org.apache.hadoop</groupId> <artifactId>hadoop-mapreduce-client-core</artifactId> <version>${hadoop.version}</version> </dependency> <dependency> <groupId>org.apache.hadoop</groupId> <artifactId>hadoop-mapreduce-client-jobclient</artifactId> <version>${hadoop.version}</version> </dependency> <!-- https://mvnrepository.com/artifact/org.apache.zookeeper/zookeeper --> <!--zookeeper--> <dependency> <groupId>org.apache.zookeeper</groupId> <artifactId>zookeeper</artifactId> <version>3.4.5</version> <type>pom</type> </dependency> <!--hbase--> <dependency> <groupId>org.apache.hbase</groupId> <artifactId>hbase-client</artifactId> <version>${hbase.version}</version> </dependency> <dependency> <groupId>org.apache.hbase</groupId> <artifactId>hbase-common</artifactId> <version>${hbase.version}</version> </dependency> <dependency> <groupId>org.apache.hbase</groupId> <artifactId>hbase-server</artifactId> <version>${hbase.version}</version> </dependency> <!--log4j--> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.17</version> </dependency> <!--测试--> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.11</version> <!--<scope>test</scope>--> </dependency> </dependencies> </project>
3.代码实现
package cn.kgc.kb10.hbase; 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 org.junit.Test; import java.io.IOException; public class HBaseClientDemo { //创建一个表 @Test public void createTable() throws IOException { //1.获取hbase连接,配置 Configuration conf = HBaseConfiguration.create(); conf.set("hbase.zookeeper.quorum","192.168.182.131"); conf.set("hbase.zookeeper.property.clientPort","2181"); //2.创建连接 Connection conn = ConnectionFactory.createConnection(conf); //3.创建admin Admin admin=conn.getAdmin(); //4.创建表的相关信息,表名 HTableDescriptor student = new HTableDescriptor(TableName.valueOf("student100")); //5.添加列族信息 student.addFamily(new HColumnDescriptor("info")); student.addFamily(new HColumnDescriptor("score")); //6.调用创建表的方法进行建表操作 admin.createTable(student); //7.关闭连接 conn.close(); } @Test public void putData2Table() throws IOException { //1.获取hbase连接,配置 Configuration conf = HBaseConfiguration.create(); conf.set("hbase.zookeeper.quorum","192.168.182.131"); conf.set("hbase.zookeeper.property.clientPort","2181"); //2.创建连接 Connection conn = ConnectionFactory.createConnection(conf); //3.获取table Table student =conn.getTable(TableName.valueOf("student100")); //4.表中添加数据rowkey Put put=new Put(Bytes.toBytes("1001")); //5.添加列 info:name zhangsan put.addColumn(Bytes.toBytes("info"),Bytes.toBytes("name"),Bytes.toBytes("zhangsan")); put.addColumn(Bytes.toBytes("info"),Bytes.toBytes("gender"),Bytes.toBytes("male")); put.addColumn(Bytes.toBytes("info"),Bytes.toBytes("age"),Bytes.toBytes("11")); //6.插入数据 student.put(put); //7.关闭连接 conn.close(); } //读取数据 @Test public void getDataFromTable() throws IOException { //1.获取hbase连接,配置 Configuration conf = HBaseConfiguration.create(); conf.set("hbase.zookeeper.quorum","192.168.182.131"); conf.set("hbase.zookeeper.property.clientPort","2181"); //2.创建连接 Connection conn = ConnectionFactory.createConnection(conf); //3.获取table Table student =conn.getTable(TableName.valueOf("student100")); //4.读取数据,Get Get get = new Get(Bytes.toBytes("1001")); //5.获取结果 Result result = student.get(get); //6.遍历 Cell[] cells = result.rawCells(); for (Cell cell : cells) { System.out.println("rowkey:"+Bytes.toString(CellUtil.cloneRow(cell))); System.out.println("列族:"+Bytes.toString(CellUtil.cloneFamily(cell))); System.out.println("列名:"+Bytes.toString(CellUtil.cloneQualifier(cell))); System.out.println("value:"+Bytes.toString(CellUtil.cloneValue(cell))); System.out.println("-----------------"); } conn.close(); } //删除 @Test public void dropTable() throws IOException { //1.获取hbase连接,配置 Configuration conf = HBaseConfiguration.create(); conf.set("hbase.zookeeper.quorum","192.168.182.131"); conf.set("hbase.zookeeper.property.clientPort","2181"); //2.创建连接 Connection conn = ConnectionFactory.createConnection(conf); //3.创建admin Admin admin=conn.getAdmin(); //4.禁用表 admin.disableTable(TableName.valueOf("student100")); //5.删除表 admin.deleteTable(TableName.valueOf("student100")); conn.close(); } }