In fact, you can also do this:
var Room = [
{
ID: 'bot',
name: 'test',
sex: true
}, {
ID: 2,
name: 'test8',
sex: true
}, {
ID: 3,
name: 'test5',
sex: false
}, {
ID: 4,
name: 'test2',
sex: true
}];
"update Room set name = 'man' where sex=true".executeSQL();
Supported SQL The statements include SELECT INSERT UPDATE DELETE CREATE TABLE DROP TABLE
3. As mentioned last time, I found that DOM can actually be operated with SQL
For example, you can directly insert 100 image elements as follows:
'create table logolist'.ForDOM().executeSQL();
for (var i=0;i<100;i ) {
"insert into logolist(nodename,title,src) values ('img','google','images/google.gif')".ForDOM() .execute();
};
Then use UPDATE to update the src attribute of the image element:
("update logolist set src='" logo1 "'").ForDOM().execute();
or DELETE these that meet the conditions Element:
("delete from logolist where title='google'") .ForDOM().execute();
Or act as a selector:
var result = ("select * from logolist").ForDOM().execute();
for(var i=0;iresult[i].src = 'baidu.gif';
};
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
