本人学识尚浅!高手师傅们,帮忙将下列asp代码“翻译”成jsp代码。mySQL = "SELECT * FROM user where IDname='" & username & "'"
rs.Open mySQL,conn,1,3
if not (rs.Bof or rs.eof) then
isun="true"
end if
If not isun="true" Then
rs.addnew
rs("IDname")=username
rs("passwd")=passwd
rs("name")=realname
rs("num")=num
rs("email")=email
rs("dept")=department
rs("class")=yourclass
rs("enroltime")=date()
rs.update
sql= "UPDATE class Set amount=amount+1 where dept = '"&department&"'"
conn.Execute(sql)
end ifrs.close
set rs=nothing
conn.Close
set conn=nothing
rs.Open mySQL,conn,1,3
if not (rs.Bof or rs.eof) then
isun="true"
end if
If not isun="true" Then
rs.addnew
rs("IDname")=username
rs("passwd")=passwd
rs("name")=realname
rs("num")=num
rs("email")=email
rs("dept")=department
rs("class")=yourclass
rs("enroltime")=date()
rs.update
sql= "UPDATE class Set amount=amount+1 where dept = '"&department&"'"
conn.Execute(sql)
end ifrs.close
set rs=nothing
conn.Close
set conn=nothing
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货