创新举措是什么意思:ASP+ACCESS数据库如何更新数据！

方法1:
<%
dim conn,connstr
set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db1.mdb")
conn.Open connstr
set rs=server.createobject("adodb.recordset")
sql="Select * from [User] where userid="& userid
rs.open sql,conn,1,3
if rs.eof and rs.bof then
response.write "该用户名不存在。"
else
rs("password")=trim(request.form("password")
rs("skin")=teim(request.form("skin"))
rs.Update
Response.write "修改成功!"
end if
rs.close
set rs=nothing
%>
2.还有一种方法,直接运行sql语句:

<%
dim conn,connstr
set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db1.mdb")
conn.Open connstr
name1=request.form("musicname")
name2=request.form("musicname1")
idd=request.form("idd")
if name1<>"" then
sql="UPDATE [music] set musicname='"& name1 &"',musicname1='"& name2 &"' where id="&idd
conn.execute(sql)
response.write ("<br><br><center>歌曲修改成功!</center><br>")
else
response.write("<br><br><center>错误，歌曲名为空！</center>")
end if
%>

上面两种方法都对 方式都一样的