Question

java编程通过编号删除数据库一条数据要怎么改

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();}
}
}

Answer 1

是什么错误信息？
如果是SQLException产生，估计是SQL语句有对。删除应该是这个语法：
delete from 图书信息表 WHERE 编号= ?