对于有","和"'"符号向数据库提交问题？

Question

可以使用rs.updateString()写入。
-------------------------
39度十几天了，41度三四天了，今天41度，明天还是41度，没有空调，没有MM，叫我怎么活？
我就要被烤成人干了，救命啊……
20多天没下过雨，也没有阴天过，甚至连多云都很少出现过。
-------------------------
我流落在凄凉的世界里－孤苦伶仃
我过着动荡无助的生活－四处漂泊

Answer 1

这是我以前用asp时用的，你看看，改一下就可以了。就是进行转化一下： Function decode(Str)
     str=replace(str,"'","‘")   
     str=replace(str,Chr(13)&Chr(10),"<br>")
     str=replace(str,Chr(10),"<br>")     
     str=replace(str,"""","\""")  
     decode=str
 end function
 
  
 Function encode(Str)
Str=Replace(Str,"'","’")
Str=Replace(Str,"""","“")
'Str=Replace(Str,"<","&lt")
Str=Replace(Str,"<","《")
'Str=Replace(Str,">","&gt")
Str=Replace(Str,">","》")
Str=Replace(Str,"%","%%")
str=Replace(str,"&","＆")
encode=Str
 end function

Answer 2

能不能说的详细一点，在jsp中到底应该怎么弄？up

Answer 3

str.replace("'","''");一个单引号换成两个单引号

Answer 4

str.replaceAll("'","''");一个单引号换成两个单引号

Answer 5

请使用preparedStatement
sql = "insert into t1(answer) values (?)";
PreparedStatement= conn.prepareStatement(sql);
pst.setString(1,"'");//不会出错了
pst.executeUpdate();

Answer 6

Function decode(Str)
     str=replace(str,"'","‘")   
     str=replace(str,Chr(13)&Chr(10),"<br>")
     str=replace(str,Chr(10),"<br>")     
     str=replace(str,"""","\""")  
     decode=str
 end function
 
  
 Function encode(Str)
Str=Replace(Str,"'","’")
Str=Replace(Str,"""","“")
'Str=Replace(Str,"<","&lt")
Str=Replace(Str,"<","《")
'Str=Replace(Str,">","&gt")
Str=Replace(Str,">","》")
Str=Replace(Str,"%","%%")
str=Replace(str,"&","＆")
encode=Str
 end function
我认为这个方法挺好的，大家认为呢？？？？