📄 teacher_user.java
字号:
package classfile;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import java.io.*;
public class Teacher_user extends JFrame
{
JMenuBar mb=new JMenuBar();
JMenu m1=new JMenu("查询");
JMenu m2=new JMenu("录入");
JMenu m3=new JMenu("统计");
JMenu m4=new JMenu("退出");
JMenuItem mbb=new JMenuItem("退出");
JMenuItem mb1=new JMenuItem("按课程查询");
JMenuItem mb2=new JMenuItem("按班级查询");
JMenuItem mb3=new JMenuItem("按课程录入");
JMenuItem mb4=new JMenuItem("按班级录入");
JMenuItem mb8=new JMenuItem("单个录入");
JMenu mb5=new JMenu("及格率");
JMenuItem mb9=new JMenuItem("某课程及格率");
JMenuItem mb10=new JMenuItem("某班某课程及格率");
JMenu mb6=new JMenu("优秀率");
JMenuItem mb11=new JMenuItem("某课程优秀率");
JMenuItem mb12=new JMenuItem("某班某课程优秀率");
JMenu mb7=new JMenu("良好率");
JMenuItem mb13=new JMenuItem("某课程良好率");
JMenuItem mb14=new JMenuItem("某班某课程良好率");
JTextArea txt=new JTextArea();
JDialog g1=new JDialog(this,"按课程查询成绩");
JDialog g2=new JDialog(this,"按班级查询成绩");
JDialog g3=new JDialog(this,"按课程录入");
JDialog g4=new JDialog(this,"单个录入");
JDialog g5=new JDialog(this,"班级选择");
JDialog g6=new JDialog(this,"班级成绩录入");
JDialog g7=new JDialog(this,"统计");
JDialog g8=new JDialog(this,"统计");
JLabel lab1=new JLabel("课程名");
JLabel lab2=new JLabel("操作符");
JLabel lab3=new JLabel("待查询值");
JLabel lab4=new JLabel("课程名");
JLabel lab5=new JLabel("班级");
JLabel lab6=new JLabel("操作符");
JLabel lab7=new JLabel("待查询值");
JLabel lab8=new JLabel("请输入课程名");
JLabel lab9=new JLabel("学号");
JLabel lab10=new JLabel("成绩");
JLabel lab11=new JLabel("课程名");
JLabel lab12=new JLabel("学号");
JLabel lab13=new JLabel("成绩");
JLabel lab14=new JLabel("班级");
JLabel lab15=new JLabel("学号");
JLabel lab16=new JLabel("姓名");
JLabel lab17=new JLabel("成绩");
JLabel lab18=new JLabel("课程");
JLabel lab19=new JLabel("课程名");
JLabel lab20=new JLabel("课程");
JLabel lab21=new JLabel("班级");
JComboBox com=new JComboBox();
JComboBox oper=new JComboBox();
JComboBox com1=new JComboBox();
JComboBox com2=new JComboBox();
JComboBox com3=new JComboBox();
JComboBox com4=new JComboBox();
JComboBox com5=new JComboBox();
JComboBox com6=new JComboBox();
JComboBox com7=new JComboBox();
JComboBox com8=new JComboBox();
JComboBox com9=new JComboBox();
JComboBox oper1=new JComboBox();
JPanel p=new JPanel();
JPanel p1=new JPanel();
JPanel p2=new JPanel();
JPanel p3=new JPanel();
JPanel p4=new JPanel();
JPanel p5=new JPanel();
JTextField txt1=new JTextField(" ");
JTextField txt2=new JTextField(" ");
JTextField txt3=new JTextField(" ");
JTextField txte1=new JTextField(" ");
JTextField txte2=new JTextField(" ");
JTextField txte3=new JTextField(" ");
JTextField txte4=new JTextField(" ");
JTextField txte5=new JTextField(" ");
JTextField txte6=new JTextField(" ");
JTextField txte7=new JTextField(" ");
JTextField txte8=new JTextField(" ");
JTextField txte9=new JTextField(" ");
JTextField txte10=new JTextField(" ");
JTextField text1=new JTextField(" ");
JTextField text2=new JTextField(" ");
JTextField text3=new JTextField(" ");
JTextField text4=new JTextField(" ");
JTextField text5=new JTextField(" ");
JTextField text6=new JTextField(" ");
JTextField text7=new JTextField(" ");
JTextField text8=new JTextField(" ");
JTextField text9=new JTextField(" ");
JTextField text10=new JTextField(" ");
JTextField text11=new JTextField(" ");
JTextField text12=new JTextField(" ");
JTextField text13=new JTextField(" ");
JTextField text14=new JTextField(" ");
JTextField text15=new JTextField(" ");
JTextField text16=new JTextField(" ");
JButton b1=new JButton("查询");
JButton b2=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("取消");
JButton b9=new JButton("确定");
JButton b10=new JButton("取消");
JButton b11=new JButton("确定");
JButton b12=new JButton("取消");
JButton b13=new JButton("确定");
JButton b14=new JButton("取消");
JButton b15=new JButton("确定");
JButton b16=new JButton("取消");
public Teacher_user()
{
m1.add(mb1);
m1.add(mb2);
m2.add(mb3);
m2.add(mb4);
m2.add(mb8);
m3.add(mb5);
m3.add(mb6);
m3.add(mb7);
m4.add(mbb);
mb.add(m1);
mb.add(m2);
mb.add(m3);
mb.add(m4);
mb5.add(mb9);
mb5.add(mb10);
mb6.add(mb11);
mb6.add(mb12);
mb7.add(mb13);
mb7.add(mb14);
mb.setBackground(Color.red);
txt.setBackground(Color.yellow);
txt.setFont(new Font("Dialog",Font.BOLD,24));
txt.setEditable(false);
this.setJMenuBar(mb);
this.add(txt);
oper.addItem("=");
oper.addItem(">");
oper.addItem("<");
oper1.addItem("=");
oper1.addItem(">");
oper1.addItem("<");
combo1_actionPerformed();
combo2_actionPerformed();
combo3();
p.setLayout(new GridLayout(2,3));
p.add(lab1);
p.add(lab2);
p.add(lab3);
p.add(com);
p.add(oper);
p.add(txt1);
p1.setLayout(new GridLayout(1,2));
p1.add(b1);
p1.add(b2);
p2.setLayout(new GridLayout(2,4));
p2.add(lab4);
p2.add(lab5);
p2.add(lab6);
p2.add(lab7);
p2.add(com1);
p2.add(com2);
p2.add(oper1);
p2.add(txt2);
p3.setLayout(new GridLayout(1,2));
p3.add(b3);
p3.add(b4);
p4.setLayout(new GridLayout(6,3));
p4.add(lab15);
p4.add(lab16);
p4.add(lab17);
p4.add(text2);
p4.add(text3);
p4.add(text4);
p4.add(text5);
p4.add(text6);
p4.add(text7);
p4.add(text8);
p4.add(text9);
p4.add(text10);
p4.add(text11);
p4.add(text12);
p4.add(text13);
p4.add(text14);
p4.add(text15);
p4.add(text16);
text2.setEditable(false);
text3.setEditable(false);
text5.setEditable(false);
text6.setEditable(false);
text8.setEditable(false);
text9.setEditable(false);
text11.setEditable(false);
text12.setEditable(false);
text14.setEditable(false);
text15.setEditable(false);
p5.setLayout(new GridLayout(1,2));
p5.add(b11);
p5.add(b12);
g1.setBounds(90,90,500,130);
g1.setBackground(Color.blue);
g1.add(p,BorderLayout.CENTER);
g1.add(p1,BorderLayout.SOUTH);
g2.setBounds(90,90,500,130);
g2.setBackground(Color.blue);
g2.add(p2,BorderLayout.CENTER);
g2.add(p3,BorderLayout.SOUTH);
g3.setLayout(new GridLayout(8,2));
g3.setBounds(90,90,300,500);
g3.setForeground(Color.CYAN);
g3.add(lab8);
g3.add(txt3);
g3.add(lab9);
g3.add(lab10);
g3.add(txte1);
g3.add(txte2);
g3.add(txte3);
g3.add(txte4);
g3.add(txte5);
g3.add(txte6);
g3.add(txte7);
g3.add(txte8);
g3.add(txte9);
g3.add(txte10);
g3.add(b5);
g3.add(b6);
g4.setBounds(90,90,500,100);
g4.setBackground(Color.pink);
g4.setLayout(new GridLayout(2,4));
g4.add(lab11);
g4.add(lab12);
g4.add(lab13);
g4.add(b7);
g4.add(com3);
g4.add(com4);
g4.add(text1);
g4.add(b8);
g5.setLayout(new GridLayout(2,3));
g5.setBounds(100,100,300,130);
g5.add(lab14);
g5.add(lab18);
g5.add(b9);
g5.add(com5);
g5.add(com6);
g5.add(b10);
g6.add(p4);
g6.add(p5,BorderLayout.SOUTH);
g7.setLayout(new GridLayout(2,2));
g7.add(lab19);
g7.add(b13);
g7.add(com7);
g7.add(b14);
g7.setBounds(130,130,270,140);
g8.setLayout(new GridLayout(2,3));
g8.add(lab20);
g8.add(lab21);
g8.add(b15);
g8.add(com8);
g8.add(com9);
g8.add(b16);
g8.setBounds(100,100,300,150);
b1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
course_query_actionPerformed(e);
}
});
b2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
cancel1_actionPerformed(e);
}
});
b3.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
class_query_actionPerformed(e);
}
});
b4.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
cancel2_actionPerformed(e);
}
});
b5.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
in_based_on_course_actionPerformed(e);
}
});
b6.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
cancel3_actionPerformed(e);
}
});
b7.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
in_sigle_actionPerformed(e);
}
});
b8.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
cancel4_actionPerformed(e);
}
});
b9.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
g6.setBounds(600,600,100,300);
g6.setVisible(true);
mySetText();
}
});
b10.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
cancel5_actionPerformed();
}
});
b11.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
in_based_on_class_actionPerformed();
}
});
b12.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
cancel6_actionPerformed();
}
});
b14.addActionListener(new monitor4());
b16.addActionListener(new monitor5());
mb1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
g1.setVisible(true);
}
});
mb2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
g2.setVisible(true);
}
});
mb3.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
g3.setVisible(true);
}
});
mb8.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
g4.setVisible(true);
}
});
mb4.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
g5.setVisible(true);
}
});
mb9.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
b13.addActionListener(new monitor1());
g7.setVisible(true);
}
});
mb10.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
b15.addActionListener(new monitor6());
g8.setVisible(true);
}
});
mb11.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
b13.addActionListener(new monitor2());
g7.setVisible(true);
}
});
mb12.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
b15.addActionListener(new monitor7());
g8.setVisible(true);
}
});
mb13.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
b13.addActionListener(new monitor3());
g7.setVisible(true);
}
});
mb14.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
b15.addActionListener(new monitor8());
g8.setVisible(true);
}
});
mbb.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e)
{
exit();
}
});
this.setBounds(200,200,800,600);
}
void exit()
{
this.setVisible(false);
}
void cancel1_actionPerformed(ActionEvent e)
{
g1.setVisible(false);
}
void cancel2_actionPerformed(ActionEvent e)
{
g2.setVisible(false);
}
void cancel3_actionPerformed(ActionEvent e)
{
g3.setVisible(false);
}
void cancel4_actionPerformed(ActionEvent e)
{
g4.setVisible(false);
}
void cancel5_actionPerformed()
{
g5.setVisible(false);
}
void cancel6_actionPerformed()
{
g6.setVisible(false);
}
void combo1_actionPerformed()//查找课程名
{
dataBase db=new dataBase();
String sql="select DISTINCT cname from course where cno in(select cno from teacher1 where id='"+Login.name+"')";
ResultSet rs=db.getResult(sql);
try
{
String rq=" ";
while(rs.next())
{
rq=rs.getString(1);
com.addItem(rq);
com1.addItem(rq);
com3.addItem(rq);
com6.addItem(rq);
com7.addItem(rq);
com8.addItem(rq);
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
void combo2_actionPerformed()//查找班级
{
dataBase db=new dataBase();
String sql="select DISTINCT class from student where sno in(select sno from sc where cno in(select cno from teacher1 where id='"+Login.name+"'))";
ResultSet rs=db.getResult(sql);
try
{
String t=" ";
while(rs.next())
{
t=rs.getString(1);
com2.addItem(t);
com5.addItem(t);
com9.addItem(t);
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
void combo3()//查找学号
{
dataBase db=new dataBase();
String sql="select DISTINCT sno from student where class in(select class from teacher1 where id='"+Login.name+"')";
ResultSet rs=db.getResult(sql);
try
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -