xuanke.java

这是一个由JAVA语言编写的程序.. 含有论文程序源代码

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.JOptionPane;
public class xuanke extends Frame implements ActionListener
{
	String url="jdbc:odbc:S_C";
	Connection con;
    Statement stmt;
	PreparedStatement ps;
    ResultSet rs;
    Button ad_loading,student_loading;    //a
    Button input_course,input_grade,query_part,query_sc,query_grade,query_all,delete_course,a_back;//b
    Button queryc,backc;  //c
    Button deleted,backd;//d
    Button look_course,sc,quit_sc,QueryGrade,backe;//e
    Button backf;//f
    Button ok2,back2;//2
    Button loading3,regedit,back3;//3
    Button ok4,back4,allquery,myquery;//4
    Button ok5,back5;//5
    Button back6;//6
    Button ok7,back7;//7
    Button back8; //8
    Button back9;//9
    Button ok10,back10;//10
    Button back11;   //11
    Button back12;   //12
    Button ad_studentquery,ad_coursequery,onecourse,onestudent,back13;//13
    Button back14;   //14
    Button ok15,back15;//15
    Button ok16,back16;//16
    Button loading17,T_regedit,back17;//17
    Button ok18,back18;//18
    Button back19;//19
    Button q_a,q_c,q_n,back20;//20
    Button ok21,back21;//21
    Button ok22,back22;//22
    Button back23; //23
    

	TextField addno=new TextField(10); 
	TextField addname=new TextField(10); 
	TextField addcredit=new TextField(10); 
	TextField addaddress=new TextField(8); 
	TextField addbegintime=new TextField(8); 
	TextField query_name=new TextField(8); //c
    TextField userField=new TextField(8); 
    TextField passwordField=new TextField(10);
    TextField T_userField=new TextField(6); 
    TextField T_passwordField=new TextField(10);
    TextField R_userField=new TextField(6); 
    TextField R_passwordField=new TextField(10);
    TextField R_realnameField=new TextField(6);
    TextField R_deptField=new TextField(8); 
    TextField R_TuserField=new TextField(6); 
    TextField R_TpasswordField=new TextField(10);
    TextField R_TrealnameField=new TextField(6);
    TextField R_TdeptField=new TextField(8);
    TextField inputCno_Field=new TextField(8);
    TextField quitCno_Field=new TextField(8);
    TextField L_Sno=new TextField(8);  //10
    TextField L_grade=new TextField(8);
    TextField L_Cno=new TextField(8);  //10
    TextField detele_name=new TextField(8);
    TextField Cname_Field=new TextField(8);
    TextField Sname_Field=new TextField(8);
    TextField Sname_Grade=new TextField(8);
    TextField Cname_Grade=new TextField(8);
    TextArea  displayc,displayd,display8,display9,display5,displayf,display6,display7;
    TextArea  display11,display12,display14,display15,display16,display19,display21,display22,display23;
	public xuanke(){
        setLayout(new CardLayout());//总体采用卡片式布局
        
        Panel carda=new Panel();       //第a张卡片总菜单
        carda.setLayout(new GridLayout(3,1));
        carda.setBackground(Color.pink);
        Panel pa1=new Panel();
        Label Sysname=new Label("全校学生选课系统");
        pa1.add(Sysname);
        Sysname.setFont(new Font("Alias",Font.BOLD,25));
        carda.add(pa1);
        Panel pa2=new Panel();
        ad_loading=new Button("教师登陆");
        ad_loading.setFont(new Font("Alias",Font.BOLD,18));
        pa2.add(ad_loading);
        carda.add(pa2);
        Panel pa3=new Panel();
        student_loading=new Button("学生登陆");
        student_loading.setFont(new Font("Alias",Font.BOLD,18));
        pa3.add(student_loading);
        carda.add(pa3);
        add("ca",carda);
        ad_loading.addActionListener(this);
        student_loading.addActionListener(this);
        
        Panel cardb=new Panel();        //第b张卡片管理员持有功能
        cardb.setLayout(new GridLayout(5,1));
        cardb.setBackground(Color.pink);
        Panel pb1=new Panel();
        input_course=new Button("录入课程");
        input_grade=new Button("录入成绩");
        input_course.setFont(new Font("Alias",Font.BOLD,18));
        input_grade.setFont(new Font("Alias",Font.BOLD,18));
        pb1.add(input_course);
        pb1.add(input_grade);
        cardb.add(pb1);
        Panel pb2=new Panel();
        query_part=new Button("单个课程查询");        
        query_all=new Button("所有课程查询");
        query_part.setFont(new Font("Alias",Font.BOLD,18));      
        query_all.setFont(new Font("Alias",Font.BOLD,18));
        pb2.add(query_part);
        pb2.add(query_all);
        cardb.add(pb2);
        Panel pb3=new Panel();
        query_sc=new Button("选修情况查询");
        query_sc.setFont(new Font("Alias",Font.BOLD,18));
        query_grade=new Button("学生成绩查询");
        query_grade.setFont(new Font("Alias",Font.BOLD,18));
        pb3.add(query_sc);
        pb3.add(query_grade);
        cardb.add(pb3);
        Panel pb4=new Panel();
        delete_course=new Button("删除课程");
        delete_course.setFont(new Font("Alias",Font.BOLD,18));
        pb4.add(delete_course);
        cardb.add(pb4);
        Panel pb5=new Panel();
        a_back=new Button("返回");
        a_back.setFont(new Font("Alias",Font.BOLD,18));
        pb5.add(a_back);
        cardb.add(pb5);
        add("cb",cardb);
        input_course.addActionListener(this);
        input_grade.addActionListener(this);
        query_part.addActionListener(this);
        query_sc.addActionListener(this);
        query_grade.addActionListener(this);
        query_all.addActionListener(this); 
        delete_course.addActionListener(this);
        a_back.addActionListener(this);
        
        Panel cardc=new Panel();  //第c张卡片查询单个课程
        cardc.setLayout(new GridLayout(4,1));
        cardc.setBackground(Color.pink);
        Panel pc1=new Panel();
        displayc=new TextArea(20,45);
        displayc.setEditable(false);
	    pc1.add(displayc);
        cardc.add(pc1);
        Panel pc2=new Panel();
        Label D_query=new Label("请输入要查询的课程的课程名");
        D_query.setFont(new Font("Alias",Font.BOLD,15));
        pc2.add(D_query);
        cardc.add(pc2);
        Panel pc3=new Panel();
        pc3.add(query_name);
        cardc.add(pc3);
        Panel pc4=new Panel();
        queryc=new Button("查询");
        backc=new Button("返回");
        pc4.add(queryc);
        pc4.add(backc);
        cardc.add(pc4);
        add("cc",cardc);
        queryc.addActionListener(this);
        backc.addActionListener(this);
        
        Panel cardd=new Panel();  //第d张卡片删除课程
        cardd.setLayout(new GridLayout(4,1));
        cardd.setBackground(Color.pink);
        Panel pd0=new Panel();
        displayd=new TextArea(20,45);
	    pd0.add(displayd); 
	    cardd.add(pd0);     
        Panel pd1=new Panel();
        Label D_delete=new Label("请输入要删除的课程的课程名");
        D_delete.setFont(new Font("Alias",Font.BOLD,15));
        pd1.add(D_delete);
        cardd.add(pd1);
        Panel pd2=new Panel();
        pd2.add(detele_name);
        cardd.add(pd2);
        Panel pd3=new Panel();
        deleted=new Button("删除");
        backd=new Button("返回");
        pd3.add(deleted);
        pd3.add(backd);
        cardd.add(pd3);
        add("cd",cardd);
        deleted.addActionListener(this);
        backd.addActionListener(this);
                
        Panel carde=new Panel();  //第e张卡片学生登陆后的菜单
        carde.setLayout(new GridLayout(5,1));
        carde.setBackground(Color.pink);
        Panel pe1=new Panel();
        look_course=new Button("课程浏览");
        look_course.setFont(new Font("Alias",Font.BOLD,18));
        pe1.add(look_course);
        carde.add(pe1);
        Panel pe2=new Panel();
        sc=new Button("选课");
        quit_sc=new Button("退选");
        sc.setFont(new Font("Alias",Font.BOLD,18));
        quit_sc.setFont(new Font("Alias",Font.BOLD,18));
        pe2.add(sc);
        pe2.add(quit_sc);
        carde.add(pe2);
        Panel pe3=new Panel();
        allquery=new Button("查看所有选修情况");
        myquery=new Button("查看自己选修课程");
        allquery.setFont(new Font("Alias",Font.BOLD,18));
        myquery.setFont(new Font("Alias",Font.BOLD,18));
        pe3.add(allquery);
        pe3.add(myquery);
        carde.add(pe3);
        Panel pe4=new Panel();
        QueryGrade=new Button("成绩查询");
        QueryGrade.setFont(new Font("Alias",Font.BOLD,18));
        pe4.add(QueryGrade);
        carde.add(pe4);
        Panel pe5=new Panel();
        backe=new Button("返回");
        backe.setFont(new Font("Alias",Font.BOLD,18));
        pe5.add(backe);
        carde.add(pe5);
        add("ce",carde);
        look_course.addActionListener(this);
        sc.addActionListener(this);
        quit_sc.addActionListener(this);     
        allquery.addActionListener(this);     
        myquery.addActionListener(this);  
        QueryGrade.addActionListener(this);      
        backe.addActionListener(this);
        
        Panel cardf=new Panel();    //第f张卡片学生浏览课程
        cardf.setLayout(new GridLayout(3,1));
        cardf.setBackground(Color.pink);
        Panel pf1=new Panel();
        Label D_allcourse=new Label("***所有的选修课程如下***");
        D_allcourse.setFont(new Font("Alias",Font.BOLD,15));
		pf1.add(D_allcourse);
        cardf.add(pf1);   
        Panel pf2=new Panel();
	    displayf=new TextArea(20,45);
	    pf2.add(displayf); 
	    cardf.add(pf2);     
	    Panel pf3=new Panel();
        backf=new Button("返回");
        backf.setFont(new Font("Alias",Font.BOLD,18));
        pf3.add(backf);
        cardf.add(pf3);    
	    add("cf",cardf); 
	    backf.addActionListener(this);  
       
        Panel card2=new Panel();               //第2张卡片录入课程
        card2.setLayout(new GridLayout(7,1));
        card2.setBackground(Color.pink);
        Panel p21=new Panel();
        p21.add(new Label(" 课程号"));
	    p21.add(addno);
	    card2.add(p21);
	    Panel p22=new Panel();
	    p22.add(new Label(" 课程名"));
	    p22.add(addname);
	    card2.add(p22);
	    Panel p23=new Panel();
	    p23.add(new Label(" 学分 "));
	    p23.add(addcredit);
	    card2.add(p23);
	    Panel p24=new Panel();
	    p24.add(new Label("上课地点"));
	    p24.add(addaddress);
	    card2.add(p24);
	    Panel p25=new Panel();
	    p25.add(new Label("开课时间"));
	    p25.add(addbegintime);
	    card2.add(p25);
	    Panel p27=new Panel();
	    ok2=new Button("确定");
	    back2=new Button("返回");
	    p27.add(ok2);
	    p27.add(back2);
	    card2.add(p27);
	    add("c2",card2);
	    ok2.addActionListener(this);
	    back2.addActionListener(this);
	    
        Panel card3=new Panel();                //第3张卡片学生登陆界面
        card3.setLayout(new GridLayout(4,1));
        card3.setBackground(Color.pink);
        Panel p31=new Panel();        
        Label welcome=new Label("选课管理系统");	
        welcome.setFont(new Font("Alias",Font.BOLD,15));
        p31.add(welcome);
		card3.add(p31);		
		Panel p32=new Panel();
		p32.add(new Label("用户名"));
        p32.add(userField);
        card3.add(p32);       
        Panel p33=new Panel();
        p33.add(new Label("密码"));
        p33.add(passwordField);
        passwordField.setEchoChar('*');
        card3.add(p33);
        Panel p34=new Panel();
        loading3=new Button("登录");
        loading3.setFont(new Font("黑体",Font.BOLD,15));
        regedit=new Button("注册");
        regedit.setFont(new Font("黑体",Font.BOLD,15));
        back3=new Button("返回");
        back3.setFont(new Font("黑体",Font.BOLD,15));
        p34.add(loading3);
        p34.add(regedit);
        p34.add(back3);
        card3.add(p34);
        add("c3",card3); 
        loading3.addActionListener(this);
        regedit.addActionListener(this); 
        back3.addActionListener(this); 
        
        Panel card4=new Panel();              //第4张卡片学生注册
        card4.setLayout(new GridLayout(5,1));
        card4.setBackground(Color.pink);
        Panel p41=new Panel();
		p41.add(new Label("用户名(学号)"));
        p41.add(R_userField);
        card4.add(p41); 
        Panel p42=new Panel();
		p42.add(new Label("真实姓名"));
        p42.add(R_realnameField);
        card4.add(p42);       
        Panel p43=new Panel();
        p43.add(new Label("密码"));
        p43.add(R_passwordField);
        R_passwordField.setEchoChar('*');
        card4.add(p43);
        Panel p44=new Panel();
        p44.add(new Label("所属系别"));
        p44.add(R_deptField);
        card4.add(p44);
        Panel p45=new Panel();
        ok4=new Button("提交");
        back4=new Button("返回");
        p45.add(ok4);
        p45.add(back4);
        card4.add(p45);
        add("c4",card4); 
        ok4.addActionListener(this);  
        back4.addActionListener(this);  
        
        Panel card5=new Panel();           //第5张卡片学生选课
        card5.setLayout(new GridLayout(4,1));
        card5.setBackground(Color.pink);
        Panel p51=new Panel();
        Label D_SC=new Label("***选修课程如下,输入号课程进行选课***");
        D_SC.setFont(new Font("Alias",Font.BOLD,15));
        p51.add(D_SC);
        card5.add(p51);   
        Panel p52=new Panel();
	    display5=new TextArea(20,45);
	    p52.add(display5); 
	    card5.add(p52);     
        Panel p53=new Panel();
        p53.add(new Label("输入要选课程的课程号"));
        p53.add(inputCno_Field);
        card5.add(p53);     
        Panel p54=new Panel();
        ok5=new Button("确定");
        back5=new Button("返回");
        p54.add(ok5); 
        p54.add(back5); 
        card5.add(p54);    
        add("c5",card5); 
        ok5.addActionListener(this);  
        back5.addActionListener(this);  
             
        Panel card6=new Panel();           //第6张卡片管理员查看所有课程
        card6.setLayout(new GridLayout(3,1));
        card6.setBackground(Color.pink);
        Panel p61=new Panel();
        Label D_course=new Label("***所有的选修课程如下***");
		D_course.setFont(new Font("Alias",Font.BOLD,15));
		p61.add(D_course);
        card6.add(p61);   
        Panel p62=new Panel();
	    display6=new TextArea(20,45);
	    p62.add(display6);