xuesheng.java

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

package test;



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

import javax.swing.*;
public class Xuesheng  extends JFrame implements ActionListener{
	int n;
	sql sqll;ResultSet rs;String xuehao="98001";sql sqll2;ResultSet rs2;sql sqll3;ResultSet rs3;sql2 sql21,sql22;
	JButton b1=new JButton("本人信息");
	JButton b3=new JButton("所有课程");
	JButton b4=new JButton("已选课程");
	JButton b5=new JButton("选课");
	JButton b6=new JButton("注销选课");
	JButton b7=new JButton("查询");
	JButton b8=new JButton("成绩查询");
	JLabel  j1=new  JLabel("输入课程号");
	JTextField field1,field2,field3;
	JScrollPane js1;
	JComboBox jcb1,jcb2;
	

	JTabbedPane jtp; JTextArea ja,ja2,ja3,ja4;
	public Xuesheng(){
	
	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();
     ja=new JTextArea(15,30);ja2=new JTextArea(10,15);ja3=new JTextArea(10,15);ja4=new JTextArea(10,15);
    
	//................................................
	jtp=new JTabbedPane();
	  JPanel jp1=new JPanel();
	  JPanel jp2=new JPanel();
	  JPanel jp3=new JPanel();
	  JPanel jp4=new JPanel();
	  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);
	  jp1.setLayout(new BorderLayout());
	  jp1.add(p1,BorderLayout.NORTH);
	  //p1.setLayout(new GridLayout(1,1));
	  p1.add(b1);b1.addActionListener(this);
	  jp1.add(p2,BorderLayout.CENTER);
	  p2.add(ja);p2.setBackground(Color.BLUE);
	  //***************************************************
	 
	  b3.addActionListener(this); b4.addActionListener(this); b7.addActionListener(this);
	  b5.addActionListener(this); b6.addActionListener(this);b8.addActionListener(this);
		//JButton b5=new JButton("查询成绩");
	  jp2.setLayout(new BorderLayout());
	  js1=new JScrollPane(ja2);
		jp2.add(p3,BorderLayout.NORTH);
		p3.setLayout(new FlowLayout());
		p3.add(b3);p3.add(b4);;p3.add(b5);;p3.add(b6);
		jp2.add(p4,BorderLayout.CENTER);
		p4.setBackground(Color.green);
		p4.add(js1);
		jp2.add(p5,BorderLayout.SOUTH);
		field1=new JTextField(10);
		p5.add(j1);p5.add(field1);
		//ja2.isDisplayable();
		/*jp2.setLayout(new GridLayout(2,1));
		jp2.add(p3);
		p3.setLayout(new FlowLayout());
		p3.add(b3);p3.add(b4);
		jp2.add(p4);
		p4.add(ja2);*/
		 //******************************************
		 jp3.setLayout(new BorderLayout());
		jp3.add(p6,BorderLayout.NORTH);
		jp3.add(p7,BorderLayout.CENTER);
		jcb1=new 	JComboBox();
		jcb1.addItem("按课程号查询"); jcb1.addItem("按课程名查询");
		field2=new JTextField(10);
		  p6.add(jcb1);  p6.add(field2); p6.add(b7);
		  p7.add(ja3);
			//**********************************************
		  jp4.setLayout(new BorderLayout());
			jp4.add(p8,BorderLayout.NORTH);
			jp4.add(p9,BorderLayout.CENTER);
			jcb2=new 	JComboBox();
			jcb2.addItem("按课程号查询"); jcb2.addItem("按课程名查询");
			field3=new JTextField(10);
			  p8.add(jcb2);  p8.add(field3); p8.add(b8);
			  p9.add(ja4);
		
		
	}
	public static void main(String[] args){		 
		Xuesheng good=new Xuesheng();
		good.setVisible(true);
	}
	public void actionPerformed(ActionEvent e) {
		
		if(e.getSource()==b1){System.out.println(this.xuehao);
		 ja.append(this.xuehao);
		 String s="select *from student where 学号="+this.xuehao;
			sqll=new sql();
			try{rs=sqll.execsql(s); ja.append("\n"+"学号"+" "+"姓名"+" "+"性别"+" "+"年龄"+" "+"院系号");
			  while(rs.next()){ 
				  ja.append("\n"+rs.getString(1)+rs.getString(2)+rs.getString(3)+rs.getString(4)+" "+rs.getString(5));
				  //ja.append("\n");
				
			              }
			}catch(Exception f){f.printStackTrace(); }
			}
		// TODO Auto-generated method stub
		if(e.getSource()==b3){
			String s="select *from course";
			sqll=new sql();
			try{rs=sqll.execsql(s); ja2.append("\n"+"课程号"+" "+"课程名"+" "+"先行课"+" "+"学分");
			  while(rs.next()){ 
				  ja2.append("\n"+rs.getString(1)+rs.getString(2)+rs.getString(3)+rs.getString(4));
				  //ja.append("\n");
				
			              }
			}catch(Exception f){f.printStackTrace(); }
		}
		if(e.getSource()==b4){
			String s="select course.课程号,course.课程名 from xuanke,course where xuanke.课程号=course.课程号 and xuanke.学号="+this.xuehao;
			sqll3=new sql();
			try{rs3=sqll3.execsql(s); ja2.append("\n"+"课程号"+" "+"课程名"+" "+"先行课"+" "+"学分");
			  while(rs3.next()){ 
				  ja2.append("\n"+rs3.getString(1)+rs3.getString(2));
				  //ja.append("\n");
			
			              }	rs3.close();
			}catch(Exception f){f.printStackTrace(); }
		}
		//****************************************************************************************
		if(e.getSource()==b5){
			if(field1.getText().trim().isEmpty()){JOptionPane.showMessageDialog(this,"课号不得为空！"+JOptionPane.WARNING_MESSAGE);}
			else {
			String s="insert into xuanke(学号,课程号) values"+"("+this.xuehao+","+field1.getText().trim()+")";
			sql21=new sql2();
			try{n=sql21.execsql(s); 
				if(n>0){JOptionPane.showMessageDialog(this,"选课成功！"+JOptionPane.WARNING_MESSAGE);}
			            
			}catch(Exception f){f.printStackTrace();}
		}}
		//*************************************************************************************************************8888
		if(e.getSource()==b6){
			if(field1.getText().trim().isEmpty()){JOptionPane.showMessageDialog(this,"课号不得为空！"+JOptionPane.WARNING_MESSAGE);}
			else {
			String s="delete from xuanke where 学号="+this.xuehao+"and 课程号="+field1.getText().trim();
			sql21=new sql2();
			try{n=sql21.execsql(s); 
				if(n>0){JOptionPane.showMessageDialog(this,"注销成功！"+JOptionPane.WARNING_MESSAGE);}
			            
			}catch(Exception f){f.printStackTrace();}
		}}
		//*************************************************************************************************************8888
		if(e.getSource()==b7&&jcb1.getSelectedItem().equals("按课程号查询") ){
			String s="select * from course where 课程号="+field2.getText();
			sqll=new sql();
			try{rs=sqll.execsql(s); ja3.append("\n"+"课程号"+" "+"课程名"+" "+"先行课"+" "+"学分");
			  while(rs.next()){ 
				  ja3.append("\n"+rs.getString(1)+rs.getString(2)+rs.getString(3)+rs.getString(4));
				  //ja.append("\n");
				
			              }
			}catch(Exception f){f.printStackTrace(); }
		}
		if(e.getSource()==b7&&jcb1.getSelectedItem().equals("按课程名查询") ){
			String s="select * from course where 课程名='"+field2.getText()+"'";
			sqll2=new sql();
			try{rs2=sqll2.execsql(s); ja3.append("\n"+"课程号"+" "+"课程名"+" "+"先行课"+" "+"学分");
			  while(rs2.next()){ 
				  ja3.append("\n"+rs2.getString(1)+rs2.getString(2)+rs2.getString(3)+rs2.getString(4));
				  //ja.append("\n");
				
			              }
			}catch(Exception f){f.printStackTrace(); }
		}
//			*************************************************************************************************************8888
			if(e.getSource()==b8&&jcb2.getSelectedItem().equals("按课程号查询") ){
				String s="select * from xuanke where 课程号="+field3.getText()+"and 学号="+this.xuehao;
				sqll=new sql();
				try{rs=sqll.execsql(s); ja4.append("\n"+"学号"+" "+"课程号"+" "+"成绩");
				  while(rs.next()){ 
					  ja4.append("\n"+rs.getString(1)+rs.getString(2)+rs.getString(3));
					  //ja.append("\n");
					
				              }
				}catch(Exception f){f.printStackTrace(); }
			}
			//*************************************************************************************************************8888
			if(e.getSource()==b8&&jcb2.getSelectedItem().equals("按课程名查询") ){
				String s="select 学号,xueke.课程号 course.课程名 xuanke.成绩 from xuanke,couese where xueke.课程号=course.课程号 and course.课程名="+field3.getText().trim()+"and 学号="+this.xuehao;
				sqll=new sql();
				try{rs=sqll.execsql(s); ja4.append("\n"+"学号"+" "+"课程号"+" "+"课程名"+" "+"成绩");
				  while(rs.next()){ 
					  ja4.append("\n"+rs.getString(1)+rs.getString(2)+rs.getString(3)+rs.getString(4));
					  //ja.append("\n");
					
				              }
				}catch(Exception f){f.printStackTrace(); }
			}
	
		
	}

}