Lowest price ever! Learn Generative AI for 48% less!
Get my discount0
how to get sting value in query
System.out.print("Enter MName= "); mname=br.readLine(); su ="UPDATE contact SET mname= "+ mname +" WHERE id="+cid; System.out.println(su); n=s.executeUpdate(su);
2 Answers
+ 3
Sahil Kshirsagar https://stackoverflow.com/questions/36146935/how-to-query-for-a-string-in-java-jdbc
Hope it's helpful to you
+ 4
You should never use string concatenation to write SQL. This is how you can fall victim to code injection attacks. You should use PreparedStatement instead, as suggested in the stackoverflow article linked by Sakshi.
https://www.baeldung.com/java-statement-preparedstatement