[問題] JSP無法存入單引號進SQL
用JSP寫入包含單引號的字串時，
會發生錯誤，爬文之後也嘗試使用用string.replace("'","''");
也就是說用兩個單引號取代一個單引號
或是以"/'"進行取代
但仍然無法解決
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ''primosomal
protein N'')' at line 1
錯誤如上
不知道大家有沒有甚麼解決方法
麻煩各位了
==================
恩 我使用的是MYSOL
語法為
INSERT INTO ptt(Genome, PID, Synonym, Gene, Location, Strand, Length, Code,
COG, Product)VALUES('Acholeplasma laidlawii
PG-8A','162447190','ACL_0324','-','333175..335439','+','754','-','COG1198L','primosomal
protein N'');
==================
部分程式碼如下
while((lineStr = br.readLine()) != null) {
stmt = conDB.createStatement();
String splitdata[]=lineStr.split("\t");
splitdata[8].replaceAll("'", "''");
String updataCode = "INSERT INTO ptt(Genome, PID, Synonym, Gene,
Location, Strand, Length, Code, COG, Product)VALUES" +
"('"+genomeName+"','"+ splitdata[3]+"','"+
splitdata[5]+"','"+splitdata[4]+"','"+ splitdata[0]+"','"
+splitdata[1]+"','"+ splitdata[2]+"','"+splitdata[6]+"','"+
splitdata[7]+"','"+splitdata[8]+"');";
System.out.println(updataCode);
stmt.executeUpdate(updataCode);
}
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 203.64.101.194
→
01/03 22:07, , 1F
01/03 22:07, 1F
→
01/03 22:08, , 2F
01/03 22:08, 2F
推
01/03 22:10, , 3F
01/03 22:10, 3F
→
01/03 22:12, , 4F
01/03 22:12, 4F
※ 編輯: BIGBLACK918 來自: 203.64.101.194 (01/03 22:15)
※ 編輯: BIGBLACK918 來自: 203.64.101.194 (01/03 22:19)
→
01/03 22:18, , 5F
01/03 22:18, 5F
→
01/03 22:22, , 6F
01/03 22:22, 6F
→
01/03 22:25, , 7F
01/03 22:25, 7F