if (obj == btnDel) //删除
{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 实例化JDBC-ODBC桥的驱动
Connection cn = DriverManager.getConnection("jdbc:odbc:local"); // 连接数据库
// 创建Statement接口对象
Statement stat = cn.createStatement();
ResultSet rs = stat.executeQuery("select 床号 from Medical ");
if (!rs.next()) { // 判断数据库中是否有要删除的记录,如没有则显示提示框
txtNumbed.setText("");
lblMess.setText("数据库中没有您要删除的床号!");
}
else {
String Medical = "delete from Medical where 床号=?'" +
txtNumbed.getText() + "'";
stat.executeUpdate(Medical); // 删除Medical表中对应床号的数据记录
// 清空信息框
txtNumbed.setText("");
txtName.setText("");
txtSex.setText("");
txtInDate.setText("");
txtDoc.setText("");
txtDep.setText("");
txtUnit.setText("");
txtAge.setText("");
txtTotal.setText("");
txtCase.setText("");
txtOutDate.setText("");
txtinnumbed.setText("");
lblMess.setText("记录已成功删除!");
}
} catch (Exception ex)
{ // 捕捉异常
System.out.println(ex.getMessage());
}
}
{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 实例化JDBC-ODBC桥的驱动
Connection cn = DriverManager.getConnection("jdbc:odbc:local"); // 连接数据库
// 创建Statement接口对象
Statement stat = cn.createStatement();
ResultSet rs = stat.executeQuery("select 床号 from Medical ");
if (!rs.next()) { // 判断数据库中是否有要删除的记录,如没有则显示提示框
txtNumbed.setText("");
lblMess.setText("数据库中没有您要删除的床号!");
}
else {
String Medical = "delete from Medical where 床号=?'" +
txtNumbed.getText() + "'";
stat.executeUpdate(Medical); // 删除Medical表中对应床号的数据记录
// 清空信息框
txtNumbed.setText("");
txtName.setText("");
txtSex.setText("");
txtInDate.setText("");
txtDoc.setText("");
txtDep.setText("");
txtUnit.setText("");
txtAge.setText("");
txtTotal.setText("");
txtCase.setText("");
txtOutDate.setText("");
txtinnumbed.setText("");
lblMess.setText("记录已成功删除!");
}
} catch (Exception ex)
{ // 捕捉异常
System.out.println(ex.getMessage());
}
}
中的?是什么意思。这应该会引起SQL错误。
没有必要啊,String Medical = "delete from Medical where 床号='" + txtNumbed.getText() + "'"; 就可以删除全部信息了。