我正在嘗試將Stringsql插入我的數(shù)據(jù)庫中。該字符串可以包含一個“ ' ”。當(dāng)我現(xiàn)在嘗試將其插入數(shù)據(jù)庫時,出現(xiàn)此錯誤:[SQLITE_ERROR] SQL錯誤或缺少數(shù)據(jù)庫(“ ':語法錯誤后的”字符附近)函數(shù)調(diào)用: Main.execute("INSERT INTO Projektname(projektname) VALUES('" + txtFd_name.getText() + "');");Main.execute:public static void execute(String query){ class.forName("org.sqlite.JDBC"); Connection conn = DriverManager.getConnection("jdbc:sqlite:D:\\user\\eclipse-workspace\\S2LDB.db"); Statement stat = conn.createStatement(); stat.execute(query);}我嘗試過 org.apache.commons.text.StringEscapeUtils.escapeJava()
3 回答

墨色風(fēng)雨
TA貢獻(xiàn)1853條經(jīng)驗 獲得超6個贊
我把這篇文章固定為兩個。像這樣的東西:
Main.execute("INSERT INTO Projektname(projektname) VALUES(''" + txtFd_name.getText() + "'');");
添加回答
舉報
0/150
提交
取消