代码：SQlite建立用户表和智能家居状态表用户表内容包括用户名密码智能家居状态表包括家居名称家居状态值模式一个用户对应一个智能家居状态表通过键值对连接并插入数据不要用python-- 创建用户表CREATE TABLE IF NOT EXISTS users uid INTEGER PRIMARY KEY AUTOINCREMENT username varchar10;

-- 创建用户表 CREATE TABLE IF NOT EXISTS users ( uid INTEGER PRIMARY KEY AUTOINCREMENT, username varchar(10), passwd varchar(10) ); INSERT INTO users (username, passwd) VALUES ('AA', '123456'); INSERT INTO users (username, passwd) VALUES ('B', '121212');

-- 创建智能家居状态表 CREATE TABLE IF NOT EXISTS Status ( sid INTEGER PRIMARY KEY AUTOINCREMENT, uid INTEGER , device_name varchar(10), device_state varchar(10), value REAL, mode varchar(10), FOREIGN KEY (uid) REFERENCES users (uid) ); INSERT INTO Status(uid, device_name, device_state, value, mode) VALUES (1, 'Curtains', 'On', 1.1, '睡眠模式');