procedure TMainForm.ServerSocket1ClientRead(Sender: TObject;
Socket: TCustomWinSocket);
var
str: string;
USER, UserName, PassWord, xinming, xinbie, dizhi, yidongdianhua, zuoji, email: string;
s: array[0..25] of Char;
begin str := Socket.ReceiveText; if Pos('reg_', str) > 0 then
begin str := Copy(str, 5, Length(str) - 4);
UserName := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
PassWord := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
xinming := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
xinbie := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
dizhi := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
yidongdianhua := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
zuoji := Copy(str, 1, Pos('_', str) - 1);
email := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from vo_userinfor where username=:username');
ADOQuery1.Parameters.ParamByName('username').Value := UserName;
ADOQuery1.Open;
if ADOQuery1.RecordCount >= 1 then
begin s := '用户名已经被注册!'; Send(Socket.SocketHandle, s, SizeOf(s), 0);
Exit;
end
else
begin ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('insert into vo_userinfor(turename,username,userpassword,departmentid,fd_employee_isdeleted,xinming,xinbie,dizhi,yidongdianhua,zuoji,email) values(:user,:username,:password,1,0,:xinming,:xinbie,:dizhi,:yidongdianhua,:zuoji,:email)'); ADOQuery1.Parameters.ParamByName('user').Value := USER; ADOQuery1.Parameters.ParamByName('username').Value := UserName;
ADOQuery1.Parameters.ParamByName('password').Value := PassWord;
ADOQuery1.Parameters.ParamByName('xinming').Value := xinming; ADOQuery1.Parameters.ParamByName('xinbie').Value := xinbie; ADOQuery1.Parameters.ParamByName('dizhi').Value := dizhi; ADOQuery1.Parameters.ParamByName('zuoji').Value := zuoji; ADOQuery1.Parameters.ParamByName('email').Value := email;
ADOQuery1.ExecSQL;
showmessage('4');
s := '注册成功!';
Send(Socket.SocketHandle, s, SizeOf(s), 0);
Exit;
上面是代码,执行行 ADOQuery1.Parameters.ParamByName('password').Value := PassWord;就不执行了
ADOQuery1.Parameters.ParamByName('xinming').Value := xinming; ADOQuery1.Parameters.ParamByName('xinbie').Value := xinbie; ADOQuery1.Parameters.ParamByName('dizhi').Value := dizhi; ADOQuery1.Parameters.ParamByName('zuoji').Value := zuoji; ADOQuery1.Parameters.ParamByName('email').Value := email;
ADOQuery1.ExecSQL;
showmessage('4');
s := '注册成功!';
Send(Socket.SocketHandle, s, SizeOf(s), 0);
Exit;
Socket: TCustomWinSocket);
var
str: string;
USER, UserName, PassWord, xinming, xinbie, dizhi, yidongdianhua, zuoji, email: string;
s: array[0..25] of Char;
begin str := Socket.ReceiveText; if Pos('reg_', str) > 0 then
begin str := Copy(str, 5, Length(str) - 4);
UserName := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
PassWord := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
xinming := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
xinbie := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
dizhi := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
yidongdianhua := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
zuoji := Copy(str, 1, Pos('_', str) - 1);
email := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from vo_userinfor where username=:username');
ADOQuery1.Parameters.ParamByName('username').Value := UserName;
ADOQuery1.Open;
if ADOQuery1.RecordCount >= 1 then
begin s := '用户名已经被注册!'; Send(Socket.SocketHandle, s, SizeOf(s), 0);
Exit;
end
else
begin ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('insert into vo_userinfor(turename,username,userpassword,departmentid,fd_employee_isdeleted,xinming,xinbie,dizhi,yidongdianhua,zuoji,email) values(:user,:username,:password,1,0,:xinming,:xinbie,:dizhi,:yidongdianhua,:zuoji,:email)'); ADOQuery1.Parameters.ParamByName('user').Value := USER; ADOQuery1.Parameters.ParamByName('username').Value := UserName;
ADOQuery1.Parameters.ParamByName('password').Value := PassWord;
ADOQuery1.Parameters.ParamByName('xinming').Value := xinming; ADOQuery1.Parameters.ParamByName('xinbie').Value := xinbie; ADOQuery1.Parameters.ParamByName('dizhi').Value := dizhi; ADOQuery1.Parameters.ParamByName('zuoji').Value := zuoji; ADOQuery1.Parameters.ParamByName('email').Value := email;
ADOQuery1.ExecSQL;
showmessage('4');
s := '注册成功!';
Send(Socket.SocketHandle, s, SizeOf(s), 0);
Exit;
上面是代码,执行行 ADOQuery1.Parameters.ParamByName('password').Value := PassWord;就不执行了
ADOQuery1.Parameters.ParamByName('xinming').Value := xinming; ADOQuery1.Parameters.ParamByName('xinbie').Value := xinbie; ADOQuery1.Parameters.ParamByName('dizhi').Value := dizhi; ADOQuery1.Parameters.ParamByName('zuoji').Value := zuoji; ADOQuery1.Parameters.ParamByName('email').Value := email;
ADOQuery1.ExecSQL;
showmessage('4');
s := '注册成功!';
Send(Socket.SocketHandle, s, SizeOf(s), 0);
Exit;
解决方案 »
- 請教:在ie中可以顯示的網頁,在webbrowser中確無法顯示,怎麼回事?在線等!給100分
- 急啊!怎么取得一个整形数组里面两个最大的数?
- 请教创建datamodual窗口有什么用?怎么用啊?
- csdn人都是活雷锋
- 怎样备份数据库文件?
- pascal中有类似c语言中的argc,argv的命令行参数传递吗?
- 订单系统引起的主/从联想
- 能把IMAGEEN 中文的帮助说明文档给我发一份吗?
- 登录+主窗体+MDI窗体:登录→主窗体→MDI窗体,打开MDI窗体时报错,但如果去掉登录窗体(主窗体→MDI窗体)就能够正常打开MDI窗体
- 各位拉我一把, 说实话如果我实现不了这图表曲线问题我也该换饭碗拉。送200分
- DELPHI2007 能否顺利编译 delphi7 程序?
- 关于生成richedit控件的问题,麻烦解答一下
UserName := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
PassWord := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
xinming := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
xinbie := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
dizhi := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
yidongdianhua := Copy(str, 1, Pos('_', str) - 1);
str := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
zuoji := Copy(str, 1, Pos('_', str) - 1);
email := Copy(str, Pos('_', str) + 1, Length(str) - Pos('_', str));
在这已经全赋值了,
2.可以把这部分的adoquery1换成一个新的adoquery试试.
跟踪一下看取值是否正确
如有乱码,或其它数据库不认识的编码
这些问题都可以导致写数据库失败