基于上篇的脚手架数据库移植

说明

在移植过程中，最重要的两点是数据库表的设计和一点sql语句的修改，大佬的脚手架地址奉上：https://gitee.com/duxiaod/irs。以下介绍我觉得比较重要的代码修改和数据库表的修改，其他的问题运行项目报错修改即可。记得引入ojdbc14_11g.jar，否则Oracle数据库连接不成功。

代码修改

MainMapper代码的修改，主要是修改了sql。其他的Mapper.xml文件中insert语句主键改为序列.nextval。

public interface MainMapper {

@Select("SELECT * FROM tb_users WHERE TRUNC(create_time) = TRUNC(SYSDATE)")

List<TbUsers> selUsersToday();

@Select("SELECT * FROM TB_USERS WHERE TRUNC(SYSDATE) - TRUNC(CREATE_TIME) = 1")

List<TbUsers> selUsersYesterday();

@Select("SELECT * FROM TB_USERS WHERE TO_CHAR(CREATE_TIME, 'yyyyiw') = TO_CHAR(SYSDATE, 'yyyyiw')")

List<TbUsers> selUsersYearWeek();

@Select("SELECT * FROM TB_USERS WHERE TO_CHAR(CREATE_TIME,'yyyymm') = TO_CHAR(SYSDATE,'yyyymm')")

List<TbUsers> selUsersMonth();

}

配置修改

1、resource/mybatis文件夹下的SqlMapConfig.xml中修改

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE configuration

PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

<!-- 配置分页插件 -->

<plugins>

<plugin interceptor="com.github.pagehelper.PageHelper">

<!-- 设置数据库类型 Oracle,Mysql,MariaDB,SQLite,Hsqldb,PostgreSQL六种数据库-->       

        <property name="dialect" value="Oracle"/>

</plugin>

</plugins>

</configuration>

2、resource/recource中db.properties修改

jdbc.driver=oracle.jdbc.driver.OracleDriver

jdbc.url=

jdbc.username=

jdbc.password=

数据库表以及序列

序列要最后创建，根据数据库中的主键的值进行创建。

create table TB_ROLES

(

  role_id    NUMBER(20) not null,

  role_name  VARCHAR2(50) not null,

  role_remark VARCHAR2(100)

)

tablespace WMS

  pctfree 10

  initrans 1

  maxtrans 255

  storage

  (

    initial 64K

    next 8K

    minextents 1

    maxextents unlimited

  );

comment on column TB_ROLES.role_id

  is '角色编号';

comment on column TB_ROLES.role_name

  is '角色名';

alter table TB_ROLES

  add constraint PK_ROLEID primary key (ROLE_ID)

  using index

  tablespace WMS

  pctfree 10

  initrans 2

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

create table TB_ADMIN

(

  id      NUMBER(20) not null,

  username VARCHAR2(50) not null,

  password VARCHAR2(50) not null,

  salt    VARCHAR2(5),

  fullname VARCHAR2(50) not null,

  e_mail  VARCHAR2(100),

  sex      VARCHAR2(1) not null,

  birthday VARCHAR2(50) not null,

  address  VARCHAR2(100) not null,

  phone    VARCHAR2(20) not null,

  role_id  NUMBER(20)

)

tablespace WMS

  pctfree 10

  initrans 1

  maxtrans 255

  storage

  (

    initial 64K

    next 8K

    minextents 1

    maxextents unlimited

  );

comment on column TB_ADMIN.id

  is '管理员ID';

comment on column TB_ADMIN.username

  is '用户名';

comment on column TB_ADMIN.password

  is '密码';

comment on column TB_ADMIN.fullname

  is '全名';

comment on column TB_ADMIN.sex

  is '性别，0：女，1：男，2：保密';

comment on column TB_ADMIN.address

  is '地址';

comment on column TB_ADMIN.phone

  is '手机号';

comment on column TB_ADMIN.role_id

  is '角色编号';

alter table TB_ADMIN

  add constraint PK_ADMINID primary key (ID)

  using index

  tablespace WMS

  pctfree 10

  initrans 2

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

alter table TB_ADMIN

  add constraint F_ROLEID foreign key (ROLE_ID)

  references TB_ROLES (ROLE_ID) on delete cascade;

create table TB_LOG

(

  id          NUMBER(20) not null,

  username    VARCHAR2(50) not null,

  operation  VARCHAR2(50) not null,

  method      VARCHAR2(100),

  params      VARCHAR2(500),

  ip          VARCHAR2(64),

  create_time VARCHAR2(50) not null

)

tablespace WMS

  pctfree 10

  initrans 1

  maxtrans 255

  storage

  (

    initial 64K

    next 8K

    minextents 1

    maxextents unlimited

  );

comment on column TB_LOG.operation

  is '操作';

comment on column TB_LOG.method

  is '执行方法';

comment on column TB_LOG.params

  is '请求参数';

comment on column TB_LOG.ip

  is 'ip';

comment on column TB_LOG.create_time

  is '操作时间';

alter table TB_LOG

  add constraint PK_LOGID primary key (ID)

  using index

  tablespace WMS

  pctfree 10

  initrans 2

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

create table TB_MENUS

(

  menu_id  NUMBER(20) not null,

  title    VARCHAR2(20) not null,

  icon      VARCHAR2(20),

  href      VARCHAR2(100),

  perms    VARCHAR2(500),

  spread    VARCHAR2(10) not null,

  parent_id NUMBER(20) not null,

  sorting  NUMBER(20)

)

tablespace WMS

  pctfree 10

  initrans 1

  maxtrans 255

  storage

  (

    initial 64K

    next 8K

    minextents 1

    maxextents unlimited

  );

comment on column TB_MENUS.menu_id

  is '菜单编号';

comment on column TB_MENUS.title

  is '菜单名';

comment on column TB_MENUS.icon

  is '图标';

comment on column TB_MENUS.href

  is '资源地址';

comment on column TB_MENUS.perms

  is '权限';

comment on column TB_MENUS.spread

  is 'true：展开，false：不展开';

comment on column TB_MENUS.parent_id

  is '父节点';

alter table TB_MENUS

  add constraint PK_MENUID primary key (MENU_ID)

  using index

  tablespace WMS

  pctfree 10

  initrans 2

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

create table TB_ROLES_MENUS

(

  menu_id NUMBER(20) not null,

  role_id NUMBER(20) not null

)

tablespace WMS

  pctfree 10

  initrans 1

  maxtrans 255

  storage

  (

    initial 64K

    next 8K

    minextents 1

    maxextents unlimited

  );

alter table TB_ROLES_MENUS

  add constraint PK_RMID primary key (ROLE_ID, MENU_ID)

  using index

  tablespace WMS

  pctfree 10

  initrans 2

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

alter table TB_ROLES_MENUS

  add constraint F_MID foreign key (MENU_ID)

  references TB_MENUS (MENU_ID) on delete cascade;

alter table TB_ROLES_MENUS

  add constraint F_RID foreign key (ROLE_ID)

  references TB_ROLES (ROLE_ID) on delete cascade;

create table TB_USERS

(

  userid      NUMBER(20) not null,

  e_mail      VARCHAR2(50) not null,

  nickname    VARCHAR2(50) not null,

  password    VARCHAR2(50) not null,

  sex        VARCHAR2(1) not null,

  birthday    VARCHAR2(50) not null,

  address    VARCHAR2(100) not null,

  phone      VARCHAR2(20),

  e_code      VARCHAR2(50) not null,

  status      VARCHAR2(1),

  create_time DATE not null

)

tablespace WMS

  pctfree 10

  initrans 1

  maxtrans 255

  storage

  (

    initial 64K

    next 8K

    minextents 1

    maxextents unlimited

  );

comment on column TB_USERS.nickname

  is '昵称：唯一';

comment on column TB_USERS.sex

  is '0：女，1：男，2：保密';

comment on column TB_USERS.status

  is '0：未激活，1：正常，2：禁用';

alter table TB_USERS

  add constraint PK_UID primary key (USERID)

  using index

  tablespace WMS

  pctfree 10

  initrans 2

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

create table TB_JOBS

(

  job_id            VARCHAR2(50) not null,

  job_name          VARCHAR2(50),

  job_group_name    VARCHAR2(50),

  trigger_name      VARCHAR2(50),

  trigger_group_name VARCHAR2(50),

  cron              VARCHAR2(50),

  class_name        VARCHAR2(50),

  status            VARCHAR2(2)

)

tablespace WMS

  pctfree 10

  initrans 1

  maxtrans 255

  storage

  (

    initial 64K

    next 8K

    minextents 1

    maxextents unlimited

  );

comment on column LKM.TB_JOBS.job_id

  is '任务编号';

comment on column LKM.TB_JOBS.job_name

  is '任务名称';

comment on column LKM.TB_JOBS.job_group_name

  is '任务分组代码';

comment on column LKM.TB_JOBS.trigger_name

  is '触发器名称';

comment on column LKM.TB_JOBS.trigger_group_name

  is '触发器分组代码';

comment on column LKM.TB_JOBS.cron

  is '时间表达式';

comment on column LKM.TB_JOBS.class_name

  is '任务类';

comment on column LKM.TB_JOBS.status

  is '状态，0：启用，1：停用';

alter table TB_JOBS

  add constraint PK_JOB_ID primary key (JOB_ID)

  using index

  tablespace WMS

  pctfree 10

  initrans 2

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

create sequence SEQ_TB_ADMIN

minvalue 1

maxvalue 9999999999999999999999999999

start with 40

increment by 1

cache 20;

create sequence SEQ_TB_LOG

minvalue 1

maxvalue 99999999999999999999999999

start with 61

increment by 1

cache 20;

create sequence SEQ_TB_MENU

minvalue 1

maxvalue 99999999999999999999999999

start with 71

increment by 1

cache 20;

create sequence SEQ_TB_ROLES

minvalue 1

maxvalue 999999999999999999999999999

start with 81

increment by 1

cache 20;

create sequence SEQ_TB_USERS

minvalue 1

maxvalue 9999999999999999999999999999

start with 21

increment by 1

cache 20;

create sequence SEQ_TB_JOBS

minvalue 1

maxvalue 9999999999999999999999999999

start with 25

increment by 1

cache 20;

insert into TB_ROLES (role_id, role_name, role_remark)values (1, '超级管理员', '超级管理员');

insert into TB_ROLES (role_id, role_name, role_remark)values (61, 'ccccc', 'bbbbbb');

commit;

insert into TB_ADMIN (id, username, password, salt, fullname, e_mail, sex, birthday, address, phone, role_id)values (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', null, 'admin', 'isduxd@163.com', '1', '1994-11-08', '北京市通州区科创十四街', '17693109997', 1);

insert into TB_ADMIN (id, username, password, salt, fullname, e_mail, sex, birthday, address, phone, role_id)values (18, 'test', 'e10adc3949ba59abbe56e057f20f883e', null, 'test', 'test@test.com', '1', '2018-02-25', '甘肃省兰州市榆中县和平镇', '17601038192', null);

insert into TB_ADMIN (id, username, password, salt, fullname, e_mail, sex, birthday, address, phone, role_id)values (19, 'zgh.zhang', '5917270981938dc69698032acdccbe36', null, '张国辉', 'zgh.zhang@lokomo.cn', '1', '2019-04-29', 'aaaa', '15552298054', 61);

commit;

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (2, '系统管理', '', null, null, 'false', 0, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (4, '账户管理', '&#xe613;', 'sys/adminList', null, 'false', 2, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (3, '角色管理', '&#xe613;', 'sys/roleList', null, 'false', 2, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (9, '用户管理', '&#xe61d;', null, null, 'false', 0, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (10, '添加用户', '&#xe608;', 'user/addUser', null, 'false', 9, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (11, '管理用户', '&#xe60e;', 'user/userList', null, 'false', 9, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (14, '系统日志', '&#xe61d;', null, null, 'false', 0, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (15, '日志管理', '&#xe642;', 'log/logList', null, 'false', 14, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (43, 'SQL监控', '&#xe642;', null, null, 'false', 0, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (44, 'SQL监控', '&#xe642;', 'sys/druid', null, 'false', 43, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (46, '菜单管理', '&#xe642;', 'sys/menuList', null, 'false', 2, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (16, '查看', null, null, 'sys:role:list', 'false', 3, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (17, '新增', null, null, 'sys:role:save', 'false', 3, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (18, '修改', null, null, 'sys:role:update', 'false', 3, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (19, '删除', null, null, 'sys:role:delete', 'false', 3, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (20, '查看', null, null, 'sys:admin:list', 'false', 4, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (21, '新增', null, null, 'sys:admin:save', 'false', 4, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (22, '修改', null, null, 'sys:admin:update', 'false', 4, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (23, '删除', null, null, 'sys:admin:delete', 'false', 4, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (33, '新增', null, null, 'user:user:save', 'false', 10, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (34, '查看', null, null, 'user:user:list', 'false', 11, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (35, '新增', null, null, 'user:user:save', 'false', 11, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (36, '修改', null, null, 'user:user:update', 'false', 11, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (37, '删除', null, null, 'user:user:delete', 'false', 11, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (42, '查看', null, null, 'log:log:list', 'false', 15, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (45, '查看', null, null, 'sys:druid:list', 'false', 44, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (47, '查看', null, null, 'sys:menu:list', 'false', 46, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (48, '新增', null, null, 'sys:menu:save', 'false', 46, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (49, '修改', null, null, 'sys:menu:update', 'false', 46, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (50, '删除', null, null, 'sys:menu:delete', 'false', 46, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (1, '后台首页', '', 'page/main.html', null, 'false', 0, 9999);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (59, '任务调度', '&#xe620;', 'job/jobList', null, 'false', 2, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (60, '查看', null, null, 'job:job:list', 'false', 59, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (61, '新增', null, null, 'job:job:save', 'false', 59, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (62, '修改', null, null, 'job:job:update', 'false', 59, null);

insert into TB_MENUS (menu_id, title, icon, href, perms, spread, parent_id, sorting)values (63, '删除', null, null, 'job:job:delete', 'false', 59, null);

commit;

insert into TB_ROLES_MENUS (menu_id, role_id)values (1, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (2, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (3, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (4, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (9, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (10, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (11, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (14, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (15, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (16, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (17, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (18, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (19, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (20, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (21, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (22, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (23, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (33, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (34, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (35, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (36, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (37, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (42, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (43, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (44, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (45, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (46, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (47, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (48, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (49, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (50, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (1, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (2, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (3, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (4, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (9, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (10, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (11, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (16, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (17, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (18, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (19, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (20, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (21, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (22, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (23, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (33, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (34, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (35, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (36, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (37, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (46, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (47, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (48, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (49, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (50, 61);

insert into TB_ROLES_MENUS (menu_id, role_id)values (59, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (60, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (61, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (62, 1);

insert into TB_ROLES_MENUS (menu_id, role_id)values (63, 1);

commit;

最后编辑于 ：
©著作权归作者所有,转载或内容合作请联系作者
  • 人面猴
    序言：七十年代末，一起剥皮案震惊了整个滨河市，随后出现的几起案子，更是在滨河造成了极大的恐慌，老刑警刘岩，带你破解...
    沈念sama阅读 214,717评论 6赞 496
  • 死咒
    序言：滨河连续发生了三起死亡事件，死亡现场离奇诡异，居然都是意外死亡，警方通过查阅死者的电脑和手机，发现死者居然都...
    沈念sama阅读 91,501评论 3赞 389
  • 救了他两次的神仙让他今天三更去死
    文/潘晓璐 我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
    开封第一讲书人阅读 160,311评论 0赞 350
  • 道士缉凶录：失踪的卖姜人
    文/不坏的土叔 我叫张陵，是天一观的道长。 经常有香客问我，道长，这世上最难降的妖魔是什么？ 我笑而不...
    开封第一讲书人阅读 57,417评论 1赞 288
  • 港岛之恋（遗憾婚礼）
    正文 为了忘掉前任，我火速办了婚礼，结果婚礼上，老公的妹妹穿的比我还像新娘。我一直安慰自己，他们只是感情好，可当我...
    茶点故事阅读 66,500评论 6赞 386
  • 恶毒庶女顶嫁案：这布局不是一般人想出来的
    文/花漫 我一把揭开白布。 她就那样静静地躺着，像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上，一...
    开封第一讲书人阅读 50,538评论 1赞 293
  • 城市分裂传说
    那天，我揣着相机与录音，去河边找鬼。 笑死，一个胖子当着我的面吹牛，可吹牛的内容都是我干的。 我是一名探鬼主播，决...
    沈念sama阅读 39,557评论 3赞 414
  • 双鸳鸯连环套：你想象不到人心有多黑
    文/苍兰香墨 我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
    开封第一讲书人阅读 38,310评论 0赞 270
  • 万荣杀人案实录
    序言：老挝万荣一对情侣失踪，失踪者是张志新（化名）和其女友刘颖，没想到半个月后，有当地人在树林里发现了一具尸体，经...
    沈念sama阅读 44,759评论 1赞 307
  • 护林员之死
    正文 独居荒郊野岭守林人离奇死亡，尸身上长有42处带血的脓包…… 初始之章·张勋 以下内容为张勋视角 年9月15日...
    茶点故事阅读 37,065评论 2赞 330
  • 白月光启示录
    正文 我和宋清朗相恋三年，在试婚纱的时候发现自己被绿了。 大学时的朋友给我发了我未婚夫和他白月光在一起吃饭的照片。...
    茶点故事阅读 39,233评论 1赞 343
  • 活死人
    序言：一个原本活蹦乱跳的男人离奇死亡，死状恐怖，灵堂内的尸体忽然破棺而出，到底是诈尸还是另有隐情，我是刑警宁泽，带...
    沈念sama阅读 34,909评论 5赞 338
  • 日本核电站爆炸内幕
    正文 年R本政府宣布，位于F岛的核电站，受9级特大地震影响，放射性物质发生泄漏。R本人自食恶果不足惜，却给世界环境...
    茶点故事阅读 40,548评论 3赞 322
  • 男人毒药：我在死后第九天来索命
    文/蒙蒙 一、第九天 我趴在偏房一处隐蔽的房顶上张望。 院中可真热闹，春花似锦、人声如沸。这庄子的主人今日做“春日...
    开封第一讲书人阅读 31,172评论 0赞 21
  • 一桩弑父案，背后竟有这般阴谋
    文/苍兰香墨 我抬头看了看天上的太阳。三九已至，却和暖如春，着一层夹袄步出监牢的瞬间，已是汗流浃背。 一阵脚步声响...
    开封第一讲书人阅读 32,420评论 1赞 268
  • 情欲美人皮
    我被黑心中介骗来泰国打工， 没想到刚下飞机就差点儿被人妖公主榨干…… 1. 我叫王不留，地道东北人。 一个月前我还...
    沈念sama阅读 47,103评论 2赞 365
  • 代替公主和亲
    正文 我出身青楼，却偏偏与公主长得像，于是被迫代替她去往敌国和亲。 传闻我的和亲对象是个残疾皇子，可洞房花烛夜当晚...
    茶点故事阅读 44,098评论 2赞 352

推荐阅读更多精彩内容