一条SQL语句 引发的两个问题:
语句入下:
public void jButton3_actionPerformed(ActionEvent e)
{
PreparedStatement stmt1 = null;
String ls_dept = (String)jComboBox1.getSelectedItem();
String sql_dept = "select * from AppendEquipmentRegister where dept = '"+ls_dept+"'";
// String sql_dept = "select * from AppendEquipmentRegister where if_scrap =" +1;
try
{
conn1= DriverManager.getConnection("jdbc:odbc:SDB", "sa","123");
stmt1 = conn1.prepareStatement(sql_dept);
stmt1.execute();
conn1.commit();
queryDataSet1.refresh() ;
}
catch (Exception ex)
{
ex.printStackTrace();
} }
}问题 1:如果 sql_dept 后 还有个and if_scarp =1 的条件 改怎么加到后sql_dept 后面去?问题2 :为什么 我查询条件改变后 执行到结果了
queryDataSet1.refresh() ; 没能重新刷新jdbTable
-----------------------------
解决问题后 马上送分 解决一个25分 谢谢各位好心人 (佛祖会保佑你的!)
语句入下:
public void jButton3_actionPerformed(ActionEvent e)
{
PreparedStatement stmt1 = null;
String ls_dept = (String)jComboBox1.getSelectedItem();
String sql_dept = "select * from AppendEquipmentRegister where dept = '"+ls_dept+"'";
// String sql_dept = "select * from AppendEquipmentRegister where if_scrap =" +1;
try
{
conn1= DriverManager.getConnection("jdbc:odbc:SDB", "sa","123");
stmt1 = conn1.prepareStatement(sql_dept);
stmt1.execute();
conn1.commit();
queryDataSet1.refresh() ;
}
catch (Exception ex)
{
ex.printStackTrace();
} }
}问题 1:如果 sql_dept 后 还有个and if_scarp =1 的条件 改怎么加到后sql_dept 后面去?问题2 :为什么 我查询条件改变后 执行到结果了
queryDataSet1.refresh() ; 没能重新刷新jdbTable
-----------------------------
解决问题后 马上送分 解决一个25分 谢谢各位好心人 (佛祖会保佑你的!)
String sql_dept = "select * from AppendEquipmentRegister where dept = '"+ls_dept+"'"
+ " ,and if_scarp =1 "; 不就行了
问题2:jdbTable是个JTable?
至少应该重画一下吧
我也不太懂
问题 1:"select * from AppendEquipmentRegister where dept = '"+ls_dept+"' and if_scarp =1";
比如set一下Vector,再fireTableDataChanged();
就是每次刷新后 不能马上把上次刷新的结果清除 具体该怎么重绘?jdbTable
jdbTable1.setDataSet(queryDataSet1);
public void jButton3_actionPerformed(ActionEvent e)
{ PreparedStatement stmt1 = null;
String ls_dept = (String)jComboBox1.getSelectedItem();
String sql_dept = "select distinct * from AppendEquipmentRegister where dept = '"+ls_dept+"'and if_scrap =1 ";
try
{
conn1= DriverManager.getConnection("jdbc:odbc:SDB", "sa","123");
stmt1 = conn1.prepareStatement(sql_dept);
stmt1.execute();
queryDataSet1.refresh() ;
}
catch (Exception ex)
{
ex.printStackTrace();
} }
}