guanliyuan.java

数据库 学生综合管理系统 实现了学生课程教师管理 及学生选课

package test;


import java.awt.*;
import java.io.*;//输入输出
import java.awt.event.*;
import java.sql.*;

import javax.swing.*;
public class Guanliyuan  extends JFrame implements ActionListener{
	sql sqll;ResultSet rs;String xuehao="adfgagag";sql sqll2;ResultSet rs2;sql sqll3;ResultSet rs3;
	sql2 sql21,sql22; int aa,bb;
	JButton b1=new JButton("查询");JButton b2=new JButton("查询");
	JButton b3=new JButton("添加");
	JButton b4=new JButton("删除");
	JButton b5=new JButton("修改");
	JButton bb3=new JButton("添加");
    JButton bb4=new JButton("删除");
    JButton bb5=new JButton("修改");
    JButton bbb3=new JButton("添加");
    JButton bbb4=new JButton("删除");
    JButton bbb5=new JButton("修改");
	
	
	JButton b7=new JButton("查询");
	JButton b8=new JButton("成绩查询");
	JLabel  j1=new  JLabel("学号");JLabel  j2=new  JLabel("姓名");JLabel  j3=new  JLabel("性别");
	JLabel  j4=new  JLabel("年龄");JLabel  j5=new  JLabel("院系号");
	JLabel  jj1=new  JLabel("教师号");JLabel  jj2=new  JLabel("教师名");JLabel  jj3=new  JLabel("院系号");
	JLabel  jj4=new  JLabel("课程名");JLabel  jj5=new  JLabel("课程号");
	JLabel  jj6=new  JLabel("先行课");JLabel  jj7=new  JLabel("学分");
	JTextField field1,field2,field3;
	JTextField ff1,ff2,ff3,ff4,ff5,ff6,ff7,ff8,ff9;
	JTextField fff1,fff2,fff3,fff4;
	JScrollPane js1;
	JComboBox jcb1,jcb2,jcb3;
	

	JTabbedPane jtp; JTextArea ja,ja2,ja3,ja4;
	public Guanliyuan (){
	
	Container contentpane=getContentPane(); 
    setBounds(500,400,500,400);
   setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);	
   setTitle("管理员界面");
   JPanel p1=new JPanel(),p2=new JPanel(),p3 =new JPanel(),p4 =new JPanel(),p5 =new JPanel();
   JPanel p6=new JPanel(),p7=new JPanel(),p8 =new JPanel(),p9 =new JPanel(),p10 =new JPanel();
   JPanel p11=new JPanel(),p12=new JPanel(),p13 =new JPanel(),p14 =new JPanel(),p15 =new JPanel();
   JPanel p16=new JPanel(),p17=new JPanel(),p18 =new JPanel(),p19 =new JPanel(),p20 =new JPanel(),p21 =new JPanel();
     ja=new JTextArea(15,30);ja2=new JTextArea(10,15);ja3=new JTextArea(10,15);ja4=new JTextArea(10,15);
    //contentpane.add(p1,BorderLayout.NORTH);	
	//contentpane.add(p2,BorderLayout.CENTER);	
	//contentpane.add(p3,BorderLayout.SOUTH);	
	//................................................
	jtp=new JTabbedPane();
	  JPanel jp1=new JPanel();
	  JPanel jp2=new JPanel();
	  JPanel jp3=new JPanel();
	  JPanel jp4=new JPanel();
	  ff1=new JTextField(10); ff2=new JTextField(10); ff3=new JTextField(10); ff4=new JTextField(10);
	  ff5=new JTextField(10); ff6=new JTextField(10); ff7=new JTextField(10);ff8=new JTextField(10);
	  fff1=new JTextField(10); fff2=new JTextField(10); fff3=new JTextField(10); fff4=new JTextField(10);
	  jtp=new JTabbedPane();
	  //jp1.setBackground(Color.yellow);
	  jp2.setBackground(Color.black);
	  jp3.setBackground(Color.green);
	  jp4.setBackground(Color.blue);
	  
	 
	  
	  
	  
	  jtp.add(jp1,"学生管理");
	  jtp.add(jp2,"教师管理");
	  jtp.add(jp3,"课程管理");
	  jtp.add(jp4,"退出系统");
	  contentpane.add(jtp);
	  //**********************************************************************
	  b1.addActionListener(this);b2.addActionListener(this);b3.addActionListener(this);b4.addActionListener(this);
	  b5.addActionListener(this);
	  
	  
	  //*********************************************************************
	  jp1.setLayout(new BorderLayout());
	  jp1.add(p1,BorderLayout.NORTH);
	  jcb1=new 	JComboBox();
		jcb1.addItem("按学号查询"); jcb1.addItem("按姓名查询");jcb1.addItem("按院系查询");
		field1=new JTextField(10);
		p1.add(jcb1);p1.add(field1);p1.add(b1);
		 b1.addActionListener(this);
		jp1.add(p2,BorderLayout.CENTER);
	  p2.setLayout(new GridLayout(5,1));
	  p2.add(p3);  p2.add(p4);  p2.add(p5);  p2.add(p6);  p2.add(p7);
	  p3.setLayout(new FlowLayout());  p4.setLayout(new FlowLayout());
	  p5.setLayout(new FlowLayout());  p6.setLayout(new FlowLayout());  p7.setLayout(new FlowLayout());
	  p3.add(j1); p3.add(ff1);
	  p4.add(j2); p4.add(ff2);
	  p5.add(j3); p5.add(ff3);
	  p6.add(j4); p6.add(ff4);
	  p7.add(j5); p7.add(ff5);
	  
	  jp1.add(p8,BorderLayout.SOUTH);
	  p8.add(b3);	  p8.add(b4);	  p8.add(b5);
	  //******************************************************************************
	  
	  jp2.setLayout(new BorderLayout());
	  jp2.add(p14,BorderLayout.NORTH);
	  jcb2=new 	JComboBox();
		jcb2.addItem("按教师号查询"); jcb2.addItem("按教师名查询");jcb2.addItem("按院系查询");
		field2=new JTextField(10);
		p14.add(jcb2);p14.add(field2);p14.add(b2);
		 b2.addActionListener(this);
		jp2.add(p9,BorderLayout.CENTER);
	  p9.setLayout(new GridLayout(5,1));
	  p9.add(p10);  p9.add(p11);  p9.add(p12);  
	  p10.setLayout(new FlowLayout());  p11.setLayout(new FlowLayout());
	  p12.setLayout(new FlowLayout());  
	  p10.add(jj1); p10.add(ff6);
	  p11.add(jj2); p11.add(ff7);
	  p12.add(jj3); p12.add(ff8);
	  
	  //************************************************************
	  jp2.add(p13,BorderLayout.SOUTH);
	  p13.add(bb3);	  p13.add(bb4);	  p13.add(bb5);
	  //******************************************************
	  jp3.setLayout(new BorderLayout());
	  jp3.add(p15,BorderLayout.NORTH);
	  jcb3=new 	JComboBox();
		jcb3.addItem("按课程号查询"); jcb3.addItem("按课程名查询");jcb3.addItem("按学分查询");
		field3=new JTextField(10);
		p15.add(jcb3);p15.add(field3);p15.add(b7);
		jp3.add(p16,BorderLayout.CENTER);
		  p16.setLayout(new GridLayout(5,1));
		  p16.add(p17);  p16.add(p18);  p16.add(p19); p16.add(p20); 
		  p17.setLayout(new FlowLayout());  p18.setLayout(new FlowLayout());
		  p19.setLayout(new FlowLayout());  p20.setLayout(new FlowLayout());  
		  p17.add(jj4); p17.add(fff1);
		  p18.add(jj5); p18.add(fff2);
		  p19.add(jj6); p19.add(fff3);
		  p20.add(jj7); p20.add(fff4);
		  jp3.add(p21,BorderLayout.SOUTH);
		  p21.add(bbb3);	  p21.add(bbb4);	  p21.add(bbb5);
	}
	public static void main(String[] args){		 
		Guanliyuan  good=new Guanliyuan ();
		good.setVisible(true);
	}
	public void actionPerformed(ActionEvent e) {
		// TODO 自动生成方法存根
		if(e.getSource()==b1&&jcb1.getSelectedItem().equals("按学号查询") ){
		 String s="select *from student where 学号="+field1.getText().trim();
			sqll=new sql();
			try{rs=sqll.execsql(s); 
			  while(rs.next()){ 
				  //ja.append("\n"+rs.getString(1)+rs.getString(2)+rs.getString(3)+rs.getString(4)+" "+rs.getString(5));
				 ff1.setText(rs.getString(1).trim()); ff2.setText(rs.getString(2).trim());
				 ff3.setText(rs.getString(3).trim()); ff4.setText(rs.getString(4).trim());
				 ff5.setText(rs.getString(5).trim());
			              }
			}catch(Exception f){f.printStackTrace(); }
			}
		//********************************************************************************************************************
		if(e.getSource()==b4 ){
			if(ff1.getText().trim().isEmpty()){JOptionPane.showMessageDialog(this,"学号不得为空！"+JOptionPane.WARNING_MESSAGE);}
			else {
			 String s="delete from student where 学号="+ff1.getText().trim();
			 String s2="delete from xuanke where 学号="+ff1.getText().trim();
				sql21=new sql2();sql22=new sql2();
				try{aa=sql21.execsql(s); bb=sql22.execsql(s2); 
				 if(aa>0){ JOptionPane.showMessageDialog(this,"删除成功！"+JOptionPane.WARNING_MESSAGE);
					 
				              }
				}catch(Exception f){f.printStackTrace(); }
			}
				}
		//************************************************************************************************************************
		if(e.getSource()==b3 ){
			if(ff1.getText().trim().isEmpty()){JOptionPane.showMessageDialog(this,"学号不得为空！"+JOptionPane.WARNING_MESSAGE);}
			else {
			 String s="select *from student where 学号="+ff1.getText().trim();
			 String s2="insert into student(学号,姓名,性别,年龄,院系号) values('"+ff1.getText().trim()+"','"+ff2.getText().trim()+"','"+ff3.getText().trim()+"','"+ff4.getText().trim()+"','"+ff5.getText().trim()+"')";
			// String s3="insert into student(ff1.getText().trim(),ff2.getText().trim(),ff3.getText().trim(),ff4.getText().trim(),ff5.getText().trim())";
			 sqll=new sql();sql21=new sql2();
				try{rs=sqll.execsql(s); 
				if(rs.next()){ 
					JOptionPane.showMessageDialog(this,"已存在学号为"+ff1.getText().trim()+"的学生 添加操作被禁止！"+JOptionPane.WARNING_MESSAGE);
				              }
				else{aa=sql21.execsql(s2); 
				if(aa>0)
				JOptionPane.showMessageDialog(this,"添加成功！"+JOptionPane.WARNING_MESSAGE);
					
				}
				}catch(Exception f){f.printStackTrace(); }
			}
				}
			
//		************************************************************************************************************************
		if(e.getSource()==b5 ){
			if(ff1.getText().trim().isEmpty()){JOptionPane.showMessageDialog(this,"学号不得为空！"+JOptionPane.WARNING_MESSAGE);}
			else {
			// String s="update student set 姓名＝"+ff2.getText().trim()+","+"性别＝"+ff3.getText().trim()+","+"年龄＝"+ff4.getText().trim()+",院系号＝"+ff3.getText().trim()+"where 学号="+ff1.getText().trim();
				 String s="update student set 性别='"+ff3.getText().trim()+"',姓名='"+ff2.getText().trim()+"',年龄='"+ff4.getText().trim()+"',院系号='"+ff5.getText().trim()+"' where 学号='"+ff1.getText().trim()+"'";
				 
				 
				sql21=new sql2();
				try{aa=sql21.execsql(s);
				 if(aa>0){ JOptionPane.showMessageDialog(this,"成功！"+JOptionPane.WARNING_MESSAGE);
					 
				              }
				}catch(Exception f){f.printStackTrace(); }
			}
				}
		//************************************************************************************************************************
	}
	
	}