java学生管理系统界面设计

关于学生管理系统的界面设计:代码如下:
数据库设计

DROP TABLE IF EXISTS `stu`;
CREATE TABLE `stu` (
  `stuId` int(11) NOT NULL AUTO_INCREMENT,
  `stuName` varchar(30) DEFAULT NULL,
  `stuSex` varchar(30) DEFAULT NULL,
  `stuAge` int(11) DEFAULT NULL,
  `stuJg` varchar(30) DEFAULT NULL,
  `stuDept` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`stuId`)
) ENGINE=MyISAM AUTO_INCREMENT=10002 DEFAULT CHARSET=utf8;

添加学生信息界面

/**
 * @author 逸軒
 * https://www.jianshu.com/u/1b1f7b0b32d6
 */
import java.awt.BorderLayout;  
import java.awt.Dialog;  
import java.awt.Frame;  
import java.awt.GridLayout;  
import java.awt.event.ActionEvent;  
import java.awt.event.ActionListener;  
  
import javax.swing.*;  
  
public class StuAddDialog extends JDialog implements ActionListener{  
    //=========面板控件  
    //......左侧标题栏  
    private JLabel idLab,nameLab,sexLab,ageLab,jgLab,deptLab;  
    //......右侧信息选择填写栏  
    private JTextField idTxt,nameTxt,sexTxt,ageTxt,jgTxt,deptTxt;  
    //......添加和取消按钮  
    private JButton addBtn,cancelBtn;  
    //......布局控件  
    private JPanel left,center,bottom;  
      
    //构造函数  
    public StuAddDialog(Frame owner, String title, boolean modal)   
    {  
        //========重写父类方法  
        super(owner, title, modal);  
        //========左侧标签栏  
        idLab = new JLabel("学号: ");  
        nameLab = new JLabel("姓名: ");  
        sexLab = new JLabel("性别: ");  
        ageLab = new JLabel("年龄: ");  
        jgLab = new JLabel("籍贯: ");  
        deptLab = new JLabel("系别: ");  
        //========右侧信息填写栏  
        idTxt = new JTextField();  
        nameTxt = new JTextField();  
        sexTxt = new JTextField();  
        ageTxt = new JTextField();  
        jgTxt = new JTextField();  
        deptTxt = new JTextField();  
        //========添加和取消按钮  
        addBtn = new JButton("添加");  
        cancelBtn = new JButton("取消");  
        //......添加监听  
        addBtn.addActionListener(this);  
        addBtn.setActionCommand("add");  
        cancelBtn.addActionListener(this);  
        cancelBtn.setActionCommand("cancel");  
        //========创建布局  
        //......创建左边栏  
        left = new JPanel();  
        left.setLayout(new GridLayout(6, 1));  
        left.add(idLab);  left.add(nameLab);   
        left.add(sexLab); left.add(ageLab);   
        left.add(jgLab);  left.add(deptLab);   
        //......创建右边栏  
        center = new JPanel();  
        center.setLayout(new GridLayout(6, 1));  
        center.add(idTxt);  center.add(nameTxt);  
        center.add(sexTxt); center.add(ageTxt);  
        center.add(jgTxt);  center.add(deptTxt);  
        //========底层添加和取消按钮  
        bottom = new JPanel();  
        bottom.add(addBtn);  
        bottom.add(cancelBtn);  
        //========整体布局  
        this.add(left,BorderLayout.WEST);  
        this.add(center,BorderLayout.CENTER);  
        this.add(bottom,BorderLayout.SOUTH);  
        //========设置窗口属性  
          
        this.setSize(300, 250);  
        this.setResizable(false);  
        this.setVisible(true);  
    }  
  
    @Override  
    public void actionPerformed(ActionEvent e)   
    {  
        // TODO Auto-generated method stub  
        if(e.getActionCommand().equals("add")) {  
            /***********************添加学生信息**************************/  
            StuModel tmp = new StuModel();  
            String sql = "insert into stu values(?,?,?,?,?,?)";  
            String []paras = {idTxt.getText(),nameTxt.getText(),sexTxt.getText(),  
                            ageTxt.getText(),jgTxt.getText(),deptTxt.getText()};  
            if(!tmp.cudStu(sql, paras))  
                JOptionPane.showMessageDialog(this, "添加学生信息失败");  
            //========关闭窗口  
            this.dispose();  
        } else if(e.getActionCommand().equals("cancel")) {  
            //========关闭窗口  
            this.dispose();  
        }  
    }  
}  

数据库连接

/**
 * @author 逸軒
 * https://www.jianshu.com/u/1b1f7b0b32d6
 */
import java.sql.*;  

public class SqlHelper {  
    //========数据库  
    private Connection ct = null;  
    private PreparedStatement ps = null;  
    private ResultSet rs = null;  
    private String driver = "com.mysql.jdbc.Driver";  //后面加上utf-8 不然中文乱码
    private String url = "jdbc:mysql://localhost:3306/test?characterEncoding=utf-8";  
    private String user = "root";  
    private String passwd = "";  
      
    //========查询  
    public ResultSet queryExecute(String sql, String []paras)  
    {  
        try {  
            //========1、加载驱动  
            Class.forName(driver);  
            //========2、连接  
            ct = DriverManager.getConnection(url, user, passwd);  
            //========3、创建PreparedStatement  
            ps = ct.prepareStatement(sql);  
            //========4、给问号赋值  
            if(paras != null) {  
                for(int i = 0; i < paras.length; i++) {  
                    ps.setString(i + 1, paras[i]);  
                }  
            }  
            //========5、执行  
            rs = ps.executeQuery();  
        } catch (Exception e) {  
            // TODO: handle exception  
            e.printStackTrace();  
        } finally {  
            //this.close();  
        }  
        //========返回值  
        return rs;  
    }  
      
    //========增删改  
    public boolean cudExecute(String sql, String []paras)  
    {  
        boolean b = true;  
        try {  
            //========1、加载驱动  
            Class.forName(driver);  
            //========2、连接  
            ct = DriverManager.getConnection(url, user, passwd);  
            //========3、创建PreparedStatement  
            ps = ct.prepareStatement(sql);  
            //========4、给问号赋值  
            for(int i = 0; i < paras.length; i++) {  
                ps.setString(i + 1, paras[i]);  
            }  
            //========5、执行  
            if(ps.executeUpdate() != 1) b = false;  
        } catch (Exception e) {  
            // TODO: handle exception  
            b = false;  
            e.printStackTrace();  
        } finally {  
            this.close();  
        }  
        //========返回值  
        return b;  
    }  
      
    //========关闭资源  
    public void close()  
    {  
        try {  
            if(rs!=null) rs.close();  
            if(ps!=null) ps.close();  
            if(ct!=null) ct.close();  
        } catch (Exception e2) {  
            // TODO: handle exception  
            e2.printStackTrace();  
        }  
    }  
      
}  

学生管理界面有查询功能、修改信息功能、删除功能

/**
 * @author 逸軒
 * https://www.jianshu.com/u/1b1f7b0b32d6
 */
import java.awt.*;  
import javax.swing.*;  
import java.awt.event.*;  
  
public class StudentManage extends JFrame implements ActionListener   
{  
    /** 
     * @param args 
     */  
    public static void main(String[] args)   
    {  
        // TODO Auto-generated method stub  
        new StudentManage();  
    }  
  
    //========面板控件  
    private JLabel queryLab = null;  
    private JTextField queryTxt = null;  
    private JButton queryBtn = null;  
    private JButton allBtn = null;  
    private JTable resultTb = null;  
    private JScrollPane jsp = null;  
    private JButton addBtn = null;  
    private JButton deleteBtn = null;  
    private JButton updateBtn = null;  
    private JPanel top = null;  
    private JPanel bottom = null;  
    //========  
    private StuModel sm = null;  
      
    //构造函数  
    public StudentManage()  
    {  
        super("学生管理系统");
        /***************************初始化面板控件***********************/  
        //========查询栏  
        queryLab = new JLabel("请输入姓名:");  
        queryTxt = new JTextField(10);  
        queryBtn = new JButton("查询");  
        allBtn = new JButton("全部");  
        //......添加查询栏监听  
        queryBtn.addActionListener(this);  
        queryBtn.setActionCommand("query");  
        allBtn.addActionListener(this);  
        allBtn.setActionCommand("all");  
        //========增删改栏  
        addBtn = new JButton("添加");  
        deleteBtn = new JButton("删除");  
        updateBtn = new JButton("修改");  
        //......添加增删改栏监听  
        addBtn.addActionListener(this);  
        addBtn.setActionCommand("add");  
        deleteBtn.addActionListener(this);  
        deleteBtn.setActionCommand("delete");  
        updateBtn.addActionListener(this);  
        updateBtn.setActionCommand("update");  
        //========创建窗口整体布局  
        //......顶层查询栏  
        top = new JPanel();  
        top.add(queryLab);  
        top.add(queryTxt);  
        top.add(queryBtn);  
        top.add(allBtn);  
        //......底层增删改栏  
        bottom = new JPanel();  
        bottom.add(addBtn);  
        bottom.add(deleteBtn);  
        bottom.add(updateBtn);  
        //......中间层显示栏  
        sm = new StuModel();  
        String sql = "select * from stu";  
        sm.queryStu(sql, null);  
        resultTb = new JTable(sm);  
        jsp = new JScrollPane(resultTb);  
        //......构建整体布局  
        this.add(top,BorderLayout.NORTH);  
        this.add(jsp,BorderLayout.CENTER);  
        this.add(bottom,BorderLayout.SOUTH);  
        //========设置窗口属性  
        this.setSize(400, 300);  
        this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);  
        this.setVisible(true);  
        this.setResizable(false);  
    }  
      
    //监听  
    @Override  
    public void actionPerformed(ActionEvent e)  
    {  
        // TODO Auto-generated method stub  
        if(e.getActionCommand().equals("query")) {  
            /*********************查询***********************/  
            //========获取输入学生的姓名  
            String name = queryTxt.getText().trim();  
            if(name.length() != 0) {  
                //========姓名输入有效时,执行查询  
                //......定义参数  
                String sql = "select * from stu where stuName=?";  
                String []paras = {name};  
                //......更新模型  
                jtableUpdate(sql, paras);  
            } else {  
                //========姓名为空时,设置提醒  
                JOptionPane.showMessageDialog(this, "姓名输入不能为空");  
            }  
        } else if(e.getActionCommand().equals("add")) {  
            /*********************添加***********************/  
            new StuAddDialog(this, "添加学生信息", true);  
            String sql = "select * from stu";  
            jtableUpdate(sql, null);  
        } else if(e.getActionCommand().equals("all")) {  
            /*********************全部显示***********************/  
            String sql = "select * from stu";  
            jtableUpdate(sql, null);  
        } else if(e.getActionCommand().equals("delete")) {  
            /*********************删除***********************/  
            //========获取选择行号  
            int rowNum = this.resultTb.getSelectedRow();  
            if(rowNum == -1) {  
                JOptionPane.showMessageDialog(this, "请选择一行");  
                return ;  
            }  
            //========获取学生ID号  
            String stuId = (String)sm.getValueAt(rowNum, 0);  
            //========删除学生  
            String sql = "delete from stu where stuId=?";  
            String []paras = {stuId};  
            StuModel tmp = new StuModel();  
            tmp.cudStu(sql, paras);  
            //========更新模型  
            sql = "select * from stu";  
            jtableUpdate(sql, null);  
        } else if(e.getActionCommand().equals("update")) {  
            /*********************修改***********************/  
            //========获取选择行号  
            int rowNum = this.resultTb.getSelectedRow();  
            if(rowNum == -1) {  
                JOptionPane.showMessageDialog(this, "请选择一行");  
                return ;  
            }  
            new StuUpdateDialog(this, "修改学生信息", true, sm, rowNum);  
            String sql = "select * from stu";  
            jtableUpdate(sql, null);  
        }  
    }  
      
    //========更新JTable内数据  
    public void jtableUpdate(String sql, String[] paras)  
    {  
        //......创建模型  
        sm = new StuModel();  
        sm.queryStu(sql, paras);  
        //......更新显示  
        resultTb.setModel(sm);  
    }  
  
}  

修改学生信息界面设计

/**
 * @author 逸軒
 * https://www.jianshu.com/u/1b1f7b0b32d6
 */
import java.awt.BorderLayout;  
import java.awt.Frame;  
import java.awt.GridLayout;  
import java.awt.event.ActionEvent;  
import java.awt.event.ActionListener;  
  
import javax.swing.JButton;  
import javax.swing.JDialog;  
import javax.swing.JLabel;  
import javax.swing.JOptionPane;  
import javax.swing.JPanel;  
import javax.swing.JTextField;  
import javax.swing.table.AbstractTableModel;  
  
public class StuUpdateDialog extends JDialog implements ActionListener{  
    //=========面板控件  
    //......左侧标题栏  
    private JLabel idLab,nameLab,sexLab,ageLab,jgLab,deptLab;  
    //......右侧信息选择填写栏  
    private JTextField idTxt,nameTxt,sexTxt,ageTxt,jgTxt,deptTxt;  
    //......添加和取消按钮  
    private JButton addBtn,cancelBtn;  
    //......布局控件  
    private JPanel left,center,bottom;  
      
    //构造函数  
    public StuUpdateDialog(Frame owner, String title, boolean modal, StuModel sm, int rowNum)   
    {  
        //========重写父类方法  
        super(owner, title, modal);  
        //========左侧标签栏  
        idLab = new JLabel("学号: ");  
        nameLab = new JLabel("姓名: ");  
        sexLab = new JLabel("性别: ");  
        ageLab = new JLabel("年龄: ");  
        jgLab = new JLabel("籍贯: ");  
        deptLab = new JLabel("系别: ");  
        //========右侧信息填写栏  
        idTxt = new JTextField();     
        idTxt.setText((String)sm.getValueAt(rowNum, 0));  
        idTxt.setEditable(false);  
        nameTxt = new JTextField();  
        nameTxt.setText((String)sm.getValueAt(rowNum, 1));  
        sexTxt = new JTextField();  
        sexTxt.setText((String)sm.getValueAt(rowNum, 2));  
        ageTxt = new JTextField();  
        ageTxt.setText((String)sm.getValueAt(rowNum, 3));  
        jgTxt = new JTextField();  
        jgTxt.setText((String)sm.getValueAt(rowNum, 4));  
        deptTxt = new JTextField();  
        deptTxt.setText((String)sm.getValueAt(rowNum, 5));  
        //========添加和取消按钮  
        addBtn = new JButton("修改");  
        cancelBtn = new JButton("取消");  
        //......添加监听  
        addBtn.addActionListener(this);  
        addBtn.setActionCommand("update");  
        cancelBtn.addActionListener(this);  
        cancelBtn.setActionCommand("cancel");  
        //========创建布局  
        //......创建左边栏  
        left = new JPanel();  
        left.setLayout(new GridLayout(6, 1));  
        left.add(idLab);  left.add(nameLab);   
        left.add(sexLab); left.add(ageLab);   
        left.add(jgLab);  left.add(deptLab);   
        //......创建右边栏  
        center = new JPanel();  
        center.setLayout(new GridLayout(6, 1));  
        center.add(idTxt);  center.add(nameTxt);  
        center.add(sexTxt); center.add(ageTxt);  
        center.add(jgTxt);  center.add(deptTxt);  
        //========底层添加和取消按钮  
        bottom = new JPanel();  
        bottom.add(addBtn);  
        bottom.add(cancelBtn);  
        //========整体布局  
        this.add(left,BorderLayout.WEST);  
        this.add(center,BorderLayout.CENTER);  
        this.add(bottom,BorderLayout.SOUTH);  
        //========设置窗口属性  
          
        this.setSize(300, 250);  
        this.setResizable(false);  
        this.setVisible(true);  
    }  
  
    @Override  
    public void actionPerformed(ActionEvent e) {  
        // TODO Auto-generated method stub  
        if(e.getActionCommand().equals("update")) {  
        /***********************修改学生信息**************************/  
            StuModel tmp = new StuModel();  
            String sql = "update stu set stuName=?,stuSex=?,stuAge=?,stuJg=?,stuDept=? where stuId=?";  
            String []paras = {nameTxt.getText(),sexTxt.getText(),ageTxt.getText(),  
                            jgTxt.getText(),deptTxt.getText(),idTxt.getText()};  
            if(!tmp.cudStu(sql, paras))  
                JOptionPane.showMessageDialog(this, "修改学生信息失败");  
            //========关闭窗口  
            this.dispose();  
        } else if(e.getActionCommand().equals("cancel")) {  
            //========关闭窗口  
            this.dispose();  
        }  
    }  
}  

查询学生功能

/**
 * @author 逸軒
 * https://www.jianshu.com/u/1b1f7b0b32d6
 */
import java.sql.ResultSet;  
import java.util.Vector;  
import javax.swing.table.AbstractTableModel;  
  
public class StuModel extends AbstractTableModel{  
    private Vector columnNames;  
    private Vector rowDates;  
      
    //  
    public StuModel()  
    {  
        String sql = "select * from stu";  
        String []paras = {};  
          
    }  
      
    //========增删改学生  
    public boolean cudStu(String sql, String []paras)  
    {  
        return new SqlHelper().cudExecute(sql, paras);  
    }  
      
    //========查询学生  
    public void queryStu(String sql, String []paras)  
    {  
        SqlHelper sqlHelper = null;  
        //========初始化JTable信息  
        columnNames = new Vector();  
        rowDates = new Vector();  
        columnNames.add("学号"); columnNames.add("名字");  
        columnNames.add("性别"); columnNames.add("年龄");  
        columnNames.add("籍贯"); columnNames.add("系别");  
          
        try {  
            sqlHelper = new SqlHelper();  
            ResultSet rs = sqlHelper.queryExecute(sql, paras);  
            while(rs.next()) {  
                Vector row = new Vector();  
                row.add(rs.getString(1));  
                row.add(rs.getString(2));  
                row.add(rs.getString(3));  
                row.add(rs.getString(4));  
                row.add(rs.getString(5));  
                row.add(rs.getString(6));  
                rowDates.add(row);  
            }  
        } catch (Exception e) {  
            // TODO: handle exception  
        } finally {  
            sqlHelper.close();  
        }  
          
    }  
  
    @Override  
    public int getColumnCount() {  
        // TODO Auto-generated method stub  
        return this.columnNames.size();  
    }  
  
    @Override  
    public int getRowCount() {  
        // TODO Auto-generated method stub  
        return this.rowDates.size();  
    }  
  
    @Override  
    public Object getValueAt(int row, int col) {  
        // TODO Auto-generated method stub  
        if(!rowDates.isEmpty())  
            return ((Vector)this.rowDates.get(row)).get(col);  
        else  
            return null;  
    }  
  
      
    @Override  
    public String getColumnName(int column) {  
        // TODO Auto-generated method stub  
        return (String)this.columnNames.get(column);  
    }  
  
      
}  

截图演示


2.JPG
3.JPG
4.JPG
5.JPG

推荐阅读更多精彩内容