The-system-of-students-information.zip_The Information

package frame; import java.awt.BorderLayout; import java.awt.FlowLayout; import java.awt.Font; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Enumeration; import java.util.Vector; import javax.swing.AbstractButton; import javax.swing.ImageIcon; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JSplitPane; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.JToolBar; import javax.swing.JTree; import javax.swing.UIManager; import javax.swing.UnsupportedLookAndFeelException; import javax.swing.table.DefaultTableModel; import javax.swing.tree.DefaultMutableTreeNode; import javax.swing.tree.TreeNode; import javax.swing.tree.TreePath; import sql.StuAdd; import sql.StuTable; import sql.StuUpdate; import sql.TeaTable; public class StuMainFrame extends JFrame implements ActionListener{ JButton add,delete,correct,BInformation,BSystem,BHelp,BOff,search; JTextField sno,sname; static JPanel upPanel; static JPanel rightPanel; JPanel jp3; static JToolBar menu; StuTable stm,stm1; static JTable jtb,table; static JSplitPane splitPane1; static JSplitPane splitPane2; JScrollPane jsp; StuTable st; Connection ct=null; PreparedStatement ps=null; ResultSet rs=null; String nodeName; DefaultTableModel dtm; protected static Object SwingUtilities; public StuMainFrame(){ menu=new JToolBar(); BInformation=new JButton(" 信息管理 ",new ImageIcon("image/Information.png")); BInformation.setHorizontalTextPosition(AbstractButton.CENTER);//设置文字的横向位置 BInformation.setVerticalTextPosition(AbstractButton.BOTTOM);//设置文字的纵向位置 BInformation.setToolTipText("点击这里查询学生信息");//设置提示文字 BInformation.setFocusPainted(false); //设置画焦点 //BInformation.setRequestFocusEnabled(false);//设置不能获得焦点，使焦点不停留 BInformation.addActionListener(this); add=new JButton(" 添加 ",new ImageIcon("image/add.png")); add.setHorizontalTextPosition(AbstractButton.CENTER);//设置文字的横向位置 add.setVerticalTextPosition(AbstractButton.BOTTOM);//设置文字的纵向位置 add.setToolTipText("点击这里进行添加信息");//设置提示文字 add.setFocusPainted(false); //设置画焦点 add.addActionListener(this); correct=new JButton(" 修改 ",new ImageIcon("image/correct.png")); correct.setHorizontalTextPosition(AbstractButton.CENTER);//设置文字的横向位置 correct.setVerticalTextPosition(AbstractButton.BOTTOM);//设置文字的纵向位置 correct.setToolTipText("点击这里进行修改信息");//设置提示文字 correct.setFocusPainted(false); //设置画焦点 correct.addActionListener(this); delete=new JButton(" 删除 ",new ImageIcon("image/delete.png")); delete.setHorizontalTextPosition(AbstractButton.CENTER);//设置文字的横向位置 delete.setVerticalTextPosition(AbstractButton.BOTTOM);//设置文字的纵向位置 delete.setToolTipText("点击这里进行删除信息");//设置提示文字 delete.setFocusPainted(false); //设置画焦点 delete.addActionListener(this); BSystem=new JButton(" 系统设置 ",new ImageIcon("image/System.png")); BSystem.setHorizontalTextPosition(AbstractButton.CENTER); BSystem.setVerticalTextPosition(AbstractButton.BOTTOM); BSystem.setToolTipText("点击这里进行系统设置"); BSystem.setFocusPainted(false);//设置不画焦点 //BSystem.setRequestFocusEnabled(false);//设置不能获得焦点，使焦点不停留 BSystem.addActionListener(this); BHelp=new JButton(" 帮助 ",new ImageIcon("image/Help.png")); BHelp.setHorizontalTextPosition(AbstractButton.CENTER); BHelp.setVerticalTextPosition(AbstractButton.BOTTOM); BHelp.setToolTipText("点击这里获取帮助"); BHelp.setFocusPainted(false); //BHelp.setRequestFocusEnabled(false); BHelp.addActionListener(this); BOff=new JButton(" 注销 ",new ImageIcon("image/Off.png")); BOff.setHorizontalTextPosition(AbstractButton.CENTER); BOff.setVerticalTextPosition(AbstractButton.BOTTOM); BOff.setToolTipText("点击这里注销当前用户"); BOff.setFocusPainted(false); //BOff.setRequestFocusEnabled(false); BOff.addActionListener(this); menu.add(BInformation); menu.add(add); menu.add(correct); menu.add(delete); menu.add(BSystem); //menu.addSeparator();//添加分隔线 menu.add(BHelp); menu.add(BOff); menu.setRollover(true); //设置转滚效果，鼠标移上去时出现边框 menu.setFloatable(false);//设置工具条不可移动 menu.setToolTipText("选择不同选项进行学生信息管理");//设置提示文字 upPanel=new JPanel(); upPanel.setBackground(null); upPanel.setOpaque(false); upPanel.add(menu); DefaultMutableTreeNode root=new DefaultMutableTreeNode("用户"); DefaultMutableTreeNode node1=new DefaultMutableTreeNode("学生"); DefaultMutableTreeNode node2=new DefaultMutableTreeNode("教师"); DefaultMutableTreeNode node3=new DefaultMutableTreeNode("管理员"); DefaultMutableTreeNode node311=new DefaultMutableTreeNode("学生管理"); DefaultMutableTreeNode node312=new DefaultMutableTreeNode("教师管理"); DefaultMutableTreeNode node313=new DefaultMutableTreeNode("管理员管理"); root.add(node1); root.add(node2); root.add(node3); node3.add(node311); node3.add(node312); node3.add(node313); DefaultMutableTreeNode leafnode=new DefaultMutableTreeNode("成绩查询"); node1.add(leafnode); leafnode=new DefaultMutableTreeNode("修改成绩"); node2.add(leafnode); leafnode=new DefaultMutableTreeNode("录入成绩"); node2.add(leafnode); leafnode=new DefaultMutableTreeNode("删除成绩"); node2.add(leafnode); leafnode=new DefaultMutableTreeNode("录入新学生信息"); node311.add(leafnode); leafnode=new DefaultMutableTreeNode("删除学生信息"); node311.add(leafnode); leafnode=new DefaultMutableTreeNode("录入新教师信息"); node312.add(leafnode); leafnode=new DefaultMutableTreeNode("删除教师信息"); node312.add(leafnode); leafnode=new DefaultMutableTreeNode("录入新管理员信息"); node313.add(leafnode); leafnode=new DefaultMutableTreeNode("删除管理员信息"); node313.add(leafnode); final JTree tree=new JTree(root); tree.addMouseListener(new MouseAdapter() { public void mousePressed(MouseEvent e) { try{ TreePath treepath=tree.getSelectionPath(); TreeNode treenode=(TreeNode) treepath.getLastPathComponent(); int TreeModel=tree.getLeadSelectionRow(); stm1=new StuTable(); jtb=new JTable(stm1); jsp=new JScrollPane(jtb); nodeName=treenode.toString(); stm=new StuTable(); if(nodeName=="学生"){ JOptionPane.showMessageDialog(null,"请选增、改、删按钮"); } else if(nodeName=="教师"){ //Thread.sleep(500); new TeaMainFrame(); Loading Loading2=new Loading(); StuMainFrame.this.setVisible(false); } else if(nodeName=="管理员"){ new TeaMainFrame(); Loading Loading2=new Loading(); StuMainFrame.this.setVisible(false); } ((javax.swing.SwingUtilities) StuMainFrame.this.SwingUtilities).updateComponentTreeUI(rightPanel); //JOptionPane.showMessageDialog(null,nodeName); }catch(NullPointerException ne){} catch (Exception e1) { // TODO Auto-generated catch block e1.printStackTrace(); } }}); stm=new StuTable();//通过StuTable类建立表 jtb=new JTable(stm);//建立格 JScrollPane jsp=new JScrollPane(jtb);//建立带滚动条面板 //JScrollPane jsp=new JScrollPane(table); search=new JButton("查找"); search.addActionL