java - 我如何将字符串变量插入到java中的Sql语句中

Question

如何将组合框中的值传递到 sql 语句？

 String name = comboBox.getSelectedItem().toString(); 
    String sql = "SELECT surname FROM employee WHERE etairia = name ";
    result = statement.executeQuery(sql);

Answer 1

试试这个:

String name = comboBox.getSelectedItem().toString(); 
String sql = "SELECT surname FROM employee WHERE etairia = (?)";
statement = conn.prepareStatement(sql); // conn is Connection
statement.setString(1, name); // '1' is the param index, it's always start from 1, not from zero
result = statement.executeQuery();