midp1_read.asp

来自「j2me lan 聊天 server 基于 servlet 使用向导： 」· ASP 代码 · 共 37 行

<%
userName=Request("user")
passWord=Request("pass")
fromwho=Request("from")

	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 content From sanchat_mss where tou='" &userName& "' and fromu='" &fromwho& "' and notread='1'"
		rs.open sql,Conn,3,3
		if rs.eof<>true then
			'response.write Uni("　")
			response.write rs("content")
		end if
	else
		response.write "what are you doing?"
	end if
	rs.close
	conn.close
	set rs=nothing
	set conn=nothing
	session.abandon

Function Uni(Byval Chinese)
Dim i
For i = 1 to Len (Chinese)
A=Mid(Chinese, i, 1)
Uni=Uni & "&#x" & Hex(Ascw(A)) & ";"
Next
End Function

%>