问题描述
- java中怎么获取sql数据表中某指定行(gysqc=get_item)的所有数据?求解答
-
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();
}
解决方案
select * from tb_gysinfo where gysqc=get_item,话说这是最基础的SQL了,你一点SQL都不会?
解决方案二:
sql语句改成 sql_chaxun = "select * from tb_gysinfo t where t.gysqc = "+get_item;
解决方案三:
使用where条件进行筛选啊,直接使用gysqc=get_item条件就行
解决方案四:
通过where进行选择。参考这个:http://blog.csdn.net/qq_19558705/article/details/49947317
解决方案五:
嗯哦,解决了,谢谢哈
时间: 2024-08-08 14:41:44