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(); }
public void actionPerformed(ActionEvent e){ Object obj=e.getSource(); Statement stmt=null;
ResultSet rs=null,rs1=null;
String sql=null,sql1=null,sqlSC=null;
if(obj==查找){if(学号1.getText().equals(\请填写查询的学号！\else{
sql1=\学号1.getText()+\ try{
Connection dbConn1=CONN();
stmt=(Statement)dbConn1.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); rs1=stmt.executeQuery(sql1);
if(rs1.next()){学号.setText(rs1.getString(\
姓名.setText(rs1.getString(\ 系别.setText(rs1.getString(\ save=学号1.getText().trim(); }
else{JOptionPane.showMessageDialog(this,\没有这个学号的学生\ stmt.close(); rs1.close();
}catch(SQLException e1){
System.out.print(\ } } }
else{
if(obj==删除){if(save==null)JOptionPane.showMessageDialog(this,\还没查找需要修改的学生\
else{sql=\
sqlSC=\try{
Connection dbConn1=CONN();
stmt=(Statement)dbConn1.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); stmt.executeUpdate(sql); stmt.executeUpdate(sqlSC); save=null;
JOptionPane.showMessageDialog(this,\删除完成\学号.setText(\
姓名.setText(\ 系别.setText(\
stmt.close();
}catch(SQLException e1){
System.out.print(\ } } } } }
//连接数据库方法
public static Connection CONN(){
String driverName = \ //加载JDBC驱动 String dbURL = \DatabaseName=student\ //连接服务器和数据库test
String userName = \ //默认用户名 String userPwd = \ //密码 Connection dbConn=null;
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println(\Successful!\ //如果连接成功 控制台输出Connection Successful!
} catch (Exception e) { e.printStackTrace(); }
return dbConn;
} }
Menu.java:
import java.awt.*;
import java.awt.event.*; import javax.swing.*;
public class Menu extends JFrame implements ActionListener{ Addstu 增加学生界面; Updatastu 修改学生界面; Delstu 删除学生界面; AddC 增加课程界面; DelC 删除课程界面; UpdateC 修改课程界面; AddSC 增加选课界面; DelSC 删除选课界面; UpdateSC 修改选课界面; Selstu 学生查询界面; JPanel pCenter;
CardLayout card=null; JLabel label=null;
JMenuBar mb=new JMenuBar();//菜单栏 JMenu m1=new JMenu(\学生管理\
JMenuItem add1=new JMenuItem(\ \
JMenuItem updata1=new JMenuItem(\ \JMenuItem delete1=new JMenuItem(\ \JMenu m2=new JMenu(\课程管理\
JMenuItem add2=new JMenuItem(\ \
JMenuItem updata2=new JMenuItem(\ \JMenuItem delete2=new JMenuItem(\ \JMenu m3=new JMenu(\选课管理\
JMenuItem add3=new JMenuItem(\ \
JMenuItem updata3=new JMenuItem(\ \JMenuItem delete3=new JMenuItem(\ \JMenu m4=new JMenu(\查询管理\
JMenuItem 学生查询=new JMenuItem(\查询信息 \JMenuItem m5=new JMenuItem(\系统退出\Font t=new Font (\public Menu (){
this.setTitle(\学生选课管理系统\
try {UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());} catch(Exception e){System.err.println(\不能设置外观: \
//组合菜单 addMenu1(); addMenu2(); addMenu3(); addMenu4(); addJMenuBar(); setJMenuBar(mb);
label=new JLabel(\选课管理系统\label.setFont(new Font(\宋体\
label.setHorizontalTextPosition(SwingConstants.CENTER); label.setForeground(Color.red); //点击事件
add1.addActionListener(this); updata1.addActionListener(this); delete1.addActionListener(this); m5.addActionListener(this); add2.addActionListener(this); delete2.addActionListener(this); updata2.addActionListener(this); add3.addActionListener(this); delete3.addActionListener(this); updata3.addActionListener(this); 学生查询.addActionListener(this);
card=new CardLayout(); pCenter=new JPanel(); pCenter.setLayout(card);
增加学生界面=new Addstu(); 修改学生界面=new Updatastu(); 删除学生界面=new Delstu(); 增加课程界面=new AddC(); 删除课程界面=new DelC(); 修改课程界面=new UpdateC(); 增加选课界面=new AddSC(); 删除选课界面=new DelSC(); 修改选课界面=new UpdateSC(); 学生查询界面=new Selstu();
pCenter.add(\欢迎界面\
pCenter.add(\增加学生界面\增加学生界面); pCenter.add(\修改学生界面\修改学生界面); pCenter.add(\删除学生界面\删除学生界面);
pCenter.add(\增加课程界面\增加课程界面); pCenter.add(\删除课程界面\删除课程界面); pCenter.add(\修改课程界面\修改课程界面); pCenter.add(\增加选课界面\增加选课界面); pCenter.add(\删除选课界面\删除选课界面); pCenter.add(\修改选课界面\修改选课界面); pCenter.add(\学生查询界面\学生查询界面);
add(pCenter,BorderLayout.CENTER); validate();
setVisible(true);
setBounds(400,150,600,380);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
addWindowListener(new WindowAdapter(){//关闭程序时的操作 public void windowClosing(WindowEvent e){System.exit(0);} });
validate(); }
private void addJMenuBar() {
mb.add(m1);mb.add(m2);mb.add(m3);mb.add(m4);mb.add(m5); }
private void addMenu4() { m4.add(学生查询); m4.setFont(t); }
private void addMenu3() { m3.add(add3); m3.add(updata3); m3.add(delete3); m3.setFont(t); }
private void addMenu2() {//将菜单加入到菜单栏中 m2.add(add2); m2.add(updata2); m2.add(delete2); m2.setFont(t); }
private void addMenu1() { m1.add(add1); m1.add(updata1); m1.add(delete1); m1.setFont(t);//字体 }