JAVA数据库课程设计--学生选课管理系统的分解

import java.sql.*; import javax.swing.*;

public class UpdateC extends JPanel implements ActionListener{

String save=null;

JTextField 课号1,课号,课名;

JButton 修改,查找; public UpdateC(){

try

{UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());}catch(Exception e){System.err.println(\不能设置外观: \+e);}

课号1=new JTextField(12); 课号=new JTextField(12); 课名=new JTextField(12); 修改=new JButton(\修改\); 查找=new JButton(\查找\);

Box box1=Box.createHorizontalBox();//横放box Box box2=Box.createHorizontalBox(); Box box3=Box.createHorizontalBox(); Box box4=Box.createHorizontalBox(); Box box5=Box.createHorizontalBox();

box1.add(new JLabel(\课号:\,JLabel.CENTER)); box1.add(课号);

box2.add(new JLabel(\课名:\,JLabel.CENTER)); box2.add(课名); box3.add(修改);

box5.add(new JLabel(\课号:\,JLabel.CENTER)); box5.add(课号1); box5.add(查找);

修改.addActionListener(this);

Box boxH=Box.createVerticalBox();//竖放box boxH.add(box1); boxH.add(box2); boxH.add(box3); boxH.add(box4);

boxH.add(Box.createVerticalGlue()); JPanel picPanel=new JPanel(); JPanel messPanel=new JPanel(); messPanel.add(box5); picPanel.add(boxH);

setLayout(new BorderLayout()); JSplitPane splitV=new

查找.addActionListener(this);

JSplitPane(JSplitPane.VERTICAL_SPLIT,messPanel,picPanel);//分割 add(splitV,BorderLayout.CENTER);

validate();}

删除界面:DelC.java/DelSC.java /Deltu.java

先查找你想要删除的项目，然后删除，此外，若删除C表或则S表的内容，会连同SC表中对应的信息一起修改。

import java.awt.*; import java.awt.event.*; import java.sql.*; import javax.swing.*;

public class DelC extends JPanel implements ActionListener{

String save=null;

JTextField 课号1,课号,课名; JButton 删除,查找; public DelC(){ try

{UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());}catch(Exception e){System.err.println(\不能设置外观: \+e);}

课号1=new JTextField(12); 课号=new JTextField(12); 课名=new JTextField(12); 删除=new JButton(\删除\); 查找=new JButton(\查找\);

Box box1=Box.createHorizontalBox();//横放box Box box2=Box.createHorizontalBox(); Box box3=Box.createHorizontalBox(); Box box4=Box.createHorizontalBox(); Box box5=Box.createHorizontalBox();

box1.add(new JLabel(\课号:\,JLabel.CENTER)); box1.add(课号);

box2.add(new JLabel(\课名:\,JLabel.CENTER)); box2.add(课名); box4.add(删除);

box5.add(new JLabel(\课号:\,JLabel.CENTER)); box5.add(课号1);

box5.add(查找);

Box boxH=Box.createVerticalBox();//竖放box boxH.add(box1); boxH.add(box2); boxH.add(box3); boxH.add(box4);

boxH.add(Box.createVerticalGlue()); 删除.addActionListener(this);

查找.addActionListener(this); JPanel picPanel=new JPanel();

JPanel messPanel=new JPanel(); messPanel.add(box5); picPanel.add(boxH);

setLayout(new BorderLayout()); JSplitPane splitV=new

JSplitPane(JSplitPane.VERTICAL_SPLIT,messPanel,picPanel);//分割 add(splitV,BorderLayout.CENTER);

validate();}

查询界面:Selsto.java

可以以任意条件模糊查找相关的表。

import java.awt.*; import java.awt.event.*; import java.sql.*; import javax.swing.*;

public class Selstu extends JPanel implements ActionListener{

JTextField 学号,姓名,系别; JButton 查找;

JTextField 课号,课名; JButton 查找1;

JTextField 课号1,学号1,成绩; JButton 查找2; public Selstu (){

学号=new JTextField(12);

姓名=new JTextField(12); 系别=new JTextField(12); 课号=new JTextField(12); 课名=new JTextField(12); 课号1=new JTextField(12); 学号1=new JTextField(12); 成绩=new JTextField(12);

查找=new JButton(\查找学生信息\); 查找1=new JButton(\查找课程信息\); 查找2=new JButton(\查找选课信息\);

Box box1=Box.createHorizontalBox();//横放box Box box2=Box.createHorizontalBox(); Box box4=Box.createHorizontalBox(); Box box5=Box.createHorizontalBox(); Box box6=Box.createHorizontalBox(); Box box7=Box.createHorizontalBox();

box1.add(new JLabel(\学号:\,JLabel.CENTER)); box1.add(学号);

box1.add(new JLabel(\姓名:\,JLabel.CENTER)); box1.add(姓名);

box1.add(new JLabel(\系别:\,JLabel.CENTER)); box1.add(系别); box2.add(查找);

box4.add(new JLabel(\课号:\,JLabel.CENTER)); box4.add(课号);

box4.add(new JLabel(\课名:\,JLabel.CENTER)); box4.add(课名); box6.add(查找1);

box5.add(new JLabel(\课号:\,JLabel.CENTER)); box5.add(课号1);

box5.add(new JLabel(\学号:\,JLabel.CENTER)); box5.add(学号1);

box5.add(new JLabel(\成绩:\,JLabel.CENTER)); box5.add(成绩); box7.add(查找2);

Box boxH1=Box.createVerticalBox();//竖放box boxH1.add(box1); boxH1.add(box2);

boxH1.add(Box.createVerticalGlue()); Box boxH2=Box.createVerticalBox();//竖放box boxH2.add(box4); boxH2.add(box6);

boxH2.add(Box.createVerticalGlue()); Box boxH3=Box.createVerticalBox();//竖放box