/*
*按用户名查询
*/
void jTextField1_keyPressed(KeyEvent e) {
if (e.getKeyChar()==KeyEvent.VK_ENTER){
String sqlQuery = "Select * From tbUserinfo where UserName
="+"'"+jTextField1.getText()+"'";
queryDataSet1.close();
queryDataSet1.setQuery(new QueryDescriptor(database1, sqlQuery));
queryDataSet1.open();
queryDataSet1.refilter();
}
}
*按用户名查询
*/
void jTextField1_keyPressed(KeyEvent e) {
if (e.getKeyChar()==KeyEvent.VK_ENTER){
String sqlQuery = "Select * From tbUserinfo where UserName
="+"'"+jTextField1.getText()+"'";
queryDataSet1.close();
queryDataSet1.setQuery(new QueryDescriptor(database1, sqlQuery));
queryDataSet1.open();
queryDataSet1.refilter();
}
}
这样就不需要从数据库里按要求提取数据,而是从dataset里再次筛选
看看JB自带的Samples吧
void jButton7_actionPerformed(ActionEvent e)
{
//按基本条件在结果集中查询
queryDataSet1.close();
String sqlQuery=new String(); //这里为拼凑一查询语句字符串
if(getCompareCharacter().equals("like") || getCompareCharacter().equals("not like") )
{
sqlQuery="select * from 人才登记表 where "+jdbComboBox1.getSelectedItem()
+" "+getCompareCharacter()+" '%"+jQueryContext.getText()+"%'";
}
else
{
sqlQuery="select * from 人才登记表 where "+jdbComboBox1.getSelectedItem()
+" "+getCompareCharacter()+" "+":parameter";
} parameterRow1.setString("parameter",jQueryContext.getText());
System.out.println(sqlQuery);
queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, sqlQuery,
parameterRow1, true, Load.ALL));
queryDataSet1.open();
queryDataSet1.refilter(); }
DataRow[] firstDataSet保存起来
当需要再使用的时候再用readRow.copyto()转到dataset中去