非关系型数据库操作Word文件下载.docx
《非关系型数据库操作Word文件下载.docx》由会员分享,可在线阅读,更多相关《非关系型数据库操作Word文件下载.docx(24页珍藏版)》请在冰豆网上搜索。
//localhost/stu"
staticfinalStringUSER="
root"
staticfinalStringPASSWD="
123"
publicstaticvoidmain(String[]args){
insertData();
}
privatestaticvoidinsertData(){
Connectionconn=null;
Statementstmt=null;
try{
Class.forName(DRIVER);
System.out.println("
Connectingtoaselecteddatabase..."
);
conn=DriverManager.getConnection(DB,USER,PASSWD);
stmt=conn.createStatement();
Stringsql="
insertintostudentvalues('
scofield'
45,89,100)"
stmt.executeUpdate(sql);
Insertingrecordsintothetablesuccessfully!
"
}catch(ClassNotFoundExceptione){
e.printStackTrace();
}catch(SQLExceptione){
}finally{
if(stmt!
=null)
stmt.close();
if(conn!
conn.close();
}
运行截图如下:
b)代码如下:
publicclassTestMySQL{
getData();
publicstaticvoidgetData(){
ResultSetrs=null;
selectname,Englishfromstudentwherename='
"
rs=stmt.executeQuery(sql);
name"
+"
\t\t"
English"
while(rs.next()){
System.out.print(rs.getString
(1)+"
System.out.println(rs.getInt
(2));
if(rs!
rs.close();
}catch(SQLExceptione1){
e1.printStackTrace();
2.HBase数据库操作
1.设计完成后,用scan指令浏览表的相关信息:
2.查询zhangsan的Computer成绩:
3.修改lisi的Math成绩,改为95:
4.根据上面已经设计出的student,用HbaseAPI编程。
a)添加数据:
45Math:
89Computer:
importjava.io.IOException;
importorg.apache.hadoop.conf.Configuration;
importorg.apache.hadoop.hbase.HBaseConfiguration;
importorg.apache.hadoop.hbase.TableName;
importorg.apache.hadoop.hbase.client.Admin;
importorg.apache.hadoop.hbase.client.Connection;
importorg.apache.hadoop.hbase.client.ConnectionFactory;
importorg.apache.hadoop.hbase.client.Put;
importorg.apache.hadoop.hbase.client.Table;
publicclassTestHBase{
publicstaticConfigurationconfiguration;
publicstaticConnectionconnection;
publicstaticAdminadmin;
configuration=HBaseConfiguration.create();
configuration.set("
hbase.rootdir"
"
hdfs:
//localhost:
9000/hbase"
connection=ConnectionFactory.createConnection(configuration);
admin=connection.getAdmin();
}catch(IOExceptione){
insertRow("
student"
scofield"
score"
45"
Math"
89"
Computer"
100"
close();
publicstaticvoidinsertRow(StringtableName,StringrowKey,
StringcolFamily,Stringcol,Stringval)throwsIOException{
Tabletable=connection.getTable(TableName.valueOf(tableName));
Putput=newPut(rowKey.getBytes());
put.addColumn(colFamily.getBytes(),col.getBytes(),val.getBytes());
table.put(put);
table.close();
publicstaticvoidclose(){
if(admin!
=null){
admin.close();
if(null!
=connection){
connection.close();
importorg.apache.hadoop.hbase.Cell;
importorg.apache.hadoop.hbase.CellUtil;
importorg.apache.hadoop.hbase.client.Get;
importorg.apache.hadoop.hbase.client.Result;
publicclassTestHBase2{
getData("
publicstaticvoidgetData(StringtableName,StringrowKey,
StringcolFamily,Stringcol)throwsIOException{
Getget=newGet(rowKey.getBytes());
get.addColumn(colFamily.getBytes(),col.getBytes());
Resultresult=table.get(get);
showCell(result);
publicstaticvoidshowCell(Resultresult){
Cell[]cells=result.rawCells();
for(Cellcell:
cells){
RowName:
+newString(CellUtil.cloneRow(cell))
Timetamp:
+cell.getTimestamp()+"
columnFamily:
+newString(CellUtil.cloneFamily(cell))+"
rowName:
+newString(CellUtil.cloneQualifier(cell))+"
value:
+newString(CellUtil.cloneValue(cell))
3.Redis数据库操作
1.设计完之后,用hgetall命令分别输出zhangsan和lisi的成绩信息:
importjava.util.Map;
importredis.clients.jedis.Jedis;
publicclassTestRedis{
Jedisjedis=newJedis("
localhost"
jedis.hset("
student.scofield"
Map<
String,String>
value=jedis.hgetAll("
for(Map.Entry<
entry:
value.entrySet()){
System.out.println(entry.getKey()+"
:
+entry.getValue());
运行结果如下:
publicclassTestRedis2{
Stringvalue=jedis.hget("
sEnglishscoreis:
+value);
4.MongoDB数据库操作
1.设计完后,用find()方法输出两个学生的信息:
importjava.util.ArrayList;
importjava.util.List;
importorg.bson.Document;
importcom.mongodb.MongoClient;
importcom.mongodb.client.MongoCollection;
importcom.mongodb.client.MongoDatabase;
publicclassTestMongoDB{
MongoClientmongoClient=newMongoClient("
27017);
MongoDatabasemongoDatabase=mongoClient.getDatabase("
MongoCollection<
Document>
collection=mongoDatabase
.getCollection("
Documentdocument=newDocument("
).append(
newDocument("
45).append("
89).append(
100));
List<
documents=newArrayList<
();
documents.add(document);
collection.insertMany(documents);
文档插入成功"
importcom.mongodb.client.MongoCursor;
importcom.mongodb.client.model.Filters;
importstaticcom.mongodb.client.model.Filters.eq;
publicclassTestMongoDB2{
MongoClientmongoClient=newMongoClient("
27017);
collection=mongoDatabase.getCollection("
MongoCursor<
cursor=collection.find(newDocument("
"
)).
projection(newDocument("
1).append("
_id"
0)).iterator();
while(cursor.hasNext())
System.out.println(cursor.next().toJson());
1.编程实现文件合并和去重操作