诸位大侠,以下是代码,我用的是access数据库, 数据库中有一条记录
2006-05-02 00001 4556545 焊接 201 车架 6845 焊接 546 ¥3.20 ¥0.00
void query1_actionPerformed(ActionEvent e) { String time11=(String)dateComboBox1.getSelectedItem();
String time12=(String)dateComboBox2.getSelectedItem();
Date time1=Date.valueOf(time11);
Date time2=Date.valueOf(time12);
String query="SELECT * FROM ShengChanShuLiangBiao WHERE productDate>#"+time1+
" #AND productDate<#"+time2+"#";
try{
Statement statement=connection.createStatement();
ResultSet rs=statement.executeQuery(query);
ResultSetMetaData rsmd=rs.getMetaData(); Vector ColumnName=new Vector();
Vector rows=new Vector(); for(int i=0;i<colnames.length;++i)
ColumnName.addElement(colnames[i]);
boolean first=rs.next();
if(first==false){
JOptionPane.showMessageDialog(this,"没有查询结果,请重试!");
return;
}else{
do{
rows.addElement(getNextRow(rs,rsmd));
}while(rs.next()); } jScrollPane1.remove(1);
jTable1=new JTable(rows,ColumnName);
jScrollPane1.add(jTable1);
jTable1.setPreferredScrollableViewportSize(new Dimension(500,10));
jScrollPane1.validate();
}catch(Exception ex){ex.printStackTrace();}
}
不管怎么着,总是查询不出来结果,jbuilder9.0也没有提示任何异常信息,请问这该怎么解决呀?
2006-05-02 00001 4556545 焊接 201 车架 6845 焊接 546 ¥3.20 ¥0.00
void query1_actionPerformed(ActionEvent e) { String time11=(String)dateComboBox1.getSelectedItem();
String time12=(String)dateComboBox2.getSelectedItem();
Date time1=Date.valueOf(time11);
Date time2=Date.valueOf(time12);
String query="SELECT * FROM ShengChanShuLiangBiao WHERE productDate>#"+time1+
" #AND productDate<#"+time2+"#";
try{
Statement statement=connection.createStatement();
ResultSet rs=statement.executeQuery(query);
ResultSetMetaData rsmd=rs.getMetaData(); Vector ColumnName=new Vector();
Vector rows=new Vector(); for(int i=0;i<colnames.length;++i)
ColumnName.addElement(colnames[i]);
boolean first=rs.next();
if(first==false){
JOptionPane.showMessageDialog(this,"没有查询结果,请重试!");
return;
}else{
do{
rows.addElement(getNextRow(rs,rsmd));
}while(rs.next()); } jScrollPane1.remove(1);
jTable1=new JTable(rows,ColumnName);
jScrollPane1.add(jTable1);
jTable1.setPreferredScrollableViewportSize(new Dimension(500,10));
jScrollPane1.validate();
}catch(Exception ex){ex.printStackTrace();}
}
不管怎么着,总是查询不出来结果,jbuilder9.0也没有提示任何异常信息,请问这该怎么解决呀?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货