安卓期末大作业（AndroidStudio开发），垃圾分类助手app，分为前台后台，代码有注释，均能正常运行

rubbish.db create table user (uid INTEGER primary key autoincrement,username varchar(32) not null,password varchar(64) not null,telephone varchar(11),sex varchar(2) not null,image_user varchar(300),state tinyint(1) not null) insert into user (username,password,sex,state) values ('admin','admin','男',0); create table rubbish (rid INTEGER primary key autoincrement,rname varchar(100) not null,cid INTEGER not null) create table category (cid INTEGER primary key autoincrement,cname varchar(100) not null,image_cat varchar(300) not null,description varchar(400)) create table news (nid INTEGER primary key autoincrement,image_news varchar(300),title varchar(50) not null,content varchar(500) not null,createtime datetime not null)