unidac+mssql 增查改删

增

unqry1.Close;
unqry1.SQL.Clear;
unqry1.SQL.add('insert into hy_user(hy_user,password,guizu,logintime) values(''' + trim(edt1.Text) + ''',''' + password + ''',''' + cbb1.text + ''',''' + DateTimetostr((now())) + ''')');
unqry1.ExecSQL;

查

unqry1.Close;
unqry1.SQL.Clear;
unqry1.SQL.Add('select * from pinpai where guizu=''' + g2 + '''');
unqry1.Open;

改

unqry2.Close;
unqry1.SQL.Clear;
unqry1.SQL.Add('Update hy_user set logintime=''' + DateTimetostr((now())) + ''' where hy_user=''' + userID + '''');
unqry1.ExecSQL;

删

unqry1.SQL.Clear;
unqry1.SQL.add('DELETE FROM goodstp where ID='''+tpid+'''');
unqry1.ExecSQL;