Question

学生选课系统登录的源代码(asp+access)要怎么写?

如果用户的名称和密码都与数据库的匹配，则让他进入系统，否则不让他进入系统

Answer 1

string ls_uname,ls_pwd1,ls_pwd2,ls_sno,ls_s1
ls_uname=sle_userid.text
ls_pwd1=sle_password.text
select userName
into :ls_sno
from userTB
where userName=:ls_uname;
if sle_userid.text="" or sle_password.text="" then
messagebox("提示","用户名或密码不能为空,请输入用户名或密码！")
//sle_userid.text=""
//sle_password.text=""
return
end if
select password
into :ls_pwd2
from userTB
where userName = :ls_uname ;
//sle_1.text=ls_sno
//sle_2.text=ls_pwd2
if ls_pwd1 = ls_pwd2 then
open(w_main)
close(w_login)
else
messagebox("错误","用户名或密码错误，请重新输入!")
sle_password.text=""
return
end if
大概的形式就是这样的