sql连表增删改查

第一条登录查询  （userlist）
SELECT *
  FROM [CenterControl2].[dbo].[userlist] WHERE  name = 'wework'
  and pass = 'wework'

android语句:
select * from [userlist]where 1=1 and name=3and pass=4

首页获取：编写连表查询获取设备控制，场景控制，分组控制数据个数
 select sum(t.num1) as deviceCount,sum(t.num2) as sceneCount,sum(t.num3) as controlCount from (
    select count(*) num1,0 as num2,0 as num3 from [CenterControl2].[dbo].[controller]
  union 
    select 0 as num1,count(*) num2,0 as num3 from [CenterControl2].[dbo].[scene]
    union 
    select 0 as num1,0 as num2,count(*) num3 from [CenterControl2].[dbo].[group]
) t

首页获取：编写连表查询获取分组控制，通过group表去找groupcontroller表中的controllerID去controller表中去找相应设备；
长按分组控制时显示出来（以列表的形式）；
长按分组控制sql语句:
 select control.name from [CenterControl2].[dbo].[controller] control where control.id =ANY
  (select [controllerID]  from [CenterControl2].[dbo].[groupcontroller]  groupc 
  where groupc.groupID = 3)

数据库插入动作之分组详情-》 INSERT INTO [CenterControl2].[dbo].[group] ([name], [type]) VALUES ('新风组3','新风')

数据库控制动作之-》设备控制： INSERT INTO [CenterControl2].[dbo].[operate] ([status],[flag],[ip]) SELECT 1,0,com.ip FROM [CenterControl2].[dbo].[communicator] com where com.id = 1