图1 图2 (2)查询用户窗体w_seek,如图2所示。 (3)信息维护窗体w_pre,如图3所示。 图3 核心代码 app_sy下的代码为: // Profile Dianshang = "ODBC" = False = "Connectstring='DSN=dianshang'" connect using sqlca; if <> 0 then messagebox("提示","数据库连接错误") end if open (w_main) 登录窗体w_main“确定”按钮下的代码为: string id,pwd id = pwd = int kk SELECT count(*) INTO :kk FROM "dianshang_login" WHERE "dianshang_login"."sy_id" = :id ; if kk < 1 then messagebox("提示","没有该用户") return end if string mm SELECT sy_pwd INTO :mm FROM "dianshang_login" WHERE "dianshang_login"."sy_id" = :id ; if mm <> pwd then messagebox("提示","密码错误,请重新输入!") return end if open(w_seek) close(parent) 查询用户窗体w_seek“确定”按钮下的代码为: string id id = int kk SELECT count(*) INTO :kk FROM "dianshang_login" WHERE "dianshang_login"."sy_id" = :id ; if kk < 1 then messagebox("提示","没有该用户") return end if string mm SELECT sy_pwd INTO :mm FROM "dianshang_login" WHERE "dianshang_login"."sy_id" = :id ; = id = mm 查询用户窗体w_pre“添加”按钮下的代码为: string id,pwd id = pwd = if trim(id) = "" then messagebox("提示","用户名不能为空!") () return end if int kk SELECT count(*) INTO :kk FROM "dianshang_login" WHERE "dianshang_login"."sy_id" = :id ; if kk > 0 then messagebox("提示","该用户已经存在,无法添加") ret
中国古典音乐 China classical music 英文介绍 来自淘豆网www.taodocs.com转载请标明出处.