Java毕业设计_基于Android的签到点名系统

基于Android的签到点名系统

基于Android的签到点名系统mysql数据库创建语句
基于Android的签到点名系统oracle数据库创建语句
基于Android的签到点名系统sqlserver数据库创建语句
基于Android的签到点名系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
基于Android的签到点名系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
高质量编程视频：shangyepingtai.xin
基于Android的签到点名系统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 ‘姓名’,
sex varchar(100) comment ‘性别’,
address varchar(100) comment ‘地址’,
mobile varchar(100) comment ‘手机’
) comment ‘客户’;
SQLCopy
公告表创建语句如下：

create table t_gg(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
pic varchar(100) comment ‘图片’,
content varchar(100) comment ‘内容’,
showDate varchar(100) comment ‘日期’
) comment ‘公告’;
SQLCopy
课程表创建语句如下：

create table t_kc(
id int primary key auto_increment comment ‘主键’,
teacherId int comment ‘老师’,
kcName varchar(100) comment ‘课程名称’,
pic varchar(100) comment ‘图片’,
content varchar(100) comment ‘课程内容’
) comment ‘课程’;
SQLCopy
课程签到表创建语句如下：

create table t_kcqd(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
kcId int comment ‘课程’,
insertDate datetime comment ‘日期’,
jwd varchar(100) comment ‘经纬度’
) comment ‘课程签到’;
SQLCopy
用户选择课程表创建语句如下：

create table t_kcxz(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
kcId int comment ‘课程’
) comment ‘用户选择课程’;
SQLCopy
信息交流表创建语句如下：

create table t_message(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
messageContent varchar(100) comment ‘内容’,
types int comment ‘’,
insertDate datetime comment ‘时间’
) comment ‘信息交流’;
SQLCopy
老师表创建语句如下：

create table t_teacher(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
teacherName varchar(100) comment ‘姓名’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
phone varchar(100) comment ‘电话’,
pic varchar(100) comment ‘头像’
) comment ‘老师’;
SQLCopy
基于Android的签到点名系统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),
sex varchar(100),
address varchar(100),
mobile 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.sex is ‘性别’;
comment on column t_customer.address is ‘地址’;
comment on column t_customer.mobile is ‘手机’;
–客户表加注释
comment on table t_customer is ‘客户’;
SQLCopy
公告表创建语句如下：

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

create table t_kc(
id integer,
teacherId int,
kcName varchar(100),
pic varchar(100),
content varchar(100)
);
–课程字段加注释
comment on column t_kc.id is ‘主键’;
comment on column t_kc.teacherId is ‘老师’;
comment on column t_kc.kcName is ‘课程名称’;
comment on column t_kc.pic is ‘图片’;
comment on column t_kc.content is ‘课程内容’;
–课程表加注释
comment on table t_kc is ‘课程’;
SQLCopy
课程签到表创建语句如下：

create table t_kcqd(
id integer,
customerId int,
kcId int,
insertDate datetime,
jwd varchar(100)
);
–课程签到字段加注释
comment on column t_kcqd.id is ‘主键’;
comment on column t_kcqd.customerId is ‘用户’;
comment on column t_kcqd.kcId is ‘课程’;
comment on column t_kcqd.insertDate is ‘日期’;
comment on column t