MongoDB介绍
行业应用场景：
db. blogposts. save ( {
title : "My First Post" ,
author : { name : "Jane" , id : 1 } ,
comments : [ { by : "Abe" , text : "First" } , { by
: "Ada" , text : "Good post" } ]
} ) ;
db. blogposts. find ( { "author.name" : "Jane" } ) ;
db. blogposts. findOne ( {
title : "My First Post" ,
"author.name" : "Jane" ,
comments : [ { by : "Abe" , text : "First" } , { by
: "Ada" , text : "Good post" } ]
} ) ;
db. blogposts. find ( { "comments.by" : "Ada" } ) ;
[ root@A opt]
[ root@A opt]
[ root@A mongodb-linux-x86_64-4.1.3]
[ root@A opt]
[ root@A mongodb-linux-x86_64-4.1.3]
dbpath = /data/mongo/
port = 27017
bind_ip = 0.0 .0.0
fork = true
logpath = /data/mongo/MongoDB.log
logappend = true
auth = false
[ root@A mongodb-linux-x86_64-4.1.3]
[ root@A /]
[ root@A mongodb-linux-x86_64-4.1.3]
MongoDB Compass Community ：
MongoDB Compass Community由MongoDB开发人员开发，这意味着更高的可靠性和兼容性
show dbs
use 数据库名
db.laosun.insert( { "did" :1,"dname" : "开发部" ,"loc" : "A区1座" } )
db.createCollection( "集合名" )
show tables
show collections
db.集合名.drop( )
db.dropDatabase( )
db.dept.insert(
{
"did" :1,
"dname" : "开发部" ,
"loc" : "A区1座"
} )
db.dept.find( )
var dataVar = {
"did" :2,
"dname" : "市场部" ,
"loc" : "深圳" ,
"count" :20
}
db.dept.insert( dataVar)
var dataVar = {
"did" :2,
"dname" : "市场部"
}
db.dept.insert( dataVar)
db.dept.insert( [
{ "did" :3,"dname" : "人事部" } ,
{ "did" :4,"dname" : "保洁部" }
] )
for( var i = 1 ; i< 100 ; i++) {
db.dept.insert( { "did" :i,"dname" : "测试" +i+"部" } ) ;
}
db.dept.remove( {
"_id" : ObjectId( "6114d0d2430f6b4dcc876c41" )
} )
db.dept.remove(
{ id:3} ,
{ justOne: 1 }
)
{ id:3} ,
1
)
db.dept.remove( {
"dname" : /测试/
} )
db.dept.remove( {
"dname" : /测试/
} ,true)
db.dept.remove( { } )
db.dept.drop( )
db
db.dropDatabase( )
db.laosun.update(
{ "id" :55} ,
{ "id" :88}
)
db.laosun.update(
{ "id" :55} ,
{ $set :{ "id" :88} } ,
false,
true
)
var dataVar = {
"id" :1,
"name" : "吕布" ,
"age" :29,
"address" : "灵界" ,
}
db.student.insert( dataVar)
var dataNew = {
"id" :1,
"name" : "吕小布" ,
"age" :29,
"address" : "灵幻界" ,
}
db.student.update( {
"_id" : ObjectId( "6114df1d430f6b4dcc876c42" ) ,
} ,dataNew)
db.student.update(
{ "age" :27} ,
{ "$set " :{ "address" : "大东北" } } ,
false,
false
)
db.student.update(
{ "age" :99} ,
{ "$set " :{ "name" : "上仙" } } ,
true,
false
)
db.student.update(
{ "age" :27} ,
{ "$set " :{ "address" : "东北三省" } } ,
true,
false
)
db.student.update(
{ "age" :27} ,
{ "$set " :{ "address" : "东北三省" } } ,
true,
true
)
db.student.insert( {
"name" : "地三鲜" ,
"age" :88,
"score" :99
} )
db.student.update(
{ "age" :88} ,
{
"$inc " :{
"age" :2,
"score" :-10
}
}
)
db.student.update(
{ "age" :90} ,
{
"$set " :{
"score" :100
}
}
)
db.student.update(
{ "name" : "地三鲜" } ,
{
"$unset " :{
"age" :1,
"score" :1
}
}
)
db.student.update(
{ "name" : "地三鲜" } ,
{
"$push " :{
"subject" : "毛概"
}
}
)
db.student.update(
{ "name" : "地三鲜" } ,
{
"$push " :{
"subject" : "邓论"
}
}
)
db.student.insert( { "name" : "毛血旺" } )
db.student.update(
{ "name" : "毛血旺" } ,
{
"$push " :{
"cai" :{
"$each " :[ "豆腐" ,"鸭血" ,"豆芽" ]
}
}
}
)
db.student.update(
{ "name" : "毛血旺" } ,
{
"$push " :{
"caiii9" :[ "豆腐" ,"鸭血" ,"豆芽" ]
}
}
)
db.student.update(
{ "name" : "毛血旺" } ,
{
"$addToSet " :{
"cai" : "豆腐"
}
}
)
db.student.update(
{ "name" : "毛血旺" } ,
{
"$addToSet " :{
"cai" : "油菜"
}
}
)
db.student.update(
{ "name" : "地三鲜" } ,
{
"$pop " :{
"subject" :-1
}
}
)
db.student.update(
{ "name" : "地三鲜" } ,
{
"$pop " :{
"subject" :1
}
}
)
db.student.update(
{ "name" : "毛血旺" } ,
{
"$pull " :{
"cai" : "鲍鱼"
}
}
)
db.student.update(
{ "name" : "毛血旺" } ,
{
"$pull " :{
"cai" : "油菜"
}
}
)
db.student.insert( {
"name" : "孙大仙" ,
"subject" :[ "毛概" ,"邓论" ,"计算机" ]
} )
db.student.update(
{ "name" : "孙大仙" } ,
{
"$pullAll " :{
"subject" :[ "毛概" ,"计算机" ]
}
}
)
db.student.update(
{ "name" : "毛血旺" } ,
{
"$rename " :{
"cai" : "配菜"
}
}
)
db.dept.insert( {
"did" :1,
"dname" : "开发部" ,
"address" : "北京海淀"
} )
db.dept.insert( {
"did" :2,
"dname" : "市场部" ,
"address" : "上海虹桥"
} )
db.dept.findOne( )
db.dept.find( {
"did" :1
} )
db.dept.find(
{ "did" :1} ,
{ "dname" :1}
)
db.dept.find(
{ "did" :1} ,
{ "dname" :1,"address" :1}
)
db.dept.find(
{ "did" :1} ,
{ "dname" :1,"address" :1}
) .pretty( )
db.dept.findOne( )
db.student.drop( ) ;
db.student.insert( { "name" : "张三" ,"sex" : "男" ,"age" :19,"address" : "高碑店" } )
db.student.insert( { "name" : "李四" ,"sex" : "女" ,"age" :18,"address" : "海淀区" } )
db.student.insert( { "name" : "王五" ,"sex" : "女" ,"age" :21,"address" : "东城区" } )
db.student.insert( { "name" : "赵六" ,"sex" : "女" ,"age" :21,"address" : "高碑店" } )
db.student.insert( { "name" : "孙七" ,"sex" : "男" ,"age" :22,"address" : "东城区" } )
db.student.insert( { "name" : "田八" ,"sex" : "女" ,"age" :22,"address" : "王府井" } )
db.student.insert( { "name" : "钱九" ,"sex" : "男" ,"age" :23,"address" : "东城区" } )
db.student.insert( { "name" : "周十" ,"sex" : "男" ,"age" :17,"address" : "高碑店" } )
db.student.find( {
"sex" : "女"
} )
db.student.find( {
"age" : {
"$gt " : 18
}
} )
db.student.find( {
"age" : {
"$gt " : 18
} ,
"sex" : "女"
} )
db. student. find ( {
"age" : {
"$gte" : 18 ,
"$lte" : 20
} ,
} )
db.student.find( {
"$or " :[
{ "age" :{ "$gt " :18} } ,
{ "sex" :{ "$eq " : "女" } }
]
} )
db.student.find( {
"$nor " :[
{ "age" :{ "$gt " :22} } ,
{ "sex" :{ "$eq " : "女" } }
]
} )
db.student.find( {
"age" :{
"$not " : {
"$lt " :21
}
}
} )
db.student.find( {
"age" :{
"$mod " :[ 2,0 ]
}
} )
db.student.find( {
"age" :{
"$mod " :[ 20,1 ]
}
} ) ;
db.student.find( {
"name" :{
"$in " :[ "张三" ,"李四" ,"王五" ]
}
} )
db.student.find( {
"name" :{
"$nin " :[ "张三" ,"李四" ,"王五" ]
}
} )
db.student.insert( { "name" : "老孙 - A" ,"sex" : "男" ,"age" :17,"address" : "中关村1" ,
"subject" :[ "语文" ,"数学" ,"英语" ] } )
db.student.insert( { "name" : "老孙 - B" ,"sex" : "女" ,"age" :18,"address" : "中关村2" ,
"subject" :[ "语文" ,"数学" ,"英语" ,"物理" ] } )
db.student.insert( { "name" : "老孙 - C" ,"sex" : "男" ,"age" :19,"address" : "中关村3" ,
"subject" :[ "语文" ,"数学" ,"英语" ,"物理" ,"化学" ] } )
db.student.insert( { "name" : "老孙 - D" ,"sex" : "女" ,"age" :20,"address" : "中关村4" ,
"subject" :[ "物理" ,"化学" ] } )
db.student.insert( { "name" : "老孙 - E" ,"sex" : "男" ,"age" :21,"address" : "中关村5" ,
"subject" :[ "语文" ,"数学" ,"化学" ] } )
db.student.find( {
"subject" : {
"$all " : [ "语文" ,"数学" ]
}
} )
db.student.find( {
"address" : {
"$all " : [ "中关村3" ]
}
} )
db.student.find( {
"subject.1" : "数学"
} )
db.student.find( {
"subject" : {
"$size " : 2
}
} )
db.student.find(
{ "age" :19} ,
{
"subject" : {
"$slice " :2
}
} )
db.student.find(
{ "age" :19} ,
{
"subject" : {
"$slice " :-2
}
} )
db.student.find(
{ "age" :19} ,
{
"subject" : {
"$slice " : [ 1,2 ]
}
} )
db.student.insert( {
"name" : "孙大仙" ,
"sex" : "男" ,
"age" :31,
"address" : "天宫院" ,
"subject" :[ "java" ,"mongo" ,"html" ] ,
"pets" :[
{
"name" : "大G" ,
"age" :3,
"brand" : "狗"
} ,
{
"name" : "大咪" ,
"age" :4,
"brand" : "猫"
}
]
} )
db.student.insert( { "name" : "乔丹" ,"sex" : "男" ,"age" :47,"address" : "芝加哥" ,"subject" :[ "数学" ,"英语" ] ,
"pets" :[
{ "name" : "杰瑞" ,"age" :2,"brand" : "鼠" } ,
{ "name" : "山姆" ,"age" :3,"brand" : "猫" }
] } )
db.student.insert( { "name" : "kobe" ,"sex" : "男" ,"age" :40,"address" : "洛杉矶" ,"subject" :[ "英语" ,"篮球" ] ,
"pets" :[
{ "name" : "克里斯提娜" ,"age" :2,"brand" : "金丝雀" } ,
{ "name" : "雪瑞" ,"age" :12,"brand" : "马" }
] } )
db.student.find(
{
"age" : {
"$gte " :20
} ,
"pets" : {
"$elemMatch " : {
"brand" : "猫"
}
}
}
)
db.student.find( {
"pets" :{
"$exists " : true
}
} )
db.student.find( {
"$where " : "this.age > 40"
} )
db.student.find( {
$where : "this.age > 40"
} )
db.student.find( "this.age>=40" ) ;
db.student.find( {
$and :[
{ $where : "this.age > 30" } ,
{ $where : "this.age < 40" }
]
} )
db.student.find( {
"name" : {
"$regex " : /孙/
}
} )
db.student.find( {
"name" : /孙/
} )
db.student.find( {
"name" : /a/i
} )
db.student.find( {
"subject" : /化/
} )
db.student.find( ) .sort( {
"age" : 1
} )
db.student.find( ) .sort( {
"age" : -1
} )
db.student.find( ) .sort( {
"$natural " : -1
} )
db.student.find( ) .skip( 0 ) .limit( 5 ) .sort( {
"age" :1
} )
db.student.find( ) .skip( 5 ) .limit( 5 ) .sort( {
"age" :1
} )
var you = db.student.find( )
while( you.hasNext( )) {
print( you.next( ) .name)
}
var you = db.student.find( )
while( you.hasNext( )) {
printjson( you.next( ))
}
db.person.insert( { "name" : "吕布" ,"sex" : "男" ,"age" :19,"address" : "高碑店" } )
db.person.insert( { "name" : "赵云" ,"sex" : "女" ,"age" :18,"address" : "海淀区" } )
db.person.insert( { "name" : "典韦" ,"sex" : "女" ,"age" :21,"address" : "东城区" } )
db.person.insert( { "name" : "关羽" ,"sex" : "女" ,"age" :21,"address" : "高碑店" } )
db.person.insert( { "name" : "马超" ,"sex" : "男" ,"age" :22,"address" : "东城区" } )
db.person.insert( { "name" : "张飞" ,"sex" : "女" ,"age" :22,"address" : "王府井" } )
db.person.insert( { "name" : "黄忠" ,"sex" : "男" ,"age" :23,"address" : "东城区" } )
db.person.insert( { "name" : "夏侯惇" ,"sex" : "男" ,"age" :17,"address" : "高碑店" } )
db.person.getIndexes( )
db.person.ensureIndex( {
"age" : -1
} )
db.person.dropIndex( {
"age" : -1
} )
db.person.dropIndexes( )
db.user1.insert( {
"name" : "a1"
} )
db.user1.find( )
db.user1.ensureIndex(
{
"name" :1
} ,
{
"unique" :true
}
)
db.phones.ensureIndex(
{ "time" :1} ,
{ "expireAfterSeconds" :10}
)
db.phones.insert( { "num" :110,"time" : ISODate( "2020-01-01T22:55:13.369Z" ) } )
db.phones.insert( { "num" :119,"time" : ISODate( "2020-01-02T22:55:13.369Z" ) } )
db.phones.insert( { "num" :120,"time" : ISODate( "2020-01-03T22:55:13.369Z" ) } )
db.phones.insert( { "num" :114,"time" : new Date( ) } )
db.news.insert( { "title" : "NoSQL" ,"nei" : "MongoDB" } )
db.news.insert( { "title" : "js java" ,"nei" : "前端技术" } )
db.news.insert( { "title" : "编程语言" ,"nei" : "java" } )
db.news.insert( { "title" : "java" ,"nei" : "好语言" } )
db.news.insert( { "title" : "java" ,"nei" : "java" } )
db.news.ensureIndex( {
"title" : "text" ,
"nei" : "text"
} )
db.news.find( {
"$text " :{
"$search " : "java"
}
} )
db.news.find( {
"$text " :{
"$search " : "java js"
}
} )
db.news.find( {
"$text " :{
"$search " : "\" java\" \" js\" "
}
} )
db.news.find( {
"$text " :{
"$search " : "java -js"
}
} )
db.news.find(
{
"$text " :{
"$search " : "java"
}
} ,
{
"score" :{
"$meta " : "textScore"
}
}
)
db.news.find(
{
"$text " :{
"$search " : "java"
}
} ,
{
"score" :{
"$meta " : "textScore"
}
}
) .sort( {
"score" :{
"$meta " : "textScore"
}
} )
db.news.dropIndexes( )
db.news.ensureIndex( { "$* *" : "text" } )
db.shops.insert( { 'loc' :[ 10,10 ] } )
db.shops.insert( { 'loc' :[ 11,11 ] } )
db.shops.insert( { 'loc' :[ 13,12 ] } )
db.shops.insert( { 'loc' :[ 50,14 ] } )
db.shops.insert( { 'loc' :[ 66,66 ] } )
db.shops.insert( { 'loc' :[ 110,119 ] } )
db.shops.insert( { 'loc' :[ 93,24 ] } )
db.shops.insert( { 'loc' :[ 99,54 ] } )
db.shops.insert( { 'loc' :[ 77,7 ] } )
db.shops.ensureIndex( {
"loc" : "2d"
} )
db.shops.find( {
"loc" :{
"$near " :[ 11,11 ] ,
"$maxDistance " :5
}
} )
db.shops.find( {
"loc" :{
"$geoWithin " :{
"$box " :[ [ 9,9 ] ,[ 11,11 ] ]
}
}
} )
db.shops.find( {
"loc" :{
"$geoWithin " :{
"$center " :[ [ 9,9 ] ,2]
}
}
} )
db.shops.find( {
"loc" :{
"$geoWithin " :{
"$polygon " :[ [ 9,9 ] ,[ 12,15 ] ,[ 66,7 ] ]
}
}
} )
db.class.insert(
{
"id" :1,
"className" : "一年一班" ,
"students" :[
{ "name" : "吕布" , "gender" : "男" } ,
{ "name" : "貂蝉" , "gender" : "女" }
]
} ,
{
"id" :2,
"className" : "一年二班" ,
"students" :[
{ "name" : "韩立" , "gender" : "男" } ,
{ "name" : "南宫婉" , "gender" : "女" }
]
} ,
)
db.student.count( )
db.student.count( { "name" :/孙/i} )
db.student.find( )
db.runCommand( {
"distinct" : "student" ,
"key" : "name"
} )
db.emps.insert( { "name" : "张三" ,"sex" : "男" ,"age" :19,"job" : "程序猿" ,"salary" :5000} )
db.emps.insert( { "name" : "李四" ,"sex" : "女" ,"age" :18,"job" : "美工" ,"salary" :6000} )
db.emps.insert( { "name" : "王五" ,"sex" : "女" ,"age" :21,"job" : "测试" ,"salary" :7000} )
db.emps.insert( { "name" : "赵六" ,"sex" : "女" ,"age" :21,"job" : "程猿" ,"salary" :5500} )
db.emps.insert( { "name" : "孙七" ,"sex" : "男" ,"age" :22,"job" : "测试" ,"salary" :8000} )
db.emps.insert( { "name" : "田八" ,"sex" : "女" ,"age" :22,"job" : "程序猿" ,"salary" :3000} )
db.emps.insert( { "name" : "钱九" ,"sex" : "男" ,"age" :23,"job" : "美工" ,"salary" :4500} )
db.emps.insert( { "name" : "周十" ,"sex" : "男" ,"age" :17,"job" : "程序猿" ,"salary" :9000} )
var jobMap = function ( ) {
emit( this.job , this.name)
}
var jobReduce = function( key,values) {
return { job:key,names:values} ;
}
db.runCommand( {
"mapreduce" : "emps" ,
"map" :jobMap,
"reduce" :jobReduce,
"out" : "emps_job_names"
} )
db.emps_job_names.find( )
var sexMap = function ( ) {
emit( this.sex,{
"ccount" :1,
"csal" :this.salary,
"cavg" :this.salary,
"cmax" :this.salary,
"cmin" :this.salary,
"cname" :this.name
} )
}
var sexReduce = function( key , values) {
var total = 0
var sum = 0
var max = values[ 0 ] .cmax
var min = values[ 0 ] .cmin
var names = new Array( )
for( var i in values) {
total += values[ i] .ccount
sum += values[ i] .csal
if( max < values[ i] .cmax) {
max = values[ i] .cmax
}
if( min > values[ i] .cmin) {
min = values[ i] .cmin
}
names[ i] = values[ i] .cname
}
var avg = ( sum/total) .toFixed( 2 )
return {
"count" :total,
"avg" :avg,
"sum" :sum,
"max" :max,
"min" :min,
"names" :names
}
}
db.runCommand( {
"mapreduce" : "emps" ,
"map" :sexMap,
"reduce" :sexReduce,
"out" : "emps_info"
} )
db.emps_info.find( )
db.emps.aggregate( {
"$group " :{
"_id" : "$job " ,
"job_count" :{
"$sum " :1
}
}
} )
db.emps.aggregate( {
"$group " :{
"_id" : "$job " ,
"job_salary_sum" :{
"$sum " : "$salary "
}
}
} )
db.emps.aggregate( {
"$group " :{
"_id" : "$job " ,
"sum" :{
"$sum " : "$salary "
} ,
"avg" :{
"$avg " : "$salary "
} ,
"max" :{
"$max " : "$salary "
} ,
"min" :{
"$min " : "$salary "
} ,
}
} )
db.emps.aggregate( {
"$group " :{
"_id" : "$job " ,
"salary" :{
"$push " : "$salary "
}
}
} )
db.emps.aggregate( {
"$group " :{
"_id" : "$job " ,
"xingming" :{
"$push " : "$name "
}
}
} )
db.emps.aggregate( {
"$group " :{
"_id" : "$job " ,
"xingming" :{
"$addToSet " : "$name "
}
}
} )
db.emps.aggregate( {
"$project " :{
"_id" :0,
"name" :1
}
} )
db.emps.aggregate( {
"$project " :{
"_id" :0,
"姓名" : "$name " ,
"职位" : "$job " ,
"工资" : "$salary "
}
} )
db.emps.aggregate( {
"$project " :{
"_id" :0,
"姓名" : "$name " ,
"职位" : "$job " ,
"工资" : "$salary " ,
"年薪" :{
"$multiply " :[ "$salary " ,12]
}
}
} )
db.emps.aggregate( {
"$project " :{
"_id" :0,
"姓名" : "$name " ,
"职位" : "$job " ,
"工资" : "$salary " ,
"money" :{
"$gte " :[ "$salary " ,8000]
}
}
} )
db.emps.aggregate( {
"$project " :{
"_id" :0,
"姓名" : "$name " ,
"职位" : "$job " ,
"is程序猿" :{
"$eq " :[ "$job " ,"程序猿" ]
}
}
} )
db.emps.aggregate( {
"$project " :{
"_id" :0,
"姓名" : "$name " ,
"职位" : "$job " ,
"is程序猿" :{
"$eq " :[ "$job " ,{ "$toUpper " : "程序猿" } ]
}
}
} )
db.emps.aggregate( {
"$project " :{
"_id" :0,
"姓名" : "$name " ,
"职位" : "$job " ,
"is程序猿" :{
"$strcasecmp " :[ "$job " ,"程序猿" ]
}
}
} )
db.emps.aggregate( {
"$project " :{
"_id" :0,
"姓名" : "$name " ,
"职位" : "$job " ,
"姓氏" :{
"$substrBytes " :[ "$name " ,0,3]
}
}
} )
db.emps.aggregate( {
"$sort " :{
"age" :1
}
} )
db.emps.aggregate( {
"$sort " :{
"salary" :-1
}
} )
db.emps.aggregate( {
"$sort " :{
"age" :1,
"salary" :-1
}
} )
db.emps.aggregate(
{
"$project " :{
"_id" :0,
"name" :1,
"age" :1,
"job" :1
}
} ,
{
"$limit " :3
}
)
db.emps.aggregate(
{
"$project " :{
"_id" :0,
"name" :1,
"age" :1,
"job" :1
}
} ,
{
"$skip " :3
} ,
{
"$limit " :3
}
)
db.dept.insert( { "name" : "技术部" ,"业务" :[ "研发" ,"培训" ,"维护" ] } )
db.dept.insert( { "name" : "人事部" ,"业务" :[ "招聘" ,"调岗" ,"发工资" ] } )
db.dept.insert( { "name" : "市场部" ,"业务" :[ "销售" ,"渠道" ,"开拓" ] } )
db.dept.aggregate( [ { "$unwind " : "$业务" } ] )
db.emps.aggregate(
{
"$project " :{
"_id" :0,
"name" :1,
"job" :1
}
} ,
{
"$skip " :3
} ,
{
"$limit " :3
} ,
{
"$out " : "emps_test"
}
)
db.emps_test.find( )
db.shops.drop( )
db.shops.insert( { 'loc' :[ 10,10 ] } )
db.shops.insert( { 'loc' :[ 11,11 ] } )
db.shops.insert( { 'loc' :[ 13,12 ] } )
db.shops.insert( { 'loc' :[ 50,14 ] } )
db.shops.insert( { 'loc' :[ 66,66 ] } )
db.shops.insert( { 'loc' :[ 110,119 ] } )
db.shops.insert( { 'loc' :[ 93,24 ] } )
db.shops.insert( { 'loc' :[ 99,54 ] } )
db.shops.insert( { 'loc' :[ 77,7 ] } )
db.shops.ensureIndex( {
"loc" : "2d"
} )
db.shops.aggregate( {
"$geoNear " :{
"near" :[ 11,11 ] ,
"distanceField" : "loc" ,
"maxDistance" :2,
"spherical" :true
}
} ,{
"$limit " :5
} )
{
$lookup :
{
from: < collection to join> 从表,
localField: < field from the input documents> 主表主键,
foreignField: < field from the documents of the "from" collection> 从表主键,
as: < output array field> 输出文档的新增值命名
}
}
db.orders.insert( [
{ "order_id" : 1 , "pname" : "可乐" , "price" : 12 , "count" : 2 } ,
{ "order_id" : 2 , "pname" : "薯片" , "price" : 20 , "count" : 1 } ,
{ "order_id" : 3 }
] )
db.stock.insert( [
{ "s_id" : 1 , "sku" : "可乐" , "description" : "product 1" , "instock" : 120 } ,
{ "s_id" : 2 , "sku" : "面包" , "description" : "product 2" , "instock" : 80 } ,
{ "s_id" : 3 , "sku" : "香肠" , "description" : "product 3" , "instock" : 60 } ,
{ "s_id" : 4 , "sku" : "薯片" , "description" : "product 4" , "instock" : 70 } ,
{ "s_id" : 5 , "sku" : null, "description" : "Incomplete" } ,
{ "s_id" : 6 }
] )
db.orders.aggregate( {
"$lookup " :{
from: "stock" ,
localField: "pname" ,
foreignField: "sku" ,
as: "shop_stock"
}
} )
db.createCollection( "depts" ,{
"capped" :true,
"size" :1024,
"max" :5
} )
db.depts.insert( { "name" : "开发部-1" ,"loc" : "北京" } )
db.depts.insert( { "name" : "开发部-2" ,"loc" : "北京" } )
db.depts.insert( { "name" : "开发部-3" ,"loc" : "北京" } )
db.depts.insert( { "name" : "开发部-4" ,"loc" : "北京" } )
db.depts.insert( { "name" : "开发部-5" ,"loc" : "北京" } )
db.depts.insert( { "name" : "开发部-6" ,"loc" : "北京" } )
< dependency> < groupId> </ groupId> < artifactId> </ artifactId> < version> </ version> </ dependency> <?xml version="1.0" encoding="UTF-8"?>
< beansxmlns = " http://www.springframework.org/schema/beans" xmlns: xsi= " http://www.w3.org/2001/XMLSchema-instance" xmlns: mongo= " http://www.springframework.org/schema/data/mongo" xmlns: context= " http://www.springframework.org/schema/context" xsi: schemaLocation= "
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/springbeans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/data/mongo
http://www.springframework.org/schema/data/mongo/spring-mongo.xsd" > < mongo: db-factoryid = " mongoDbFactory" client-uri = " mongodb://192.168.164.128:27017/laosun" /> < beanid = " mongoTemplate" class = " org.springframework.data.mongodb.core.MongoTemplate" > < constructor-argname = " mongoDbFactory" ref = " mongoDbFactory" > </ constructor-arg> </ bean> < context: component-scanbase-package = " dao" > </ context: component-scan> </ beans> package entity ;
import org. springframework. data. mongodb. core. mapping. Document ;
import java. io. Serializable ;
@Document ( collection = "emps" )
public class Emp implements Serializable {
private String _id;
private String name;
private String sex;
private double age;
private String job;
private double salary;
@Override
public String toString ( ) {
return "Emp{" +
"_id='" + _id + '\'' +
", name='" + name + '\'' +
", sex='" + sex + '\'' +
", age=" + age +
", job='" + job + '\'' +
", salary=" + salary +
'}' ;
}
public Emp ( ) {
}
public Emp ( String name, String sex, double age, String job, double salary) {
this . name = name;
this . sex = sex;
this . age = age;
this . job = job;
this . salary = salary;
}
public Emp ( String _id, String name, String sex, double age, String job, double salary) {
this . _id = _id;
this . name = name;
this . sex = sex;
this . age = age;
this . job = job;
this . salary = salary;
}
public String get_id ( ) {
return _id;
}
public void set_id ( String _id) {
this . _id = _id;
}
public String getName ( ) {
return name;
}
public void setName ( String name) {
this . name = name;
}
public String getSex ( ) {
return sex;
}
public void setSex ( String sex) {
this . sex = sex;
}
public double getAge ( ) {
return age;
}
public void setAge ( double age) {
this . age = age;
}
public String getJob ( ) {
return job;
}
public void setJob ( String job) {
this . job = job;
}
public double getSalary ( ) {
return salary;
}
public void setSalary ( double salary) {
this . salary = salary;
}
}
package dao ;
import entity. Emp ;
import java. util. List ;
public interface EmpDao {
void save ( Emp emp) ;
void delete ( String id) ;
void update ( Emp emp) ;
Emp findById ( String id) ;
List < Emp > findListPage ( Integer pageIndex, Integer pageSize, String name) ;
}
mongoTemplate. findAll ( Emp . class )
mongoTemplate. findById ( Object id, Emp . class )
mongoTemplate. find ( Query query, Emp . class )
mongoTemplate. upsert ( Query query, Update update, Emp . class )
mongoTemplate. remove ( Query query, Emp . class )
mongoTemplate. insert ( Object Emp )
package dao. impl ;
import dao. EmpDao ;
import entity. Emp ;
import org. springframework. beans. factory. annotation. Autowired ;
import org. springframework. data. mongodb. core. MongoTemplate ;
import org. springframework. stereotype. Repository ;
import java. util. List ;
@Repository ( "empDao" )
public class EmpDaoImpl implements EmpDao {
@Autowired
private MongoTemplate mongoTemplate;
@Override
public void save ( Emp emp) {
mongoTemplate. insert ( emp) ;
}
@Override
public void delete ( String id) {
}
@Override
public void update ( Emp emp) {
}
@Override
public Emp findById ( String id) {
}
@Override
public List < Emp > findListPage ( Integer pageIndex, Integer pageSize, String name) {
return null ;
}
}
package test ;
import dao. EmpDao ;
import entity. Emp ;
import org. springframework. context. support. ClassPathXmlApplicationContext ;
public class TestMongo {
public static void main ( String [ ] args) {
ClassPathXmlApplicationContext context = new
ClassPathXmlApplicationContext ( "application.xml" ) ;
EmpDao empDao = context. getBean ( "empDao" , EmpDao . class ) ;
Emp emp = new Emp ( "1" , "1" , 1 , "1" , 1 ) ;
empDao. save ( emp) ;
System . out. println ( "添加成功" ) ;
}
}
package dao. impl ;
import com. mongodb. client. result. DeleteResult ;
import com. mongodb. client. result. UpdateResult ;
import dao. EmpDao ;
import entity. Emp ;
import org. springframework. beans. factory. annotation. Autowired ;
import org. springframework. data. mongodb. core. MongoTemplate ;
import org. springframework. data. mongodb. core. query. Criteria ;
import org. springframework. data. mongodb. core. query. Query ;
import org. springframework. data. mongodb. core. query. Update ;
import org. springframework. stereotype. Repository ;
import org. springframework. util. StringUtils ;
import java. util. Collection ;
import java. util. Iterator ;
import java. util. List ;
import java. util. Queue ;
import java. util. regex. Pattern ;
@Repository ( "empDao" )
public class EmpDaoImpl implements EmpDao {
@Autowired
private MongoTemplate mongoTemplate;
@Override
public void save ( Emp emp) {
mongoTemplate. insert ( emp) ;
}
@Override
public void delete ( String id) {
Query query = new Query ( Criteria . where ( "_id" ) . is ( id) ) ;
DeleteResult remove = mongoTemplate. remove ( query, Emp . class ) ;
long deletedCount = remove. getDeletedCount ( ) ;
if ( deletedCount > 0 ) {
System . out. println ( "删除成功" ) ;
} else {
System . out. println ( "删除失败" ) ;
}
}
@Override
public void update ( Emp emp) {
Query query = new Query ( Criteria . where ( "_id" ) . is ( emp. get_id ( ) ) ) ;
Update update = new Update ( ) ;
update. set ( "name" , emp. getName ( ) ) ;
update. set ( "age" , emp. getAge ( ) ) ;
update. set ( "sex" , emp. getSex ( ) ) ;
update. set ( "job" , emp. getJob ( ) ) ;
update. set ( "salary" , emp. getSalary ( ) ) ;
UpdateResult upsert = mongoTemplate. upsert ( query, update, Emp . class ) ;
long modifiedCount = upsert. getModifiedCount ( ) ;
if ( modifiedCount > 0 ) {
System . out. println ( "修改成功" ) ;
} else {
System . out. println ( "修改失败" ) ;
}
}
@Override
public Emp findById ( String id) {
Emp byId = mongoTemplate. findById ( id, Emp . class ) ;
return byId;
}
@Override
public List < Emp > findListPage ( Integer pageIndex, Integer pageSize, String name) {
Query query = new Query ( ) ;
if ( ! StringUtils . isEmpty ( name) ) {
String format = String . format ( "%s%s%s" , "^.*" , name, ".*$" ) ;
Pattern compile = Pattern . compile ( format, Pattern . CASE_INSENSITIVE ) ;
query. addCriteria ( Criteria . where ( "name" ) . regex ( compile) ) ;
}
long count = mongoTemplate. count ( query, Emp . class ) ;
System . out. println ( count) ;
List < Emp > = mongoTemplate. find ( query. skip ( ( pageIndex- 1 ) * pageSize) . limit ( pageSize) ,
Emp . class ) ;
return emps;
}
}
package test ;
import dao. EmpDao ;
import entity. Emp ;
import org. springframework. context. support. ClassPathXmlApplicationContext ;
import java. util. List ;
public class TestMongo {
public static void main ( String [ ] args) {
ClassPathXmlApplicationContext context = new
ClassPathXmlApplicationContext ( "application.xml" ) ;
EmpDao empDao = context. getBean ( "empDao" , EmpDao . class ) ;
List < Emp > = empDao. findListPage ( 1 , 5 , "哈" ) ;
System . out. println ( listPage) ;
}
}
package dao. impl ;
public class test {
public static void main ( String [ ] args) {
String str= null ;
str= String . format ( "Hi,%s" , "小超" ) ;
System . out. println ( str) ;
str= String . format ( "Hi,%s %s %s" , "小超" , "是个" , "大帅哥" ) ;
System . out. println ( str) ;
System . out. printf ( "Hi,%s" , "小超" ) ;
}
}
1574
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
