汽车销售管理系统--java

package edu.jxau.ccie.jk; import java.awt.BorderLayout; import java.awt.Color; import java.awt.Container; import java.awt.Dimension; import java.awt.FlowLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Arrays; import java.util.Vector; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JTextArea; import javax.swing.JTextField; import javax.swing.table.DefaultTableModel; import edu.jxau.ccie.jk.销售情况Search; public class 销售情况Search extends JFrame implements ActionListener { private 数据库连接 d = new 数据库连接(); public final int width = 800; public final int height = 600; public String bgTable; private Container contentpane; private JScrollPane jspane; private Vector vctEmploye; private Vector vctColumnName; private JTable jtable; private Vector rec_vet; private Vector columnNames; private JTextField nameJtext; private JButton CloseBut; private JButton searchBut; private JTextArea Jta; public Dimension dim = getToolkit().getScreenSize(); public 销售情况Search() { setTitle("信息查询"); setBounds( (dim.width - width)/2,(dim.height - height) /2 , width,height ); setResizable(false); contentpane=this.getContentPane(); contentpane.setLayout(new BorderLayout()); JButton searchBut=new JButton("查询"); searchBut.setBackground(Color.blue); searchBut.addActionListener(this); JLabel nameLable=new JLabel("请输入要查询行的编号："); nameJtext=new JTextField(8); Jta=new JTextArea(5,10); JPanel southJPanel=new JPanel(); southJPanel.setBackground(Color.blue); FlowLayout sJPflow=new FlowLayout(); sJPflow.setHgap(10); sJPflow.setVgap(20); southJPanel.setLayout(sJPflow); southJPanel.add(nameLable); southJPanel.add(nameJtext); southJPanel.add(searchBut); searchBut.setBounds(50,50,60,50); Jta.setText(""); contentpane.add(southJPanel,BorderLayout.NORTH); showTableData(); contentpane.add(Jta,BorderLayout.SOUTH); contentpane.add(jspane,BorderLayout.CENTER); this.setDefaultCloseOperation(DISPOSE_ON_CLOSE); setVisible(true); } private void showTableData() { try { int count = 0; Statement s=d.getConnection().createStatement(); String sql="select * from 销售情况 "; ResultSet rs=s.executeQuery(sql); while(rs.next()) { count++; } rs = s.executeQuery(sql); count = 0; vctEmploye=new Vector(); while(rs.next()) { rec_vet=new Vector(); rec_vet.add(rs.getString("ID")); rec_vet.add(rs.getString("ProductID")); rec_vet.add(rs.getString("CustomerID")); rec_vet.add(rs.getString("SellDateTime")); rec_vet.add(rs.getString("Price")); rec_vet.add(rs.getString("Count")); vctEmploye.add(rec_vet); } String[] title = {"ID","CarID","顾客ID","出售日期","价格","数量"}; columnNames = new Vector(Arrays.asList(title)); jtable = new JTable(); DefaultTableModel model=new DefaultTableModel(vctEmploye,columnNames); jtable.setModel(model); this.jspane=new JScrollPane(jtable); } catch(SQLException e) { e.printStackTrace(); } } public void actionPerformed(ActionEvent e) { String comm; if(e.getSource() instanceof JButton) { comm=e.getActionCommand(); if(comm.equals("查询")) { try { Statement s=d.getConnection().createStatement(); String sql="select * from 销售情况 where ID='"+nameJtext.getText()+"'"; ResultSet rs=s.executeQuery(sql); if(rs.next()) { String si="查询结果:\n"+" "+"ID"+" "+"商品ID"+" "+"顾客ID"+" "+"出售日期"+" "+"价格"+" "+"数量"+" "+"\n"; si+=" "+rs.getString("ID")+" "+rs.getString("ProductID")+" "+rs.getString("CustomerID")+" "+rs.getString("SellDateTime")+" "+rs.getString("Price")+" "+rs.getString("Count")+" "+"\n"; Jta.setText(si); } else { JOptionPane.showMessageDialog(null,"sorry,不存在你要查询的数据！"); } } catch (Exception error) { System.err.println("异常："+error.getMessage()); } } } } public static void main(String args[]){ new 销售情况Search(); } }