利用java和mysql数据库创建学生信息管理系统

相关介绍

管理系统的使用可以大大提高我们的工作效率，给我们的生活带来极大的便利，因此我们在学习编程语言的时候大多是要学习和实现一个管理系统的创建的。

学生信息管理系统是进一步推进学生学籍管理规范化、电子化控制和管理学生信息的总要举措。系统针对学校学生信息的特点以及管理中实际需要而设计，能够有效地实现学生信息管理的信息化，减轻管理人员的工作负担，高效率、规范化地管理大量的学生信息，并避免人为操作的错误和不规范行为。

接下来我会带给大家一个学生信息管理系统，该系统包括一下功能：

• 登录

• 注册

• 增添

• 删除

• 修改

• 查询

下面我们来了解一下学生信息管理系统的实现：

• 该学生信息管理系统由java+mysql数据库构成

• 主要用到的java包有：

javax.swing.JButton;

javax.swing.JFrame;

javax.swing.JLabel;

javax.swing.JPasswordField;

javax.swing.JTextField;

• 该系统设立了登录页面，设置登录及注册的相关功能，并且界面化所有功能，具备增删改查功能，并且建立了功能整个页面，将所有功能控件整合至一个页面，点击相关按钮跳转至相应的功能页面

• 运行环境：

Eclipse+JDK1.8 + MySQL

主要内容

通过java连接MySQL数据库实现学生信息管理系统，使用者能够登录并完成对信息的查询、增加、修改、删除等操作。

程序设计思维导图

代码实现

登录页面创建

package sutdent_maniger;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.JPasswordField;import javax.swing.JTextField;public class Login_Register extends JFrame{/** **/private static final long serialVersionUID = 1L;Login_Register() {init();}//登录界面初始化public void init() {JFrame frame = new JFrame("登录管理系统");frame.setLayout(null);JLabel nameStr = new JLabel("账号:");nameStr.setBounds(250, 200, 100, 25);frame.add(nameStr);JLabel passwordStr = new JLabel("密码:");passwordStr.setBounds(250, 250, 100, 25);frame.add(passwordStr); JTextField userID = new JTextField();userID.setBounds(300, 200, 150, 25);frame.add(userID);JPasswordField password = new JPasswordField();password.setBounds(300, 250, 150, 25);frame.add(password);JButton buttonlogin = new JButton("登录");buttonlogin.setBounds(275, 300, 70, 25);frame.add(buttonlogin);JButton buttonregister = new JButton("注册");buttonregister.setBounds(375, 300, 70, 25);frame.add(buttonregister);frame.setBounds(400, 100, 800, 640);frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);frame.setVisible(true);//为登录按钮添加监听器 buttonlogin.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {String ID = userID.getText();String passwd = new String (password.getPassword());//创建一个Admin用户，把输入框中的用户名密码和提出来Admin admin = new Admin();admin.setID(ID);admin.setPassword(passwd);//登录Login login = new Login();login.setAdmin(admin);if(login.JudgeAdmin()==0) {//弹出账号或密码错误的窗口JFrame frame = new JFrame("账号或密码错误");frame.setLayout(null);JButton buttonqueding = new JButton("确定");buttonqueding.setBounds(100, 100, 70, 70);frame.add(buttonqueding);frame.setBounds(450, 450, 300, 300);frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);frame.setVisible(true);buttonqueding.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {//注册页面frame.setVisible(false);@SuppressWarnings("unused")Login_Register ar = new Login_Register();}});//清除密码框中的信息password.setText("");//清除账号框中的信息userID.setText("");//System.out.println("登陆失败");} else {//弹出登录成功的窗口JFrame frame = new JFrame("登录成功");frame.setLayout(null);JButton buttonqueding2 = new JButton("确定");buttonqueding2.setBounds(100, 100, 70, 25);frame.add(buttonqueding2);frame.setBounds(450, 450, 300, 300);frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);frame.setVisible(true);buttonqueding2.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {//注册页面frame.setVisible(false);@SuppressWarnings("unused")Window ar =new Window();}}); }} }); //为注册按钮添加监听器 buttonregister.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { //注册页面 frame.setVisible(false); @SuppressWarnings("unused")AdminRegister ar = new AdminRegister();} });}public static void main(String []args) {//主程序 //登录窗口@SuppressWarnings("unused")Login_Register login_register = new Login_Register();}}

登录功能

package sutdent_maniger;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class Login {Admin admin;void setAdmin(Admin admin) {this.admin=admin;//System.out.println(this.admin.getPassword()+" " + this.admin.getID());}/* * JudgeAdmin()方法 * 判断Admin的ID和密码是否正确，如果正确，显示登录成功 * 如果错误，弹出一个窗口，显示账号或密码错误 */private String driver = "com.mysql.cj.jdbc.Driver";private String url = "jdbc:mysql://localhost:3306/数据库名" />

管理员注册页面

package sutdent_maniger;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.SQLException;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JPasswordField;import javax.swing.JTextField;/* * 管理员注册界面 **/public class AdminRegister extends JFrame{/** **/private static final long serialVersionUID = 1L;AdminRegister () {init();}void init() {JFrame frame = new JFrame("注册管理员账号");frame.setLayout(null);JLabel nameStr = new JLabel("用户名:");nameStr.setBounds(250, 150, 100, 25);frame.add(nameStr);JLabel IDStr = new JLabel("账号:");IDStr.setBounds(250, 200, 100, 25);frame.add(IDStr);JLabel passwordStr = new JLabel("密码:");passwordStr.setBounds(250, 250, 100, 25);frame.add(passwordStr);JLabel confrimStr = new JLabel("确认密码:");confrimStr.setBounds(250, 300, 100, 30);frame.add(confrimStr);JTextField userName = new JTextField();userName.setBounds(320, 150, 150, 25);frame.add(userName);JTextField userID = new JTextField();userID.setBounds(320, 200, 150, 25);frame.add(userID);JPasswordField password = new JPasswordField();password.setBounds(320, 250, 150, 25);frame.add(password);JPasswordField confrimPassword = new JPasswordField();confrimPassword.setBounds(320, 300, 150, 25);frame.add(confrimPassword);JButton buttonregister = new JButton("注册");buttonregister.setBounds(350, 350, 70, 25);frame.add(buttonregister);frame.setBounds(400, 100, 800, 640);frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);frame.setVisible(true);//为注册按钮增加监听器buttonregister.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {String name = userName.getText();String ID = userID.getText();String passwd = new String (password.getPassword());String confrimpasswd = new String (confrimPassword.getPassword());//创建Register类Register register = new Register();register.setID(ID);register.setName(name);register.setPassword(passwd);register.setconfirmpasswd(confrimpasswd);//如果注册成功，返回登录界面try {if(register.JudgeRegister()) {frame.setVisible(false);@SuppressWarnings("unused")Login_Register login_register = new Login_Register();}} catch (SQLException e1) {// TODO Auto-generated catch block//e1.printStackTrace();} catch (ClassNotFoundException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}});}}

注册功能

package sutdent_maniger;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.SQLException;import javax.swing.JOptionPane;public class Register {String name;String ID;String password;String confirmpassword;private String driver = "com.mysql.cj.jdbc.Driver";private String url = "jdbc:mysql://localhost:3306/数据库" />

功能页面创建

package sutdent_maniger;import java.awt.*;import java.awt.event.*;import javax.swing.*;public class Window extends JFrame{/** **/private static final long serialVersionUID = 1L;Window () {init();}void init() { JFrame jframe = new JFrame("学生管理系统") ; //window Dimension d = new Dimension(400,300); Point p = new Point (250,350); jframe.setSize(d); jframe.setLocation(p); jframe.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); jframe.setVisible(true); JButton button1 = new JButton("添加"); JButton button2 = new JButton("修改"); JButton button3 = new JButton("查询"); JButton button4 = new JButton("删除"); JButton button5 = new JButton("浏览"); FlowLayout flow = new FlowLayout(FlowLayout.LEFT,10,10); JPanel panel = new JPanel(flow); panel.add(button1); panel.add(button2); panel.add(button3); panel.add(button4); panel.add(button5); jframe.add(panel); button1.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){@SuppressWarnings("unused")Add add = new Add(); }}); button2.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){@SuppressWarnings("unused")Change change = new Change();}}); button3.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){@SuppressWarnings("unused")Ask ask = new Ask();}}); button4.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){@SuppressWarnings("unused")Delete delete = new Delete();}}); button5.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){@SuppressWarnings("unused")Look look = new Look();}}); }}

功能实现

增

package sutdent_maniger;import java.sql.*;import java.awt.*;import java.awt.event.*;import javax.swing.*;public class Add extends JFrame {/** **/private static final long serialVersionUID = 1L;JLabel jlnumber = new JLabel("学号：");JLabel jlname = new JLabel("姓名：");JLabel jlsex = new JLabel("性别：");JLabel jlbirthday = new JLabel("出生日期：");JLabel jldepartment = new JLabel("学院：");JTextField jtnumber = new JTextField("",20);JTextField jtname = new JTextField("",20);JTextField jtsex = new JTextField("",20);JTextField jtbirthday = new JTextField("",20);JTextField jtdepartment = new JTextField("",20);JButton buttonadd = new JButton("添加");JButton buttonreturn = new JButton("返回");public Add() {JPanel jpnumber = new JPanel();JPanel jpname = new JPanel();JPanel jpsex = new JPanel();JPanel jpbirthday = new JPanel();JPanel jpdepartment = new JPanel();JPanel jpforbutton = new JPanel(new GridLayout(1,1));jpnumber.add(jlnumber);jpnumber.add(jtnumber);jpname.add(jlname);jpname.add(jtname);jpsex.add(jlsex);jpsex.add(jtsex);jpbirthday.add(jlbirthday);jpbirthday.add(jtbirthday);jpdepartment.add(jldepartment);jpdepartment.add(jtdepartment);jpforbutton.add(buttonadd);jpforbutton.add(buttonreturn);buttonadd.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){//AddConnection conn = null; @SuppressWarnings("unused")Statement stat = null;PreparedStatement ps=null;String sql = "INSERT INTO sqb_xueshengxinxi(number,name,sex,birthday,department) "+ "values(" />

删

package sutdent_maniger;import java.sql.*;import java.awt.*;import java.awt.event.*;import javax.swing.*; public class Delete extends JFrame {/** **/private static final long serialVersionUID = 1L;JLabel jlnumber = new JLabel("学号：");JTextField jtnumber = new JTextField("",20);JButton buttondelete = new JButton("删除");JButton buttonreturn = new JButton("返回");public Delete() {JPanel jpnumber = new JPanel();JPanel jpforbutton = new JPanel(new GridLayout(1,1));jpnumber.add(jlnumber);jpnumber.add(jtnumber);jpforbutton.add(buttondelete);jpforbutton.add(buttonreturn);buttondelete.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){String number = jtnumber.getText();Connection conn = null;@SuppressWarnings("unused")ResultSet res = null;Statement stat = null;String sql = "DELETE FROM sqb_xueshengxinxi WHERE number='"+number+"'";try{Class.forName("com.mysql.cj.jdbc.Driver");}catch(Exception a){a.printStackTrace();}try{conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库" />

改

package sutdent_maniger;import java.sql.*;import java.awt.*;import java.awt.event.*;import javax.swing.*;public class Change extends JFrame {/** **/private static final long serialVersionUID = 1L;JLabel jlnumber = new JLabel("学号：");JLabel jlname = new JLabel("姓名：");JLabel jlsex = new JLabel("性别：");JLabel jlbirthday = new JLabel("出生日期：");JLabel jldepartment = new JLabel("学院：");JTextField jtnumber = new JTextField("",20);JTextField jtname = new JTextField("",20);JTextField jtsex = new JTextField("",20);JTextField jtbirthday = new JTextField("",20);JTextField jtdepartment = new JTextField("",20);JButton buttonchange = new JButton("修改");JButton buttonreturn = new JButton("返回");public Change() {JPanel jpnumber = new JPanel();JPanel jpname = new JPanel();JPanel jpsex = new JPanel();JPanel jpbirthday = new JPanel();JPanel jpdepartment = new JPanel();JPanel jpforbutton = new JPanel(new GridLayout(1,1));jpnumber.add(jlnumber);jpnumber.add(jtnumber);jpname.add(jlname);jpname.add(jtname);jpsex.add(jlsex);jpsex.add(jtsex);jpbirthday.add(jlbirthday);jpbirthday.add(jtbirthday);jpdepartment.add(jldepartment);jpdepartment.add(jtdepartment);jpforbutton.add(buttonchange);jpforbutton.add(buttonreturn);buttonchange.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){@SuppressWarnings("unused")String number = jtnumber.getText();String name = jtname.getText();String sex = jtsex.getText();String birthday = jtbirthday.getText();String department = jtdepartment.getText();Connection conn = null;ResultSet res = null;Statement stat = null;String sql = "SELECT number,name,sex,birthday,department FROM 数据表;";try{Class.forName("com.mysql.cj.jdbc.Driver");}catch(Exception d){System.out.println("jdbc fall");d.printStackTrace();}try{conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库" />

查

package sutdent_maniger;import java.sql.*;import java.awt.*;import java.awt.event.*;import javax.swing.*;public class Ask extends JFrame {/** **/private static final long serialVersionUID = 1L;JLabel jlnumber = new JLabel("学号：");JLabel jlname = new JLabel("姓名：");JLabel jlsex = new JLabel("性别：");JLabel jlbirthday = new JLabel("出生日期：");JLabel jldepartment = new JLabel("学院：");JTextField jtnumber = new JTextField("",20);JLabel jname = new JLabel();JLabel jsex = new JLabel();JLabel jbirthday = new JLabel();JLabel jdepartment = new JLabel();JButton buttonask = new JButton("查询");JButton buttonreturn = new JButton("返回");public Ask() {JPanel jpnumber = new JPanel();JPanel jpname = new JPanel();JPanel jpsex = new JPanel();JPanel jpbirthday = new JPanel();JPanel jpdepartment = new JPanel();JPanel jpforbutton = new JPanel(new GridLayout(1,1));jpnumber.add(jlnumber);jpnumber.add(jtnumber);jpname.add(jlname);jpname.add(jname);jpsex.add(jlsex);jpsex.add(jsex);jpbirthday.add(jlbirthday);jpbirthday.add(jbirthday);jpdepartment.add(jldepartment);jpdepartment.add(jdepartment);jpforbutton.add(buttonask);jpforbutton.add(buttonreturn);buttonask.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){Connection conn = null;ResultSet res = null;Statement stat = null;String sql = "SELECT number,name,sex,birthday,department FROM 数据表;";try{Class.forName("com.mysql.cj.jdbc.Driver");}catch(Exception d){System.out.println("jdbc fall");d.printStackTrace();}try{conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库" />

浏览所有信息

package sutdent_maniger;import java.sql.*;import java.awt.*;import javax.swing.*;import java.util.*;public class Look extends JFrame {/** **/private static final long serialVersionUID = 1L;Connection conn = null;PreparedStatement ps = null;ResultSet res = null;//JButton buttonlook = new JButton("浏览");//JButton buttonreturn = new JButton("返回");JTable jtable;JScrollPane jscrollpane = new JScrollPane();Vector columnNames = null;Vector<Vector> rowData = null;public Look() {JPanel jpforbutton = new JPanel(new GridLayout(1,1));columnNames = new Vector();columnNames.add("学号");columnNames.add("姓名");columnNames.add("性别");columnNames.add("出生日期");columnNames.add("学院");rowData = new Vector<Vector>();//jpforbutton.add(buttonlook);//jpforbutton.add(buttonreturn);try {Class.forName("com.mysql.cj.jdbc.Driver");conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库" /> hang = new Vector();hang.add(res.getString(1));hang.add(res.getString(2));hang.add(res.getString(3));hang.add(res.getString(4));hang.add(res.getString(5));rowData.add(hang);}System.out.println("loadok!");}catch (Exception q){q.printStackTrace();System.out.println("go die");}finally{try{res.close();ps.close();conn.close();System.out.println("close ok");}catch (SQLException o){o.printStackTrace();System.out.println("go die 2");}}jtable = new JTable(rowData,columnNames);jscrollpane = new JScrollPane(jtable);this.add(jscrollpane);this.setTitle("浏览学生信息");this.setLayout(new GridLayout(2,5));this.add(jpforbutton);this.setLocation(300,300);this.setSize(500,300);this.setVisible(true);this.setResizable(false);}}

结语

利用java+MySQL实现学生信息管理系统大大提高了学生信息整理的工作效率，节约时间，节约成本，是一个很好地，非常方便的系统，对于教育工作而言是具有重要意义的。希望大家可以借助该系统可以学习到更多的编程知识，提升自我水平。

完整资源请参考

1.上传明细-CSDN创作中心

2.链接: https://pan.baidu.com/s/1pGofUyk2Vd1mOqY-ptVRBw?pwd=c2e8 提取码: c2e8 复制这段内容后打开百度网盘手机App，操作更方便哦