小狼今天很郁闷,我想要mysql中表的字段同步到hbase列族上去,非得在那dos上写命令行,今天想了一个方法,用代码完成
从mysql中获取字段名称
public static String mysql(String biaoming){
StringBuffer sb = new StringBuffer();
try {
new Dbtool();
Connection conn = Dbtool.getConnection();
PreparedStatement statement = conn.prepareStatement("desc "+biaoming);
ResultSet rs = statement.executeQuery();
while(rs.next()){
String name = rs.getString(1);
String leixing = rs.getString(2);
String isnull = rs.getString(3);
String suoyin = rs.getString(4);
sb.append(name+",");
}
} catch (Exception e) {
e.printStackTrace();
}
return sb.toString();
}
用mysql获取的字段创建hbase表
//创建表:
public static void createTable(S