数据库的内容:
GUI界面:
代码:StudentManagerment.java
package 学生基本信息;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.*;
import java.sql.*;
public class StudentManagement extends JFrame implements ActionListener{
JTabbedPane dbTabPane;
JPanel inputPanel; //录入面板
JPanel viewPanel; //浏览面板
JPanel updatePanel; //更新面板
JPanel deletePanel; //删除面板
JButton inputBtn; //录入
JButton clearBtn1;
StudentPanel inputInnerPanel;
JTextArea viewArea; //浏览
JButton viewBtn;
StudentPanel updateInnerPanel; //修改数据
JLabel updateInputLbl;
JTextField updateInputText;
JButton updateBtn;
StudentPanel deleteInnerPanel;
JLabel inputNoLabel;
JTextField inputNoField;
JButton deleteBtn;
Connection conn;
Statement stmt;
public StudentManagement(){
super("学生基本信息管理系统");
serGUIComponent();
}
public void serGUIComponent() {
// TODO Auto-generated method stub
Container c = getContentPane();
c.setLayout(new BorderLayout());
dbTabPane = new JTabbedPane();
//定义录入面板
inputPanel = new JPanel();
inputPanel.setLayout(new FlowLayout());
inputBtn = new JButton("录入");
clearBtn1 = new JButton("清除");
/*使用this对象,可以不用声明内部类而直接在本类中实现接口覆盖接口的方法。*/
inputBtn.addActionListener(this);
clearBtn1.addActionListener(this);
inputInnerPanel = new StudentPanel();
inputPanel.add(inputInnerPanel);
inputPanel.add(inputBtn);
inputPanel.add(clearBtn1);
dbTabPane.add("录入数据", inputPanel);
//定义浏览面板
viewPanel = new JPanel();
viewPanel.setLayout(new BorderLayout());
viewArea = new JTextArea(6,35);
viewBtn = new JButton("浏览&