java怎么根据编号修改数据类型_java编程通过编号删除数据库一条数据要怎么改...

classDeleteextendsJFrameimplementsActionListener{JLabellb;JTextFieldtxt1;JButtonbt1,bt2;Delete(){super("图书信息删除表");lb=newJLabel("输入要删除图书的编号");txt1=newJTex...

class Delete extends JFrame implements ActionListener

{JLabel lb;

JTextField txt1;

JButton bt1,bt2;

Delete()

{

super("图书信息删除表");

lb=new JLabel("输入要删除图书的编号");

txt1=new JTextField(10);

bt1=new JButton("确定");

bt2=new JButton("取消");

bt1.addActionListener(this);

bt2.addActionListener(this);

txt1.addActionListener(this);

setLayout(new FlowLayout(FlowLayout.CENTER));

add(lb);

add(new JLabel("编号："));

add(txt1);

add(bt1);

add(bt2);

setBounds(200,200,180,150);

setVisible(true);

addWindowListener(new WindowAdapter()

{ public void windowClosing(WindowEvent e){

dispose();}});

}

public void actionPerformed(ActionEvent e)

{

Connection con;

ResultSet rs;

PreparedStatement prestmt1,prestmt2;

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}

catch(ClassNotFoundException ex) { }

if(e.getSource()==txt1)

{

try{

con=DriverManager.getConnection("jdbc:odbc:图书信息管理系统");

prestmt1=con.prepareStatement("SELECT* FROM 图书信息表 WHERE 编号= ?,?,?,?");

prestmt1.setString(1,txt1.getText());

rs=prestmt1.executeQuery();

while (rs.next())

{

txt1.setText(rs.getString(1));

}

con.close();

}

catch(SQLException ex) { System.out.println(e); }

}

else if (e.getSource()==bt1)

{

String number=txt1.getText().trim();

if(number.length()>0)

{ try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}

catch(java.lang.ClassNotFoundException ec){

ec.printStackTrace(); }

try

{

con= DriverManager.getConnection("jdbc:odbc:图书信息管理系统");

prestmt2=con.prepareStatement("delete from 图书信息表 名称=?,单价=?,数量=? WHERE 编号= ?");

prestmt2.setString(1,number);

prestmt2.executeUpdate();

prestmt2.close();

con.close();

JOptionPane.showMessageDialog(this,"信息删除成功！","OK",JOptionPane.INFORMATION_MESSAGE);

}catch(SQLException ex)

{

ex.printStackTrace();

}

}

else {

JOptionPane.showMessageDialog(this,"请输入要删除的信息！","提示",

JOptionPane.WARNING_MESSAGE);

}

}

else if (e.getSource()==bt2)

{ dispose();}

}

}

展开