删除代码3.doc

/*删除数据*/import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.*;public class Delete3Form extends JFrame implements ActionListener JLabel labBiaoHao=new JLabel(汽车标号：); JLabel labZhongLei=new JLabel(汽车种类：);JLabel labZaiKe=new JLabel(载客数量：);JLabel labPiaoJia=new JLabel(汽车票价：); JTextField txtBiaoHao=new JTextField(20); JTextField txtZhongLei=new JTextField(20);JTextField txtZaiKe=new JTextField(20);JTextField txtPiaoJia=new JTextField(20); JButton btnDelete=new JButton(删除); JButton btnCancel=new JButton(取消); JButton btnQuery=new JButton(查询); JPanel pan=new JPanel(); JPanel pan1=new JPanel(); JPanel pan2=new JPanel(); JPanel pan3=new JPanel();JPanel pan4=new JPanel();JPanel pan5=new JPanel(); Connection con; Statement sql; ResultSet rs; Delete3Form () super(删除数据); setSize(400,300); pan1.add(labBiaoHao); pan1.add(txtBiaoHao); pan2.add(labZhongLei); pan2.add(txtZhongLei); pan3.add(labZaiKe); pan3.add(txtZaiKe); pan4.add(labPiaoJia); pan4.add(txtPiaoJia); pan5.add(btnQuery); pan5.add(btnDelete); pan5.add(btnCancel); pan.setLayout(new GridLayout(4,1); pan.add(pan1); pan.add(pan2); pan.add(pan3); pan.add(pan4); getContentPane().add(pan,Center); getContentPane().add(pan5,South); btnQuery.addActionListener(this); btnDelete.addActionListener(this); btnCancel.addActionListener(this); btnDelete.setEnabled(false); txtZhongLei.setEditable(false); txtZaiKe.setEditable(false); txtPiaoJia.setEditable(false); setVisible(true); txtBiaoHao.requestFocus(); public void actionPerformed(ActionEvent ae) if(ae.getSource()=btnCancel) dispose(); else if(ae.getSource()=btnQuery) try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch(ClassNotFoundException e) trycon=DriverManager.getConnection(jdbc:odbc: WOW ,); sql=con.createStatement(); rs=sql.executeQuery(select * from汽车表where 汽车标号=+txtBiaoHao.getText()+); if(rs.next() txtBiaoHao.setText(rs.getString(汽车标号); txtZaiKe.setText(rs.getString(载客数量); txtZhongLei.setText(rs.getString(汽车种类);txtZhongLei.setText(rs.getString(汽车票价); btnDelete.setEnabled(true); txtZhongLei.setEditable(true); txtZaiKe.setEditable(true); txtPiaoJia.setEditable(true); else System.out.println(不存在该记录! ); btnDelete.setEnabled(false); txtBiaoHao.setText(); txtZaiKe.setText(); txtZhongLei.setText(); txtPiaoJia.setText(); txtPiaoJia.setEditable(false);txtZhongLei.setEditable(false); txtZaiKe.setEditable(false); catch(SQLException e) else if(ae.getSource()=btnDelete) try System.out.println(Update 汽车表set汽车种类=+txtZhongLei.getText()+, 载客数量=+txtZaiKe.getText()+, 汽车票价=+txtPiaoJia.getText()+ where 汽车标号=+txtBiaoHao.getText()+); sql.executeUpdate(DELETE FROM 汽车表set汽车种类=+txtZhongLei.getText()+, 载客数量=+txtZaiKe.getText()+, 汽车票价=+txtPiaoJia.getText()+ where 汽车标号=+txtBiaoHao.getText()+); System.out.println(记录删除完毕！); btnDelete.setEnabled(false); txtBiaoHao.setText(); txtZaiKe.setText(); txtZhongLei.setText(); txtPiaoJia.setText(); txtPiaoJia.setEditable(false);t