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

Java+Swing+MySQL学生成绩管理系统

作者：IT小白 | 2024-07-23 23:22:17

赞

踩

java+swing+mysql

目录

一、系统介绍

1.运行环境

2.技术说明

3.系统功能

4.数据库ER图表

二、系统实现

1.整体结构 

2.用户注册、登录

3.增加学生

4.模糊查询学生信息

5.成绩管理和查询

6.查询成绩 

7.课程更改

  

 三、部分代码

1.ChangePasswordView.java

2.LoginView.java

3.RegisterView.java

4.GradeView.java

5.备注

一、系统介绍

1.运行环境

开发工具：Eclipse/IDEA

JDK版本：jdk1.8

Mysql版本：5.7

2.技术说明

Java+Swing+Mysql

3.系统功能

学生成绩管理系统是广泛使用的一种信息管理系统，在学生成绩管理系统中，需要能处理各班信息、各班下属学生的个人信息及每个学生学习成绩信息。班级信息包括班级编号、班级名称，学生信息包括学号、姓名、性别、所属班级、联系方式等，及各门课程的成绩。与班级相关的操作是查看已有班级、新增班级、修改班级名称、删除班级、录入新生信息等；与学生相关的操作是查看已有学生、修改学生基本信息、删除学生、录入成绩、修改成绩、根据姓名、学号、班级、课程等多条件查询学生成绩，并可以依据多种条件进行排序。

4.数据库ER图表

二、系统实现

1.整体结构 

2.用户注册、登录

对所有的输入都有进行正则校验，用户名有2-6位中文和6-18位英文或数字限制，且不能输入特殊符号；密码有6-18位英文或数字限制。如下图 

3.增加学生

可以对学生的信息进行修改、学生查询、增加删除。所有输入操作均有防暴力输入和正则判断。

4.模糊查询学生信息

5.成绩管理和查询

6.查询成绩 

 

7.课程更改

 三、部分代码

1.ChangePasswordView.java

  1. package com.Lauguobin.www.view.Login;
  2.  
  3. import java.awt.GridLayout;
  4. import java.awt.event.ActionEvent;
  5. import java.awt.event.ActionListener;
  6.  
  7. import javax.swing.JButton;
  8. import javax.swing.JDialog;
  9. import javax.swing.JFrame;
  10. import javax.swing.JLabel;
  11. import javax.swing.JOptionPane;
  12. import javax.swing.JPanel;
  13. import javax.swing.JPasswordField;
  14. import javax.swing.JTextField;
  15.  
  16. import com.Lauguobin.www.po.User;
  17. import com.Lauguobin.www.service.UserService;
  18. import com.Lauguobin.www.util.ViewUtil;
  19.  
  20. public class ChangePasswordView extends JDialog
  21. {
  22. 	private static final long serialVersionUID = 1L;
  23. 	private JPanel all;
  24. 	private JPanel buttons;
  25. 	
  26. 	private JLabel user;
  27. 	private JLabel oldPassword;
  28. 	private JLabel newPassword;
  29. 	
  30. 	private JTextField tu;
  31. 	private JPasswordField top;
  32. 	private JPasswordField tnp;
  33. 	
  34. 	private JButton yes;
  35. 	private JButton no;
  36. 	
  37. 	ChangePasswordView()
  38. 	 {
  39. 		 all = new JPanel(new GridLayout(3,1));
  40. 		 user = new JLabel("　　　　　用户名");
  41. 		 oldPassword = new JLabel("　　　　　旧密码");
  42. 		 newPassword = new JLabel("　　　　　新密码");
  43. 		 tu = new JTextField(13);
  44. 		 top = new JPasswordField(13);
  45. 		 tnp = new JPasswordField(13);
  46. 		 tnp.addActionListener(new ChangePasswordMonitor());
  47. 		 
  48. 		 all.add(user);
  49. 		 all.add(tu);
  50. 		 all.add(oldPassword);
  51. 		 all.add(top);
  52. 		 all.add(newPassword);
  53. 		 all.add(tnp);
  54. 		 
  55. 		 yes = new JButton("确定修改");
  56. 		 yes.addActionListener(new ChangePasswordMonitor());
  57. 		 no = new JButton("取消");
  58. 		 no.addActionListener(new ChangePasswordMonitor());
  59. 		 buttons = new JPanel();
  60. 		 buttons.add(yes);
  61. 		 buttons.add(no);
  62. 		 
  63. 		 add(all,"North");
  64. 		 add(buttons,"South");
  65. 		 
  66. 		int screenHeight = ViewUtil.geScreenHeight();
  67. 		int screenWidth = ViewUtil.geScreenWidth();
  68. 		
  69. 		setTitle("密码修改");
  70. 		setLocation(screenWidth / 3 , screenHeight  / 2);
  71. 		setResizable(false);
  72. 		pack();
  73. 		setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
  74. 		setModal(true);
  75. 		setVisible(true);
  76. 	 }
  77. 	 
  78. 	 class ChangePasswordMonitor  implements ActionListener
  79. 	 {
  80.  
  81. 		@Override
  82. 		public void actionPerformed(ActionEvent e)
  83. 		{
  84. 			//点击确定或者在新密码行敲击回车响应
  85. 			if(e.getSource() == yes || e.getSource() == tnp)
  86. 			{
  87. 				UserService us = new UserService();
  88. 				
  89. 				//封装数据
  90. 				String uname =  tu.getText();
  91. 				String pold = new String(top.getPassword());
  92. 				String pnew = new String(tnp.getPassword());
  93. 				User in = new User(uname,pold);
  94. 				
  95. 				try
  96. 				{
  97. 					//调用service判断并由其决定是否执行
  98. 					int flag = us.IfAlter(in,pnew);
  99. 					switch(flag)
  100. 					{
  101. 						case 0:
  102. 						{
  103. 							JOptionPane.showMessageDialog(null, "操作成功", "标题", JOptionPane.PLAIN_MESSAGE);
  104. 							dispose();
  105. 							break;
  106. 						}
  107. 						case 1:JOptionPane.showMessageDialog(null, "新密码长度必须位于6 - 18位", "警告", JOptionPane.WARNING_MESSAGE); 	break;
  108. 						case 2:JOptionPane.showMessageDialog(null, "原账户信息验证错误", "警告", JOptionPane.WARNING_MESSAGE); 	break;
  109. 						default :JOptionPane.showMessageDialog(null, "未知错误", "警告", JOptionPane.ERROR_MESSAGE); 	break;
  110. 					}
  111. 				}
  112. 				catch (Exception e1)
  113. 				{
  114. 					e1.printStackTrace();
  115. 				}
  116. 			}
  117. 			
  118. 			if(e.getSource() == no)
  119. 				dispose();
  120. 		}
  121. 		 
  122. 	 }
  123. }
  124.

2.LoginView.java

  1. package com.Lauguobin.www.view.Login;
  2.  
  3. import  java.awt.*;
  4. import java.awt.event.*;
  5. import javax.swing.*;
  6.  
  7. import com.Lauguobin.www.po.*;
  8. import com.Lauguobin.www.service.*;
  9. import com.Lauguobin.www.util.*;
  10. import com.Lauguobin.www.view.StudentMenagement.StudentMenageView;
  11. /**
  12.  * 登录界面的类
  13.  * @author GB菌
  14.  */
  15. public class LoginView extends JFrame
  16. {
  17. 	private static final long serialVersionUID = 1L;
  18. 	//当前登录用户的身份信息
  19. 	public static String USING_USER;
  20. 	public static String USING_USER_PASSWORD;
  21. 	public static boolean USER_IDENTITY;
  22. 	//总的Panel
  23. 	private JPanel buttonPanel;
  24. 	private JLabel picture;
  25. 	private JPanel all;
  26. 	private ButtonGroup group;
  27. 	private JPanel radios;
  28. 	private JRadioButton oldDriver;
  29. 	private JRadioButton newbie;
  30. 	private JPanel loginName;
  31. 	private JPanel loginPassword;
  32. 	private JLabel labelName;
  33. 	private JLabel labelPw;
  34. 	private JTextField name;
  35. 	private JPasswordField password;
  36. 	private JButton login;
  37. 	private JButton zc;
  38. 	private JButton quit;
  39. 	private JButton clean;
  40. 	private JButton change;
  41. 	
  42. 	/**
  43. 	 * main方法在这里
  44. 	 * @param args
  45. 	 */
  46. 	public static void main(String[] args) 
  47. 	{
  48. 		EventQueue.invokeLater
  49. 		(
  50. 				new Runnable()
  51. 				{
  52. 					public void run()
  53. 					{
  54. 						new LoginView();
  55. 					}
  56. 				}
  57. 		);
  58. 	}
  59. 	//构造方法
  60. 	public LoginView()
  61. 	{	
  62. 		int screenHeight = ViewUtil.geScreenHeight();
  63. 		int screenWidth = ViewUtil.geScreenWidth();
  64. 		
  65. 		//创建按钮并且连接
  66. 		login = new JButton("登录");
  67. 		login.addActionListener(new LoginMonitor());
  68. 		zc = new JButton("注册");
  69. 		zc.addActionListener(new LoginMonitor());
  70. 		quit = new JButton("退出");
  71. 		quit.addActionListener(new LoginMonitor());
  72. 		clean = new JButton("清除信息");
  73. 		clean.addActionListener(new LoginMonitor());
  74. 		change = new JButton("修改密码");
  75. 		change.addActionListener(new LoginMonitor());
  76. 		
  77. 		//实例化容器
  78. 		buttonPanel = new JPanel();
  79. 		loginName = new JPanel();
  80. 		loginPassword = new JPanel();
  81. 		all = new JPanel(new GridLayout(3,1));
  82. 		picture  = new JLabel(new ImageIcon("picture.jpg"));
  83. 		group =  new ButtonGroup();
  84. 		radios = new JPanel();
  85. 		labelName = new JLabel("      账号");
  86. 		name = new JTextField(13);
  87. 		name.addActionListener(new LoginMonitor());
  88. 		labelPw = new JLabel("      密码");
  89. 		password = new JPasswordField(13);
  90. 		password.addActionListener(new LoginMonitor());
  91. 		oldDriver = new JRadioButton("管理员");
  92. 		newbie = new JRadioButton("用户");
  93. 		
  94. 		loginName.add(labelName);
  95. 		loginName.add(name);
  96. 		loginName.add(clean);
  97. 		loginPassword.add(labelPw);
  98. 		loginPassword.add(password);
  99. 		loginPassword.add(change);
  100. 		group.add(oldDriver);
  101. 		group.add(newbie);
  102. 		radios.add(oldDriver);
  103. 		oldDriver.addActionListener(new LoginMonitor());
  104. 		radios.add(newbie);
  105. 		newbie.addActionListener(new LoginMonitor());
  106. 		all.add(loginName);
  107. 		all.add(loginPassword);
  108. 		all.add(radios);
  109. 		buttonPanel.add(login);
  110. 		buttonPanel.add(zc);
  111. 		buttonPanel.add(quit);
  112. 		
  113. 		add(picture,"North");
  114. 		add(all);
  115. 		add(buttonPanel , "South");
  116. 		
  117. 		setTitle("学生成绩管理系统");
  118. 		setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
  119. 		setLocation(screenWidth  / 3 , screenHeight  / 5);
  120. 		setResizable(false);
  121. 		setVisible(true);
  122. 		
  123. 		pack();
  124. 	}
  125. 	
  126. 	/**
  127. 	 * 方便事件响应管理，把这个类设置成内部类
  128. 	 * @author GB菌
  129. 	 *
  130. 	 */
  131. 	class LoginMonitor  implements ActionListener
  132. 	{
  133. 		@Override
  134. 		public void actionPerformed(ActionEvent e) 
  135. 		{
  136. 			 UserService us = new  UserService();
  137. 			 
  138. 			 //点击登录或在密码文本域中敲击回车
  139. 			if((e.getSource() == login)||(e.getSource() == password))
  140. 			{
  141. 				if(oldDriver.isSelected())
  142. 					USER_IDENTITY = true;
  143. 				else	if(newbie.isSelected())
  144. 					USER_IDENTITY = false;
  145. 				else 
  146. 				{
  147. 					JOptionPane.showMessageDialog(null, "请选择用户类型", "输入错误", JOptionPane.ERROR_MESSAGE);
  148. 					return ;
  149. 				}
  150. 				
  151. 				String n = name.getText(); 
  152. 				String p = new String(password.getPassword());
  153.  
  154. 				password.setText("");
  155. 				User user = new User(n,p,USER_IDENTITY);
  156. 				try
  157. 				{
  158. 					if(us.IfHaveUser(user))
  159. 					{
  160. 						dispose();
  161. 						USING_USER = n;
  162. 						USING_USER_PASSWORD = p;
  163. 						new StudentMenageView();
  164. 					}
  165. 					else
  166. 					{
  167. 						JOptionPane.showMessageDialog(null, "用户名、密码或用户身份选择错误", "输入错误", JOptionPane.ERROR_MESSAGE);
  168. 					}
  169. 				}
  170. 				catch (Exception e1)
  171. 				{
  172. 					e1.printStackTrace();
  173. 				}
  174. 			}
  175. 			
  176. 			//注册事件
  177. 			if(e.getSource() == zc)
  178. 			{
  179. 				new RegisterView();
  180. 			}
  181. 			
  182. 			//清除信息事件
  183. 			if(e.getSource() == clean)
  184. 			{
  185. 				name.setText("");
  186. 				password.setText("");
  187. 			}
  188. 			
  189. 			//更改密码事件
  190. 			if(e.getSource() == change)
  191. 			{
  192. 				new ChangePasswordView ();
  193. 			}
  194. 			
  195. 			//退出事件
  196. 			if(e.getSource() == quit)
  197. 			{
  198. 				int n = JOptionPane.showConfirmDialog(null, "是否退出?", "退出",JOptionPane.YES_NO_OPTION);
  199. 				if(n==0)
  200. 					System.exit(0);
  201. 			}
  202. 		}
  203. 	}
  204. 	
  205. }

3.RegisterView.java

  1. package com.Lauguobin.www.view.Login;
  2.  
  3. import java.awt.*;
  4. import java.awt.event.ActionEvent;
  5. import java.awt.event.ActionListener;
  6.  
  7. import javax.swing.*;
  8.  
  9. import com.Lauguobin.www.po.User;
  10. import com.Lauguobin.www.service.UserService;
  11. import com.Lauguobin.www.util.ViewUtil;
  12.  
  13. /** 这个窗口只有在登录界面才会用到
  14.  * 这个类用于构建注册窗口。并没有太大卵用。
  15.  * @author GB菌
  16.  *
  17.  */
  18. public class RegisterView extends JDialog
  19. {
  20.  
  21. 	private static final long serialVersionUID = 1L;
  22. 	private JPanel all;
  23. 	private JPanel buttons;
  24. 	private JPanel tips;
  25. 	private JPanel one;
  26. 	private JPanel two;
  27. 	private JPanel three;
  28. 	
  29. 	private ButtonGroup group;
  30. 	private JPanel radios;
  31. 	
  32. 	private JLabel user;
  33. 	private JLabel password;
  34. 	private JLabel affirmPassword;
  35. 	private JLabel tip1;
  36. 	private JLabel tip2;
  37. 	private JLabel tip3;
  38. 	
  39. 	private JTextField tu;
  40. 	private JPasswordField tp;
  41. 	private JPasswordField atp;
  42. 	
  43. 	private JButton yes;
  44. 	private JButton no;
  45. 	private JRadioButton oldDriver;
  46. 	private JRadioButton newbie;
  47. 	
  48. 	 RegisterView()
  49. 	 {
  50. 		all = new JPanel(new GridLayout(4,1));
  51. 		tips = new JPanel(new GridLayout(3,0));
  52. 		group =  new ButtonGroup();
  53. 		radios = new JPanel();
  54. 		one = new JPanel();
  55. 		two = new JPanel();
  56. 		three = new JPanel();
  57. 		 user = new JLabel("用户名称");
  58. 		 password = new JLabel("用户密码");
  59. 		 affirmPassword = new JLabel("确认密码");
  60. 		 tip1 = new JLabel("	　温馨提示：用户名只允许有字母、中文、数字　　");
  61. 		 tip2 = new JLabel("　　　　　　用户名允许的长度为4 - 20位　　");
  62. 		 tip3 = new JLabel("　　　　　　密码长度必须位于6 - 18位");
  63. 		tu = new JTextField(10);
  64. 		tp = new JPasswordField(10);
  65. 		tp.addActionListener(new RegisterMonitor());
  66. 		atp= new JPasswordField(10);
  67. 		atp.addActionListener(new RegisterMonitor());
  68. 		oldDriver = new JRadioButton("管理员");
  69. 		newbie = new JRadioButton("用户");
  70. 		
  71. 		group.add(oldDriver);
  72. 		group.add(newbie);
  73. 		radios.add(oldDriver);
  74. 		oldDriver.addActionListener(new RegisterMonitor());
  75. 		radios.add(newbie);
  76. 		newbie.addActionListener(new RegisterMonitor());
  77. 		one.add(user);
  78. 		one.add(tu);
  79. 		two.add(password);
  80. 		two.add(tp);
  81. 		three.add(affirmPassword);
  82. 		three.add(atp);
  83. 		all.add(one);
  84. 		all.add(two);
  85. 		all.add(three);
  86. 		all.add(radios);
  87. 		tips.add(tip1);
  88. 		tips.add(tip2);
  89. 		tips.add(tip3);
  90. 		 
  91. 		 yes = new JButton("注册");
  92. 		 yes.addActionListener(new RegisterMonitor());
  93. 		 no = new JButton("取消");
  94. 		 no.addActionListener(new RegisterMonitor());
  95. 		 buttons = new JPanel();
  96. 		 buttons.add(yes);
  97. 		 buttons.add(no);
  98. 		 
  99. 		 add(all,"North");
  100. 		 add(tips);
  101. 		 add(buttons,"South");
  102. 		 
  103. 		int screenHeight = ViewUtil.geScreenHeight();
  104. 		int screenWidth = ViewUtil.geScreenWidth();
  105. 		
  106. 		setTitle("新手上路");
  107. 		setLocation(screenWidth / 3 , screenHeight  / 2);
  108. 		setResizable(false);
  109. 		pack();
  110. 		setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
  111. 		setModal(true);
  112. 		setVisible(true);
  113.  
  114. 	 }
  115. 	 
  116. 	 class RegisterMonitor  implements ActionListener
  117. 	 {
  118.  
  119. 		@Override
  120. 		public void actionPerformed(ActionEvent e)
  121. 		{
  122. 			UserService us = new UserService();
  123. 			
  124. 			//点击确定或者在密码文本域敲击回车
  125. 			if(e.getSource() == yes || e.getSource() == tp)
  126. 			{
  127. 				String u = tu.getText();
  128. 				String p = new String(tp.getPassword());
  129. 				String p2 = new String(atp.getPassword());
  130. 				if(!p.equals(p2))
  131. 				{	
  132. 					JOptionPane.showMessageDialog(null, "两次密码输入不一致！", "输入错误", JOptionPane.ERROR_MESSAGE);
  133. 					tp.setText("");
  134. 					atp.setText("");
  135. 					return;
  136. 				}
  137. 				boolean identity;
  138. 				if(oldDriver.isSelected())
  139. 					identity = true;
  140. 				else	if(newbie.isSelected())
  141. 					identity = false;
  142. 				else 
  143. 				{
  144. 					JOptionPane.showMessageDialog(null, "请选择用户类型", "输入错误", JOptionPane.ERROR_MESSAGE);
  145. 					return ;
  146. 				}
  147. 				try
  148. 				{
  149. 					//把数据封装成对象操作
  150. 					User user = new User(u,p,identity);
  151. 					//调用service判断并由service决定是否注册
  152. 					int flag = us.IfAddUserSuccess(user);
  153. 					switch(flag)
  154. 					{
  155. 						case 0:
  156. 						{
  157. 							JOptionPane.showMessageDialog(null, "注册成功", "信息", JOptionPane.PLAIN_MESSAGE);
  158. 							dispose();
  159. 							break;
  160. 						}
  161. 						case 1:JOptionPane.showMessageDialog(null, "密码长度必须在6 - 18位", "警告", JOptionPane.WARNING_MESSAGE);break;
  162. 						case 2:JOptionPane.showMessageDialog(null, "用户名不合法", "警告", JOptionPane.WARNING_MESSAGE);break;
  163. 						case 3:JOptionPane.showMessageDialog(null, "用户已存在", "警告", JOptionPane.WARNING_MESSAGE);break;
  164. 						default :JOptionPane.showMessageDialog(null, "未知错误", "错误", JOptionPane.WARNING_MESSAGE);break;
  165. 					}
  166. 				}
  167. 				catch (Exception e1)
  168. 				{
  169. 					e1.printStackTrace();
  170. 				}
  171. 			}
  172. 			
  173. 			//点击取消
  174. 			if(e.getSource() == no)
  175. 				dispose();
  176. 		}
  177. 		 
  178. 	 }
  179. }

4.GradeView.java

  1. package com.Lauguobin.www.view.ScoreMenagement;
  2.  
  3. import java.awt.event.ActionEvent;
  4. import java.awt.event.ActionListener;
  5.  
  6. import javax.swing.*;
  7. import javax.swing.table.DefaultTableModel;
  8.  
  9. import com.Lauguobin.www.service.*;
  10. import com.Lauguobin.www.util.ViewUtil;
  11. import com.Lauguobin.www.view.Login.LoginView;
  12.  
  13. /**
  14.  * 成绩管理窗口，需要一个id来确定是谁的成绩
  15.  * @author GB菌
  16.  *
  17.  */
  18. public class GradeView extends JDialog
  19. {
  20. 	private static final long serialVersionUID = 1L;
  21. 	private JScrollPane list;
  22. 	private JTable tab;
  23. 	private JPanel inButton;
  24. 	private JPanel search;
  25. 	private JTextField text;
  26. 	private JButton s;
  27. 	private JLabel label;
  28. 	private JButton yes;
  29. 	private JButton change;
  30. 	private JButton f5;
  31. 	int id;
  32. 	
  33. 	public GradeView(int id)
  34. 	{
  35. 		this.id = id;
  36. 		
  37. 		yes = new JButton("返回");
  38. 		yes.addActionListener(new GVMonitor());
  39. 		f5 = new JButton("刷新");
  40. 		f5.addActionListener(new GVMonitor());
  41. 		change = new JButton("修改成绩");
  42. 		change.addActionListener(new GVMonitor());
  43. 		s = new JButton("搜索");
  44. 		s.addActionListener(new GVMonitor());
  45. 		text = new JTextField(15);
  46. 		text.addActionListener(new GVMonitor());
  47. 		list = new JScrollPane();
  48. 		label = new JLabel("搜索成绩<'%'和'_'模糊>");
  49. 		inButton = new JPanel();
  50. 		search = new JPanel();
  51. 		inButton.add(change);
  52. 		inButton.add(f5);
  53. 		inButton.add(yes);
  54. 		search.add(label);
  55. 		search.add(text);
  56. 		search.add(s);
  57. 		
  58. 		list = new JScrollPane();
  59. 		ScoreService ss = new ScoreService();
  60. 		Object[][] nt = ss.getAllScore(id);
  61. 		String[] title = {"学生ID","学生姓名","课程号","课程名称","学科成绩","获得学分"};
  62. 		DefaultTableModel model = new DefaultTableModel(nt, title) 
  63. 		{ 
  64. 			private static final long serialVersionUID = 1L;
  65.  
  66. 				//此处设置单元格时否可以被编辑。
  67. 			  public boolean isCellEditable(int row, int column) 
  68. 			  { 
  69. 			    return false; 
  70. 			  } 
  71. 		}; 
  72. 		tab = new JTable(model);
  73. 		tab.getTableHeader();
  74. 		ViewUtil.fitTableColumns(tab);
  75. 		list.getViewport().add(tab); 
  76. 		
  77. 		add(search,"North");
  78. 		add(list);
  79. 		add(inButton,"South");
  80. 		
  81. 		int screenHeight = ViewUtil.geScreenHeight();
  82. 		int screenWidth = ViewUtil.geScreenWidth();
  83. 		
  84. 		setTitle("查看成绩");
  85. 		setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
  86. 		setBounds(screenWidth / 3 , screenHeight / 4 , screenWidth / 3 , screenHeight  / 3);
  87. 		setModal(true);
  88. 		setResizable(false);
  89. 		setVisible(true);
  90. 	}
  91. 	
  92. 	class GVMonitor  implements ActionListener
  93. 	{
  94.  
  95. 		@Override
  96. 		public void actionPerformed(ActionEvent e)
  97. 		{
  98. 			/*
  99. 			 * 返回事件
  100. 			 */
  101. 			if(e.getSource() == yes)
  102. 				dispose();
  103. 			
  104. 			/*
  105. 			 * 搜索事件
  106. 			 */
  107. 			if(e.getSource() == text || e.getSource() == s)
  108. 			{
  109. 				String str = text.getText();
  110. 				if(str.equals(""))
  111. 				{
  112. 					JOptionPane.showMessageDialog(null, "请输入搜索条件", "警告", JOptionPane.WARNING_MESSAGE);
  113. 				}
  114. 				else
  115. 				{
  116. 					//显示搜索结果的列表
  117. 					Object info[][] = new ScoreService().getSearch(str,id);
  118. 					 String[] title = {"学生ID","学生姓名","课程号","课程名称","学科成绩","获得学分"};
  119. 					DefaultTableModel model = new DefaultTableModel(info,title) 
  120. 					{ 
  121. 						private static final long serialVersionUID = 1L;
  122.  
  123. 							//此处设置单元格时否可以被编辑。
  124. 						  public boolean isCellEditable(int row, int column) 
  125. 						  { 
  126. 						    return false; 
  127. 						  } 
  128. 					}; 
  129. 					tab.setModel(model);
  130. 					tab.getTableHeader();
  131. 					ViewUtil.fitTableColumns(tab);
  132. 					list.getViewport().add(tab); 
  133. 				}
  134. 			}
  135. 			
  136. 			/*
  137. 			 * 更改成绩事件
  138. 			 */
  139. 			if(e.getSource() == change)
  140. 			{
  141. 				if(LoginView.USER_IDENTITY)
  142. 				{
  143. 					int selectedRowIndex = tab.getSelectedRow(); 
  144. 					if(selectedRowIndex >= 0)
  145. 					{
  146. 						//调用service
  147. 						new SetScoreView(selectedRowIndex,tab,list);
  148. 					}
  149. 					else
  150. 					{
  151. 						JOptionPane.showMessageDialog(null, "请选中一行", "警告", JOptionPane.INFORMATION_MESSAGE);
  152. 					}
  153. 				}
  154. 				else
  155. 					JOptionPane.showMessageDialog(null, "你根本就不是老司机！", "警告", JOptionPane.WARNING_MESSAGE);
  156. 			}
  157. 			
  158. 			if(e.getSource() == f5)
  159. 			{
  160. 				ScoreService ss = new ScoreService();
  161. 				Object[][] nt = ss.getAllScore(id);
  162. 				String[] title = {"学生ID","学生姓名","课程号","课程名称","学科成绩","获得学分"};
  163. 				DefaultTableModel model = new DefaultTableModel(nt,title) 
  164. 				{ 
  165. 					private static final long serialVersionUID = 1L;
  166.  
  167. 						//此处设置单元格时否可以被编辑。
  168. 					  public boolean isCellEditable(int row, int column) 
  169. 					  { 
  170. 					    return false; 
  171. 					  } 
  172. 				}; 
  173. 				tab.setModel(model);
  174. 				tab.getTableHeader();
  175. 				ViewUtil.fitTableColumns(tab);
  176. 				list.getViewport().add(tab);
  177. 			}
  178. 		}
  179. 	}
  180. }
  181.

5.备注

如有侵权请联系我删除 



 

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

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

  

闽ICP备14008679号