OrientDB應(yīng)用舉例-Social

基礎(chǔ)信息

orientdb console: v2.2.31
gremlin v2.6.0
orientdb api: 2.2.x

ip: 172.28.26.214:2480

先看一個(gè)效果展示：

image.png


orientdb {db=social}> select * from V;

+----+------+---------+-------+-------+-------+--------+--------+---------+---------+--
-------+---------+---------+---------+---------+---------+---------+---------+---------
+
|#   |@RID  |@CLASS   |out_Eat|type   |in_Eat |in_Loves|in_Twins|name     |in_Friend|ou
t_Twins|out_WrokI|out_Frien|out_Study|in_Classm|out_Loves|out_Class|in_WrokIn|in_StudyI
|
+----+------+---------+-------+-------+-------+--------+--------+---------+---------+--
-------+---------+---------+---------+---------+---------+---------+---------+---------
+
|0   |#26:0 |Person   |[#58:0]|       |       |        |        |Luca     |         |
       |         |         |         |         |         |         |         |
|
|1   |#27:0 |Person   |       |       |       |        |        |Bill     |         |
       |         |         |         |         |         |         |         |
|
|2   |#28:0 |Person   |       |       |       |        |        |Jay      |         |
       |         |         |         |         |         |         |         |
|
|3   |#34:0 |Teacher  |       |       |       |[#99:0] |        |Miss Li  |         |
       |[#139:0] |         |         |         |         |         |         |
|
|4   |#35:0 |Teacher  |       |       |       |        |        |Mr Luo   |         |
       |[#138:0] |         |         |         |         |         |         |
|
|5   |#42:0 |Student  |       |       |       |        |        |LiLei    |         |
       |         |[#82:0]  |[#130:0] |         |[#98:0...|[#90:0]  |         |
|
|6   |#43:0 |Student  |       |       |       |[#98:0] |        |LiMin    |[#82:0]  |
       |         |         |         |[#90:0]  |         |         |         |
|
|7   |#44:0 |Student  |       |       |       |        |        |HanMeimei|         |
       |         |         |[#131:0] |         |         |         |         |         |
|8   |#45:0 |Student  |       |       |       |        |        |Lucy     |         |[#106:0] |         |         |         |         |         |[#91:0]  |         |         |
|9   |#46:0 |Student  |       |       |       |        |[#106:0]|Lily     |         |         |         |         |         |[#91:0]  |         |         |         |         |
|10  |#50:0 |Restau...|       |Pizza  |[#58:0]|        |        |Dante    |         |         |         |         |         |         |         |         |         |         |
|11  |#51:0 |Restau...|       |French |       |        |        |Charlie  |         |         |         |         |         |         |         |         |         |         |
|12  |#114:0|School   |       |Junior |       |        |        |No.2     |         |         |         |         |         |         |         |         |[#138:...|[#130:...|
+----+------+---------+-------+-------+-------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+

13 item(s) found. Query executed in 0.001 sec(s).

orientdb {db=social}> select * from E;

+----+------+---------+-----+------+
|#   |@RID  |@CLASS   |out  |in    |
+----+------+---------+-----+------+
|0   |#58:0 |Eat      |#26:0|#50:0 |
|1   |#82:0 |Friend   |#42:0|#43:0 |
|2   |#90:0 |Classmate|#42:0|#43:0 |
|3   |#91:0 |Classmate|#45:0|#46:0 |
|4   |#98:0 |Loves    |#42:0|#43:0 |
|5   |#99:0 |Loves    |#42:0|#34:0 |
|6   |#106:0|Twins    |#45:0|#46:0 |
|7   |#130:0|StudyIn  |#42:0|#114:0|
|8   |#131:0|StudyIn  |#44:0|#114:0|
|9   |#138:0|WrokIn   |#35:0|#114:0|
|10  |#139:0|WrokIn   |#34:0|#114:0|
+----+------+---------+-----+------+

11 item(s) found. Query executed in 0.002 sec(s).

建立一個(gè)social 的 database.

storage type: plocal
database type: graph

image.png

連接：

orientdb> connect remote:localhost/social root root

Connecting to database [remote:localhost/social] with user 'root'...OK

建立一個(gè)頂點(diǎn) Person

orientdb {db=social}>  CREATE CLASS Person EXTENDS V

Class created successfully. Total classes in database now: 12.

NOTE: 建立一個(gè)Vertex class Teacher

orientdb {db=social}>  CREATE CLASS Teacher EXTENDS V, Person

Class created successfully. Total classes in database now: 19.

NOTE: 建立一個(gè)Vertex class Student

orientdb {db=social}>  CREATE CLASS Student  EXTENDS V, Person

Class created successfully. Total classes in database now: 20.

建立 Restaurant

orientdb {db=social}> CREATE CLASS Restaurant EXTENDS V

Class created successfully. Total classes in database now: 13.

建立 school

orientdb {db=social}> CREATE CLASS School EXTENDS V

Class created successfully. Total classes in database now: 23.

建立 Person 下的記錄， Luca, Bill, Jay

orientdb {db=social}> CREATE VERTEX Person SET name='Luca'

Created vertex 'Person#26:0{name:Luca} v1' in 0.073000 sec(s).

orientdb {db=social}> CREATE VERTEX Person SET name='Bill'

Created vertex 'Person#27:0{name:Bill} v1' in 0.009000 sec(s).

orientdb {db=social}> CREATE VERTEX Person SET name='Jay'

Created vertex 'Person#28:0{name:Jay} v1' in 0.023000 sec(s).

建立 Teacher: Miss Li, Mr Luo

orientdb {db=social}> CREATE VERTEX Teacher SET name='Miss Li'

Created vertex 'Teacher#82:0{name:Miss Li} v1' in 0.055000 sec(s).

orientdb {db=social}> CREATE VERTEX Teacher SET name='Mr Luo'

Created vertex 'Teacher#83:0{name:Mr Luo} v1' in 0.014000 sec(s).

建立 Teacher: LiLei, LiMin, HanMeiMei,Lily, Lucy

orientdb {db=social}>  CREATE VERTEX Student SET name='LiLei'

Created vertex 'Student#90:0{name:LiLei} v1' in 0.028000 sec(s).

orientdb {db=social}>  CREATE VERTEX Student SET name='LiMin'

Created vertex 'Student#91:0{name:LiMin} v1' in 0.038000 sec(s).

orientdb {db=social}>  CREATE VERTEX Student SET name='HanMeimei'

Created vertex 'Student#92:0{name:HanMeimei} v1' in 0.021000 sec(s).


orientdb {db=social}>   CREATE VERTEX Student SET name='Lucy'

Created vertex 'Student#45:0{name:Lucy} v1' in 0.002000 sec(s).


orientdb {db=social}>  CREATE VERTEX Student SET name='Lily'

Created vertex 'Student#46:0{name:Lily} v1' in 0.001000 sec(s).

NOTE: 建立Restaurant 的記錄九昧， Dante, Charlie

orientdb {db=social}>  CREATE VERTEX Restaurant SET name='Dante', type='Pizza'

Created vertex 'Restaurant#34:0{name:Dante,type:Pizza} v1' in 0.043000 sec(s).

orientdb {db=social}> CREATE VERTEX Restaurant SET name='Charlie', type='French'

Created vertex 'Restaurant#35:0{name:Charlie,type:French} v1' in 0.070000 sec(s).

NOTE: 建立School 的記錄， NO.2

orientdb {db=social}> CREATE VERTEX School SET name='No.2', type='Junior '

Created vertex 'School#114:0{name:No.2,type:Junior } v1' in 0.001000 sec(s).

NOTE: 建立關(guān)系 Eat

orientdb {db=social}> CREATE CLASS Eat EXTENDS E

Class created successfully. Total classes in database now: 14.

NOTE: 建立關(guān)系 love

orientdb {db=social}> CREATE CLASS Love EXTENDS E

Class created successfully. Total classes in database now: 15.

NOTE: 建立關(guān)系 Know

orientdb {db=social}> CREATE CLASS Know EXTENDS E

Class created successfully. Total classes in database now: 16.

NOTE: 建立關(guān)系 Friend

orientdb {db=social}> CREATE CLASS Friend EXTENDS E, Know

Class created successfully. Total classes in database now: 17.

NOTE: 建立關(guān)系 Classmate

orientdb {db=social}> CREATE CLASS Classmate  EXTENDS E, Know

Class created successfully. Total classes in database now: 18.

NOTE: 建立關(guān)系 Loves

orientdb {db=social}> CREATE CLASS Loves  EXTENDS E, Know

Class created successfully. Total classes in database now: 21.

NOTE: 建立關(guān)系 Twins

orientdb {db=social}>  CREATE CLASS Twins  EXTENDS E, Know

Class created successfully. Total classes in database now: 22.

NOTE: 建立關(guān)系 WorkIn

orientdb {db=social}> CREATE CLASS WorkIN  EXTENDS E

Class created successfully. Total classes in database now: 24.

NOTE: 建立關(guān)系 StudyIn

orientdb {db=social}> CREATE CLASS StudyIn  EXTENDS E

Class created successfully. Total classes in database now: 25.

NOTE: 建立一個(gè)Map: Luca Eat Dante

orientdb {db=social}>  create EDGE Eat from (select from Person where name = 'Luca') to (select from Restaurant where name = 'Dante');

+----+-----+------+-----+-----+
|#   |@RID |@CLASS|out  |in   |
+----+-----+------+-----+-----+
|0   |#42:0|Eat   |#26:0|#34:0|
+----+-----+------+-----+-----+
Created '1' edges in 0.014000 sec(s).

LiLei Friend Limin

orientdb {db=social}> create EDGE Friend from (select from Student where name = 'LiLei') to (select from Student where name = 'LiMin');

+----+-----+------+-----+-----+
|#   |@RID |@CLASS|out  |in   |
+----+-----+------+-----+-----+
|0   |#82:0|Friend|#42:0|#43:0|
+----+-----+------+-----+-----+
Created '1' edges in 0.003000 sec(s).

NOTE: LiLei Loves LiMin

orientdb {db=social}> create EDGE Loves from (select from Student where name = 'LiLei') to (select from Student where name = 'LiMin');

+----+-----+------+-----+-----+
|# |@RID |@CLASS|out |in |
+----+-----+------+-----+-----+
|0 |#98:0|Loves |#42:0|#43:0|
+----+-----+------+-----+-----+
Created '1' edges in 0.002000 sec(s).

NOTE: LiLei Classmate LiMin

orientdb {db=social}> create EDGE Classmate from (select from Student where name = 'LiLei') to (select from Student where name = 'LiMin');

+----+-----+---------+-----+-----+
|#   |@RID |@CLASS   |out  |in   |
+----+-----+---------+-----+-----+
|0   |#90:0|Classmate|#42:0|#43:0|
+----+-----+---------+-----+-----+
Created '1' edges in 0.002000 sec(s).

NOTE: LiLei Loves Miss Li

orientdb {db=social}> create EDGE Loves from (select from Student where name = 'LiLei') to (select from Teacher where name = 'Miss Li');

+----+-----+------+-----+-----+
|#   |@RID |@CLASS|out  |in   |
+----+-----+------+-----+-----+
|0   |#99:0|Loves |#42:0|#34:0|
+----+-----+------+-----+-----+
Created '1' edges in 0.003000 sec(s).

NOTE: 建立一個(gè)Map: Lucy Twins Lily

orientdb {db=social}> create EDGE Twins from (select from Student where name = 'Lucy') to (select from Student where name = 'Lily');

+----+------+------+-----+-----+
|#   |@RID  |@CLASS|out  |in   |
+----+------+------+-----+-----+
|0   |#106:0|Twins |#45:0|#46:0|
+----+------+------+-----+-----+
Created '1' edges in 0.002000 sec(s).

NOTE: 建立一個(gè)Map: Lucy Classmate Lily

orientdb {db=social}> create EDGE Classmate from (select from Student where name = 'Lucy') to (select from Student where name = 'Lily');

+----+-----+---------+-----+-----+
|#   |@RID |@CLASS   |out  |in   |
+----+-----+---------+-----+-----+
|0   |#91:0|Classmate|#45:0|#46:0|
+----+-----+---------+-----+-----+
Created '1' edges in 0.002000 sec(s).

NOTE: 建立一個(gè)Map: LiLei StudyIn NO2

orientdb {db=social}> create EDGE StudyIn from (select from Student where name = 'LiLei') to (select from School where name = 'No.2');

+----+------+-------+-----+------+
|#   |@RID  |@CLASS |out  |in    |
+----+------+-------+-----+------+
|0   |#130:0|StudyIn|#42:0|#114:0|
+----+------+-------+-----+------+
Created '1' edges in 0.002000 sec(s).

NOTE: 建立一個(gè)Map: HanMeiMei StudyIn NO2

orientdb {db=social}> create EDGE StudyIn from (select from Student where name = 'HanMeimei') to (select from School where name = 'No.2');

+----+------+-------+-----+------+
|#   |@RID  |@CLASS |out  |in    |
+----+------+-------+-----+------+
|0   |#131:0|StudyIn|#44:0|#114:0|
+----+------+-------+-----+------+
Created '1' edges in 0.003000 sec(s).

NOTE: 建立一個(gè)Map: Mr Luo WrokIn NO2

orientdb {db=social}> create EDGE WrokIn from (select from Teacher where name = 'Mr Luo') to (select from School where name = 'No.2');

+----+------+------+-----+------+
|#   |@RID  |@CLASS|out  |in    |
+----+------+------+-----+------+
|0   |#138:0|WrokIn|#35:0|#114:0|
+----+------+------+-----+------+
Created '1' edges in 0.045000 sec(s).

NOTE: 建立一個(gè)Map: Miss Li WrokIn NO2

orientdb {db=social}> create EDGE WrokIn from (select from Teacher where name = 'Miss Li') to (select from School where name = 'No.2');

+----+------+------+-----+------+
|#   |@RID  |@CLASS|out  |in    |
+----+------+------+-----+------+
|0   |#139:0|WrokIn|#34:0|#114:0|
+----+------+------+-----+------+
Created '1' edges in 0.002000 sec(s).

查詢(xún)

查看有幾個(gè)Person

這里可以把Person 的子類(lèi) Teacher, Student 查出來(lái)号坡。

orientdb {db=social}> select * from Person;

+----+-----+-------+-------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+
|#   |@RID |@CLASS |out_Eat|in_Loves|in_Twins|name     |in_Friend|out_Twins|out_WrokI|out_Frien|out_Study|in_Classm|out_Loves|out_Class|
+----+-----+-------+-------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+
|0   |#26:0|Person |[#58:0]|        |        |Luca     |         |         |         |         |         |         |         |         |
|1   |#27:0|Person |       |        |        |Bill     |         |         |         |         |         |         |         |         |
|2   |#28:0|Person |       |        |        |Jay      |         |         |         |         |         |         |         |         |
|3   |#34:0|Teacher|       |[#99:0] |        |Miss Li  |         |         |[#139:0] |         |         |         |         |         |
|4   |#35:0|Teacher|       |        |        |Mr Luo   |         |         |[#138:0] |         |         |         |         |         |
|5   |#42:0|Student|       |        |        |LiLei    |         |         |         |[#82:0]  |[#130:0] |         |[#98:0...|[#90:0]  |
|6   |#43:0|Student|       |[#98:0] |        |LiMin    |[#82:0]  |         |         |         |         |[#90:0]  |         |         |
|7   |#44:0|Student|       |        |        |HanMeimei|         |         |         |         |[#131:0] |         |         |         |
|8   |#45:0|Student|       |        |        |Lucy     |         |[#106:0] |         |         |         |         |         |[#91:0]  |
|9   |#46:0|Student|       |        |[#106:0]|Lily     |         |         |         |         |         |[#91:0]  |         |         |
+----+-----+-------+-------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+

10 item(s) found. Query executed in 0.002 sec(s).

查看定義了幾種關(guān)系（關(guān)系列表）

orientdb {db=social}> select * from Know;

+----+------+---------+-----+-----+
|#   |@RID  |@CLASS   |out  |in   |
+----+------+---------+-----+-----+
|0   |#82:0 |Friend   |#42:0|#43:0|
|1   |#90:0 |Classmate|#42:0|#43:0|
|2   |#91:0 |Classmate|#45:0|#46:0|
|3   |#98:0 |Loves    |#42:0|#43:0|
|4   |#99:0 |Loves    |#42:0|#34:0|
|5   |#106:0|Twins    |#45:0|#46:0|
+----+------+---------+-----+-----+

6 item(s) found. Query executed in 0.002 sec(s).


orientdb {db=social}>  select * from E;

+----+------+---------+-----+------+
|#   |@RID  |@CLASS   |out  |in    |
+----+------+---------+-----+------+
|0   |#58:0 |Eat      |#26:0|#50:0 |
|1   |#82:0 |Friend   |#42:0|#43:0 |
|2   |#90:0 |Classmate|#42:0|#43:0 |
|3   |#91:0 |Classmate|#45:0|#46:0 |
|4   |#98:0 |Loves    |#42:0|#43:0 |
|5   |#99:0 |Loves    |#42:0|#34:0 |
|6   |#106:0|Twins    |#45:0|#46:0 |
|7   |#130:0|StudyIn  |#42:0|#114:0|
|8   |#131:0|StudyIn  |#44:0|#114:0|
|9   |#138:0|WrokIn   |#35:0|#114:0|
|10  |#139:0|WrokIn   |#34:0|#114:0|
+----+------+---------+-----+------+

11 item(s) found. Query executed in 0.002 sec(s).

NOTE: 查詢(xún) LiMin 的 Friend StudyIn 的 School

orientdb {db=social}> MATCH {class: Person, as: people, where:(name = 'LiMin')}.both('Friend').both('StudyIn') {as: school} RETURN person, school.name

+----+------+-----------+
|#   |person|school_name|
+----+------+-----------+
|0   |      |No.2       |
+----+------+-----------+

1 item(s) found. Query executed in 0.002 sec(s).

NOTE: 查詢(xún) LiMin 的 Friend StudyIn 的 School 中的 Teacher

orientdb {db=social}>  MATCH {class: Person, as: people, where:(name = 'LiMin')}.both('Friend').both('StudyIn').both('WrokIn') {as: teacher} RETURN person, teacher.name

+----+------+------------+
|#   |person|teacher_name|
+----+------+------------+
|0   |      |Mr Luo      |
|1   |      |Miss Li     |
+----+------+------------+

2 item(s) found. Query executed in 0.002 sec(s).

NOTE: 查詢(xún) LiMin 的 Friend StudyIn 的 School 中的 Teacher 和 Student

orientdb {db=social}> MATCH {class: Person, as: people, where:(name = 'LiMin')}.both('Friend').both('StudyIn').both('E') {as: person} RETURN person.name

+----+-----------+
|#   |person_name|
+----+-----------+
|0   |Mr Luo     |
|1   |Miss Li    |
|2   |LiLei      |
|3   |HanMeimei  |
+----+-----------+

4 item(s) found. Query executed in 0.003 sec(s).

擴(kuò)展閱讀

orientdb sql query to select edge and vertex fields property.

https://stackoverflow.com/questions/28534120/orientdb-sql-query-to-select-edge-and-vertex-fields-property
簡(jiǎn)介：
有一些例子可以參考鸦难。

最后編輯于：2017.12.25 22:36:45

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請(qǐng)聯(lián)系作者

人面猴
序言：七十年代末，一起剝皮案震驚了整個(gè)濱河市，隨后出現(xiàn)的幾起案子形葬，更是在濱河造成了極大的恐慌，老刑警劉巖暮的，帶你破解...
沈念sama閱讀 217,826評(píng)論 6贊 506
死咒
序言：濱河連續(xù)發(fā)生了三起死亡事件笙以，死亡現(xiàn)場(chǎng)離奇詭異，居然都是意外死亡冻辩，警方通過(guò)查閱死者的電腦和手機(jī)猖腕，發(fā)現(xiàn)死者居然都...
沈念sama閱讀 92,968評(píng)論 3贊 395
救了他兩次的神仙讓他今天三更去死
文/潘曉璐我一進(jìn)店門(mén)，熙熙樓的掌柜王于貴愁眉苦臉地迎上來(lái)恨闪，“玉大人倘感，你說(shuō)我怎么就攤上這事×剩” “怎么了老玛？”我有些...
開(kāi)封第一講書(shū)人閱讀 164,234評(píng)論 0贊 354
道士緝兇錄：失蹤的賣(mài)姜人
文/不壞的土叔我叫張陵，是天一觀的道長(zhǎng)。經(jīng)常有香客問(wèn)我逻炊，道長(zhǎng)互亮，這世上最難降的妖魔是什么？我笑而不...
開(kāi)封第一講書(shū)人閱讀 58,562評(píng)論 1贊 293
?港島之戀（遺憾婚禮）
正文為了忘掉前任余素，我火速辦了婚禮豹休，結(jié)果婚禮上，老公的妹妹穿的比我還像新娘桨吊。我一直安慰自己威根，他們只是感情好，可當(dāng)我...
茶點(diǎn)故事閱讀 67,611評(píng)論 6贊 392
惡毒庶女頂嫁案：這布局不是一般人想出來(lái)的
文/花漫我一把揭開(kāi)白布视乐。她就那樣靜靜地躺著洛搀，像睡著了一般。火紅的嫁衣襯著肌膚如雪佑淀。梳的紋絲不亂的頭發(fā)上留美，一...
開(kāi)封第一講書(shū)人閱讀 51,482評(píng)論 1贊 302
城市分裂傳說(shuō)
那天，我揣著相機(jī)與錄音伸刃，去河邊找鬼谎砾。笑死，一個(gè)胖子當(dāng)著我的面吹牛捧颅，可吹牛的內(nèi)容都是我干的景图。我是一名探鬼主播，決...
沈念sama閱讀 40,271評(píng)論 3贊 418
雙鴛鴦連環(huán)套：你想象不到人心有多黑
文/蒼蘭香墨我猛地睜開(kāi)眼碉哑，長(zhǎng)吁一口氣：“原來(lái)是場(chǎng)噩夢(mèng)啊……” “哼挚币！你這毒婦竟也來(lái)了？” 一聲冷哼從身側(cè)響起扣典，我...
開(kāi)封第一講書(shū)人閱讀 39,166評(píng)論 0贊 276
萬(wàn)榮殺人案實(shí)錄
序言：老撾萬(wàn)榮一對(duì)情侶失蹤妆毕，失蹤者是張志新（化名）和其女友劉穎，沒(méi)想到半個(gè)月后激捏，有當(dāng)?shù)厝嗽跇?shù)林里發(fā)現(xiàn)了一具尸體设塔，經(jīng)...
沈念sama閱讀 45,608評(píng)論 1贊 314
?護(hù)林員之死
正文獨(dú)居荒郊野嶺守林人離奇死亡，尸身上長(zhǎng)有42處帶血的膿包…… 初始之章·張勛以下內(nèi)容為張勛視角年9月15日...
茶點(diǎn)故事閱讀 37,814評(píng)論 3贊 336
?白月光啟示錄
正文我和宋清朗相戀三年远舅，在試婚紗的時(shí)候發(fā)現(xiàn)自己被綠了闰蛔。大學(xué)時(shí)的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片。...
茶點(diǎn)故事閱讀 39,926評(píng)論 1贊 348
活死人
序言：一個(gè)原本活蹦亂跳的男人離奇死亡图柏，死狀恐怖序六，靈堂內(nèi)的尸體忽然破棺而出，到底是詐尸還是另有隱情蚤吹，我是刑警寧澤例诀，帶...
沈念sama閱讀 35,644評(píng)論 5贊 346
?日本核電站爆炸內(nèi)幕
正文年R本政府宣布随抠，位于F島的核電站，受9級(jí)特大地震影響繁涂，放射性物質(zhì)發(fā)生泄漏拱她。R本人自食惡果不足惜，卻給世界環(huán)境...
茶點(diǎn)故事閱讀 41,249評(píng)論 3贊 329
男人毒藥：我在死后第九天來(lái)索命
文/蒙蒙一扔罪、第九天我趴在偏房一處隱蔽的房頂上張望秉沼。院中可真熱鬧，春花似錦矿酵、人聲如沸唬复。這莊子的主人今日做“春日...
開(kāi)封第一講書(shū)人閱讀 31,866評(píng)論 0贊 22
一樁弒父案全肮，背后竟有這般陰謀
文/蒼蘭香墨我抬頭看了看天上的太陽(yáng)敞咧。三九已至，卻和暖如春辜腺，著一層夾襖步出監(jiān)牢的瞬間休建，已是汗流浹背。一陣腳步聲響...
開(kāi)封第一講書(shū)人閱讀 32,991評(píng)論 1贊 269
情欲美人皮
我被黑心中介騙來(lái)泰國(guó)打工哪自，沒(méi)想到剛下飛機(jī)就差點(diǎn)兒被人妖公主榨干…… 1. 我叫王不留丰包，地道東北人。一個(gè)月前我還...
沈念sama閱讀 48,063評(píng)論 3贊 370
代替公主和親
正文我出身青樓壤巷，卻偏偏與公主長(zhǎng)得像，于是被迫代替她去往敵國(guó)和親瞧毙。傳聞我的和親對(duì)象是個(gè)殘疾皇子胧华，可洞房花燭夜當(dāng)晚...
茶點(diǎn)故事閱讀 44,871評(píng)論 2贊 354