SQL Query based on user input in Java

Question

dis = new DataInputStream(csocket.getInputStream());
int choice = dis.readInt();
Connection conn = MySqlConnect.ConnectDB();
PreparedStatement pst = conn.prepareStatement("Select hostname from clients where C_ID=");
ResultSet rs = pst.executeQuery();

How can I put choice into the given query?

https://docs.oracle.com/javase/tutorial/jdbc/basics/prepared.html#supply_values_ps — brso05, Apr 25 '16 at 17:51
http://stackoverflow.com/questions/12745186/passing-parameters-to-a-jdbc-preparedstatement — brso05, Apr 25 '16 at 17:54

score 1 · Answer 1 · answered Apr 25 '16 at 17:52

1

You can try to use pst.setInt like this:

 PreparedStatement pst=conn.prepareStatement("Select hostname from clients where C_ID=?");
 pst.setInt(1, choice);
 ResultSet rs=pst.executeQuery();

answered Apr 25 '16 at 17:52

Abdelhak

8,257
4
21
35

SQL Query based on user input in Java

1 Answers1