Java毕业设计_基于Android的失物招领APP的设计与实现

基于Android的失物招领APP的设计与实现

基于Android的失物招领APP的设计与实现mysql数据库创建语句
基于Android的失物招领APP的设计与实现oracle数据库创建语句
基于Android的失物招领APP的设计与实现sqlserver数据库创建语句
基于Android的失物招领APP的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
基于Android的失物招领APP的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计
高质量编程视频：shangyepingtai.xin
基于Android的失物招领APP的设计与实现mysql数据库版本源码：
超级管理员表创建语句如下：

create table t_admin(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘超级管理员账号’,
password varchar(100) comment ‘超级管理员密码’
) comment ‘超级管理员’;
insert into t_admin(username,password) values(‘admin’,‘123456’);
SQLCopy
建议表创建语句如下：

create table t_contact(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
phone varchar(100) comment ‘联系方式’,
content varchar(100) comment ‘内容’,
insertDate datetime comment ‘日期’
) comment ‘建议’;
SQLCopy
用户表创建语句如下：

create table t_customer(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
name varchar(100) comment ‘姓名’,
phone varchar(100) comment ‘手机’,
sex varchar(100) comment ‘性别’,
age varchar(100) comment ‘年龄’,
address varchar(100) comment ‘家庭住址’,
idcard varchar(100) comment ‘身份证’,
insertDate datetime comment ‘入库日期’,
headPic varchar(100) comment ‘’
) comment ‘用户’;
SQLCopy
宠物表创建语句如下：

create table t_cw(
id int primary key auto_increment comment ‘主键’,
cwName varchar(100) comment ‘宠物别名’,
zl varchar(100) comment ‘种类’,
pz varchar(100) comment ‘品种’,
sex varchar(100) comment ‘性别’,
ms varchar(100) comment ‘毛色’,
jkzt varchar(100) comment ‘健康状态’,
llfw varchar(100) comment ‘流浪范围’,
hjdz varchar(100) comment ‘获救地址’,
cwnl varchar(100) comment ‘宠物年龄’,
status varchar(100) comment ‘状态’,
customerId int comment ‘用户’,
syrxm varchar(100) comment ‘收养人姓名’,
syrsex varchar(100) comment ‘性别’,
syrsfz varchar(100) comment ‘身份证’,
ly varchar(100) comment ‘理由’,
jtzz varchar(100) comment ‘家庭住址’,
jtcy varchar(100) comment ‘家庭成员’,
syrdh varchar(100) comment ‘收养人电话’,
jjdz varchar(100) comment ‘交接地址’
) comment ‘宠物’;
SQLCopy
就业帮助表创建语句如下：

create table t_jybz(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
pic varchar(100) comment ‘图片’,
content varchar(100) comment ‘内容’,
showDate datetime comment ‘日期’
) comment ‘就业帮助’;
SQLCopy
表创建语句如下：

create table t_liuyan(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘’,
toId int comment ‘’,
content varchar(100) comment ‘’,
insertDate datetime comment ‘’,
status varchar(100) comment ‘’,
flag varchar(100) comment ‘’
) comment ‘’;
SQLCopy
物品类型表创建语句如下：

create table t_lx(
id int primary key auto_increment comment ‘主键’,
lxName varchar(100) comment ‘物品类型’
) comment ‘物品类型’;
SQLCopy
评论表创建语句如下：

create table t_pinglun(
id int primary key auto_increment comment ‘主键’,
wdxxId int comment ‘评论信息’,
customerId int comment ‘评论人’,
content varchar(100) comment ‘评论内容’,
insertDate datetime comment ‘评论日期’
) comment ‘评论’;
SQLCopy
七嘴八舌表创建语句如下：

create table t_qzbs(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
title varchar(100) comment ‘标题’,
content varchar(100) comment ‘内容’,
insertDate datetime comment ‘发布日期’
) comment ‘七嘴八舌’;
SQLCopy
热点表创建语句如下：

create table t_rd(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
url varchar(100) comment ‘连接地址’
) comment ‘热点’;
SQLCopy
同学录表创建语句如下：

create table t_txl(
id int primary key auto_increment comment ‘主键’,
txName varchar(100) comment ‘姓名’,
pic varchar(100) comment ‘头像’,
bj varchar(100) comment ‘班级’,
lxfs varchar(100) comment ‘联系方式’
) comment ‘同学录’;
SQLCopy
我的好友表创建语句如下：

create table t_wdhy(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘我’,
hhId int comment ‘好友’,
insertDate datetime comment ‘关注日期’
) comment ‘我的好友’;
SQLCopy
我的消息表创建语句如下：

create table t_wdxx(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘我’,
title varchar(100) comment ‘标题’,
pic varchar(100) comment ‘图片’,
content varchar(100) comment ‘内容’,
zan int comment ‘赞’,
insertDate datetime comment ‘发布日期’,
lxId int comment ‘’,
ysId int comment ‘’,
xzId int comment ‘’
) comment ‘我的消息’;
SQLCopy
形状表创建语句如下：

create table t_xz(
id int primary key auto_increment comment ‘主键’,
xzName varchar(100) comment ‘形状’
) comment ‘形状’;
SQLCopy
颜色表创建语句如下：

create table t_ys(
id int primary key auto_increment comment ‘主键’,
ysName varchar(100) comment ‘颜色’
) comment ‘颜色’;
SQLCopy
基于Android的失物招领APP的设计与实现oracle数据库版本源码：
超级管理员表创建语句如下：

create table t_admin(
id integer,
username varchar(100),
password varchar(100)
);
insert into t_admin(id,username,password) values(1,‘admin’,‘123456’);
–超级管理员字段加注释
comment on column t_admin.id is ‘主键’;
comment on column t_admin.username is ‘超级管理员账号’;
comment on column t_admin.password is ‘超级管理员密码’;
–超级管理员表加注释
comment on table t_admin is ‘超级管理员’;
SQLCopy
建议表创建语句如下：

create table t_contact(
id integer,
customerId int,
phone varchar(100),
content varchar(100),
insertDate datetime
);
–建议字段加注释
comment on column t_contact.id is ‘主键’;
comment on column t_contact.customerId is ‘用户’;
comment on column t_contact.phone is ‘联系方式’;
comment on column t_contact.content is ‘内容’;
comment on column t_contact.insertDate is ‘日期’;
–建议表加注释
comment on table t_contact is ‘建议’;
SQLCopy
用户表创建语句如下：

create table t_customer(
id integer,
username varchar(100),
password varchar(100),
name varchar(100),
phone varchar(100),
sex varchar(100),
age varchar(100),
address varchar(100),
idcard varchar(100),
insertDate datetime,
headPic varchar(100)
);
–用户字段加注释
comment on column t_customer.id is ‘主键’;
comment on column t_customer.username is ‘账号’;
comment on column t_customer.password is ‘密码’;
comment on column t_customer.name is ‘姓名’;
comment on column t_customer.phone is ‘手机’;
comment on column t_customer.sex is ‘性别’;
comment on column t_customer.age is ‘年龄’;
comment on column t_customer.address is ‘家庭住址’;
comment on column t_customer.idcard is ‘身份证’;
comment on column t_customer.insertDate is ‘入库日期’;
comment on column t_customer.headPic is ‘’;
–用户表加注释
comment on table t_customer is ‘用户’;
SQLCopy
宠物表创建语句如下：

create table t_cw(
id integer,
cwName varchar(100),
zl varchar(100),
pz varchar(100),
sex varchar(100),
ms varchar(100),
jkzt varchar(100),
llfw varchar(100),
hjdz varchar(100),
cwnl varchar(100),
status varchar(100),
customerId int,
syrxm varchar(100),
syrsex varchar(100),
syrsfz varchar(100),
ly varchar(100),
jtzz varchar(100),
jtcy varchar(100),
syrdh varchar(100),
jjdz varchar(100)
);
–宠物字段加注释
comment on column t_cw.id is ‘主键’;
comment on column t_cw.cwName is ‘宠物别名’;
comment on column t_cw.zl is ‘种类’;
comment on column t_cw.pz is ‘品种’;
comment on column t_cw.sex is ‘性别’;
comment on column t_cw.ms is ‘毛色’;
comment on column t_cw.jkzt is ‘健康状态’;
comment on column t_cw.llfw is ‘流浪范围’;
comment on column t_cw.hjdz is ‘获救地址’;
comment on column t_cw.cwnl is ‘宠物年龄’;
comment on column t_cw.status is ‘状态’;
comment on column t_cw.customerId is ‘用户’;
comment on column t_cw.syrxm is ‘收养人姓名’;
comment on column t_cw.syrsex is ‘性别’;
comment on column t_cw.syrsfz is ‘身份证’;
comment on column t_cw.ly is ‘理由’;
comment on column t_cw.jtzz is ‘家庭住址’;
comment on column t_cw.jtcy is ‘家庭成员’;
comment on column t_cw.syrdh is ‘收养人电话’;
comment on column t_cw.jjdz is ‘交接地址’;
–宠物表加注释
comment on table t_cw is ‘宠物’;
SQLCopy
就业帮助表创建语句如下：

create table t_jybz(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100),
showDate datetime
);
–就业帮助字段加注释
comment on column t_jybz.id is ‘主键’;
comment on column t_jybz.title is ‘标题’;
comment on column t_jybz.pic is ‘图片’;
comment on column t_jybz.content is ‘内容’;
comment on column t_jybz.showDate is ‘日期’;
–就业帮助表加注释
comment on table t_jybz is ‘就业帮助’;
SQLCopy
表创建语句如下：

create table t_liuyan(
id integer,
customerId int,
toId int,
content varchar(100),
insertDate datetime,
status varchar(100),
flag varchar(100)
);
–字段加注释
comment on column t_liuyan.id is ‘主键’;
comment on column t_liuyan.customerId is ‘’;
comment on column t_liuyan.toId is ‘’;
comment on column t_liuyan.content is ‘’;
comment on column t_liuyan.insertDate is ‘’;
comment on column t_liuyan.status is ‘’;
comment on column t_liuyan.flag is ‘’;
–表加注释
comment on table t_liuyan is ‘’;
SQLCopy
物品类型表创建语句如下：

create table t_lx(
id integer,
lxName varchar(100)
);
–物品类型字段加注释
comment on column t_lx.id is ‘主键’;
comment on column t_lx.lxName is ‘物品类型’;
–物品类型表加注释
comment on table t_lx is ‘物品类型’;
SQLCopy
评论表创建语句如下：

create table t_pinglun(
id integer,
wdxxId int,
customerId int,
content varchar(100),
insertDate datetime
);
–评论字段加注释
comment on column t_pinglun.id is ‘主键’;
comment on column t_pinglun.wdxxId is ‘评论信息’;
comment on column t_pinglun.customerId is ‘评论人’;
comment on column t_pinglun.content is ‘评论内容’;
comment on column t_pinglun.insertDate is ‘评论日期’;
–评论表加注释
comment on table t_pinglun is ‘评论’;
SQLCopy
七嘴八舌表创建语句如下：

create table t_qzbs(
id integer,
customerId int,
title varchar(100),
content varchar(100),
insertDate datetime
);
–七嘴八舌字段加注释
comment on column t_qzbs.id is ‘主键’;
comment on column t_qzbs.customerId is ‘用户’;
comment on column t_qzbs.title is ‘标题’;
comment on column t_qzbs.content is ‘内容’;
comment on column t_qzbs.insertDate is ‘发布日期’;
–七嘴八舌表加注释
comment on table t_qzbs is ‘七嘴八舌’;