51,407
社区成员
发帖
与我相关
我的任务
分享 if(e.getSource()==chaxun)
{//分三部分:第一如果是radio1.....第二是radio2.....第三是radio3......
boolean b=spbianhao.isSelected();
boolean c=spmc.isSelected();
boolean d=spjiage.isSelected();
if(b==true)//按商品编号进行查询
{//获取编号然后得到spbianhao_box的值,把相应的项添加到table上,并设置table的行值
Connection con;
PreparedStatement sql;
ResultSet rs;
try{
con=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databaseName=guorui","sa","945432957");
sql=con.prepareStatement("select * from 商品进货表 where 商品编号= ?");
sql.setInt(1,Integer.parseInt((String)spbianhao_box.getSelectedItem()));
rs=sql.executeQuery();
rs.next();
int getRow=rs.getRow();
if(getRow!=0)
{
//如果是一个人销售多个商品时,显示不出来。????????????????????
int bianhao=rs.getInt(1);
String mingcheng=rs.getString(2);
int shuliang=rs.getInt(3);
String danjia=rs.getString(4);
String shijian=rs.getString(5);
Object shuju[][]={{bianhao,mingcheng,shuliang,danjia,shijian}};
getContentPane().remove(table);
table=new JTable(shuju ,name);
JScrollPane scrollpane=new JScrollPane(table);
scrollpane.setBounds(10,20,450,200);
add(scrollpane);
table.repaint();
validate();
con.close();
}
else{
JOptionPane.showMessageDialog(this,"对不起,没有与此对应的项!\n请确认后重新输入!","消息",JOptionPane.INFORMATION_MESSAGE);
}
}
catch(SQLException one)
{
JOptionPane.showMessageDialog(this,"sql错误:"+one,"警告",JOptionPane.WARNING_MESSAGE);
}
}