ASP添加记录

<!--#include file="conn.asp"-->
<%
dim mingcheng,jiage
mingcheng=trim(request.Form("mingc"))
jiage=trim(request.Form("jiag"))
   set rs=server.CreateObject("adodb.recordset")
       rs.open"select * from jg ",conn,1,3
    rs.addnew
       rs("mingcheng")=trim(request.Form("mingc"))
       rs("jiage")=trim(request.Form("jiag"))
    rs.update
    response.write "<script>"
  response.write "alert('记录添加成功!');window.location='tianjiayz1.asp'"
  response.write "</script>"
rs.close
set rs=nothing
conn.close
set conn=nothing
%>