cmenu.java

用JAVA+SQL编写的一个教学管理软件

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.io.*;

public class Cmenu extends JFrame{
	
	private JComboBox cmb_select;
	private JButton btn_ok,btn_exit;
	private JPanel panel,panel1,panel2;
	private int tempId;
	private String tempStatus,tempName;
	private String[] stu={"查询个人信息","查询成绩","修改密码"};
	private String[] tech={"学生信息管理","学生成绩管理","成绩查询统计","导出学生信息","修改密码"};
	private String[] admi={"教师信息管理","学生信息管理","导出学生信息","导出教师信息","修改密码"};
	private	File file=new File("Backup.xls");
	private String path=file.getAbsolutePath();
	public Cmenu(String status,String name,int id){
		super(name+status+"，你好！");
		tempId=id;
		tempStatus=status;
		tempName=name;
		if(status.equals("同学")){
			cmb_select=new JComboBox(stu);
			cmb_select.setMaximumRowCount(3);
		}
		else if(status.equals("老师")){
			cmb_select=new JComboBox(tech);
			cmb_select.setMaximumRowCount(3);
		}
		else if(status.equals("管理员")){
			cmb_select=new JComboBox(admi);
			cmb_select.setMaximumRowCount(3);
		}
		
		btn_ok=new JButton("确认");
		btn_exit=new JButton("返回");
		panel=new JPanel();
		
		panel1=new JPanel();
		panel1.setLayout(new GridLayout(1,1));
		panel1.add(cmb_select);
		panel1.setBorder(BorderFactory.createEmptyBorder(40,50,10,50));
		panel2=new JPanel();
		panel2.setLayout(new GridLayout(1,2,10,0));
		panel2.add(btn_ok);
		panel2.add(btn_exit);
		panel2.setBorder(BorderFactory.createEmptyBorder(30,30,20,30));
		panel.setLayout(new GridLayout(2,1));
		panel.add(panel1);
		panel.add(panel2);
		getContentPane().add(panel);
		//窗口监听
		addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e)
			{
				dispose();
				System.exit(0);
			}
		});	
		setLocation(400,250);
		setResizable(false);
		pack();
		setVisible(true);
		
		btn_exit.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				dispose();
				School demo=new School();
			}	
		});
		
		btn_ok.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				try{
				int index=cmb_select.getSelectedIndex();
				if(cmb_select.getItemAt(index).equals("查询个人信息")){
					Connection conn=null;
					DateSource date=new DateSource();
					conn=date.getconnection();
					String sql="SELECT * FROM students WHERE id=?";
					PreparedStatement stmt=conn.prepareStatement(sql);
					stmt.setInt(1,tempId);
					ResultSet rs=stmt.executeQuery();
					if(rs.next())
					JOptionPane.showMessageDialog(cmb_select,
					 "姓名:"+rs.getString(3)+"\n"
					+"性别:"+rs.getString(4)+"\n"
					+"年龄:"+rs.getInt(5)+"\n"
					+"班级:"+rs.getInt(6)+"\n"
					+"籍贯:"+rs.getString(7)+"\n"
					+"学院:"+rs.getString(8)
					,"学生信息",1);
					rs.close();
					conn.close();
				}
				else if(cmb_select.getItemAt(index).equals("查询成绩")){
					String stu_score="";
					Connection conn=null;
					DateSource date=new DateSource();
					conn=date.getconnection();
					String sql="SELECT name,score FROM course JOIN score ON course.id=score.Cou_id WHERE Stu_id=? and score is NOT NULL";
					PreparedStatement stmt=conn.prepareStatement(sql);
					stmt.setInt(1,tempId);
					ResultSet rs=stmt.executeQuery();
					while(rs.next())stu_score=stu_score+rs.getString(1)+":"+rs.getDouble(2)+"\n";
					if(stu_score.equals(""))stu_score="无记录";
					JOptionPane.showMessageDialog(cmb_select,stu_score,"学生成绩",1);
				}
				else if(cmb_select.getItemAt(index).equals("修改密码")){
					dispose();
					Editpassword edp=new Editpassword(tempStatus,tempName,tempId);
				}
				else if(cmb_select.getItemAt(index).equals("学生信息管理")){
					dispose();
					Stuinfo sti=new Stuinfo(tempStatus,tempName,tempId);
				}
				else if(cmb_select.getItemAt(index).equals("教师信息管理")){
					dispose();
					Techinfo tei=new Techinfo(tempName,tempId);
				}
				else if(cmb_select.getItemAt(index).equals("学生成绩管理")){
					dispose();
					Stuscore stsc=new Stuscore(tempName,tempId);
				}
				else if(cmb_select.getItemAt(index).equals("成绩查询统计")){
					dispose();
					Queryscore ques=new Queryscore(tempName,tempId);
				}
				else if(cmb_select.getItemAt(index).equals("导出学生信息")){
					
						Connection conn1=null;
        				DateSource date1=new DateSource();
		        		conn1=date1.getconnection();
        				String sql1="insert into OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE="+path+"',sheet1$)select id,name,sex,age,class,state,dep from students";
        				Statement stmt1=conn1.createStatement();
        				stmt1.execute(sql1);
        				stmt1.close();
        				conn1.close();
						JOptionPane.showMessageDialog(cmb_select,"导出成功","提示",1);
				}
				else if(cmb_select.getItemAt(index).equals("导出教师信息")){
						Connection conn2=null;
        				DateSource date2=new DateSource();
		        		conn2=date2.getconnection();
        				String sql2="insert into OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE="+path+"',sheet2$)select id,name,sex,age,dep,Tlevel,sal from teacher";
        				Statement stmt2=conn2.createStatement();
        				stmt2.execute(sql2);
        				stmt2.close();
        				conn2.close();
						JOptionPane.showMessageDialog(cmb_select,"导出成功","提示",1);
				}
				
				}catch(Exception ex){
					JOptionPane.showMessageDialog(cmb_select,ex.getMessage(),"错误",1);
				}
			
			}
		});
				
	}
	
	
	
	
}