在edit1控件中输入用户名，然后如何使用sql语句显示有关这一用户名的信息(30分)

Q

qfy424

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-28

• #1

数据库我已经连接，其中表名是user 由2个字段，username和password
运用tquery控件query1.SQL.Add('SELECT*FROM user WHERE username？？？？
这后面应该怎么写

 

B

bbs_delphi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-28

• #2

'select * from user where username=''+edit1.text+''';

 

L

li_zhifu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-28

• #3

'Select * From [user] Where username='#39+Edit1.Text+#39+' and Password='#39+Edit2.Text+#39

 

T

tanhua

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-28

• #4

query1.sql.add('SELECT*FROM user WHERE username=:name);
query1.params.items[0].asstring := Trim(Edit1.text);

 

D

dreaveboy_zjj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-28

• #5

query1.SQL.Add('SELECT * FROM user WHERE username='+''''+username+'''')
已经经过验证是完全可以用的.

 

梦

梦菲斯

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-28

• #6

这是最基本的SQL语法啊！

 

L

liwen_big

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-28

• #7

'select * from user where username='+edit1.text;

 

L

lb_icesea79

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-28

• #8

'SELECT*FROM user WHERE username='+' '+Edit1.Text;

 

C

cuijingjun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-28

• #9

query1.sql.clear;
query1.sql.add('select * from user where username='''+edit1.text+''');
query1.open;

 

C

cooler168

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-28

• #10

三楼（tonmy）的简单实用！

 

T

tonmy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-28

• #11

'select * from user where username='''+edit1.text+'''';

 

L

lnboy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-28

• #12

Var
SQLString:String;
begin
SQLString:='select * from admin where adminname='+'"'+EditUserName.Text+'"'+' and adminpass='+'"'+EditPassword.Text+'"';
//ShowMessage(SQLString);
DataModule1.ADOquery1.SQL.Clear;
DataModule1.ADOquery1.SQL.Add(SQLString);
DataModule1.ADOquery1.Active:=True;
end;
注意SQL语句里的单引号和双引号是有区别的，一不小心就会出错。