xueshengguanli.zip_Java 8_成绩批量导入_选课

import java.awt.*; import java.awt.event.*; import java.beans.PropertyChangeEvent; import java.beans.PropertyChangeListener; import java.io.File; import java.io.IOException; import java.io.ObjectInputStream; import java.io.ObjectOutputStream; import java.net.Socket; import java.sql.Timestamp; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.Vector; import javax.swing.*; import javax.swing.border.EmptyBorder; import javax.swing.table.DefaultTableModel; import com.sunking.swing.JDatePicker; import com.sunking.swing.OpenSwingUtil; public class Manager extends JFrame { CardLayout cl;JComboBox textb3; private String statea,stateb;static Vector vr; private ObjectOutputStream oos=null; private ObjectInputStream ois=null; private Socket ClientSocket=null; private JFileChooser jfc = new JFileChooser(); Vector<Integer> row=new Vector<Integer>(); Vector<Integer> rowmes=new Vector<Integer>(); Vector mes=new Vector(); Vector<String> headVectormes=new Vector(); JTable departablemes; DefaultTableModel tableModelmes=new DefaultTableModel(); Vector vb;String listb1[];Vector va;String listb2[];Vector vd;String listb3[]; Vector log=new Vector();Vector jiangcheng=new Vector(); Vector rowVector=new Vector(); Vector rowVector2=new Vector(); Vector rowVector3=new Vector(); Vector rowVector4=new Vector(); Vector rowVector5=new Vector(); Vector rowV1=new Vector();Vector rowV2=new Vector(); Vector<String> headVector=new Vector(); Vector<String> headVectorlog=new Vector();Vector<String> headVectorjiangcheng=new Vector(); Vector<String> headVector2=new Vector(); Vector<String> headVector3=new Vector(); Vector<String> headVector4=new Vector(); Vector<String> headVector5=new Vector(); Vector<String> headVector6=new Vector(); Vector<String> headVector8=new Vector(); JTable stutable; JTable teachertable; JTable departable; JTable departablelog;JTable departablejiangcheng; JTable stable; String id; SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); DefaultTableModel tableModel=new DefaultTableModel(); DefaultTableModel tableModel2=new DefaultTableModel(); DefaultTableModel tableModel3=new DefaultTableModel(); DefaultTableModel tableModel4=new DefaultTableModel(); DefaultTableModel tableModel5=new DefaultTableModel(); DefaultTableModel tableModel6=new DefaultTableModel(); DefaultTableModel tableModel7=new DefaultTableModel(); DefaultTableModel tableModellog=new DefaultTableModel(); DefaultTableModel tableModeljiangcheng=new DefaultTableModel(); int intstr=0; DefaultTableModel tableModel8=new DefaultTableModel(); public void Exit(){ try { oos.writeUTF("exit"); oos.flush(); ois.close(); ois.close(); ClientSocket.close(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } this.setVisible(false); this.dispose(); } public Manager(String ID, ObjectOutputStream os, ObjectInputStream is,Socket clientSocket) { this.setVisible(false); this.id=ID; this.oos=os; this.ois=is; this.ClientSocket=clientSocket; String statestr="select 年 from courseState"; Vector vectorxing=null; try { oos.writeUTF("Info"+statestr); oos.flush(); vectorxing=(Vector)ois.readObject(); intstr=(Integer)((Vector)vectorxing.get(0)).get(0); } catch (Exception e2) { // TODO Auto-generated catch block e2.printStackTrace(); } JPanel panela=new JPanel(); JPanel panelb=new JPanel(); JPanel panelc=new JPanel(); JPanel paneld=new JPanel(); JPanel panele=new JPanel(); JPanel panelee=new JPanel(); JPanel panelf=new JPanel(); JPanel panel1=new JPanel(); JPanel panel2=new JPanel(); JPanel panellog=new JPanel(); JPanel panelmes=new JPanel(); JPanel paneljiangcheng=new JPanel(); JPanel panelstate=new JPanel(); final JPanel centerPanel=new JPanel(); cl=new CardLayout(); centerPanel.setLayout(cl); centerPanel.add("1",panela); centerPanel.add("2",panelb); centerPanel.add("3",panelc); centerPanel.add("4",paneld); centerPanel.add("5",panele); centerPanel.add("6",panelf); centerPanel.add("7",panel2); centerPanel.add("8",panel1); centerPanel.add("11",paneljiangcheng); centerPanel.add("9",panellog); centerPanel.add("10",panelstate); centerPanel.add("12",panelmes); centerPanel.add("13",panelee); JButton freshMan=new JButton("未修新生"); freshMan.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { cl.show(centerPanel, "6"); } } ); JButton mesbt=new JButton("留言帮助"); mesbt.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { cl.show(centerPanel, "12"); } } ); JButton jiangchengbt=new JButton("奖惩管理"); jiangchengbt.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { cl.show(centerPanel, "11"); } } ); JButton bt1=new JButton("学生管理"); bt1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { cl.show(centerPanel, "1"); } } ); JButton bt2=new JButton("课程管理"); bt2.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { cl.show(centerPanel, "2"); } } ); JButton bt3=new JButton("教师管理"); bt3.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { cl.show(centerPanel, "3"); } } ); JButton bt4=new JButton("院系管理"); bt4.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { cl.show(centerPanel, "4"); } } ); JButton bt5=new JButton("修改密码"); bt5.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { cl.show(centerPanel, "5"); } } ); JButton btlog=new JButton("系统日志"); btlog.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { cl.show(centerPanel, "9"); } } ); this.addWindowListener(new WindowAdapter() { public void windowClosing(WindowEvent e) { if(oos!=null){ try{ oos.writeUTF("exit"); oos.flush(); oos.close(); ois.close(); ClientSocket.close();}catch(Exception e1){ System.exit(0); } } System.exit(0); } }); JButton exitBt=new JButton("退出系统"); exitBt.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub int i=JOptionPane.showConfirmDialog(null, " 确实要退出吗?","",JOptionPane.OK_OPTION); if(i!=JOptionPane.OK_OPTION){ } else{ Exit(); new SchLoginMain().setVisible(true); } } }); JButton FSSBt=new JButton("传输共享"); FSSBt.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub new ShareSoftware().start(); } }); JButton courseBt=new JButton("选课情况"); courseBt.addActionListener(new ActionListener()//添加事件响应，修改学分 { public void actionPerformed(ActionEvent e) { cl.show(centerPanel, "7"); } } ); JButton cBt=new JButton("课程总揽"); cBt.addActionListener(new ActionListener()//添加事件响应，修改学分 { public void actionPerformed(ActionEvent e) { cl.show(centerPanel, "8"); } } ); JButton classBt=new JButton("班级管理"); classBt.addActionListener(new ActionListener()//添加事件响应，修改学分 { public void actionPerformed(ActionEvent