with query1 do
begin
close;
sql.clear;
sql.add('insert into tab1 values(''al'',:str)');
parambyname('str').asstring:=str;
execsql;
end;
begin
close;
sql.clear;
sql.add('insert into tab1 values(''al'',:str)');
parambyname('str').asstring:=str;
execsql;
end;
java中可以用下面那个转换一下
public static String escapeSQLTags(String s){
if(s==null||s.length()==0){
return s;
}
StringBuffer buf =new StringBuffer();
char ch=' ';
for(int i=0;i<s.length();i++){
ch=s.charAt(i);
if(ch=='\''){
buf.append("\'\'");
}
else{
buf.append(ch);
}
}
return buf.toString();
}
delphi也可以类似处理吧
with query1 do
begin
close;
sql.clear;
sql.add('insert into tab1 values(:str)');
parambyname('str').asstring:=str;
execsql;
end;
str:='i don'+"'"+'t knot';
用"'"即可表示 '
str:='i don'+''''+'t knot';
用''''(连续四个')即可表示 '