• 基于java学生选课系统

    开发工具eclipse,jdk1.8 

    技术：java swing

    数据库：mysql5.7

    学生选课系统功能：管理员、教师、学生三个角色

    一、管理员功能：

    1.登录、修改密码、退出系统

    2.学生管理：添加、修改、删除、查询

    3.班级管理：添加、修改、删除、查询

    4.教师管理：添加、修改、删除、查询

    5.课程管理：添加、修改、删除、查询

    6.选课管理：修改选课、推选课程

    7.帮助、关于

    二、教师功能：

    1.登录、修改密码、退出系统

    2.学生管理：添加、修改、删除、查询

    3.班级管理：添加、修改、删除、查询

    4.教师管理：修改个人信息

    5.课程管理：添加、修改、删除、查询

    6.选课管理：修改选课、推选课程

    7.帮助、关于

    三、学生功能：

    1.登录、修改密码、退出系统

    2.学生管理：修改个人信息

    3.选课管理：修改选课、推选课程

    4.帮助、关于

     管理员截图：

     

     

     

     

     

     

    教师截图：

     

     

     

     

     

     

    学生截图：

     

     

     

    1. package com.artisan.view;
    2.  
    3. import java.awt.EventQueue;
    4.  
    5. import javax.swing.JInternalFrame;
    6. import javax.swing.GroupLayout;
    7. import javax.swing.GroupLayout.Alignment;
    8. import javax.swing.JOptionPane;
    9. import javax.swing.JScrollPane;
    10. import javax.swing.JLabel;
    11.  
    12. import java.awt.Font;
    13. import java.util.List;
    14. import java.util.Vector;
    15.  
    16. import javax.swing.ImageIcon;
    17. import javax.swing.JTextField;
    18. import javax.swing.JButton;
    19. import javax.swing.LayoutStyle.ComponentPlacement;
    20. import javax.swing.JTable;
    21. import javax.swing.table.DefaultTableModel;
    22. import javax.swing.UIManager;
    23.  
    24. import com.artisan.dao.ClassDao;
    25. import com.artisan.model.StudentClass;
    26. import com.artisan.util.StringUtil;
    27.  
    28. import java.awt.event.ActionListener;
    29. import java.awt.event.ActionEvent;
    30.  
    31. import javax.swing.JTextArea;
    32.  
    33. import java.awt.event.MouseAdapter;
    34. import java.awt.event.MouseEvent;
    35.  
    36. public class ManageClassFrm extends JInternalFrame {
    37. 	private JTextField searchClassNameTextField;
    38. 	private JTable classListTable;
    39. 	private JTextField editClassNameTextField;
    40. 	private JTextArea editClassInfoTextArea;
    41. 	/**
    42. 	 * Launch the application.
    43. 	 */
    44. 	public static void main(String[] args) {
    45. 		EventQueue.invokeLater(new Runnable() {
    46. 			public void run() {
    47. 				try {
    48. 					ManageClassFrm frame = new ManageClassFrm();
    49. 					frame.setVisible(true);
    50. 				} catch (Exception e) {
    51. 					e.printStackTrace();
    52. 				}
    53. 			}
    54. 		});
    55. 	}
    56.  
    57. 	/**
    58. 	 * Create the frame.
    59. 	 */
    60. 	public ManageClassFrm() {
    61. 		setClosable(true);
    62. 		setIconifiable(true);
    63. 		setTitle("\u73ED\u7EA7\u4FE1\u606F\u7BA1\u7406");
    64. 		setBounds(100, 100, 773, 562);
    65. 		
    66. 		JScrollPane scrollPane = new JScrollPane();
    67. 		
    68. 		JLabel label = new JLabel("\u73ED\u7EA7\u540D\u79F0\uFF1A");
    69. 		label.setIcon(new ImageIcon(ManageClassFrm.class.getResource("/images/\u73ED\u7EA7\u540D\u79F0.png")));
    70. 		label.setFont(new Font("微软雅黑", Font.PLAIN, 14));
    71. 		
    72. 		searchClassNameTextField = new JTextField();
    73. 		searchClassNameTextField.setColumns(10);
    74. 		
    75. 		JButton searchButton = new JButton("\u67E5\u8BE2");
    76. 		searchButton.addActionListener(new ActionListener() {
    77. 			public void actionPerformed(ActionEvent arg0) {
    78. 				StudentClass sc = new StudentClass();
    79. 				sc.setName(searchClassNameTextField.getText().toString());
    80. 				setTable(sc);
    81. 			}
    82. 		});
    83. 		searchButton.setIcon(new ImageIcon(ManageClassFrm.class.getResource("/images/\u641C\u7D22.png")));
    84. 		searchButton.setFont(new Font("微软雅黑", Font.PLAIN, 14));
    85. 		
    86. 		JLabel label_1 = new JLabel("\u73ED\u7EA7\u540D\u79F0\uFF1A");
    87. 		label_1.setIcon(new ImageIcon(ManageClassFrm.class.getResource("/images/\u73ED\u7EA7\u540D\u79F0.png")));
    88. 		label_1.setFont(new Font("微软雅黑", Font.PLAIN, 14));
    89. 		
    90. 		editClassNameTextField = new JTextField();
    91. 		editClassNameTextField.setColumns(10);
    92. 		
    93. 		JLabel label_2 = new JLabel("\u73ED\u7EA7\u4FE1\u606F\uFF1A");
    94. 		label_2.setIcon(new ImageIcon(ManageClassFrm.class.getResource("/images/\u73ED\u7EA7\u4ECB\u7ECD.png")));
    95. 		label_2.setFont(new Font("微软雅黑", Font.PLAIN, 14));
    96. 		
    97. 		editClassInfoTextArea = new JTextArea();
    98. 		
    99. 		JButton submitEditButton = new JButton("\u786E\u8BA4\u4FEE\u6539");
    100. 		submitEditButton.addActionListener(new ActionListener() {
    101. 			public void actionPerformed(ActionEvent ae) {
    102. 				submitEditAct(ae);
    103. 			}
    104. 		});
    105. 		submitEditButton.setIcon(new ImageIcon(ManageClassFrm.class.getResource("/images/\u786E\u8BA4.png")));
    106. 		submitEditButton.setFont(new Font("微软雅黑", Font.PLAIN, 14));
    107. 		
    108. 		JButton submitDeleteButton = new JButton("\u5220\u9664");
    109. 		submitDeleteButton.addActionListener(new ActionListener() {
    110. 			public void actionPerformed(ActionEvent ae) {
    111. 				deleteClassAct(ae);
    112. 			}
    113. 		});
    114. 		submitDeleteButton.setIcon(new ImageIcon(ManageClassFrm.class.getResource("/images/\u5220\u9664.png")));
    115. 		submitDeleteButton.setFont(new Font("微软雅黑", Font.PLAIN, 14));
    116. 		GroupLayout groupLayout = new GroupLayout(getContentPane());
    117. 		groupLayout.setHorizontalGroup(
    118. 			groupLayout.createParallelGroup(Alignment.LEADING)
    119. 				.addGroup(groupLayout.createSequentialGroup()
    120. 					.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
    121. 						.addGroup(groupLayout.createSequentialGroup()
    122. 							.addGap(160)
    123. 							.addComponent(label)
    124. 							.addGap(18)
    125. 							.addComponent(searchClassNameTextField, GroupLayout.PREFERRED_SIZE, 207, GroupLayout.PREFERRED_SIZE)
    126. 							.addGap(50)
    127. 							.addComponent(searchButton))
    128. 						.addGroup(groupLayout.createSequentialGroup()
    129. 							.addGap(110)
    130. 							.addComponent(scrollPane, GroupLayout.PREFERRED_SIZE, 536, GroupLayout.PREFERRED_SIZE))
    131. 						.addGroup(groupLayout.createSequentialGroup()
    132. 							.addGap(53)
    133. 							.addGroup(groupLayout.createParallelGroup(Alignment.LEADING, false)
    134. 								.addGroup(groupLayout.createSequentialGroup()
    135. 									.addPreferredGap(ComponentPlacement.RELATED)
    136. 									.addComponent(label_2)
    137. 									.addGap(18)
    138. 									.addComponent(editClassInfoTextArea))
    139. 								.addGroup(groupLayout.createSequentialGroup()
    140. 									.addComponent(label_1)
    141. 									.addGap(18)
    142. 									.addComponent(editClassNameTextField, GroupLayout.PREFERRED_SIZE, 146, GroupLayout.PREFERRED_SIZE)))
    143. 							.addGap(102)
    144. 							.addGroup(groupLayout.createParallelGroup(Alignment.LEADING, false)
    145. 								.addComponent(submitDeleteButton, GroupLayout.DEFAULT_SIZE, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
    146. 								.addComponent(submitEditButton, GroupLayout.DEFAULT_SIZE, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))
    147. 					.addContainerGap(111, Short.MAX_VALUE))
    148. 		);
    149. 		groupLayout.setVerticalGroup(
    150. 			groupLayout.createParallelGroup(Alignment.LEADING)
    151. 				.addGroup(groupLayout.createSequentialGroup()
    152. 					.addGap(45)
    153. 					.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
    154. 						.addComponent(label, GroupLayout.PREFERRED_SIZE, 27, GroupLayout.PREFERRED_SIZE)
    155. 						.addComponent(searchClassNameTextField, GroupLayout.PREFERRED_SIZE, 33, GroupLayout.PREFERRED_SIZE)
    156. 						.addComponent(searchButton, GroupLayout.PREFERRED_SIZE, 31, GroupLayout.PREFERRED_SIZE))
    157. 					.addGap(30)
    158. 					.addComponent(scrollPane, GroupLayout.PREFERRED_SIZE, 282, GroupLayout.PREFERRED_SIZE)
    159. 					.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
    160. 						.addGroup(groupLayout.createSequentialGroup()
    161. 							.addGap(18)
    162. 							.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
    163. 								.addComponent(label_1)
    164. 								.addComponent(editClassNameTextField, GroupLayout.PREFERRED_SIZE, 30, GroupLayout.PREFERRED_SIZE))
    165. 							.addGap(18)
    166. 							.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
    167. 								.addGroup(groupLayout.createSequentialGroup()
    168. 									.addComponent(editClassInfoTextArea, GroupLayout.DEFAULT_SIZE, 66, Short.MAX_VALUE)
    169. 									.addContainerGap())
    170. 								.addGroup(Alignment.TRAILING, groupLayout.createSequentialGroup()
    171. 									.addComponent(label_2)
    172. 									.addGap(32))))
    173. 						.addGroup(groupLayout.createSequentialGroup()
    174. 							.addGap(30)
    175. 							.addComponent(submitEditButton)
    176. 							.addGap(34)
    177. 							.addComponent(submitDeleteButton)
    178. 							.addContainerGap())))
    179. 		);
    180. 		
    181. 		classListTable = new JTable();
    182. 		classListTable.addMouseListener(new MouseAdapter() {
    183. 			@Override
    184. 			public void mouseClicked(MouseEvent me) {
    185. 				selectedTableRow(me);
    186. 			}
    187. 		});
    188. 		classListTable.setFont(new Font("微软雅黑", Font.PLAIN, 12));
    189. 		classListTable.setModel(new DefaultTableModel(
    190. 			new Object[][] {
    191. 			},
    192. 			new String[] {
    193. 					"\u73ED\u7EA7\u7F16\u53F7","\u73ED\u7EA7\u540D\u79F0" , "\u73ED\u7EA7\u4FE1\u606F\u4ECB\u7ECD"
    194. 			}
    195. 		) {
    196. 			boolean[] columnEditables = new boolean[] {
    197. 				false, false, false
    198. 			};
    199. 			public boolean isCellEditable(int row, int column) {
    200. 				return columnEditables[column];
    201. 			}
    202. 		});
    203. 		classListTable.getColumnModel().getColumn(2).setPreferredWidth(316);
    204. 		scrollPane.setViewportView(classListTable);
    205. 		getContentPane().setLayout(groupLayout);
    206. 		setTable(new StudentClass());
    207. 	}
    208. 	protected void deleteClassAct(ActionEvent ae) {
    209. 		// TODO Auto-generated method stub
    210. 		if(JOptionPane.showConfirmDialog(this, "您确定删除么？") != JOptionPane.OK_OPTION){
    211. 			return;
    212. 		}
    213. 		int index = classListTable.getSelectedRow();
    214. 		if(index == -1){
    215. 			JOptionPane.showMessageDialog(this, "请选中要删除的数据!");
    216. 			return;
    217. 		}
    218. 		DefaultTableModel dft = (DefaultTableModel) classListTable.getModel();
    219. 		int id = Integer.parseInt(dft.getValueAt(classListTable.getSelectedRow(), 0).toString());
    220. 		ClassDao classDao = new ClassDao();
    221. 		if(classDao.delete(id)){
    222. 			JOptionPane.showMessageDialog(this, "删除成功!");
    223. 		}else{
    224. 			JOptionPane.showMessageDialog(this, "删除失败!");
    225. 		}
    226. 		classDao.closeDao();
    227. 		setTable(new StudentClass());
    228. 	}
    229.  
    230. 	protected void submitEditAct(ActionEvent ae) {
    231. 		// TODO Auto-generated method stub
    232. 		ClassDao classDao = new ClassDao();
    233. 		int index = classListTable.getSelectedRow();
    234. 		if(index == -1){
    235. 			JOptionPane.showMessageDialog(this, "请选中要修改的数据!");
    236. 			return;
    237. 		}
    238. 		DefaultTableModel dft = (DefaultTableModel) classListTable.getModel();
    239. 		String className = dft.getValueAt(classListTable.getSelectedRow(), 1).toString();
    240. 		String classInfo = dft.getValueAt(classListTable.getSelectedRow(), 2).toString();
    241. 		String editClassName = editClassNameTextField.getText().toString();
    242. 		String editClassInfo = editClassInfoTextArea.getText().toString();
    243. 		if(StringUtil.isEmpty(editClassName)){
    244. 			JOptionPane.showMessageDialog(this, "请填写要修改的名称!");
    245. 			return;
    246. 		}
    247. 		if(className.equals(editClassName) && classInfo.equals(editClassInfo)){
    248. 			JOptionPane.showMessageDialog(this, "您还没有做任何修改!");
    249. 			return;
    250. 		}
    251. 		int id = Integer.parseInt(dft.getValueAt(classListTable.getSelectedRow(), 0).toString());
    252. 		StudentClass sc = new StudentClass();
    253. 		sc.setId(id);
    254. 		sc.setName(editClassName);
    255. 		sc.setInfo(editClassInfo);
    256. 		if(classDao.update(sc)){
    257. 			JOptionPane.showMessageDialog(this, "更新成功!");
    258. 		}else{
    259. 			JOptionPane.showMessageDialog(this, "更新失败!");
    260. 		}
    261. 		classDao.closeDao();
    262. 		setTable(new StudentClass());
    263. 	}
    264.  
    265. 	protected void selectedTableRow(MouseEvent me) {
    266. 		// TODO Auto-generated method stub
    267. 		DefaultTableModel dft = (DefaultTableModel) classListTable.getModel();
    268. 		editClassNameTextField.setText(dft.getValueAt(classListTable.getSelectedRow(), 1).toString());
    269. 		editClassInfoTextArea.setText(dft.getValueAt(classListTable.getSelectedRow(), 2).toString());
    270. 	}
    271.  
    272. 	private void setTable(StudentClass studentClass){
    273. 		DefaultTableModel dft = (DefaultTableModel) classListTable.getModel();
    274. 		dft.setRowCount(0);
    275. 		ClassDao classDao = new ClassDao();
    276. 		List classList = classDao.getClassList(studentClass);
    277. 		for (StudentClass sc : classList) {
    278. 			Vector v = new Vector();
    279. 			v.add(sc.getId());
    280. 			v.add(sc.getName());
    281. 			v.add(sc.getInfo());
    282. 			dft.addRow(v);
    283. 		}
    284. 		classDao.closeDao();
    285. 	}
    286. }

    package com.artisan.view;

    import java.awt.EventQueue;
    import java.awt.Font;
    import java.awt.event.ActionEvent;
    import java.awt.event.ActionListener;
    import java.awt.event.ItemEvent;
    import java.awt.event.ItemListener;
    import java.awt.event.MouseAdapter;
    import java.awt.event.MouseEvent;
    import java.util.ArrayList;
    import java.util.List;
    import java.util.Vector;

    import javax.swing.GroupLayout;
    import javax.swing.GroupLayout.Alignment;
    import javax.swing.ImageIcon;
    import javax.swing.JButton;
    import javax.swing.JComboBox;
    import javax.swing.JInternalFrame;
    import javax.swing.JLabel;
    import javax.swing.JOptionPane;
    import javax.swing.JPanel;
    import javax.swing.JScrollPane;
    import javax.swing.JTable;
    import javax.swing.LayoutStyle.ComponentPlacement;
    import javax.swing.border.TitledBorder;
    import javax.swing.table.DefaultTableModel;

    import com.artisan.dao.CourseDao;
    import com.artisan.dao.SelectedCourseDao;
    import com.artisan.dao.StudentDao;
    import com.artisan.model.Course;
    import com.artisan.model.SelectedCourse;
    import com.artisan.model.Student;

    public class ManageSelectedCourseFrm extends JInternalFrame {
        private JTable selectedCourseListTable;
        private JComboBox searchCourseComboBox;
        private JComboBox searchStudentComboBox;
        private JComboBox editSelectedStudentComboBox;
        private JComboBox editSelectedCourseComboBox;
        private List studentList = new ArrayList();
        private List courseList = new ArrayList();
        /**
         * Launch the application.
         */
        public static void main(String[] args) {
            EventQueue.invokeLater(new Runnable() {
                public void run() {
                    try {
                        ManageSelectedCourseFrm frame = new ManageSelectedCourseFrm();
                        frame.setVisible(true);
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                }
            });
        }

        /**
         * Create the frame.
         */
        public ManageSelectedCourseFrm() {
            setClosable(true);
            setIconifiable(true);
            setTitle("\u9009\u8BFE\u7BA1\u7406");
            setBounds(100, 100, 669, 562);
            
            JLabel label = new JLabel("\u5B66\u751F\uFF1A");
            label.setIcon(new ImageIcon(ManageSelectedCourseFrm.class.getResource("/images/\u5B66\u751F\u7BA1\u7406.png")));
            label.setFont(new Font("微软雅黑", Font.PLAIN, 14));
            
            searchStudentComboBox = new JComboBox();
            searchStudentComboBox.addItemListener(new ItemListener() {
                public void itemStateChanged(ItemEvent ie) {
                    studentChangeAct(ie);
                }
            });
            
            JLabel label_1 = new JLabel("\u8BFE\u7A0B\uFF1A");
            label_1.setIcon(new ImageIcon(ManageSelectedCourseFrm.class.getResource("/images/\u65B0\u4EBA\u8BFE\u7A0B.png")));
            label_1.setFont(new Font("微软雅黑", Font.PLAIN, 14));
            
            searchCourseComboBox = new JComboBox();
            
            JButton confirmSelectedButton = new JButton("\u786E\u8BA4\u9009\u8BFE");
            confirmSelectedButton.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent ae) {
                    confirmSelectedCourse(ae);
                }
            });
            confirmSelectedButton.setFont(new Font("微软雅黑", Font.PLAIN, 14));
            confirmSelectedButton.setIcon(new ImageIcon(ManageSelectedCourseFrm.class.getResource("/images/\u786E\u8BA4.png")));
            
            JScrollPane scrollPane = new JScrollPane();
            
            JPanel panel = new JPanel();
            panel.setBorder(new TitledBorder(null, "\u4FEE\u6539\u9009\u8BFE", TitledBorder.LEADING, TitledBorder.TOP, null, null));
            GroupLayout groupLayout = new GroupLayout(getContentPane());
            groupLayout.setHorizontalGroup(
                groupLayout.createParallelGroup(Alignment.TRAILING)
                    .addGroup(groupLayout.createSequentialGroup()
                        .addGap(46)
                        .addComponent(label)
                        .addGap(2)
                        .addComponent(searchStudentComboBox, GroupLayout.PREFERRED_SIZE, 124, GroupLayout.PREFERRED_SIZE)
                        .addGap(20)
                        .addComponent(label_1)
                        .addGap(12)
                        .addComponent(searchCourseComboBox, GroupLayout.PREFERRED_SIZE, 127, GroupLayout.PREFERRED_SIZE)
                        .addGap(36)
                        .addComponent(confirmSelectedButton)
                        .addContainerGap(49, Short.MAX_VALUE))
                    .addGroup(groupLayout.createSequentialGroup()
                        .addContainerGap(81, Short.MAX_VALUE)
                        .addComponent(scrollPane, GroupLayout.PREFERRED_SIZE, 493, GroupLayout.PREFERRED_SIZE)
                        .addGap(77))
                    .addGroup(Alignment.LEADING, groupLayout.createSequentialGroup()
                        .addGap(75)
                        .addComponent(panel, GroupLayout.PREFERRED_SIZE, 500, GroupLayout.PREFERRED_SIZE)
                        .addContainerGap(78, Short.MAX_VALUE))
            );
            groupLayout.setVerticalGroup(
                groupLayout.createParallelGroup(Alignment.LEADING)
                    .addGroup(groupLayout.createSequentialGroup()
                        .addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
                            .addGroup(groupLayout.createSequentialGroup()
                                .addGap(36)
                                .addComponent(label))
                            .addGroup(groupLayout.createSequentialGroup()
                                .addGap(34)
                                .addComponent(searchStudentComboBox, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
                            .addGroup(groupLayout.createSequentialGroup()
                                .addGap(34)
                                .addComponent(label_1))
                            .addGroup(groupLayout.createSequentialGroup()
                                .addGap(33)
                                .addComponent(searchCourseComboBox, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
                            .addGroup(groupLayout.createSequentialGroup()
                                .addGap(32)
                                .addComponent(confirmSelectedButton)))
                        .addGap(47)
                        .addComponent(scrollPane, GroupLayout.PREFERRED_SIZE, 216, GroupLayout.PREFERRED_SIZE)
                        .addGap(31)
                        .addComponent(panel, GroupLayout.PREFERRED_SIZE, 144, GroupLayout.PREFERRED_SIZE)
                        .addContainerGap(35, Short.MAX_VALUE))
            );
            
            selectedCourseListTable = new JTable();
            selectedCourseListTable.addMouseListener(new MouseAdapter() {
                @Override
                public void mouseClicked(MouseEvent me) {
                    selectedCourse(me);
                }
            });
            selectedCourseListTable.setModel(new DefaultTableModel(
                new Object[][] {
                },
                new String[] {
                    "\u9009\u8BFE\u7F16\u53F7", "\u5B66\u751F\u59D3\u540D", "\u8BFE\u7A0B\u540D\u79F0"
                }
            ) {
                boolean[] columnEditables = new boolean[] {
                    false, false, false
                };
                public boolean isCellEditable(int row, int column) {
                    return columnEditables[column];
                }
            });
            scrollPane.setViewportView(selectedCourseListTable);
            
            JLabel label_2 = new JLabel("\u5B66\u751F\uFF1A");
            label_2.setIcon(new ImageIcon(ManageSelectedCourseFrm.class.getResource("/images/\u5B66\u751F\u7BA1\u7406.png")));
            label_2.setFont(new Font("微软雅黑", Font.PLAIN, 14));
            
            editSelectedStudentComboBox = new JComboBox();
            
            JLabel label_3 = new JLabel("\u8BFE\u7A0B\uFF1A");
            label_3.setIcon(new ImageIcon(ManageSelectedCourseFrm.class.getResource("/images/\u65B0\u4EBA\u8BFE\u7A0B.png")));
            label_3.setFont(new Font("微软雅黑", Font.PLAIN, 14));
            
            editSelectedCourseComboBox = new JComboBox();
            
            JButton confirmEditButton = new JButton("\u786E\u8BA4\u4FEE\u6539");
            confirmEditButton.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent ae) {
                    editSelectCourseAct(ae);
                }
            });
            confirmEditButton.setIcon(new ImageIcon(ManageSelectedCourseFrm.class.getResource("/images/\u786E\u8BA4.png")));
            confirmEditButton.setFont(new Font("微软雅黑", Font.PLAIN, 14));
            
            JButton deleteCourseButton = new JButton("\u9000\u9009\u8BFE\u7A0B");
            deleteCourseButton.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent ae) {
                    deleteSelectedCourse(ae);
                }
            });
            deleteCourseButton.setFont(new Font("微软雅黑", Font.PLAIN, 14));
            deleteCourseButton.setIcon(new ImageIcon(ManageSelectedCourseFrm.class.getResource("/images/\u5220\u9664.png")));
            GroupLayout gl_panel = new GroupLayout(panel);
            gl_panel.setHorizontalGroup(
                gl_panel.createParallelGroup(Alignment.LEADING)
                    .addGroup(gl_panel.createSequentialGroup()
                        .addGroup(gl_panel.createParallelGroup(Alignment.LEADING)
                            .addGroup(gl_panel.createSequentialGroup()
                                .addContainerGap()
                                .addComponent(label_2)
                                .addGap(18)
                                .addComponent(editSelectedStudentComboBox, GroupLayout.PREFERRED_SIZE, 127, GroupLayout.PREFERRED_SIZE))
                            .addGroup(gl_panel.createSequentialGroup()
                                .addGap(75)
                                .addComponent(confirmEditButton)))
                        .addGroup(gl_panel.createParallelGroup(Alignment.LEADING)
                            .addGroup(gl_panel.createSequentialGroup()
                                .addGap(39)
                                .addComponent(label_3)
                                .addGap(18)
                                .addComponent(editSelectedCourseComboBox, 0, 140, Short.MAX_VALUE))
                            .addGroup(gl_panel.createSequentialGroup()
                                .addGap(65)
                                .addComponent(deleteCourseButton)))
                        .addContainerGap())
            );
            gl_panel.setVerticalGroup(
                gl_panel.createParallelGroup(Alignment.LEADING)
                    .addGroup(gl_panel.createSequentialGroup()
                        .addContainerGap()
                        .addGroup(gl_panel.createParallelGroup(Alignment.BASELINE)
                            .addComponent(label_2)
                            .addComponent(editSelectedStudentComboBox, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
                            .addComponent(label_3)
                            .addComponent(editSelectedCourseComboBox, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(ComponentPlacement.RELATED, 52, Short.MAX_VALUE)
                        .addGroup(gl_panel.createParallelGroup(Alignment.BASELINE)
                            .addComponent(confirmEditButton)
                            .addComponent(deleteCourseButton))
                        .addContainerGap())
            );
            panel.setLayout(gl_panel);
            getContentPane().setLayout(groupLayout);
            setStudentCombox();
            setCourseCombox();
            initTable();
            setAuthority();
        }
        protected void deleteSelectedCourse(ActionEvent ae) {
            // TODO Auto-generated method stub
            int row = selectedCourseListTable.getSelectedRow();
            if(row == -1){
                JOptionPane.showMessageDialog(this, "请选择要修改的数据！");
                return;
            }
            int selected_id = Integer.parseInt(selectedCourseListTable.getValueAt(row, 0).toString());
            String courseName = selectedCourseListTable.getValueAt(row, 2).toString();
            SelectedCourse sc = new SelectedCourse();
            sc.setId(selected_id);
            SelectedCourseDao scDao = new SelectedCourseDao();
            CourseDao courseDao = new CourseDao();
            if(scDao.delete(selected_id)){
                if(courseDao.updateSelectedNum(getCourseIdByName(courseName), -1)){
                    JOptionPane.showMessageDialog(this, "退课成功！");
                }else{
                    JOptionPane.showMessageDialog(this, "退课成功，更新课程信息失败！");
                }
            }else{
                JOptionPane.showMessageDialog(this, "退课失败！");
            }
            scDao.closeDao();
            courseDao.closeDao();
            initTable();
        }

        protected void editSelectCourseAct(ActionEvent ae) {
            // TODO Auto-generated method stub
            int row = selectedCourseListTable.getSelectedRow();
            if(row == -1){
                JOptionPane.showMessageDialog(this, "请选择要修改的数据！");
                return;
            }
            int selected_id = Integer.parseInt(selectedCourseListTable.getValueAt(row, 0).toString());
            String studentName = selectedCourseListTable.getValueAt(row, 1).toString();
            String courseName = selectedCourseListTable.getValueAt(row, 2).toString();
            Student student = (Student) editSelectedStudentComboBox.getSelectedItem();
            Course course = (Course) editSelectedCourseComboBox.getSelectedItem();
            if(studentName.equals(student.getName())&&courseName.equals(course.getName())){
                JOptionPane.showMessageDialog(this, "还未修改数据！");
                return;
            }
            CourseDao courseDao = new CourseDao();
            if(!courseDao.selectedEnable(course.getId())){
                JOptionPane.showMessageDialog(this, "该课程已经选满，不能再选!");
                return;
            }
            
            SelectedCourse sc = new SelectedCourse();
            sc.setId(selected_id);
            sc.setStudent_id(student.getId());
            sc.setCourse_id(course.getId());
            SelectedCourseDao scDao = new SelectedCourseDao();
            if(scDao.isSelected(sc)){
                JOptionPane.showMessageDialog(this, "已经选过这门课程了，不能再选!");
                return;
            }
            if(scDao.updateSelectedCourse(sc)){
                if(courseDao.updateSelectedNum(sc.getCourse_id(),1)){
                    if(courseDao.updateSelectedNum(getCourseIdByName(courseName), -1)){
                        JOptionPane.showMessageDialog(this, "修改成功！!");
                    }
                }else{
                    JOptionPane.showMessageDialog(this, "修改成功，课程信息更新失败!");
                }
            }
            courseDao.closeDao();
            scDao.closeDao();
            initTable();
        }

        protected void selectedCourse(MouseEvent me) {
            // TODO Auto-generated method stub
            int row = selectedCourseListTable.getSelectedRow();
            String studentName = selectedCourseListTable.getValueAt(row, 1).toString();
            String courseName = selectedCourseListTable.getValueAt(row, 2).toString();
            for (int i = 0; i < editSelectedStudentComboBox.getItemCount();i++) {
                Student student = (Student) editSelectedStudentComboBox.getItemAt(i);
                if(studentName.equals(student.getName())){
                    editSelectedStudentComboBox.setSelectedIndex(i);
                    break;
                }
            }
            for (int i = 0; i < editSelectedCourseComboBox.getItemCount();i++) {
                Course course = (Course) editSelectedCourseComboBox.getItemAt(i);
                if(courseName.equals(course.getName())){
                    editSelectedCourseComboBox.setSelectedIndex(i);
                    break;
                }
            }
        }

        protected void studentChangeAct(ItemEvent ie) {
            // TODO Auto-generated method stub
            if(ie.getStateChange() == ItemEvent.SELECTED){
                initTable();
            }
            //JOptionPane.showMessageDialog(this, ie.getStateChange());
        }

        protected void confirmSelectedCourse(ActionEvent ae) {
            // TODO Auto-generated method stub
            Student sstudent = (Student) searchStudentComboBox.getSelectedItem();
            Course scourse = (Course) searchCourseComboBox.getSelectedItem();
            SelectedCourse sc = new SelectedCourse();
            sc.setStudent_id(sstudent.getId());
            sc.setCourse_id(scourse.getId());
            CourseDao courseDao = new CourseDao();
            if(!courseDao.selectedEnable(scourse.getId())){
                JOptionPane.showMessageDialog(this, "该课程已经选满，不能再选!");
                return;
            }
            SelectedCourseDao scDao = new SelectedCourseDao();
            if(scDao.isSelected(sc)){
                JOptionPane.showMessageDialog(this, "已经选过这门课程了，不能再选!");
                return;
            }
            if(scDao.addSelectedCourse(sc)){
                if(courseDao.updateSelectedNum(sc.getCourse_id(),1)){
                    JOptionPane.showMessageDialog(this, "选课成功！!");
                }else{
                    JOptionPane.showMessageDialog(this, "选课成功，课程信息更新失败!");
                }
            }else{
                JOptionPane.showMessageDialog(this, "选课失败!");
            }
            courseDao.closeDao();
            scDao.closeDao();
            initTable();
        }

        private void setStudentCombox(){
            StudentDao studentDao = new StudentDao();
            studentList = studentDao.getStudentList(new Student());
            studentDao.closeDao();
            for (Student student : studentList) {
                searchStudentComboBox.addItem(student);
                editSelectedStudentComboBox.addItem(student);
            }
            if("学生".equals(MainFrm.userType.getName())){
                Student user = (Student) MainFrm.userObject;
                for(int i = 0; i < searchStudentComboBox.getItemCount();i++){
                    Student student = (Student) searchStudentComboBox.getItemAt(i);
                    if(student.getId() == user.getId()){
                        searchStudentComboBox.setSelectedIndex(i);
                        editSelectedStudentComboBox.setSelectedIndex(i);
                        break;
                    }
                }
            }
        }
        private void setCourseCombox(){
            CourseDao courseDao = new CourseDao();
            courseList = courseDao.getCourseList(new Course());
            courseDao.closeDao();
            for (Course course : courseList) {
                searchCourseComboBox.addItem(course);
                editSelectedCourseComboBox.addItem(course);
            }
        }
        private void getSelectedCourse(SelectedCourse selectedCourse){
            SelectedCourseDao selectedCourseDao = new SelectedCourseDao();
            List selectedCourseList = selectedCourseDao.getSelectedCourseList(selectedCourse);
            DefaultTableModel dft = (DefaultTableModel) selectedCourseListTable.getModel();
            dft.setRowCount(0);
            for (SelectedCourse sc : selectedCourseList) {
                Vector v = new Vector();
                v.add(sc.getId());
                v.add(getStudentNameById(sc.getStudent_id()));
                v.add(getCourseNameById(sc.getCourse_id()));
                dft.addRow(v);
            }
            selectedCourseDao.closeDao();
        }
        private void initTable(){
            Student student = (Student) searchStudentComboBox.getSelectedItem();
            SelectedCourse sc = new SelectedCourse();
            sc.setStudent_id(student.getId());
            getSelectedCourse(sc);
        }
        private String getStudentNameById(int id){
            for (int i = 0; i < studentList.size(); i++) {
                if(studentList.get(i).getId() == id)return studentList.get(i).getName();
            }
            return "";
        }
        private String getCourseNameById(int id){
            for (int i = 0; i < courseList.size(); i++) {
                if(id == courseList.get(i).getId())return courseList.get(i).getName();
            }
            return "";
        }
        private int getCourseIdByName(String name){
            for (int i = 0; i < courseList.size(); i++) {
                if(name.equals(courseList.get(i).getName()))return courseList.get(i).getId();
            }
            return 0;
        }
        private void setAuthority(){
            if("学生".equals(MainFrm.userType.getName())){
                searchStudentComboBox.setEnabled(false);
                editSelectedStudentComboBox.setEnabled(false);
            }
        }
    }
     

  • 相关阅读:
    Mysql查询去空格方法汇总
    使用SPDK lib搭建自己的NVMe-oF Target应用
    玩玩群晖NAS-搭建一个私有的Git服务
    道可云元宇宙每日资讯｜安踏发布“羽龙元宇宙”时装秀
    基于MSTP+VRRP的高可用企业网络规划与设计
    monkeyDev使用及初次使用问题的解决方法
    Dart 语言入门
    JVM运行时数据区——程序计数器
    RabbitMQ 总结
    JuiceFS 在多云架构中加速大模型推理
  • 原文地址：https://blog.csdn.net/weixin_42899150/article/details/127950511