midp1_delete.asp

j2me lan 聊天 server 基于 servlet 使用向导： ◆数据库管理 访问mssdataadmin目录的 default.asp ◆手机wap下载java客户程序的连接 mi

<%
msid=Request("id")
userName=Request("user")
passWord=Request("pass")
	Set conn=Server.CreateObject("ADODB.connection")
	conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("mssdata.mdb")
	conn.Open
	Set rs = Server.CreateObject("ADODB.Recordset")
	sql="Select user From sanchat_users where user='" &userName& "' and pass='" &passWord& "'"
	rs.open sql,Conn,3,3
	if rs.eof<>true then
		rs.close
		sql="select tou From sanchat_mss where id=" &msid
		rs.open sql,Conn,3,3
		if rs.eof<>true then
			if strcomp(rs("tou"),userName)=0 then
				rs.close
				sql="Delete From sanchat_mss where id=" &msid
				conn.execute(sql)
				response.write "1"
			else 
				response.write "0"
			end if
		else 
			response.write "0"
		end if
	else
		response.write "0"
	end if
	'rs.close
	conn.close
	set rs=nothing
	set conn=nothing
	session.abandon
%>