MySQL mysql select query in java

Java를 mysql 데이터베이스에 연결하는 것이 처음입니다. 여기 내 쿼리에 무엇이 잘못되었는지 :

PreparedStatement statement = conn.prepareStatement("SELECT * FROM q_table, choices, answers  WHERE q_table.QID='" + number_input + "' AND choices.CID='" + number_input + "' AND answers.AID='" + number_input + "'");

 

해결 방법

 

 String prest= "SELECT * FROM q_table, choices, answers  WHERE questions.QID=? AND choices.CID=? AND answers.AID=?";

 prest.setInt(1,1980);
 prest.setInt(2,2004);
 .
 .
 ResultSet rs = prest.executeQuery();
 while (rs.next()){
     String mov_name = rs.getString(1);
     int mov_year = rs.getInt(2);
     count++;
     System.out.println(mov_name + "\t" + "- " + mov_year);
 }
 System.out.println("Number of records: " + count);
 prest.close();
 con.close();

 

참조 페이지 https://stackoverflow.com/questions/5089229