java流程可视化管理_Java实训（GUI和mysql8.0）——可视化学生管理系统

里面有源码工程文件和相关工具

mysql8.0官网下载

主窗口

package 学籍管理系统视窗;

import java.awt.BorderLayout;

import java.awt.EventQueue;

import javax.swing.JFrame;

import javax.swing.JPanel;

import javax.swing.border.EmptyBorder;

import java.awt.CardLayout;

import java.awt.Toolkit;

import javax.swing.JMenuBar;

import javax.swing.JMenu;

import javax.swing.JMenuItem;

import java.awt.event.MouseAdapter;

import java.awt.event.MouseEvent;

import java.sql.SQLException;

import javax.swing.JButton;

import java.awt.event.ActionListener;

import java.awt.event.ActionEvent;

import javax.swing.SwingConstants;

import javax.swing.ImageIcon;

import javax.swing.KeyStroke;

import java.awt.event.KeyEvent;

import java.awt.event.InputEvent;

public class 主窗口 extends JFrame {

private JPanel contentPane;

/**

* Launch the application.

*/

public static void main(String[] args) {

EventQueue.invokeLater(new Runnable() {

public void run() {

try {

主窗口 frame = new 主窗口();

frame.setVisible(true);

} catch (Exception e) {

e.printStackTrace();

}

}

});

}

/**

* Create the frame.

* @throws SQLException

*/

public 主窗口() throws SQLException {

//this.setLocationRelativeTo(null);

setBounds(100, 100, 800, 500);

this.setLocationRelativeTo(null);

contentPane = new JPanel();

contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));

setContentPane(contentPane);

CardLayout card=new CardLayout();

contentPane.setLayout(card);

欢迎面板 欢迎面板=new 欢迎面板();

contentPane.add("0",欢迎面板);

修改面板 修改面板=new 修改面板();

contentPane.add("2",修改面板);

录入面板 录入面板=new 录入面板();

contentPane.add("1",录入面板);

删除面板 删除面板=new 删除面板();

contentPane.add("3",删除面板);

查询面板 查询面板=new 查询面板();

contentPane.add("4",查询面板);

查看面板 查看面板=new 查看面板();

contentPane.add("5",查看面板);

setTitle("\u5E7F\u5DDE\u822A\u6D77\u5B66\u9662\u5B66\u751F\u7BA1\u7406\u7CFB\u7EDF");

setIconImage(Toolkit.getDefaultToolkit().getImage("E:\\eclipse64\u4F4D\\workplace\\\u5B66\u7C4D\u7BA1\u7406\u7CFB\u7EDF\u89C6\u7A97\\image\\668eca61e8886291e5af08b33983448e.jpg"));

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

JMenuBar menuBar = new JMenuBar();

setJMenuBar(menuBar);

JMenu menu = new JMenu("\u64CD\u4F5C\u83DC\u5355");

menu.setIcon(new ImageIcon("E:\\eclipse64\u4F4D\\workplace\\\u5B66\u7C4D\u7BA1\u7406\u7CFB\u7EDF\u89C6\u7A97\\image\\\u622A\u56FE20190624192426.png"));

menuBar.add(menu);

JMenuItem menuItem = new JMenuItem("\u5F55\u5165\u5B66\u751F\u4FE1\u606F");

menuItem.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_Q, InputEvent.ALT_MASK));

menuItem.setIcon(new ImageIcon("E:\\eclipse64\u4F4D\\workplace\\\u5B66\u7C4D\u7BA1\u7406\u7CFB\u7EDF\u89C6\u7A97\\image\\\u622A\u56FE20190624192512.png"));

menuItem.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

card.show(contentPane, "1");

}

});

menu.add(menuItem);

JMenuItem menuItem_1 = new JMenuItem("\u4FEE\u6539\u5B66\u751F\u4FE1\u606F");

menuItem_1.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_W, InputEvent.ALT_MASK));

menuItem_1.setIcon(new ImageIcon("E:\\eclipse64\u4F4D\\workplace\\\u5B66\u7C4D\u7BA1\u7406\u7CFB\u7EDF\u89C6\u7A97\\image\\\u622A\u56FE20190624192548.png"));

menuItem_1.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

card.show(contentPane, "2");

}

});

menu.add(menuItem_1);

JMenuItem menuItem_2 = new JMenuItem("\u5220\u9664\u5B66\u751F\u4FE1\u606F");

menuItem_2.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_E, InputEvent.ALT_MASK));

menuItem_2.setIcon(new ImageIcon("E:\\eclipse64\u4F4D\\workplace\\\u5B66\u7C4D\u7BA1\u7406\u7CFB\u7EDF\u89C6\u7A97\\image\\\u622A\u56FE20190624192731.png"));

menuItem_2.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

card.show(contentPane, "3");

}

});

menu.add(menuItem_2);

JMenuItem menuItem_3 = new JMenuItem("\u67E5\u8BE2\u5B66\u751F\u4FE1\u606F");

menuItem_3.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_R, InputEvent.ALT_MASK));

menuItem_3.setIcon(new ImageIcon("E:\\eclipse64\u4F4D\\workplace\\\u5B66\u7C4D\u7BA1\u7406\u7CFB\u7EDF\u89C6\u7A97\\image\\\u622A\u56FE20190624192757.png"));

menuItem_3.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

card.show(contentPane, "4");

}

});

menu.add(menuItem_3);

JMenuItem menuItem_4 = new JMenuItem("\u663E\u793A\u6240\u6709\u4FE1\u606F");

menuItem_4.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_D, InputEvent.ALT_MASK));

menuItem_4.setIcon(new ImageIcon("E:\\eclipse64\u4F4D\\workplace\\\u5B66\u7C4D\u7BA1\u7406\u7CFB\u7EDF\u89C6\u7A97\\image\\\u622A\u56FE20190624192820.png"));

menuItem_4.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

card.show(contentPane, "5");

}

});

menu.add(menuItem_4);

}

}

欢迎面板

package 学籍管理系统视窗;

import javax.swing.JPanel;

import javax.swing.JTextArea;

import javax.swing.JLabel;

import java.awt.Color;

import java.awt.Font;

public class 欢迎面板 extends JPanel {

/**

* Create the panel.

*/

public 欢迎面板() {

setBackground(Color.CYAN);

setLayout(null);

JLabel lblNewLabel = new JLabel("\u6B22\u8FCE\u4F7F\u7528\u5E7F\u5DDE\u822A\u6D77\u5B66\u9662\u5B66\u751F\u7BA1\u7406\u7CFB\u7EDF");

lblNewLabel.setFont(new Font("宋体", Font.PLAIN, 24));

lblNewLabel.setBounds(34, 90, 387, 62);

add(lblNewLabel);

JLabel label = new JLabel("\u8BF7\u4F60\u6309\u5DE6\u4E0A\u89D2\u83DC\u5355\u680F\u63D0\u793A\u64CD\u4F5C");

label.setBounds(100, 178, 233, 18);

add(label);

}

}

录入面板

package 学籍管理系统视窗;

import java.awt.event.ItemEvent;

import java.awt.event.ItemListener;

import java.awt.event.MouseAdapter;

import java.awt.event.MouseEvent;

import java.sql.Connection;

import java.sql.SQLException;

import javax.swing.ButtonGroup;

import javax.swing.ComboBoxModel;

import javax.swing.DefaultComboBoxModel;

import javax.swing.JButton;

import javax.swing.JComboBox;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JRadioButton;

import javax.swing.JTextField;

import 数据库.Test;

import java.awt.event.ActionListener;

import java.awt.event.ActionEvent;

public class 录入面板 extends JPanel {

private JTextField textField;

private JTextField textField_1;

private JTextField textField_2;

private JLabel lblNewLabel;

/**

* Create the panel.

*/

public 录入面板() {

setLayout(null);

lblNewLabel = new JLabel("\u5B66\u53F7");

lblNewLabel.setBounds(72, 55, 30, 18);

add(lblNewLabel);

JLabel label = new JLabel("\u59D3\u540D");

label.setBounds(72, 24, 30, 18);

add(label);

textField = new JTextField("请输入学号");

textField.setBounds(116, 52, 130, 24);

textField.addMouseListener(new MouseAdapter() {

@Override

public void mouseClicked(MouseEvent e) {

textField.setText("");

}

});

add(textField);

textField.setColumns(10);

textField_1 = new JTextField("请输入姓名");

textField_1.setBounds(116, 21, 130, 24);

textField_1.addMouseListener(new MouseAdapter() {

@Override

public void mouseClicked(MouseEvent e) {

textField_1.setText("");

}

});

add(textField_1);

textField_1.setColumns(10);

JLabel label_1 = new JLabel("\u6027\u522B");

label_1.setBounds(72, 89, 30, 18);

add(label_1);

JRadioButton radioButton = new JRadioButton("\u7537");

radioButton.setBounds(126, 85, 43, 27);

add(radioButton);

JRadioButton radioButton_1 = new JRadioButton("\u5973");

radioButton_1.setBounds(175, 85, 55, 27);

add(radioButton_1);

//创建ButtonGroup对象

ButtonGroup btgSex = new ButtonGroup();

btgSex.add(radioButton);

btgSex.add(radioButton_1);

JLabel label_2 = new JLabel("\u5B66\u9662");

label_2.setBounds(72, 120, 30, 18);

add(label_2);

ComboBoxModel aModel1=new DefaultComboBoxModel(new String[]{"航海技术","航海技术1","航海技术2"});

ComboBoxModel aModel2=new DefaultComboBoxModel(new String[]{"轮机工程学","轮机工程学1","轮机工程学2"});

ComboBoxModel aModel3=new DefaultComboBoxModel(new String[]{"计算机科学与技术","电子商务(本科)","软件技术","计算机应用技术","电子商务"});

ComboBoxModel aModel4=new DefaultComboBoxModel(new String[]{"英语","日语","外语学"});

JComboBox comboBox_1 = new JComboBox();

comboBox_1.setBounds(110, 151, 168, 24);

comboBox_1.setToolTipText("");

add(comboBox_1);

JComboBox comboBox = new JComboBox();

comboBox.setBounds(110, 117, 164, 24);

comboBox.addItemListener(new ItemListener() {

public void itemStateChanged(ItemEvent e) {

if(e.getStateChange()==ItemEvent.SELECTED)

{

int a=comboBox.getSelectedIndex();

if(a==0)

{

comboBox_1.setModel(aModel1);

comboBox_1.setSelectedIndex(-1);

}

else if(a==1)

{

comboBox_1.setModel(aModel2);

comboBox_1.setSelectedIndex(-1);

}

else if(a==2)

{

comboBox_1.setModel(aModel3);

comboBox_1.setSelectedIndex(-1);

}

else if(a==3)

{

comboBox_1.setModel(aModel4);

comboBox_1.setSelectedIndex(-1);

}

}

}

});

comboBox.setModel(new DefaultComboBoxModel(new String[] {"海运学院", "轮机工程学院", "信息与通信工程学院", "外语学院"}));

comboBox.setSelectedIndex(-1);

add(comboBox);

JButton button = new JButton("\u5F55\u5165");

button.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

String sex="";

if(radioButton.isSelected()) {

sex=radioButton.getText();

}else {

sex=radioButton_1.getText();

}

if(textField_1.getText().equals("")||textField_1.getText().equals("请输入姓名")) {

JOptionPane.showMessageDialog(null,"请输入姓名","错误",JOptionPane.ERROR_MESSAGE);

return;

}

if(textField.getText().equals("")||textField.getText().equals("请输入学号")) {

JOptionPane.showMessageDialog(null,"请输入学号","错误",JOptionPane.ERROR_MESSAGE);

return;

}

if(comboBox.getSelectedIndex()==-1) {

JOptionPane.showMessageDialog(null,"请选择学院","错误",JOptionPane.ERROR_MESSAGE);

return;

}

if(comboBox_1.getSelectedIndex()==-1) {

JOptionPane.showMessageDialog(null,"请选择专业","错误",JOptionPane.ERROR_MESSAGE);

return;

}

if(textField_2.getText().equals("")) {

JOptionPane.showMessageDialog(null,"请输入班级","错误",JOptionPane.ERROR_MESSAGE);

return;

}

//保存数据

String sno=textField.getText();

String name=textField_1.getText();

String ssex;

if(radioButton.isSelected()) {

ssex="男";

}else

ssex="女";

String department=comboBox.getSelectedItem().toString();

String major=comboBox_1.getSelectedItem().toString();

String myclass=textField_2.getText();

//调用自己链接数据库操作方法test

Connection sin=Test.getconnectin();

boolean flag;

flag=Test.chongfu(sin,sno);

System.out.println(flag);

if(flag==false) {

Object str[]={sno,name,ssex,department,major,myclass};

Test.insert(sin, str);

JOptionPane.showMessageDialog(null,"录入成功","提示",JOptionPane.INFORMATION_MESSAGE);

radioButton.setSelected(false);

radioButton_1.setSelected(false);

textField.setText("请输入学号");

textField_1.setText("请输入姓名");

textField_2.setText("");

comboBox.setSelectedIndex(-1);

comboBox_1.setSelectedIndex(-1);

}

else

JOptionPane.showMessageDialog(null,"失败，学号重复","提示",JOptionPane.INFORMATION_MESSAGE);

}

});

button.setBounds(203, 232, 63, 27);

add(button);

JButton button_1 = new JButton("\u91CD\u7F6E");

button_1.addMouseListener(new MouseAdapter() {

@Override

public void mouseClicked(MouseEvent e) {

radioButton.setSelected(false);

radioButton_1.setSelected(false);

textField.setText("请输入学号");

textField_1.setText("请输入姓名");

textField_2.setText("");

comboBox.setSelectedIndex(-1);

comboBox_1.setSelectedIndex(-1);

JOptionPane.showMessageDialog(null,"重置成功","提示",JOptionPane.INFORMATION_MESSAGE);

}

});

button_1.setBounds(106, 232, 63, 27);

add(button_1);

JLabel label_3 = new JLabel("\u4E13\u4E1A");

label_3.setBounds(72, 154, 30, 18);

add(label_3);

JLabel label_4 = new JLabel("\u73ED\u7EA7");

label_4.setBounds(72, 191, 30, 18);

add(label_4);

textField_2 = new JTextField();

textField_2.setBounds(110, 188, 164, 24);

add(textField_2);

textField_2.setColumns(10);

}

}

修改面板

package 学籍管理系统视窗;

import javax.swing.JPanel;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import java.awt.Font;

import java.awt.event.ItemEvent;

import java.awt.event.ItemListener;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.JTextField;

import 数据库.Test;

import javax.swing.ButtonGroup;

import javax.swing.ComboBoxModel;

import javax.swing.DefaultComboBoxModel;

import javax.swing.JButton;

import javax.swing.JComboBox;

import javax.swing.JRadioButton;

import java.awt.event.ActionListener;

import java.awt.event.ActionEvent;

public class 修改面板 extends JPanel {

private JTextField textField;

private JTextField textField_1;

private JTextField textField_2;

/**

* Create the panel.

*/

public 修改面板() {

setLayout(null);

JLabel label = new JLabel("\u8F93\u5165\u8981\u4FEE\u6539\u4FE1\u606F\u7684\u5B66\u53F7\uFF1A");

label.setFont(new Font("宋体", Font.PLAIN, 16));

label.setBounds(42, 18, 177, 18);

add(label);

textField = new JTextField();

textField.setBounds(213, 15, 144, 24);

add(textField);

textField.setColumns(10);

JLabel label_1 = new JLabel("\uFF08\u65B0\uFF09\u59D3\u540D\uFF1A");

label_1.setBounds(42, 76, 120, 18);

add(label_1);

textField_1 = new JTextField();

textField_1.setBounds(133, 73, 120, 24);

add(textField_1);

textField_1.setColumns(10);

JRadioButton radioButton = new JRadioButton("\u7537");

radioButton.setBounds(107, 119, 51, 27);

add(radioButton);

JRadioButton radioButton_1 = new JRadioButton("\u5973");

radioButton_1.setBounds(168, 119, 51, 27);

add(radioButton_1);

ButtonGroup btgSex = new ButtonGroup();

btgSex.add(radioButton);

btgSex.add(radioButton_1);

ComboBoxModel aModel1=new DefaultComboBoxModel(new String[]{"航海技术","航海技术1","航海技术2"});

ComboBoxModel aModel2=new DefaultComboBoxModel(new String[]{"轮机工程学","轮机工程学1","轮机工程学2"});

ComboBoxModel aModel3=new DefaultComboBoxModel(new String[]{"计算机科学与技术","电子商务(本科)","软件技术","计算机应用技术","电子商务"});

ComboBoxModel aModel4=new DefaultComboBoxModel(new String[]{"英语","日语","外语学"});

JComboBox comboBox_1 = new JComboBox();

comboBox_1.setToolTipText("");

comboBox_1.setBounds(133, 207, 185, 24);

this.add(comboBox_1);

JComboBox comboBox = new JComboBox();

comboBox.addItemListener(new ItemListener() {

public void itemStateChanged(ItemEvent e) {

if(e.getStateChange()==ItemEvent.SELECTED)

{

int a=comboBox.getSelectedIndex();

if(a==0)

{

comboBox_1.setModel(aModel1);

comboBox_1.setSelectedIndex(-1);

}

else if(a==1)

{

comboBox_1.setModel(aModel2);

comboBox_1.setSelectedIndex(-1);

}

else if(a==2)

{

comboBox_1.setModel(aModel3);

comboBox_1.setSelectedIndex(-1);

}

else if(a==3)

{

comboBox_1.setModel(aModel4);

comboBox_1.setSelectedIndex(-1);

}

}

}

});

comboBox.setModel(new DefaultComboBoxModel(new String[] {"\u6D77\u8FD0\u5B66\u9662", "\u8F6E\u673A\u5DE5\u7A0B\u5B66\u9662", "\u4FE1\u606F\u4E0E\u901A\u4FE1\u5DE5\u7A0B\u5B66\u9662", "\u5916\u8BED\u5B66\u9662"}));

comboBox.setSelectedIndex(-1);

comboBox.setBounds(133, 167, 182, 24);

this.add(comboBox);

JLabel lblNewLabel = new JLabel("\u65B0\u5B66\u9662\uFF1A");

lblNewLabel.setBounds(72, 169, 71, 18);

add(lblNewLabel);

JLabel label_2 = new JLabel("\u65B0\u4E13\u4E1A\uFF1A");

label_2.setBounds(70, 210, 72, 18);

add(label_2);

JLabel label_3 = new JLabel("\u65B0 \u73ED\u7EA7");

label_3.setBounds(72, 247, 72, 18);

add(label_3);

textField_2 = new JTextField();

textField_2.setBounds(133, 244, 185, 24);

add(textField_2);

textField_2.setColumns(10);

JButton button = new JButton("\u4FEE\u6539");

button.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

String sno=textField.getText();

String name=textField_1.getText();

String ssex;

if(radioButton.isSelected()) {

ssex="男";

}else

ssex="女";

String department=comboBox.getSelectedItem().toString();

String major=comboBox_1.getSelectedItem().toString();

String myclass=textField_2.getText();

//调用自己链接数据库操作方法test

Object str[]={sno,name,ssex,department,major,myclass};

Connection sin=Test.getconnectin();

Test.update(sin, str);

radioButton.setSelected(false);

radioButton_1.setSelected(false);

textField.setText("");

textField_1.setText("");

textField_2.setText("");

comboBox.setSelectedIndex(-1);

comboBox_1.setSelectedIndex(-1);

JOptionPane.showMessageDialog(null,"修改成功","提示",JOptionPane.NO_OPTION );

}

});

button.setBounds(82, 282, 114, 27);

add(button);

JButton button_1 = new JButton("\u91CD\u7F6E");

button_1.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

radioButton.setSelected(false);

radioButton_1.setSelected(false);

textField.setText("");

textField_1.setText("");

textField_2.setText("");

comboBox.setSelectedIndex(-1);

comboBox_1.setSelectedIndex(-1);

JOptionPane.showMessageDialog(null,"重置成功!","信息",JOptionPane.INFORMATION_MESSAGE );

}

});

button_1.setBounds(204, 282, 114, 27);

add(button_1);

JButton btnNewButton = new JButton("\u67E5\u8BE2");

btnNewButton.setToolTipText("");

btnNewButton.setBounds(364, 15, 79, 27);

add(btnNewButton);

btnNewButton.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

Connection sin=Test.getconnectin();

String sno=textField.getText();

ResultSet rs=null;

PreparedStatement stmt=null;

boolean flag=false;

try {

//牛逼查找

stmt=sin.prepareStatement("select * from student where sno=?");

stmt.setObject(1,sno);

rs=stmt.executeQuery();

while(rs.next()){

String msg=rs.getString("sno")+"\n"+rs.getString("name")+"\n"+rs.getString("sex")+"\n"+rs.getString("department")+"\n"+rs.getString("subject")+"\n"+rs.getString("myclass")+"\n";

//JOptionPane.showMessageDialog(null,msg,"查询结果：",JOptionPane.NO_OPTION );

flag=true;

//修改

textField_1.setText(rs.getString("name"));

String ssex=null;

ssex=rs.getString("sex");

if(ssex.equalsIgnoreCase("男")) {

radioButton.setSelected(true);

}else {

radioButton_1.setSelected(true);

}

textField_2.setText(rs.getString("myclass"));

comboBox.setSelectedItem(rs.getString("department"));

comboBox_1.setSelectedItem(rs.getString("subject"));

}

if(flag==false) {

radioButton.setSelected(false);

radioButton_1.setSelected(false);

textField_1.setText("");

textField_2.setText("");

comboBox.setSelectedIndex(-1);

comboBox_1.setSelectedIndex(-1);

JOptionPane.showMessageDialog(null,"查无此人","查询结果",JOptionPane.NO_OPTION );

}

stmt.close();//关闭数据库

sin.close();

} catch (SQLException h) {

// TODO Auto-generated catch block

h.printStackTrace();

}

}

});

}

}

查询面板

package 学籍管理系统视窗;

import javax.swing.JPanel;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JTextField;

import 数据库.Test;

import javax.swing.JButton;

import java.awt.event.ActionListener;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.awt.event.ActionEvent;

public class 查询面板 extends JPanel {

private JTextField textField;

private JTextField textField_1;

private JTextField textField_2;

private JTextField textField_3;

private JTextField textField_4;

private JTextField textField_5;

/**

* Create the panel.

*/

public 查询面板() {

setLayout(null);

JLabel label = new JLabel("\u8F93\u5165\u8981\u67E5\u8BE2\u4FE1\u606F\u7684\u5B66\u53F7\uFF1A");

label.setBounds(37, 22, 189, 18);

add(label);

textField = new JTextField();

textField.setBounds(201, 19, 154, 24);

add(textField);

textField.setColumns(10);

JLabel label_1 = new JLabel("\u59D3\u540D");

label_1.setBounds(72, 60, 40, 18);

add(label_1);

textField_1 = new JTextField();

textField_1.setEnabled(false);

textField_1.setBounds(112, 60, 150, 24);

add(textField_1);

textField_1.setColumns(10);

JLabel label_2 = new JLabel("\u6027\u522B");

label_2.setBounds(72, 100, 52, 18);

add(label_2);

textField_2 = new JTextField();

textField_2.setEnabled(false);

textField_2.setBounds(112, 100, 150, 24);

add(textField_2);

textField_2.setColumns(10);

JLabel label_3 = new JLabel("\u5B66\u9662");

label_3.setBounds(72, 140, 41, 18);

add(label_3);

textField_3 = new JTextField();

textField_3.setEnabled(false);

textField_3.setBounds(112, 140, 150, 24);

add(textField_3);

textField_3.setColumns(10);

JLabel label_4 = new JLabel("\u4E13\u4E1A");

label_4.setBounds(72, 180, 45, 18);

add(label_4);

textField_4 = new JTextField();

textField_4.setEnabled(false);

textField_4.setBounds(112, 180, 150, 24);

add(textField_4);

textField_4.setColumns(10);

JLabel label_5 = new JLabel("\u73ED\u7EA7");

label_5.setBounds(72, 220, 45, 18);

add(label_5);

textField_5 = new JTextField();

textField_5.setEnabled(false);

textField_5.setBounds(112, 220, 150, 24);

add(textField_5);

textField_5.setColumns(10);

JButton btnNewButton = new JButton("\u67E5\u8BE2");

btnNewButton.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

Connection sin=Test.getconnectin();

String sno=textField.getText();

ResultSet rs=null;

PreparedStatement stmt=null;

try {

//牛逼查找

stmt=sin.prepareStatement("select * from student where sno=?");

stmt.setObject(1,sno);

rs=stmt.executeQuery();

boolean flag=false;

while(rs.next()){

String msg=rs.getString("sno")+"\n"+rs.getString("name")+"\n"+rs.getString("sex")+"\n"+rs.getString("department")+"\n"+rs.getString("subject")+"\n"+rs.getString("myclass")+"\n";

JOptionPane.showMessageDialog(null,msg,"查询结果：",JOptionPane.NO_OPTION );

textField_1.setText(rs.getString("name"));

textField_2.setText(rs.getString("sex"));

textField_3.setText(rs.getString("department"));

textField_4.setText(rs.getString("subject"));

textField_5.setText(rs.getString("myclass"));

flag=true;

}

if(flag==false) {

JOptionPane.showMessageDialog(null,"查无此人","查询结果",JOptionPane.NO_OPTION );

}

stmt.close();//关闭数据库

sin.close();

} catch (SQLException h) {

// TODO Auto-generated catch block

h.printStackTrace();

}

}

});

btnNewButton.setBounds(366, 17, 77, 27);

add(btnNewButton);

}

}

删除面板

package 学籍管理系统视窗;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.JButton;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JTextField;

import 数据库.Test;

public class 删除面板 extends JPanel {

private JTextField textField;

private JTextField textField_1;

private JTextField textField_2;

private JTextField textField_3;

private JTextField textField_4;

private JTextField textField_5;

/**

* Create the panel.

*/

public 删除面板() {

setLayout(null);

JLabel label = new JLabel("\u8F93\u5165\u8981\u5220\u9664\u4FE1\u606F\u7684\u5B66\u53F7\uFF1A");

label.setBounds(37, 22, 189, 18);

add(label);

textField = new JTextField();

textField.setBounds(201, 19, 154, 24);

add(textField);

textField.setColumns(10);

JLabel label_1 = new JLabel("\u59D3\u540D");

label_1.setBounds(72, 60, 40, 18);

add(label_1);

textField_1 = new JTextField();

textField_1.setEnabled(false);

textField_1.setBounds(112, 60, 150, 24);

add(textField_1);

textField_1.setColumns(10);

JLabel label_2 = new JLabel("\u6027\u522B");

label_2.setBounds(72, 100, 52, 18);

add(label_2);

textField_2 = new JTextField();

textField_2.setEnabled(false);

textField_2.setBounds(112, 100, 150, 24);

add(textField_2);

textField_2.setColumns(10);

JLabel label_3 = new JLabel("\u5B66\u9662");

label_3.setBounds(72, 140, 41, 18);

add(label_3);

textField_3 = new JTextField();

textField_3.setEnabled(false);

textField_3.setBounds(112, 140, 150, 24);

add(textField_3);

textField_3.setColumns(10);

JLabel label_4 = new JLabel("\u4E13\u4E1A");

label_4.setBounds(72, 180, 45, 18);

add(label_4);

textField_4 = new JTextField();

textField_4.setEnabled(false);

textField_4.setBounds(112, 180, 150, 24);

add(textField_4);

textField_4.setColumns(10);

JLabel label_5 = new JLabel("\u73ED\u7EA7");

label_5.setBounds(72, 220, 45, 18);

add(label_5);

textField_5 = new JTextField();

textField_5.setEnabled(false);

textField_5.setBounds(112, 220, 150, 24);

add(textField_5);

textField_5.setColumns(10);

JButton btnNewButton = new JButton("\u67E5\u8BE2");

btnNewButton.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

Connection sin=Test.getconnectin();

String sno=textField.getText();

ResultSet rs=null;

PreparedStatement stmt=null;

try {

//牛逼查找

stmt=sin.prepareStatement("select * from student where sno=?");

stmt.setObject(1,sno);

rs=stmt.executeQuery();

boolean flag=false;

while(rs.next()){

JOptionPane.showMessageDialog(null,"查询成功","提示",JOptionPane.NO_OPTION );

textField_1.setText(rs.getString("name"));

textField_2.setText(rs.getString("sex"));

textField_3.setText(rs.getString("department"));

textField_4.setText(rs.getString("subject"));

textField_5.setText(rs.getString("myclass"));

flag=true;

}

if(flag==false) {

JOptionPane.showMessageDialog(null,"查无此人","查询结果",JOptionPane.NO_OPTION );

}

stmt.close();//关闭数据库

sin.close();

} catch (SQLException h) {

// TODO Auto-generated catch block

h.printStackTrace();

}

}

});

btnNewButton.setBounds(366, 17, 77, 27);

add(btnNewButton);

JButton button = new JButton("\u5220\u9664");

button.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

//删除操作

String sno=textField.getText();

boolean flag;

Connection sin=Test.getconnectin();

flag=Test.chongfu(sin,sno);

System.out.println(flag);

if(flag) {

Test.delete(sin, sno);

JOptionPane.showMessageDialog(null,"信息删除成功!","信息",JOptionPane.INFORMATION_MESSAGE );

textField.setText("");

textField_1.setText("");

textField_2.setText("");

textField_3.setText("");

textField_4.setText("");

textField_5.setText("");

}

else

JOptionPane.showMessageDialog(null,"该学号信息不存在!","信息",JOptionPane.INFORMATION_MESSAGE );

}

});

button.setBounds(72, 257, 113, 27);

add(button);

JButton button_1 = new JButton("\u91CD\u7F6E");

button_1.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

textField.setText("");

textField_1.setText("");

textField_2.setText("");

textField_3.setText("");

textField_4.setText("");

textField_5.setText("");

JOptionPane.showMessageDialog(null,"重置成功","提示",JOptionPane.NO_OPTION );

}

});

button_1.setBounds(217, 257, 113, 27);

add(button_1);

}

}

数据库类

package 数据库;

import java.sql.*;

import javax.swing.JOptionPane;

public class Test {

public final static Connection getconnectin(){

Connection con=null;

//String driver = "com.mysql.jdbc.Driver"; 8.0不需要加载驱动

String url = "jdbc:mysql://localhost:3306/gip?useUnicode=true&characterEncoding=UTF8&useSSL=false&serverTimezone=Asia/Shanghai";

String user = "root";

String password = "123456";

try{

//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

// Class.forName(driver);

con=DriverManager.getConnection(url,user,password);

con.setCatalog("gip");

}

catch(SQLException sqle){

System.out.println(sqle+"lianjiecuowu");

}

catch(Exception e){

System.out.println(e+"diergecuowu");

}

return con;

}

//添加数据

public final static void insert(Connection con,Object obj[]){

PreparedStatement stmt=null;

try {

stmt=con.prepareStatement("insert into student(sno,name,sex,department,subject,myclass) values(?,?,?,?,?,?)");

stmt.setString(1,obj[0].toString());

stmt.setString(2,obj[1].toString());

stmt.setString(3,obj[2].toString());

stmt.setString(4,obj[3].toString());

stmt.setString(5,obj[4].toString());

stmt.setString(6,obj[5].toString());

stmt.execute();

} catch (SQLException e) {

JOptionPane.showMessageDialog(null,"shibai","操作提示",JOptionPane.NO_OPTION );

}

}

//查询数据

public final static ResultSet query(Connection con){

ResultSet rs=null;

PreparedStatement stmt=null;

try {

stmt=con.prepareStatement("select * from student");

rs=stmt.executeQuery();

//stmt.close();

//con.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return rs;

}

//判断学号重复

public final static boolean chongfu(Connection con,String a){

ResultSet rs=null;

PreparedStatement stmt=null;

boolean flag=true;;

try {

stmt=con.prepareStatement("select sno from student");

rs=stmt.executeQuery();

while(rs.next())

{

if(a.equalsIgnoreCase(rs.getString("sno")))

return true;

//System.out.println(rs.getString("sno"));

}

//stmt.close();

//con.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return false;

}

//删除数据

public final static void delete(Connection con,String s){

try {

PreparedStatement stmt;

stmt=con.prepareStatement("delete from student where sno=?");

stmt.setObject(1,s);

stmt.execute();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

finally{

}

}

//更新修改数据

public final static void update(Connection con,Object obj[]){

PreparedStatement stmt=null;

try {

stmt=con.prepareStatement("update student set name=?,sex=?,department=?,subject=?,myclass=? where sno=?");

stmt.setString(6,obj[0].toString());

stmt.setString(1,obj[1].toString());

stmt.setString(2,obj[2].toString());

stmt.setString(3,obj[3].toString());

stmt.setString(4,obj[4].toString());

stmt.setString(5,obj[5].toString());

stmt.execute();

} catch (SQLException e) {

JOptionPane.showMessageDialog(null,"shibai","操作提示",JOptionPane.NO_OPTION );

}

}

}