学生管理系统代码.doc

import java.awt.*;
import javax.swing.*;
import java.awt.Font;
import javax.swing.ButtonGroup;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swingJTextField;
import javax.swing.JPasswordField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
class LoginCheck{
private String user;
private String passWord;
public LoginCheck(String user,String passWord){
this.user=user;
this.passWord=passWord;
}
public boolean check(){
if("zhouzhiqiang".equals(user)&&"123456".equals(passWord)){
return true;
}else{
return false;
}
}
}
class ActionHandle1{
private JFrame frame=new JFrame("登录界面");
private JButton submit=new JButton("登录");
private JButton exit=new JButton("退出");
private JLabel user=new JLabel("用户名：");
private JLabel passWord=new JLabel"密 码：");
private JLabel info=new JLabel("学生管理系统");
private JTextField userText=new JTextField();
private JPasswordField passText=new JPasswordField();
public ActionHandle1(){
Font fnt=new Font("Serief",Font.BOLD,20);
info.setFont(fnt);
submit.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0){
if(arg0.getSource()==submit){
String user=userText.getText();
String password=new String(passText.getPassword());
LoginCheck log=new LoginCheck(user,password);
if(log.check()){
new ActionHandle2().setMenuBar();
}else{
JOptionPane.showMessageDialog(null, "输入的用户名或密码有误！", "警告",
JOptionPane.WARNING_MESSAGE);
userText.setText("");
passText.setText("");
}
}
}
});
exit.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0){
if(arg0.getSource()==exit){
System.exit(1);
}
}
});
frame.addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent arg0){
frame.dispose();
}
});
frame.setLayout(null);
user.setBounds(45, 45, 60, 20);
passWord.setBounds(45, 75, 60, 20);
info.setBounds(75, 5, 220, 30);
userText.setBounds(105, 45, 100, 20);
passText.setBounds(105, 75, 100, 20);
submit.setBounds(45, 120, 60, 20);
exit.setBounds(145, 120, 60, 20);
frame.getContentPane().setBackground(Color.GREEN);
frame.add(user);
frame.add(passWord);
frame.add(info);
frame.add(userText);
frame.add(passText);
frame.add(submit);
frame.add(exit);
frame.setSize(300,200);
frame.setVisible(true);
frame.setResizable(false);
}
}
class ActionHandle4{
private JFrame frame=new JFrame("录入界面-课程基本表");
private JButton ensure=new JButton("确定");
private JButton quit=new JButton("取消");
private JLabel cno=new JLabel("课程号：");
private JLabel cname=new JLabel("课程名：");
private JLabel cpno=new JLabel("先修课：");
private JLabel ccredit=new JLabel("学 分：");
private JTextField cnoText=new JTextField();
private JTextField cnameText=new JTextField();
private JTextField cpnoText=new JTextField();
private JTextField ccreditText=new JTextField();
public ActionHandle4(){
/*ensure.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0){
if(arg0.getSource()==ensure){
String sno=snoText.getText();
String sname=snameText.getText();
String sage=snoText.getText();
String sdept=snameText.getText();
LoginCheck log=new LoginCheck(user,password);
if(log.check()){

}else{
JOptionPane.showMessageDialog(null, "输入的用户名或密码有误！", "警告",
JOptionPane.WARNING_MESSAGE);
userText.setText("");
passText.setText("");

}
}
}
});*/
quit.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0){
if(arg0.getSource()==quit){
frame.dispose();
}
}
});
frame.addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent arg0){
System.exit(0);
}
});
frame.setLayout(null);
cno.setBounds(45, 45, 60, 20);
cname.setBounds(45, 75, 60, 20);
cpno.setBounds(45, 105, 60, 20);
ccredit.setBounds(45, 135, 60, 20);
cnoText.setBounds(105, 45, 100, 20);
cnameText.setBounds(105, 75, 100, 20);
cpnoText.setBounds(105 105, 100, 20);
ccreditText.setBounds(105, 135, 100, 20);
ensure.setBounds(45, 195, 60, 20);
quit.setBounds(145, 195, 60, 20);
frame.getContentPane().setBackground(Color.GREEN);
frame.add(cno);
frame.add(cname);
frame.add(cpno);
frame.add(ccredit);
frame.add(cnoText);
frame.add(cnameText);
frame.add(cpnoText);
frame.add(ccreditText);
frame.add(ensure);
frame.add(quit);
frame.setSize(300,300);
frame.setVisible(true);
frame.setResizable(false);
}
}
class ActionHandle5{
private JFrame frame=new JFrame("录入界面-成绩基本表");
private JButton ensure=new JButton("确定");
private JButton quit=new JButton("取消");
private JLabel sno=new JLabel("学 号：");
private JLabel cno=new JLabel("课程号：");
private JLabel grade=new JLabel("成 绩：");
private JTextField snoText=new JTextField();
private JTextField cnoText=new JTextField();
private JTextField gradeText=new JTextField();
public ActionHandle5(){
/*ensure.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0){
if(arg0.getSource()==ensure){
String sno=snoText.getText();
String sname=snameText.getText();
String sage=snoText.getText();
String sdept=snameText.getText();
LoginCheck log=new LoginCheck(user,password);
if(log.check()){

}else{
JOptionPane.showMessageDialog(null, "输入的用户名或密码有误！", "警告",
JOptionPaneWARNING_MESSAGE);
userText.setText("");
passText.setText("");

}
}
}
});*/
quit.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0){
if(arg0.getSource()==quit){
frame.dispose();
}
}
})
frame.addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent arg0){
System.exit(0);
}
});
frame.setLayout(null);
sno.setBounds(45, 45, 60, 20);
cno.setBounds(45, 75, 60, 20);
grade.setBounds(45, 105, 60, 20);
snoText.setBounds(105, 45, 100, 20);
cnoText.setBounds(105, 75, 100, 20);
gradeText.setBounds(105, 105, 100, 20);
ensure.setBounds(45, 195, 60, 20);
quit.setBounds(145, 195, 60, 20);
frame.getContentPane().setBackground(Color.GREEN);
frame.add(sno);
frame.add(cno);
frame.add(grade);
frame.add(snoText);
frame.add(cnoText);
frame.add(gradeText);
frame.add(ensure);
frame.add(quit);
frame.setSize(300,300);
frame.setVisible(true);
frame.setResizable(false);
}
}
class ActionHandle6{
private JFrame frame=new JFrame("更改界面");
private JButton ensure=new JButton("确定");
private JButton quit=new JButton("取消");
private JLabel sno1=new JLabel("请输入学号：");
private JLabel sno=new JLabel("学 号：");
private JLabel sname=new JLabel("姓 名：");
private JLabel sage=new JLabel("年 龄：");
private JLabel sdept=new JLabel("院 系：");
private JLabel ssex=new JLabel("性 别：");
private JRadioButton boy=new JRadioButton("男");
private JRadioButton girl=new JRadioButton("女");
private ButtonGroup sex=new ButtonGroup();
private JTextField sno1Text=new JTextField();
private JTextField snoText=new JTextField();
private JTextField snameText=new JTextField();
private JTextField sageText=new JTextField();
private JTextField sdeptText=new JTextField();
public ActionHandle6(){
/*ensure.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0){
if(arg0.getSource()==ensure){
String sno=snoText.getText();
String sname=snameText.getText();
String sage=snoText.getText();
String sdept=snameText.getText();
LoginCheck log=new LoginCheck(user,password);
if(log.check()){

}else{
JOptionPane.showMessageDialog(null, "输入的用户名或密码有误！", "警告",
JOptionPane.WARNING_MESSAGE);
userText.setText("");
passText.setText("");

}
}
}
});*/
quit.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0){
if(arg0.getSource()==quit){
frame.dispose();
}
}
});
frame.addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent arg0){
System.exit(0);
}
});
frame.setLayout(null);
sno1.setBounds(15, 15, 100, 20);
sno.setBounds(45, 45, 60, 20);
sname.setBounds(45, 75, 60, 20);
sage.setBounds(45, 105, 60, 20);
sdept.setBounds(45, 135, 60, 20);
ssex.setBounds(45, 165, 60, 20);
sno1Text.setBounds(105, 15, 100, 20);
snoText.setBounds(105, 45, 100, 20);
snameText.setBounds(105, 75, 100, 20);
sageText.setBounds(105, 105, 100, 20);
sdeptText.setBounds(105, 135, 100, 20);
ensure.setBounds(45, 195, 60, 20);
quit.setBounds(145, 195, 60, 20);
boy.setBounds(105,165,40,20);
girl.setBounds(155,165,40,20);
boy.setSelected(true);
boy.setBackground(Color.GREEN);
girl.setBackground(Color.GREEN);
sex.add(this.boy);
sex.addgirl);
frame.getContentPane().setBackground(Color.GREEN);
frame.add(sno1);
frame.add(sno);
frame.add(sname);
frame.add(sage);
frame.add(sdept);
frame.add(ssex);
frame.add(sno1Text);
frame.add(snoText);
frame.add(snameText);
frame.add(sageText);
frame.add(sdeptText);
frame.add(ensure);
frame.add(quit);
frame.add(boy);
frame.add(girl);
frame.setSize(300,300);
frame.setVisible(true);
frame.setResizable(false);
}
}
class ActionHandle7{
private JFrame frame=new JFrame("删除界面");
private JButton ensure=new JButton("确定");
private JButton quit=new JButton("取消");
private JLabel sno=new JLabel("请输入学号：");
private JTextField snoText=new JTextField();
public ActionHandle7(){
/*ensure.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0){
if(arg0.getSource()==ensure){
String snosnoText.getText();
String sname=snameText.getText();
String sage=snoText.getText();
String sdept=snameText.getText();
LoginCheck log=new LoginCheck(user,password);
if(log.check()){

}else{
JOptionPane.showMessageDialog(null, "输入的用户名或密码有误！", "警告",
JOptionPane.WARNING_MESSAGE);
userText.setText("");
passText.setText("");

}
}
}
});*/
quit.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0){
if(arg0.getSource()==quit){
frame.dispose();
}
}
});
frame.addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent arg0){
System.exit(0);
}
});
frame.setLayout(null);
sno.setBounds(25, 105, 100, 20);
snoText.setBounds(125, 105, 100, 20);
ensure.setBounds(45, 195, 60, 20);
quit.setBounds(145, 195, 60, 20);
frame.getContentPane().setBackground(Color.GREEN);
frame.add(sno);
frame.add(snoText);
frame.add(ensure);
frame.add(quit);
frame.setSize(300,300);
frame.setVisible(true);
frame.setResizable(false);
}
}
class Action01{
private JFrame frame=new JFrame("按性别查询");
private JButton ensure=new JButton("确定");
private JButton quit=new JButton("取消");
private JLabel ssex=new JLabel("性 别：");
private JRadioButton boy=new JRadioButton("男");
private JRadioButton girl=new JRadioButton("女");
private ButtonGroup sex=new ButtonGroup();
public Action01(){
/*ensure.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0){
if(arg0.getSource()==ensure){
String sno=snoText.getText();
String sname=snameTextgetText();
String sage=snoText.getText();
String sdept=snameText.getText();
LoginCheck log=new LoginCheck(user,password);
if(log.check()){

}else{
JOptionPane.showMessageDialog(null, "输入的用户名或密码有误！", "警告",
JOptionPane.WARNING_MESSAGE);
userText.setText("");
passText.setText("");

}
}
}
});*/
quit.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0){
if(arg0.getSource()==quit){
frame.dispose();
}
}
});
frame.addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent arg0){
System.exit(0);
}
});
frame.setLayout(null);
ssex.setBounds(45, 45, 60, 20);
ensure.setBounds(45, 85, 60, 20);
quit.setBounds(145, 85, 60, 20);
boy.setBounds(115,45,40,20);
girl.setBounds(165,45,40,20);
boy.setSelected(true);
boy.setBackground(Color.GREEN);
girl.setBackground(Color.GREEN);
sex.add(this.boy);
sex.add(girl);
frame.getContentPane().setBackground(Color.GREEN);
frame.add(ssex);
frame.add(ensure);
frame.add(quit);
frame.add(boy);
frame.add(girl);
frame.setSize(300,300);
frame.setVisible(true);
frame.setResizable(false);
}
}
class Action02{
private JFrame frame=new JFrame("按学号查询");
private JButton student=new JButton("学生基本表");
private JButton course=new JButton("课程表");
private JButton score=new JButton("成绩表");
private JLabel sno=new JLabel("请输入学号：");
private JTextField snoText=new JTextField();
public Action02(){
/*ensure.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0){
if(arg0.getSource()==ensure){
String snosnoText.getText();
String sname=snameText.getText();
String sage=snoText.getText();
String sdept=snameText.getText();
LoginCheck log=new LoginCheck(user,password);
if(log.check()){

}else{
JOptionPane.showMessageDialog(null, "输入的用户名或密码有误！", "警告",
JOptionPane.WARNING_MESSAGE);
userText.setText("");
passText.setText("");

}
}
}
});*/
score.addActionListener(new ActionListener(){
public void actionPerformed(ActionEven