修改
dim rs as new adodb.recordset
rs.open "select * from 表 where id=1", cnn, adOpenDynamic, adLockPessimistic
rs!name="张三"
rs.update
删除
dim rs as new adodb.recordset
rs.open "select * from 表 where id=1", cnn, adOpenDynamic, adLockPessimistic
rs.delete
rs.update
添加
dim rs as new adodb.recordset
rs.open "select * from 表 where 0=1", cnn, adOpenDynamic, adLockPessimistic
rs.addnew
rs!ID=1
rs!name="李四"
rs.update