java中怎么获取sql数据表中某指定行（gysqc=get_item）的所有数据？求解答

Question

String get_item = (String) box.getSelectedItem();
String sql_chaxun = "select * from tb_gysinfo";
try {
conn = daoConn.getConn();
st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs = st.executeQuery(sql_chaxun);
Array s1 = rs.getArray("id");
Array s2 = rs.getArray("gysqc");
Array s3 = rs.getArray("jc");
Array s4 = rs.getArray("address");
Array s5 = rs.getArray("yb");
Array s6 = rs.getArray("dh");
Array s7 = rs.getArray("cz");
Array s8 = rs.getArray("lxr");
Array[] ss = { s1, s2, s3, s4, s5, s6, s7, s8 };
tableModel.addRow(ss);
} catch (Exception e) {
e.printStackTrace();
}

Answer 1

select * from tb_gysinfo where gysqc=get_item,话说这是最基础的SQL了，你一点SQL都不会？