怎么连接sql2000数据库并进行session验证,密码是二进制的,请前辈详细指点,急!!unit FrmLogin;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, DB, ADODB;type
TFormLogin = class(TForm)
GroupBox1: TGroupBox;
Button1: TButton;
Button2: TButton;
Label1: TLabel;
Label2: TLabel;
EditName: TEdit;
EditPass: TEdit;
ADOQuery1: TADOQuery;
procedure Button1Click(Sender: TObject); //procedure show(Sender: TObject);
private { Private declarations }
public
{ Public declarations } end;
var
FormLogin: TFormLogin;implementationuses FrmMain;{$R *.dfm}procedure TFormLogin.Button1Click(Sender: TObject);
var
f: TextFile;
begin AdoQuery1.Active := False;
AdoQuery1.SQL.Clear;
AdoQuery1.SQL.Add('SELECT id FROM UserInfo WHERE UserName=''' + EditName.Text +
''' and Password=''' + EditPass.Text + '''');
AdoQuery1.Open;
if AdoQuery1.IsEmpty then //没有此用户
begin
ShowMessage('帐号错误!');
end
else
begin
AssignFile(f,'C:\tmp.txt');
rewrite(f);
WriteLn(f,EditName.Text);
WriteLn(f,EditPass.Text);
CloseFile(f);
self.ModalResult := mrOk; //返回mrOk,说明登陆成功 Application.ShowMainForm:=false;
Form1.show;
end;
AdoQuery1.Active := False;
end;end.
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, DB, ADODB;type
TFormLogin = class(TForm)
GroupBox1: TGroupBox;
Button1: TButton;
Button2: TButton;
Label1: TLabel;
Label2: TLabel;
EditName: TEdit;
EditPass: TEdit;
ADOQuery1: TADOQuery;
procedure Button1Click(Sender: TObject); //procedure show(Sender: TObject);
private { Private declarations }
public
{ Public declarations } end;
var
FormLogin: TFormLogin;implementationuses FrmMain;{$R *.dfm}procedure TFormLogin.Button1Click(Sender: TObject);
var
f: TextFile;
begin AdoQuery1.Active := False;
AdoQuery1.SQL.Clear;
AdoQuery1.SQL.Add('SELECT id FROM UserInfo WHERE UserName=''' + EditName.Text +
''' and Password=''' + EditPass.Text + '''');
AdoQuery1.Open;
if AdoQuery1.IsEmpty then //没有此用户
begin
ShowMessage('帐号错误!');
end
else
begin
AssignFile(f,'C:\tmp.txt');
rewrite(f);
WriteLn(f,EditName.Text);
WriteLn(f,EditPass.Text);
CloseFile(f);
self.ModalResult := mrOk; //返回mrOk,说明登陆成功 Application.ShowMainForm:=false;
Form1.show;
end;
AdoQuery1.Active := False;
end;end.
解决方案 »
- ★★★★★--如何取得IE的COOKIE,InternetGetCookie在xp_sp2上不能用
- adoQuery简单又奇怪的问题!高手来,小虾也来,你们应该也碰到过吧!!!
- 用 CreateFileMapping创建共享内存,如何实现该内存对应链表结构,并实现结点的读写
- 求编写 ERP 财务 功能的 教程 !!!!!!!!!!!!!!!!!!!!!!急!!!!!!!!!!!!!!!!
- 如果数据库中的某个表的结构不能确定(一些字段可能会变化),请问可不可以在Delphi中用sql语句createtbale创建该表?用此方法麻烦不?不
- 一个简单的程序,为什么panle不见了,
- 怎么样同时监听3个端口?要用到多线程吗。。。
- delphi下如何通过调用modem实现俩端信息传递
- 请问到北京找工作,去那个地方,什么方式?怎么办?????
- 请问如何判断文件是否允许打开?
- 非常奇怪的异常问题
- 有一个字段,原来是整型,我查询为什么不能再往里面加数据?
var s1:string;
begin
s1:='Provider=SQLOLEDB.1;Password='+密码+';Persist Security Info=True;User ID='+用户+';Initial Catalog='+数据库+';Data Source='+数据库地址;
DataModule1.ADOConn.Close;
DataModule1.ADOConn.ConnectionString:=s1;
try
DataModule1.ADOConn.Open;
showmessage('数据库连接成功!');
except
showmessage('数据库连接失败!');
end;
这个Password 怎么传
begin
WebBrowser1.Navigate(Edit1.Text+'?UID='+LoginForm.EditName.Text+'&PWD='+LoginForm.EditPass.Text);
//Edit1.Text 常规网址.如:http://www.csdn.com
end;procedure TForm1.WebBrowser1DownloadBegin(Sender: TObject);
begin
StatusBar1.Panels[0].Text:='正在连接:' + WebBrowser1.LocationURL;
end; 传递Password 是不是要解密啊