查询 查询所有 select * from tablename 通过id查询 select * from tablename where id= 插入 insert into tableame (id,name,pwd) values ( , , ); 修改 update tablename set name= ,pwd= where id= ; 删除 delete from tablename where id= ;