updatacar.java~21~

车辆管理系统

package carmanage;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.sql.*;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JTextField;
import java.awt.Rectangle;
import javax.swing.JLabel;
import java.awt.Font;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JTable;
import javax.swing.JScrollPane;
import car.db.Db;
import javax.swing.JOptionPane;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class UpdataCar extends JFrame {
    JPanel contentPane;
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    JTextField txtCarId = new JTextField();
    JTextField txtCar = new JTextField();
    JTextField txtCarType = new JTextField();
    JTextField txtColor = new JTextField();
    JTextField txtCarPlace = new JTextField();
    JTextField txtCarPrice = new JTextField();
    JButton btnClean = new JButton();
    JButton btnExit = new JButton();
    JButton btnFind = new JButton();
    JButton btnUpdata = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTableShow = new JTable();
    public UpdataCar() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(null);
        setSize(new Dimension(500, 500));
        setTitle("修改车辆信息窗口");
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 16));
        jLabel1.setText("找到车辆信息");
        jLabel1.setBounds(new Rectangle(152, 1, 145, 44));
        jLabel2.setText("请输入车牌号码：");
        jLabel2.setBounds(new Rectangle(24, 36, 122, 30));
        jLabel3.setText("车辆类型：");
        jLabel3.setBounds(new Rectangle(1, 84, 67, 28));
        jLabel4.setText("车型：");
        jLabel4.setBounds(new Rectangle(171, 85, 51, 32));
        jLabel5.setText("产地：");
        jLabel5.setBounds(new Rectangle(326, 88, 40, 30));
        jLabel6.setText("颜色：");
        jLabel6.setBounds(new Rectangle(4, 132, 50, 32));
        jLabel7.setText("价格：");
        jLabel7.setBounds(new Rectangle(223, 136, 39, 32));
        jLabel10.setBounds(new Rectangle(20, 453, 84, 32));
        txtCarId.setText("");
        txtCarId.setBounds(new Rectangle(151, 38, 98, 29));
        txtCar.setText("");
        txtCar.setBounds(new Rectangle(78, 90, 76, 27));
        txtCarType.setText("");
        txtCarType.setBounds(new Rectangle(234, 89, 76, 28));
        txtColor.setText("");
        txtColor.setBounds(new Rectangle(55, 135, 141, 26));
        txtCarPlace.setText("");
        txtCarPlace.setBounds(new Rectangle(367, 86, 85, 26));
        txtCarPrice.setText("");
        txtCarPrice.setBounds(new Rectangle(276, 140, 141, 26));
        btnClean.setBounds(new Rectangle(126, 185, 65, 28));
        btnClean.setText("清空");
        btnClean.addActionListener(new UpdataCar_btnClean_actionAdapter(this));
        btnExit.setBounds(new Rectangle(316, 188, 65, 28));
        btnExit.setText("退出");
        btnFind.setBounds(new Rectangle(277, 32, 72, 29));
        btnFind.setText("查询");
        btnFind.addActionListener(new UpdataCar_btnFind_actionAdapter(this));
        btnUpdata.setBounds(new Rectangle(226, 187, 65, 28));
        btnUpdata.setText("更新");
        btnUpdata.addActionListener(new UpdataCar_btnUpdata_actionAdapter(this));
        jScrollPane1.setHorizontalScrollBarPolicy(JScrollPane.
                                                  HORIZONTAL_SCROLLBAR_ALWAYS);
        jScrollPane1.setVerticalScrollBarPolicy(JScrollPane.
                                                VERTICAL_SCROLLBAR_ALWAYS);
        jScrollPane1.setBounds(new Rectangle(86, 236, 398, 204));
        contentPane.add(jLabel8);
        contentPane.add(jLabel9);
        contentPane.add(jLabel10);
        contentPane.add(jLabel1);
        contentPane.add(txtCarId);
        contentPane.add(btnFind);
        contentPane.add(jLabel2);
        contentPane.add(btnUpdata);
        contentPane.add(btnExit);
        contentPane.add(btnClean);
        contentPane.add(txtColor);
        contentPane.add(jLabel6);
        contentPane.add(txtCarPrice);
        contentPane.add(jLabel7);
        contentPane.add(jLabel3);
        contentPane.add(txtCar);
        contentPane.add(jLabel4);
        contentPane.add(txtCarType);
        contentPane.add(jLabel5);
        contentPane.add(txtCarPlace);
        contentPane.add(jScrollPane1);
        jScrollPane1.getViewport().add(jTableShow);
    }

    public void btnFind_actionPerformed(ActionEvent e) {
        String Username=txtCarId.getText().trim();
     Connection connection=null;
    ResultSet rSet=null;
    Statement statement=null;

             if(Username.length()!=0)
             {
                 try {
       String datas[][] = null ;
       int count = 1;
        Connection con = new Db().getCon() ;
       statement = con.createStatement();
       String sql = "select * from Car where CarId='" +
                    txtCarId.getText() + "'";
       rSet = statement.executeQuery(sql);
       if(rSet.next()==false){
          /*JOptionPane msg = new JOptionPane();
          JOptionPane.showConfirmDialog(this, "请正确填写车牌号码！", "没有此姓名的申请单", 2);*/
           JOptionPane.showMessageDialog(this,"请正确填写车牌号码！","提示",JOptionPane.ERROR_MESSAGE);
          txtCarId.setText("");
      }
      else {
          datas = new String[count][];
          int i = 0;
          datas[i] = new String[] {"" + rSet.getString("CarId"),  rSet.getString("Car"),
                    rSet.getString("CarType"),  rSet.getString("CarPlace"),
                    rSet.getString("CarColor"), rSet.getString("CarPrice")
                    };


          i++;

          String head[] ={"车牌号码","车型","车辆类型","产地","颜色","价格"};
           jTableShow = new JTable(datas, head);
           jScrollPane1.getViewport().add( jTableShow);
}
   }catch (Exception ex) {
            ex.printStackTrace();
        }
}

             else
             {
                 JOptionPane.showMessageDialog(null,"用户名不能为空！","提示",JOptionPane.ERROR_MESSAGE);
             }
       }








        public void btnUpdata_actionPerformed(ActionEvent e) {
            Service service = new Service();
            try {
                String msg = service.Updata(this.txtCarId.getText(),
                                            this.txtCar.getText(),
                                            this.txtCarType.getText(),
                                            this.txtCarPlace.getText(),
                                            this.txtColor.getText(),
                                            this.txtCarPrice.getText());
                javax.swing.JOptionPane.showMessageDialog(this, msg);
            } catch (Exception ex) {
                ex.printStackTrace();
            }

        }

        public void btnClean_actionPerformed(ActionEvent e) {
            this.txtCar.setText("");
            this.txtCarPlace.setText("");
            this.txtCarPrice.setText("");
            this.txtColor.setText("");
            this.txtCarType.setText("");
        }

        class UpdataCar_btnUpdata_actionAdapter implements ActionListener {
            private UpdataCar adaptee;
            UpdataCar_btnUpdata_actionAdapter(UpdataCar adaptee) {
                this.adaptee = adaptee;
            }

            public void actionPerformed(ActionEvent e) {
                adaptee.btnUpdata_actionPerformed(e);
            }
        }


        class UpdataCar_btnFind_actionAdapter implements ActionListener {
            private UpdataCar adaptee;
            UpdataCar_btnFind_actionAdapter(UpdataCar adaptee) {
                this.adaptee = adaptee;
            }

            public void actionPerformed(ActionEvent e) {
                adaptee.btnFind_actionPerformed(e);
            }
        }


        class UpdataCar_btnClean_actionAdapter implements ActionListener {
            private UpdataCar adaptee;
            UpdataCar_btnClean_actionAdapter(UpdataCar adaptee) {
                this.adaptee = adaptee;
            }

            public void actionPerformed(ActionEvent e) {
                adaptee.btnClean_actionPerformed(e);
            }
        }
    }