$(db)sql;…

sql

A SQL statement in the form of select * from table, for example; the SQL statement must be one of select/insert/delete/update statements

(db)

Data source name

…

Argument value passed to the SQL statement

A

1

$select * from EMPLOYEE

No data source is specified in the previous statement since parameter (db) is absent, and error report appears if there isn’t a currently connected data source.

2

$(demo)select * from EMPLOYEE where EID=?;1

Find the employees whose EID is 1 from the demo data source.

3

$select * from EMPLOYEE where EID in (?) or GENDER=?;[1,3,5,7],"M"

Since parameter (db) is absent, the program uses the demo data source defined in the previous statement to find the employees whose EID is [1,3,5,7] and gender is M.

A

B

1

$(demo)insert into EMPLOYEE (EID, NAME) values(?,?);100,"test"

Insert statement.

2

[51,52,53,54]

3

for A2

4

$insert into STATECAPITAL (STATEID) values(?);A3

Since parameter (db) is absent, the program uses the demo data source defined in the previous statement; pass members of A2’s sequence to B4’s statement as parameters by loop.

A

1

$(demo)delete from EMPLOYEE where EID =? or EID=?;100,101

2

$delete from EMPLOYEE where EID in(?);[1,5,7,9]

3

$delete from EMPLOYEE where NAME ='Rebecca'

Since parameter (db) is absent and no data source is specified in the previous statement, the program uses one of the currently connected data sources.

A

1

$(demo)update EMPLOYEE set NAME =?, GENDER=?

where EID =?;"testnew","M",100

2

$update EMPLOYEE set NAME ='Peter' where EID =10

Since parameter (db) is absent, the program uses the data source defined in the previous statement to modify the NAME of the employee whose EID is 10 to Peter.

3

$(sql)update Family set Name='Rose' where Eid=?;2

Update the name of a record of Family whose Eid is 2 by connecting to a data source named sql.