您的指手将惠与我一生

Question

我已经在这个里头回答了。
http://www.csdn.net/expert/Topic/322/322240.shtm

Answer 1

看看我的这段。                With F_0.ADOQuery1 do begin
                        Close ;
                        SQL.Clear ;
                        SQL.Add( 'insert  usertable ( no , username , password , enabeld , userchangepw) values ( '
                                + IntToStr( MaxNum ) + ' , '
                                + '''' + F_1.UserManager.UserName + '''' + ' , '
                                + '''' + F_1.UserManager.PassWord + '''' + ' , '
                                + '''' + F_1.UserManager.Enabled + '''' + ' , '
                                + '''' + F_1.UserManager.UserChangePw + ''''                                                                                                + ')' ) ;
                        Prepared ;
                        Try
                                ExecSQL ;
                                Application.MessageBox( '恭喜，增加用户成功！' , '提示' , MB_OK + MB_ICONINFORMATION ) ;
                        Except                                Application.MessageBox( '错误发生，增加用户失败！' , '提示' , MB_OK + MB_ICONINFORMATION ) ;
                        end ;

Answer 2

如果想要在SQL语句里面加入变量呢?

Answer 3

那就是参数一说。
而我是用字符串相加的。+ '''' + F_1.UserManager.UserName + '''' + ' , '
                                + '''' + F_1.UserManager.PassWord + '''' + ' , '
                                + '''' + F_1.UserManager.Enabled + '''' + ' , '
                                + '''' + F_1.UserManager.UserChangePw + ''''                                                                                                
是吧？？？