如何一次向多个表中写入数据示例

<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

set rs=server.createobject("ADODB.RECORDSET")

rs.open "表1",conn,1,3
rs.addnew
rs("username") = yourname
rs.update
rs.close

rs.open "表2",conn,1,3
rs.addnew
rs("username") = yourname
rs.update
rs.close

rs.open "表3",conn,1,3
rs.addnew
rs("username") = yourname
rs.update
rs.close

set rs = nothing