devbox
人工智能uu
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

基于Java+MySQL+Swing的学生管理系统_java swing+mysql学生学籍管理系统

作者：人工智能uu | 2024-07-23 23:21:13

赞

踩

java swing+mysql学生学籍管理系统

1.系统简介和开发背景

        该同学工作积极主动、高效，学习认真，待人诚恳，能够做到服从指挥、认真听取老同志的指导，不怕苦、不怕累，表现有较强的求知欲，积极观察、体验、思考，并能够灵活运用自己的知识解决工作中遇到的实际问题。   

本项目使用：jdk1.8、java、mysql、eclipse/idea

2.功能分析

学生管理模块：

（1）增删改查学生信息，当学生还有学习的学员时，不能删除学生信息；

（2）按学生查询选择课程信息，支持名称模糊查询；

学员管理模块：

（1）增删改查学员信息；

（2）按学员名查询学员信息，支持学员名模糊查询和分页显示；

3.功能模块图及说明

        管理员新增学生信息时填写对应的信息，如姓名、课程号等。后台代码将在页面创建的信息提交到控制层进行数据验证，如果信息填写符合规则且数据唯一，则该数据将存储到本地数据库中，否则添加失败。管理员进行登录时首先点击跳转到管理员登录界面按钮，输入相应的信息点击登录。登录界面流程图如图4-1所示，添加学生功能流程图如图4-2所示。

 

图4-1 登录界面流程图

                                               

图4-2 添加学生功能流程图

        管理员修改学生职位信息时可以从快速搜索区，输入学生名称进行查询。按要求填写信息后保存，第一条数据为新添加的数据；管理员修改部门信息时，依次填写好对应的信息，后台代码将信息提交到控制层进行数据验证，验证通过则修改成功，数据存储到本地数据库里，否则失败。职位修改功能流程图如图4-3所示，添加部门功能流程图如图4-4所示。

   图4-3 学生信息修改流程图

图4-4 添加学生功能流程图

学生信息管理系统的主要模块包括增加、删除、修改和查询等操作，以下是这些操作的简单描述：

增加模块：该模块允许管理员将新的学生信息添加到系统中。这通常涉及到填写一个包含各种字段（例如姓名、性别、出生日期、学号、班级等）的表单。系统将检查输入的数据是否有效，例如，学号是否唯一，然后将其添加到数据库中。

删除模块：在此模块中，管理员可以选择并删除系统中的学生信息。例如，当一个学生转学或退学时，管理员可能需要从系统中删除他们的记录。

修改模块：此模块允许管理员更新系统中已有的学生信息。例如，如果学生的家庭地址发生变化，管理员可以通过此模块更新学生的家庭地址信息。在修改数据时，管理员需要确保数据的完整性和准确性。

查询模块：此模块允许管理员和学生查询系统中的学生信息。管理员可以查看学生的全部信息，而学生通常只能查看与他们自己相关的信息，例如他们的成绩、等。

4.部分代码展示

4.1数据库表设计

  1. CREATE TABLE `admin` (
  2.   `Aid` int(11) NOT NULL,
  3.   `Aname` varchar(30) NOT NULL,
  4.   `Apwd` varchar(10) NOT NULL,
  5.   PRIMARY KEY (`Aid`)
  6. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;  PRIMARY KEY (`id`) USING BTREE
  7. ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = CREATE TABLE `course` (
  8.   `Cnum` int(11) NOT NULL AUTO_INCREMENT,
  9.   `Cno` int(11) NOT NULL,
  10.   `Cname` varchar(20) NOT NULL,
  11.   `Ctime` int(11) NOT NULL,
  12.   `Ccredit` int(11) NOT NULL,
  13.   PRIMARY KEY (`Cnum`,`Cno`),
  14.   KEY `Cname` (`Cname`),
  15.   KEY `Cno` (`Cno`)
  16. CREATE TABLE `score` (
  17.   `Sno` int(11) NOT NULL,
  18.   `Sname` varchar(20) NOT NULL,
  19.   `Cno` int(11) NOT NULL,
  20.   `Cname` varchar(20) DEFAULT NULL,
  21.   `Sscore` decimal(10,0) DEFAULT '0',
  22.   `Rescore` decimal(10,0) DEFAULT '0',
  23.   PRIMARY KEY (`Sno`,`Cno`),
  24.   KEY `Cname` (`Cname`),
  25.   KEY `Cno` (`Cno`),
  26.   KEY `Sname` (`Sname`)
  27. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  28.  
  29. -- ----------------------------
  30. -- Table structure for user_train_re   //学生，用户联系表
  31. -- ----------------------------
  32. CREATE TABLE `student` (
  33.   `Sno` int(11) NOT NULL,
  34.   `Sname` varchar(30) NOT NULL,
  35.   `Sgender` char(2) NOT NULL,
  36.   `Sage` int(11) NOT NULL,
  37.   `Sbirthday` datetime DEFAULT '1999-01-01 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  38.   `Sclass` varchar(10) NOT NULL,
  39.   `Smajor` varchar(20) NOT NULL,
  40.   `Sdept` varchar(20) NOT NULL,
  41.   `Spwd` varchar(10) NOT NULL DEFAULT '123',
  42.   PRIMARY KEY (`Sno`),
  43.   KEY `Sname` (`Sname`)
  44. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

4.2后台管理界面设计

登录

  1. package com.system.view;
  2.  
  3. import java.awt.EventQueue;
  4. import java.awt.Font;
  5. import java.awt.event.ActionEvent;
  6. import java.awt.event.ActionListener;
  7. import java.sql.SQLException;
  8.  
  9. import javax.swing.JButton;
  10. import javax.swing.JComboBox;
  11. import javax.swing.JFrame;
  12. import javax.swing.JLabel;
  13. import javax.swing.JOptionPane;
  14. import javax.swing.JPanel;
  15. import javax.swing.JPasswordField;
  16. import javax.swing.JTextField;
  17. import javax.swing.SwingConstants;
  18. import javax.swing.border.EmptyBorder;
  19.  
  20. import com.system.dao.StudentDao;
  21. import com.system.dao.UserDao;
  22.  
  23. public class Login extends JFrame {
  24.  
  25. 	private JPanel contentPane;
  26. 	private JTextField usernameField;
  27. 	private JPasswordField passwordField;
  28. 	private JComboBox comboBox;
  29.  
  30. 	/**
  31. 	 * Launch the application. 
  32. 	 */
  33. 	public static void main(String[] args) {
  34. 		EventQueue.invokeLater(new Runnable() {
  35. 			public void run() {
  36. 				try {
  37. 					Login frame = new Login();
  38. 					frame.setVisible(true);
  39. 				} catch (Exception e) {
  40. 					e.printStackTrace();
  41. 				}
  42. 			}
  43. 		});
  44. 	}
  45.  
  46. 	/**
  47. 	 * Create the frame.
  48. 	 */
  49. 	public Login() {
  50. 		setTitle("学生信息管理系统");
  51. 		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  52. 		setBounds(100, 100, 689, 428);
  53. 		contentPane = new JPanel();
  54. 		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
  55. 		setContentPane(contentPane);
  56. 		contentPane.setLayout(null);
  57.  
  58. 		JPanel panel = new JPanel();
  59. 		panel.setBounds(0, 0, 673, 389);
  60. 		contentPane.add(panel);
  61. 		panel.setLayout(null);
  62.  
  63. 		JLabel lblNewLabel = new JLabel("学生信息管理系统");
  64. 		lblNewLabel.setHorizontalAlignment(SwingConstants.CENTER);
  65. 		lblNewLabel.setFont(new Font("微软雅黑", Font.BOLD, 18));
  66. 		lblNewLabel.setBounds(114, 36, 393, 55);
  67. 		panel.add(lblNewLabel);
  68.  
  69. 		JLabel lblNewLabel_1 = new JLabel("用户名：");
  70. 		lblNewLabel_1.setHorizontalAlignment(SwingConstants.CENTER);
  71. 		lblNewLabel_1.setFont(new Font("微软雅黑", Font.BOLD, 16));
  72. 		lblNewLabel_1.setBounds(106, 112, 145, 31);
  73. 		panel.add(lblNewLabel_1);
  74.  
  75. 		JLabel lblNewLabel_1_1 = new JLabel("密码：");
  76. 		lblNewLabel_1_1.setHorizontalAlignment(SwingConstants.CENTER);
  77. 		lblNewLabel_1_1.setFont(new Font("微软雅黑", Font.BOLD, 16));
  78. 		lblNewLabel_1_1.setBounds(106, 173, 145, 31);
  79. 		panel.add(lblNewLabel_1_1);
  80.  
  81. 		JLabel lblNewLabel_1_2 = new JLabel("身份：");
  82. 		lblNewLabel_1_2.setHorizontalAlignment(SwingConstants.CENTER);
  83. 		lblNewLabel_1_2.setFont(new Font("微软雅黑", Font.BOLD, 16));
  84. 		lblNewLabel_1_2.setBounds(106, 242, 145, 31);
  85. 		panel.add(lblNewLabel_1_2);
  86.  
  87. 		usernameField = new JTextField();
  88. 		usernameField.setBounds(227, 112, 249, 37);
  89. 		panel.add(usernameField);
  90. 		usernameField.setColumns(10);
  91.  
  92. 		passwordField = new JPasswordField();
  93. 		passwordField.setBounds(227, 170, 249, 37);
  94. 		panel.add(passwordField);
  95. 		
  96. 		String[] a = new String[] { "管理员", "学生" };
  97. 		comboBox = new JComboBox(a);
  98. 		comboBox.setBounds(227, 237, 249, 42);
  99. 		panel.add(comboBox);
  100.  
  101. 		JButton btnNewButton = new JButton("登录");
  102. 		btnNewButton.addActionListener(new ActionListener() {
  103. 			public void actionPerformed(ActionEvent arg0) {
  104. 				// 获取文本框数据
  105. 				String username = usernameField.getText();
  106. 				String password = passwordField.getText();
  107. 				String type = (String) comboBox.getSelectedItem();
  108.  
  109. 				// 判断是否为空
  110. 				if (username.equals("") || password.equals("")) {
  111. 					JOptionPane.showMessageDialog(null, "用户名或密码不能为空！");
  112. 				} else {
  113. 					if ("管理员".equals(type)) {
  114. 						// 管理员登录
  115. 						try {
  116. 							UserDao log = new UserDao();
  117. 							boolean istrue = log.LoginCheck(username, password);
  118. 							if (istrue) {
  119. 								JOptionPane.showMessageDialog(null, "登录成功！");
  120. 								String a = "admin";
  121. 								setVisible(false);
  122. 								new Bg(a).setVisible(true);
  123. 							} else {
  124. 								JOptionPane.showMessageDialog(null, "用户名或密码错误！");
  125. 							}
  126. 						} catch (SQLException e1) {
  127. 							e1.printStackTrace();
  128. 						}
  129. 					} else {
  130. 						// 学生登录
  131. 						try {
  132. 							StudentDao log = new StudentDao();
  133. 							boolean istrue = log.LoginCheck(username, password);
  134. 							if (istrue) {
  135. 								JOptionPane.showMessageDialog(null, "登录成功！");
  136. 								String a = "学生"; // 不可修改，控制权限！
  137. 								setVisible(false);
  138. 								new Bg(a).setVisible(true);
  139. 							} else {
  140. 								JOptionPane.showMessageDialog(null, "用户名或密码错误！");
  141. 							}
  142. 						} catch (SQLException e1) {
  143. 							e1.printStackTrace();
  144. 						}
  145. 					}
  146. 				}
  147. 			}
  148. 		});
  149. 		btnNewButton.setFont(new Font("微软雅黑", Font.BOLD, 14));
  150. 		btnNewButton.setBounds(132, 308, 108, 37);
  151. 		panel.add(btnNewButton);
  152.  
  153. 		JButton btnNewButton_1 = new JButton("重置");
  154. 		btnNewButton_1.addActionListener(new ActionListener() {
  155. 			public void actionPerformed(ActionEvent arg0) {
  156. 				usernameField.setText("");
  157. 				passwordField.setText("");
  158. 			}
  159. 		});
  160. 		btnNewButton_1.setFont(new Font("微软雅黑", Font.BOLD, 14));
  161. 		btnNewButton_1.setBounds(399, 308, 108, 37);
  162. 		panel.add(btnNewButton_1);
  163. 	}
  164. }

查询操作

  1. package com.system.view;
  2.  
  3. import java.awt.Color;
  4. import java.awt.Font;
  5. import java.awt.SystemColor;
  6. import java.awt.event.ActionEvent;
  7. import java.awt.event.ActionListener;
  8. import java.util.List;
  9. import java.util.Vector;
  10.  
  11. import javax.swing.JButton;
  12. import javax.swing.JFrame;
  13. import javax.swing.JLabel;
  14. import javax.swing.JOptionPane;
  15. import javax.swing.JPanel;
  16. import javax.swing.JScrollPane;
  17. import javax.swing.JTable;
  18. import javax.swing.JTextField;
  19. import javax.swing.SwingConstants;
  20. import javax.swing.border.EmptyBorder;
  21.  
  22. import com.system.dao.UserDao;
  23. import com.system.entity.Student;
  24.  
  25. public class StudentSelect extends JFrame {
  26.  
  27. 	private JPanel contentPane;
  28. 	private JTextField keyField;
  29. 	private JTable table;
  30. 	private JScrollPane scrollPane;
  31.  
  32. 	/**
  33. 	 * Launch the application.
  34. 	 */
  35. 	// public static void main(String[] args) {
  36. 	// EventQueue.invokeLater(new Runnable() {
  37. 	// public void run() {
  38. 	// try {
  39. 	// StudentSelect frame = new StudentSelect();
  40. 	// frame.setVisible(true);
  41. 	// } catch (Exception e) {
  42. 	// e.printStackTrace();
  43. 	// }
  44. 	// }
  45. 	// });
  46. 	// }
  47.  
  48. 	/**
  49. 	 * Create the frame.
  50. 	 */
  51. 	public StudentSelect(String flag) {
  52. 		setTitle("学生信息管理系统");
  53. 		setBounds(100, 100, 845, 558);
  54. 		contentPane = new JPanel();
  55. 		contentPane.setBackground(Color.WHITE);
  56. 		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
  57. 		setContentPane(contentPane);
  58. 		contentPane.setLayout(null);
  59.  
  60. 		JPanel panel = new JPanel();
  61. 		panel.setBackground(SystemColor.activeCaption);
  62. 		panel.setBounds(0, 0, 848, 51);
  63. 		contentPane.add(panel);
  64. 		panel.setLayout(null);
  65.  
  66. 		JLabel lblNewLabel = new JLabel("学生基本信息");
  67. 		lblNewLabel.setFont(new Font("微软雅黑", Font.BOLD, 16));
  68. 		lblNewLabel.setHorizontalAlignment(SwingConstants.CENTER);
  69. 		lblNewLabel.setBounds(325, 10, 222, 31);
  70. 		panel.add(lblNewLabel);
  71.  
  72. 		JPanel panel_1 = new JPanel();
  73. 		panel_1.setBackground(Color.WHITE);
  74. 		panel_1.setBounds(0, 49, 829, 51);
  75. 		contentPane.add(panel_1);
  76. 		panel_1.setLayout(null);
  77.  
  78. 		JLabel lblNewLabel_1 = new JLabel("学号:");
  79. 		lblNewLabel_1.setFont(new Font("微软雅黑", Font.BOLD, 14));
  80. 		lblNewLabel_1.setBounds(225, 10, 54, 31);
  81. 		panel_1.add(lblNewLabel_1);
  82.  
  83. 		// 表头
  84. 		final Vector vector = new Vector();
  85. 		vector.add("学号");
  86. 		vector.add("姓名");
  87. 		vector.add("性别");
  88. 		vector.add("年龄");
  89. 		vector.add("班级");
  90. 		vector.add("专业");
  91. 		vector.add("系别");
  92.  
  93. 		// 表里面的数据
  94. 		Vector tData = new Vector();
  95.  
  96. 		keyField = new JTextField();
  97. 		keyField.setBounds(273, 10, 190, 31);
  98. 		panel_1.add(keyField);
  99. 		keyField.setColumns(10);
  100.  
  101. 		JButton btnNewButton = new JButton("查询");
  102. 		btnNewButton.addActionListener(new ActionListener() {
  103. 			public void actionPerformed(ActionEvent arg0) {
  104. 				// 根据学号查询学生
  105. 				String key = keyField.getText();
  106. 				if (key.equals("")) {
  107. 					JOptionPane.showMessageDialog(null, "学号不能为空！");
  108. 				} else {
  109. 					try {
  110. 						UserDao user = new UserDao();
  111. 						List<Student> list = user.Select(key, null);
  112. 						tData.clear();
  113. 						for (int i = 0; i < list.size(); i++) {
  114. 							Vector v = new Vector();
  115. 							v.add(list.get(i).getSno());
  116. 							v.add(list.get(i).getName());
  117. 							v.add(list.get(i).getGender());
  118. 							v.add(list.get(i).getAge());
  119. 							v.add(list.get(i).getClas());
  120. 							v.add(list.get(i).getMajor());
  121. 							v.add(list.get(i).getDept());
  122. 							tData.add(v);
  123. 						}
  124. 						table = new JTable(tData, vector);
  125. 						scrollPane.setViewportView(table);
  126. 						// table = new JTable(tData, vector);
  127. 					} catch (Exception e) {
  128. 						// TODO Auto-generated catch block
  129. 						e.printStackTrace();
  130. 					}
  131. 				}
  132. 			}
  133. 		});
  134. 		btnNewButton.setFont(new Font("微软雅黑", Font.BOLD, 14));
  135. 		btnNewButton.setBounds(483, 10, 67, 31);
  136. 		panel_1.add(btnNewButton);
  137.  
  138. 		scrollPane = new JScrollPane();
  139. 		scrollPane.setBounds(0, 98, 829, 421);
  140. 		contentPane.add(scrollPane);
  141.  
  142. 		try {
  143. 			UserDao user = new UserDao();
  144. 			List<Student> list = user.res();
  145. 			tData.clear();
  146. 			for (int i = 0; i < list.size(); i++) {
  147. 				Vector v = new Vector();
  148. 				v.add(list.get(i).getSno());
  149. 				v.add(list.get(i).getName());
  150. 				v.add(list.get(i).getGender());
  151. 				v.add(list.get(i).getAge());
  152. 				v.add(list.get(i).getClas());
  153. 				v.add(list.get(i).getMajor());
  154. 				v.add(list.get(i).getDept());
  155. 				tData.add(v);
  156. 			}
  157. 		} catch (Exception e) {
  158. 			// TODO Auto-generated catch block
  159. 			e.printStackTrace();
  160. 		}
  161.  
  162. 		table = new JTable(tData, vector);
  163. 		scrollPane.setViewportView(table);
  164. 	}
  165. }

添加操作

  1. package com.system.view;
  2.  
  3. import java.awt.Color;
  4. import java.awt.Font;
  5. import java.awt.event.ActionEvent;
  6. import java.awt.event.ActionListener;
  7. import java.sql.SQLException;
  8.  
  9. import javax.swing.JButton;
  10. import javax.swing.JComboBox;
  11. import javax.swing.JFrame;
  12. import javax.swing.JLabel;
  13. import javax.swing.JOptionPane;
  14. import javax.swing.JPanel;
  15. import javax.swing.JTextField;
  16. import javax.swing.SwingConstants;
  17. import javax.swing.border.EmptyBorder;
  18.  
  19. import com.system.dao.UserDao;
  20.  
  21. public class StudentAdd extends JFrame {
  22.  
  23. 	private JPanel contentPane;
  24. 	private JTextField snoField;
  25. 	private JTextField snameField;
  26. 	private JTextField sageField;
  27. 	private JTextField sclassField;
  28. 	private JTextField smajorField;
  29. 	private JTextField sdeptField;
  30. 	private JComboBox comboBox;
  31.  
  32. 	/**
  33. 	 * Launch the application.
  34. 	 */
  35. 	// public static void main(String[] args) {
  36. 	// EventQueue.invokeLater(new Runnable() {
  37. 	// public void run() {
  38. 	// try {
  39. 	// StudentAdd frame = new StudentAdd();
  40. 	// frame.setVisible(true);
  41. 	// } catch (Exception e) {
  42. 	// e.printStackTrace();
  43. 	// }
  44. 	// }
  45. 	// });
  46. 	// }
  47.  
  48. 	/**
  49. 	 * Create the frame.
  50. 	 */
  51. 	public StudentAdd(String admin) {
  52. 		setBounds(100, 100, 723, 506);
  53. 		contentPane = new JPanel();
  54. 		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
  55. 		setContentPane(contentPane);
  56. 		contentPane.setLayout(null);
  57.  
  58. 		JPanel panel = new JPanel();
  59. 		panel.setBackground(Color.WHITE);
  60. 		panel.setBounds(0, 0, 707, 467);
  61. 		contentPane.add(panel);
  62. 		panel.setLayout(null);
  63.  
  64. 		JLabel lblNewLabel = new JLabel("添加学生");
  65. 		lblNewLabel.setHorizontalAlignment(SwingConstants.CENTER);
  66. 		lblNewLabel.setFont(new Font("微软雅黑", Font.BOLD, 16));
  67. 		lblNewLabel.setBounds(237, 28, 172, 36);
  68. 		panel.add(lblNewLabel);
  69.  
  70. 		JLabel lblNewLabel_1 = new JLabel("学号：");
  71. 		lblNewLabel_1.setFont(new Font("微软雅黑", Font.BOLD, 15));
  72. 		lblNewLabel_1.setHorizontalAlignment(SwingConstants.CENTER);
  73. 		lblNewLabel_1.setBounds(201, 81, 53, 30);
  74. 		panel.add(lblNewLabel_1);
  75.  
  76. 		snoField = new JTextField();
  77. 		snoField.setBounds(267, 80, 194, 36);
  78. 		panel.add(snoField);
  79. 		snoField.setColumns(10);
  80.  
  81. 		JLabel lblNewLabel_1_1 = new JLabel("姓名：");
  82. 		lblNewLabel_1_1.setHorizontalAlignment(SwingConstants.CENTER);
  83. 		lblNewLabel_1_1.setFont(new Font("微软雅黑", Font.BOLD, 15));
  84. 		lblNewLabel_1_1.setBounds(201, 129, 53, 30);
  85. 		panel.add(lblNewLabel_1_1);
  86.  
  87. 		JLabel lblNewLabel_1_2 = new JLabel("年龄：");
  88. 		lblNewLabel_1_2.setHorizontalAlignment(SwingConstants.CENTER);
  89. 		lblNewLabel_1_2.setFont(new Font("微软雅黑", Font.BOLD, 15));
  90. 		lblNewLabel_1_2.setBounds(201, 178, 53, 30);
  91. 		panel.add(lblNewLabel_1_2);
  92.  
  93. 		JLabel lblNewLabel_1_3 = new JLabel("班级：");
  94. 		lblNewLabel_1_3.setHorizontalAlignment(SwingConstants.CENTER);
  95. 		lblNewLabel_1_3.setFont(new Font("微软雅黑", Font.BOLD, 15));
  96. 		lblNewLabel_1_3.setBounds(201, 231, 53, 30);
  97. 		panel.add(lblNewLabel_1_3);
  98.  
  99. 		JLabel lblNewLabel_1_4 = new JLabel("专业：");
  100. 		lblNewLabel_1_4.setHorizontalAlignment(SwingConstants.CENTER);
  101. 		lblNewLabel_1_4.setFont(new Font("微软雅黑", Font.BOLD, 15));
  102. 		lblNewLabel_1_4.setBounds(201, 277, 53, 30);
  103. 		panel.add(lblNewLabel_1_4);
  104.  
  105. 		JLabel lblNewLabel_1_5 = new JLabel("系别：");
  106. 		lblNewLabel_1_5.setHorizontalAlignment(SwingConstants.CENTER);
  107. 		lblNewLabel_1_5.setFont(new Font("微软雅黑", Font.BOLD, 15));
  108. 		lblNewLabel_1_5.setBounds(201, 330, 53, 30);
  109. 		panel.add(lblNewLabel_1_5);
  110.  
  111. 		JLabel lblNewLabel_1_6 = new JLabel("性别：");
  112. 		lblNewLabel_1_6.setHorizontalAlignment(SwingConstants.CENTER);
  113. 		lblNewLabel_1_6.setFont(new Font("微软雅黑", Font.BOLD, 15));
  114. 		lblNewLabel_1_6.setBounds(201, 381, 53, 30);
  115. 		panel.add(lblNewLabel_1_6);
  116.  
  117. 		snameField = new JTextField();
  118. 		snameField.setColumns(10);
  119. 		snameField.setBounds(267, 126, 194, 36);
  120. 		panel.add(snameField);
  121.  
  122. 		sageField = new JTextField();
  123. 		sageField.setColumns(10);
  124. 		sageField.setBounds(267, 177, 194, 36);
  125. 		panel.add(sageField);
  126.  
  127. 		sclassField = new JTextField();
  128. 		sclassField.setColumns(10);
  129. 		sclassField.setBounds(267, 230, 194, 36);
  130. 		panel.add(sclassField);
  131.  
  132. 		smajorField = new JTextField();
  133. 		smajorField.setColumns(10);
  134. 		smajorField.setBounds(267, 276, 194, 36);
  135. 		panel.add(smajorField);
  136.  
  137. 		sdeptField = new JTextField();
  138. 		sdeptField.setColumns(10);
  139. 		sdeptField.setBounds(267, 329, 194, 36);
  140. 		panel.add(sdeptField);
  141.  
  142. 		JButton btnNewButton = new JButton("添加");
  143. 		btnNewButton.addActionListener(new ActionListener() {
  144. 			public void actionPerformed(ActionEvent e) {
  145. 				String sno = snoField.getText();
  146. 				String sname = snameField.getText();
  147. 				String sage = sageField.getText();
  148. 				String sclass = sclassField.getText();
  149. 				String smajor = smajorField.getText();
  150. 				String sdept = sdeptField.getText();
  151. 				String sex = (String) comboBox.getSelectedItem();
  152. 				
  153. 				if (sno.equals("") || sname.equals("") || sage.equals("") || sclass.equals("") || smajor.equals("")
  154. 						|| sdept.equals("") || sex.equals("")) {
  155. 					JOptionPane.showMessageDialog(null, "信息不完整，请填写完整！");
  156. 				} else {
  157. 					UserDao userDao = new UserDao();
  158. 					try {
  159. 						boolean istrue = userDao.insert(sno, sname, sex, sage, sclass, smajor, sdept);
  160. 							if (istrue) {
  161. 								JOptionPane.showMessageDialog(null, "学生信息录入成功！");
  162. 							} else{
  163. 								JOptionPane.showMessageDialog(null, "学生录入失败，此学号已存在！");
  164. 							}
  165. 					} catch (SQLException e1) {
  166. 						// TODO Auto-generated catch block
  167. 						e1.printStackTrace();
  168. 					}
  169. 					
  170. 				}
  171. 				
  172. 			}
  173.  
  174. 		});
  175. 		btnNewButton.setFont(new Font("微软雅黑", Font.BOLD, 14));
  176. 		btnNewButton.setBounds(201, 427, 93, 30);
  177. 		panel.add(btnNewButton);
  178.  
  179. 		JButton btnNewButton_1 = new JButton("重置");
  180. 		btnNewButton_1.addActionListener(new ActionListener() {
  181. 			public void actionPerformed(ActionEvent e) {
  182. 				snoField.setText("");
  183. 				snameField.setText("");
  184. 				sageField.setText("");
  185. 				sclassField.setText("");
  186. 				smajorField.setText("");
  187. 				sdeptField.setText("");
  188.  
  189. 			}
  190. 		});
  191. 		btnNewButton_1.setFont(new Font("微软雅黑", Font.BOLD, 14));
  192. 		btnNewButton_1.setBounds(390, 427, 93, 30);
  193. 		panel.add(btnNewButton_1);
  194.  
  195. 		String[] a = new String[] { "男", "女" };
  196. 		comboBox = new JComboBox(a);
  197. 		comboBox.setBounds(267, 381, 194, 27);
  198. 		panel.add(comboBox);
  199.  
  200.  
  201.  
  202. 	}
  203. }

修改操作

  1. package com.system.view;
  2.  
  3. import java.awt.Color;
  4. import java.awt.Font;
  5. import java.awt.event.ActionEvent;
  6. import java.awt.event.ActionListener;
  7. import java.sql.SQLException;
  8.  
  9. import javax.swing.JButton;
  10. import javax.swing.JComboBox;
  11. import javax.swing.JLabel;
  12. import javax.swing.JOptionPane;
  13. import javax.swing.JPanel;
  14. import javax.swing.JTextField;
  15. import javax.swing.SwingConstants;
  16.  
  17. import com.system.dao.UserDao;
  18. import com.system.entity.Student;
  19.  
  20. public class StudentUpdate extends Bg {
  21.  
  22. 	private JPanel contentPane;
  23. 	private JTextField keyField;
  24. 	private JTextField snoField;
  25. 	private JTextField snameField;
  26. 	private JTextField sageField;
  27. 	private JTextField sclassField;
  28. 	private JTextField smajorField;
  29. 	private JTextField sdeptField;
  30. 	private JComboBox comboBox;
  31.  
  32. 	/**
  33. 	 * Launch the application.
  34. 	 */
  35. 	// public static void main(String[] args) {
  36. 	// EventQueue.invokeLater(new Runnable() {
  37. 	// public void run() {
  38. 	// try {
  39. 	// StudentUpdate frame = new StudentUpdate();
  40. 	// frame.setVisible(true);
  41. 	// } catch (Exception e) {
  42. 	// e.printStackTrace();
  43. 	// }
  44. 	// }
  45. 	// });
  46. 	// }
  47.  
  48. 	/**
  49. 	 * Create the frame.
  50. 	 */
  51. 	public StudentUpdate(String a) {
  52. 		// setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  53. 		// setBounds(100, 100, 450, 300);
  54. 		// contentPane = new JPanel();
  55. 		// contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
  56. 		// contentPane.setLayout(new BorderLayout(0, 0));
  57. 		// setContentPane(contentPane);
  58. 		super(a);
  59.  
  60. 		JPanel panel = new JPanel();
  61. 		panel.setBackground(Color.WHITE);
  62. 		panel.setBounds(166, 54, 751, 493);
  63. 		getContentPane().add(panel);
  64. 		panel.setLayout(null);
  65.  
  66. 		JLabel lblNewLabel = new JLabel("修改学生信息");
  67. 		lblNewLabel.setHorizontalAlignment(SwingConstants.CENTER);
  68. 		lblNewLabel.setFont(new Font("微软雅黑", Font.BOLD, 16));
  69. 		lblNewLabel.setBounds(270, 32, 214, 32);
  70. 		panel.add(lblNewLabel);
  71.  
  72. 		JLabel lblNewLabel_1 = new JLabel("输入学号：");
  73. 		lblNewLabel_1.setFont(new Font("微软雅黑", Font.BOLD, 14));
  74. 		lblNewLabel_1.setBounds(140, 81, 81, 19);
  75. 		panel.add(lblNewLabel_1);
  76.  
  77. 		keyField = new JTextField();
  78. 		keyField.setBounds(214, 81, 182, 21);
  79. 		panel.add(keyField);
  80. 		keyField.setColumns(10);
  81.  
  82. 		JButton btnNewButton = new JButton("查询");
  83. 		btnNewButton.addActionListener(new ActionListener() {
  84. 			public void actionPerformed(ActionEvent e) {
  85. 				String key = keyField.getText();
  86. 				if (key.equals("")) {
  87. 					JOptionPane.showMessageDialog(null, "学号不能为空！");
  88. 				} else {
  89.  
  90. 					UserDao user = new UserDao();
  91. 					Student stu = new Student();
  92. 					try {
  93. 						stu = user.select(key);
  94. 					} catch (SQLException e1) {
  95. 						// TODO Auto-generated catch block
  96. 						e1.printStackTrace();
  97. 					}
  98. 					if (stu != null) {
  99. 						snoField.setText(String.valueOf(stu.getSno()));
  100. 						snameField.setText(stu.getName());
  101. 						sageField.setText(String.valueOf(stu.getAge()));
  102. 						sclassField.setText(stu.getClas());
  103. 						smajorField.setText(stu.getMajor());
  104. 						sdeptField.setText(stu.getDept());
  105. 						comboBox.setSelectedItem(stu.getGender());
  106. 					} else {
  107. 						JOptionPane.showMessageDialog(null, "查无此生！");
  108. 					}
  109. 						
  110.  
  111. 				}
  112. 			}
  113. 		});
  114. 		btnNewButton.setFont(new Font("微软雅黑", Font.BOLD, 14));
  115. 		btnNewButton.setBounds(429, 77, 75, 26);
  116. 		panel.add(btnNewButton);
  117.  
  118. 		JLabel lblNewLabel_2 = new JLabel("查询学生是否存在！");
  119. 		lblNewLabel_2.setHorizontalAlignment(SwingConstants.CENTER);
  120. 		lblNewLabel_2.setForeground(Color.RED);
  121. 		lblNewLabel_2.setFont(new Font("微软雅黑", Font.BOLD, 13));
  122. 		lblNewLabel_2.setBounds(224, 110, 172, 19);
  123. 		panel.add(lblNewLabel_2);
  124.  
  125. 		JLabel lblNewLabel_3 = new JLabel("学生基本信息：");
  126. 		lblNewLabel_3.setFont(new Font("微软雅黑", Font.BOLD, 16));
  127. 		lblNewLabel_3.setBounds(140, 151, 182, 19);
  128. 		panel.add(lblNewLabel_3);
  129.  
  130. 		JLabel lblNewLabel_4 = new JLabel("学号：");
  131. 		lblNewLabel_4.setFont(new Font("微软雅黑", Font.BOLD, 14));
  132. 		lblNewLabel_4.setBounds(140, 193, 53, 21);
  133. 		panel.add(lblNewLabel_4);
  134.  
  135. 		snoField = new JTextField();
  136. 		snoField.setBounds(190, 188, 227, 32);
  137. 		panel.add(snoField);
  138. 		snoField.setColumns(10);
  139.  
  140. 		JLabel lblNewLabel_4_1 = new JLabel("姓名：");
  141. 		lblNewLabel_4_1.setFont(new Font("微软雅黑", Font.BOLD, 14));
  142. 		lblNewLabel_4_1.setBounds(140, 239, 53, 21);
  143. 		panel.add(lblNewLabel_4_1);
  144.  
  145. 		snameField = new JTextField();
  146. 		snameField.setColumns(10);
  147. 		snameField.setBounds(190, 235, 227, 32);
  148. 		panel.add(snameField);
  149.  
  150. 		JLabel lblNewLabel_4_1_1 = new JLabel("年龄：");
  151. 		lblNewLabel_4_1_1.setFont(new Font("微软雅黑", Font.BOLD, 14));
  152. 		lblNewLabel_4_1_1.setBounds(140, 284, 53, 21);
  153. 		panel.add(lblNewLabel_4_1_1);
  154.  
  155. 		sageField = new JTextField();
  156. 		sageField.setColumns(10);
  157. 		sageField.setBounds(190, 277, 227, 32);
  158. 		panel.add(sageField);
  159.  
  160. 		sclassField = new JTextField();
  161. 		sclassField.setColumns(10);
  162. 		sclassField.setBounds(190, 319, 227, 32);
  163. 		panel.add(sclassField);
  164.  
  165. 		JLabel lblNewLabel_4_1_1_1 = new JLabel("班级：");
  166. 		lblNewLabel_4_1_1_1.setFont(new Font("微软雅黑", Font.BOLD, 14));
  167. 		lblNewLabel_4_1_1_1.setBounds(140, 327, 53, 21);
  168. 		panel.add(lblNewLabel_4_1_1_1);
  169.  
  170. 		JLabel lblNewLabel_4_1_1_1_1 = new JLabel("班级：");
  171. 		lblNewLabel_4_1_1_1_1.setFont(new Font("微软雅黑", Font.BOLD, 14));
  172. 		lblNewLabel_4_1_1_1_1.setBounds(140, 327, 53, 21);
  173. 		panel.add(lblNewLabel_4_1_1_1_1);
  174.  
  175. 		JLabel lblNewLabel_4_1_1_1_2 = new JLabel("专业：");
  176. 		lblNewLabel_4_1_1_1_2.setFont(new Font("微软雅黑", Font.BOLD, 14));
  177. 		lblNewLabel_4_1_1_1_2.setBounds(140, 373, 53, 21);
  178. 		panel.add(lblNewLabel_4_1_1_1_2);
  179.  
  180. 		smajorField = new JTextField();
  181. 		smajorField.setColumns(10);
  182. 		smajorField.setBounds(190, 369, 227, 32);
  183. 		panel.add(smajorField);
  184.  
  185. 		JLabel lblNewLabel_4_1_1_1_2_1 = new JLabel("系别：");
  186. 		lblNewLabel_4_1_1_1_2_1.setFont(new Font("微软雅黑", Font.BOLD, 14));
  187. 		lblNewLabel_4_1_1_1_2_1.setBounds(140, 416, 53, 21);
  188. 		panel.add(lblNewLabel_4_1_1_1_2_1);
  189.  
  190. 		sdeptField = new JTextField();
  191. 		sdeptField.setColumns(10);
  192. 		sdeptField.setBounds(190, 411, 227, 32);
  193. 		panel.add(sdeptField);
  194.  
  195. 		JLabel lblNewLabel_4_1_1_1_2_1_1 = new JLabel("性别：");
  196. 		lblNewLabel_4_1_1_1_2_1_1.setFont(new Font("微软雅黑", Font.BOLD, 14));
  197. 		lblNewLabel_4_1_1_1_2_1_1.setBounds(140, 462, 53, 21);
  198. 		panel.add(lblNewLabel_4_1_1_1_2_1_1);
  199.  
  200. 		String[] b = new String[] { "男", "女" };
  201. 		comboBox = new JComboBox(b);
  202. 		comboBox.setBounds(190, 453, 227, 30);
  203. 		panel.add(comboBox);
  204.  
  205. 		JButton btnNewButton_1 = new JButton("保存");
  206. 		btnNewButton_1.addActionListener(new ActionListener() {
  207. 			public void actionPerformed(ActionEvent e) {
  208. 				
  209. 				String sno = snoField.getText();
  210. 				String sname = snameField.getText();
  211. 				String sage = sageField.getText();
  212. 				String sclass = sclassField.getText();
  213. 				String smajor = smajorField.getText();
  214. 				String sdept = sdeptField.getText();
  215. 				String sex = (String) comboBox.getSelectedItem();
  216.  
  217. 				UserDao userDao = new UserDao();
  218. 				try {
  219. 					boolean flag = userDao.update(sno, sname, sex, sage, sclass, smajor, sdept);
  220. 					if (flag) {
  221. 						JOptionPane.showMessageDialog(null, "修改成功！");
  222. 					} else {
  223. 						JOptionPane.showMessageDialog(null, "修改失败！");
  224. 					}
  225. 				} catch (SQLException e1) {
  226. 					// TODO Auto-generated catch block
  227. 					e1.printStackTrace();
  228. 				}
  229.  
  230. 			}
  231. 		});
  232. 		btnNewButton_1.setFont(new Font("微软雅黑", Font.BOLD, 14));
  233. 		btnNewButton_1.setBounds(474, 453, 93, 30);
  234. 		panel.add(btnNewButton_1);
  235. 	}
  236.  
  237. }

删除操作

  1. package com.system.view;
  2.  
  3. import java.awt.Font;
  4. import java.awt.event.ActionEvent;
  5. import java.awt.event.ActionListener;
  6.  
  7. import javax.swing.JButton;
  8. import javax.swing.JLabel;
  9. import javax.swing.JOptionPane;
  10. import javax.swing.JPanel;
  11. import javax.swing.JTextField;
  12. import javax.swing.SwingConstants;
  13.  
  14. import com.system.dao.UserDao;
  15.  
  16. public class StudentDelete extends Bg {
  17.  
  18. 	private JPanel contentPane;
  19. 	private JTextField keyField;
  20.  
  21. 	/**
  22. 	 * Launch the application.
  23. 	 */
  24. 	// public static void main(String[] args) {
  25. 	// EventQueue.invokeLater(new Runnable() {
  26. 	// public void run() {
  27. 	// try {
  28. 	// StudentDelete frame = new StudentDelete();
  29. 	// frame.setVisible(true);
  30. 	// } catch (Exception e) {
  31. 	// e.printStackTrace();
  32. 	// }
  33. 	// }
  34. 	// });
  35. 	// }
  36.  
  37. 	/**
  38. 	 * Create the frame.
  39. 	 */
  40. 	public StudentDelete(String a) {
  41. 		// setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  42. 		// setBounds(100, 100, 450, 300);
  43. 		// contentPane = new JPanel();
  44. 		// contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
  45. 		// contentPane.setLayout(new BorderLayout(0, 0));
  46. 		// setContentPane(contentPane);
  47. 		super(a);
  48.  
  49. 		JLabel lblNewLabel = new JLabel("删除学生信息");
  50. 		lblNewLabel.setHorizontalAlignment(SwingConstants.CENTER);
  51. 		lblNewLabel.setFont(new Font("微软雅黑", Font.BOLD, 18));
  52. 		lblNewLabel.setBounds(442, 113, 227, 37);
  53. 		getContentPane().add(lblNewLabel);
  54.  
  55. 		JLabel lblNewLabel_1 = new JLabel("输入学号：");
  56. 		lblNewLabel_1.setHorizontalAlignment(SwingConstants.CENTER);
  57. 		lblNewLabel_1.setFont(new Font("微软雅黑", Font.BOLD, 16));
  58. 		lblNewLabel_1.setBounds(402, 197, 81, 27);
  59. 		getContentPane().add(lblNewLabel_1);
  60.  
  61. 		keyField = new JTextField();
  62. 		keyField.setBounds(485, 193, 184, 37);
  63. 		getContentPane().add(keyField);
  64. 		keyField.setColumns(10);
  65.  
  66. 		JButton btnNewButton = new JButton("删除");
  67. 		btnNewButton.addActionListener(new ActionListener() {
  68. 			public void actionPerformed(ActionEvent e) {
  69. 				String key = keyField.getText();
  70. 				if (key.equals("")) {
  71. 					JOptionPane.showMessageDialog(null, "学号不能为空！");
  72. 				} else {
  73. 					UserDao user = new UserDao();
  74. 					try {
  75. 						if (user.delete(key)) {
  76. 							JOptionPane.showMessageDialog(null, "删除学生成功！");
  77. 						} else {
  78. 							JOptionPane.showMessageDialog(null, "删除学生失败，请检查该学号是否正确！");
  79. 						}
  80. 					} catch (Exception e1) {
  81.  
  82. 					}
  83.  
  84. 				}
  85. 			}
  86. 		});
  87. 		btnNewButton.setFont(new Font("微软雅黑", Font.BOLD, 14));
  88. 		btnNewButton.setBounds(696, 193, 102, 37);
  89. 		getContentPane().add(btnNewButton);
  90. 	}
  91.  
  92. }

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/人工智能uu/article/detail/871827
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号