Java怎么删除学生信息_学生管理系统（JAVA版） —— 删除学生信息页面

添加信息页面UI界面如下，当正确删除到数据库时，可在下方显示删除成功：

UI界面设计如下：

package ui;

import java.awt.Container;

import java.awt.Font;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JTextField;

import daoImp.ClassesDaoImp;

public class Delete extends JFrame implements ActionListener {

JLabel title,number,lbl;

JTextField num;

JButton dft,cla,rtn;

JPanel line,line1,line2,line3;

public Delete() {

// TODO Auto-generated constructor stub

Container con=getContentPane();

con.setLayout(new GridLayout(4,1));

line=new JPanel();

line1=new JPanel();

line2=new JPanel();

line3=new JPanel();

title=new JLabel("学生管理系统");

title.setFont(new Font("黑体", Font.PLAIN, 20));

number=new JLabel("学号：");

lbl=new JLabel();

num=new JTextField(10);

dft=new JButton("确定");

dft.addActionListener(this);

cla=new JButton("清空");

cla.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

num.setText("");

lbl.setText("");

}

});

rtn=new JButton("返回");

rtn.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

setVisible(false);

new Host().setVisible(true);

}

});

line.add(title);

line1.add(number);

line1.add(num);

line2.add(dft);

line2.add(cla);

line2.add(rtn);

line3.add(lbl);

con.add(line);

con.add(line1);

con.add(line2);

con.add(line3);

setTitle("删除学生信息");

setSize(340,200);

setVisible(true);

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

}

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

ClassesDaoImp cdi=new ClassesDaoImp();

String classnum=num.getText();

//将输入学号出入删除方法，按学号删除该生信息

if(cdi.delete(classnum)) {

lbl.setText("删除成功");

}else {

lbl.setText("查无此人");

}

}

}

重写ClassesDaoImp类的删除方法，实现将信息从数据库删除的功能：

package daoImp;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.List;

import dao.classesDao;

import db.DBCon;

import entity.Classes;

public class ClassesDaoImp implements classesDao {

Connection cn;

PreparedStatement psm=null;

private ResultSet rs;

@Override

public boolean add(Classes classes) throws SQLException {

// TODO Auto-generated method stub

//。。。。。。

return flag;

}

@Override

public boolean delete(String num) {

// TODO Auto-generated method stub

boolean flag=false;

DBCon dbcon=new DBCon();

cn=dbcon.getConnection();

String sql="delete from classes where num=?";

try {

psm=cn.prepareStatement(sql);

psm.setString(1, num);

if(psm.executeUpdate()!=0) {

flag=true;

}

cn.close();

psm.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return flag;

}

@Override

public boolean update(Classes classes) {

// TODO Auto-generated method stub

return false;

}

@Override

public Classes SearchByNum(String num) {

// TODO Auto-generated method stub

return null;

}

@Override

public List sreachByTeacher(String teacher) {

// TODO Auto-generated method stub

return null;

}

}