deleteinfo.java

简单的学生管理系统

package catking.home.love;
import javax.swing.*;
import java.sql.*;
public class DeleteInfo extends PrimaryKey{
	private Connection con;
	public DeleteInfo(Connection con,String title,String info)
	{
		super(title,info);
		this.con = con;
		
	}
	@Override
	protected void isConfirm() {
		// TODO Auto-generated method stub
		if(tf.getText().length() != 10)
			JOptionPane.showMessageDialog(null,"输入栏不能为空");
		else
		{
			try {
				String sqlInqury = "DELETE FROM S WHERE SNO = ?";
				PreparedStatement ps = con.prepareStatement(sqlInqury);
				ps.setString(1,tf.getText());
				if(ps.executeUpdate()>0)
					JOptionPane.showMessageDialog(null,"删除成功");
				else
					JOptionPane.showMessageDialog(null,"删除失败");
					
				
			} catch (SQLException e) {
				JOptionPane.showMessageDialog(null,"指定的记录不存在!");
			}
		}
	}
}