By using PreparedStatement, I have no problem with insert and update. But when I am doing select, preparedstatement doesn't take care of '\'' for me.
For example, I have a sql statement.
String sqlStatement = " select * from mytable where text = 'Elenor's home'";
I am wondering besides replacing the '\'' with "''", is there any other ways to do it? Any idea will be helpful!
Thanks in advance!