java实验报告 - - 129074(7)

BHandler b=new BHandler(); EXIT d=new EXIT(); b1.addActionListener(b); b2.addActionListener(d); //添加控件 c.add(use); c.add(k1); c.add(password); c.add(k2); c.add(b1); c.add(b2); setBounds(600,300,250,150); setVisible(true); setResizable(false); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } //主函数 @SuppressWarnings(\) public static void main(String[] args) { User f1=new User(new JFrame()); } //登录按钮方法 private class BHandler implements ActionListener{ @SuppressWarnings(\) public void actionPerformed(ActionEvent event){ if(k1.getText().equals(\)||k2.getText().equals(\)){ JOptionPane.showMessageDialog(User.this,\用户名密码不能为空！\ ); } else{ Statement stmt=null; ResultSet rs=null; String sql; sql=\+k1.getText()+\; try{ Connection dbConn1=CONN(); stmt=(Statement)dbConn1.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery(sql); if(rs.next()){ String xm=rs.getString(\); if(k2.getText().equals(xm.trim())){JOptionPane.showMessageDialog(User.this,\登录成功\); dispose(); new Menu();//管理窗口 } else{JOptionPane.showMessageDialog(User.this,\密码错误\);} } else{JOptionPane.showMessageDialog(User.this,\用户名错误\);} rs.close(); stmt.close(); } catch(SQLException e){ JOptionPane.showMessageDialog(User.this,\is:\+e.getMessage()); } } } }

//退出方法结束 private class EXIT implements ActionListener{

}

public void actionPerformed(ActionEvent even){ System.exit(0); }

//主界面

package search_10_3; 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 (\,Font.PLAIN,12); public Menu (){ this.setTitle(\学生成绩管理\); try {UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());} catch(Exception e){System.err.println(\不能设置外观: \+e);} //组合菜单 addMenu1(); addMenu2(); addMenu3(); addMenu4(); addJMenuBar(); setJMenuBar(mb); label=new JLabel(\欢迎使用学生成绩管理系统\,JLabel.CENTER); label.setFont(new Font(\宋体\,Font.BOLD,36)); label.setHorizontalTextPosition(SwingConstants.CENTER); label.setForeground(Color.blue); //点击事件 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(\欢迎界面\,label); 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);//字体 } public void actionPerformed(ActionEvent e){ Object obj=e.getSource(); if(obj==m5){System.exit(0);} else{if(obj==add1){ card.show(pCenter,\增加学生界面\); } else{if(obj==updata1){ card.show(pCenter,\修改学生界面\); } else{if(obj==delete1){ card.show(pCenter, \删除学生界面\); } else{if(obj==add2){ card.show(pCenter, \增加课程界面\); } else{if(obj==delete2){ card.show(pCenter, \删除课程界面\); } else{if(obj==updata2){ card.show(pCenter, \修改课程界面\); } else{if(obj==add3){ card.show(pCenter, \增加选课界面\); } else{if(obj==delete3){ card.show(pCenter, \删除选课界面\); } else{if(obj==updata3){ card.show(pCenter, \修改选课界面\); } else{if(obj==学生查询){ card.show(pCenter, \学生查询界面\); } } }}}}}}}}}} public static void main(String[] args) { new Menu(); } }

//学生类

package search_10_3; import java.sql.*; import javax.swing.*; import java.util.*;

public class Student extends JFrame { @SuppressWarnings(\) Vector rowData, columnNames; Statement stmt=null;

String sql=null; JTable jt = null; JScrollPane jsp = null; PreparedStatement ps=null; ResultSet rs=null; @SuppressWarnings({ \, \ }) public Student(String sql1){

columnNames = new Vector(); // 设置列名 columnNames.add(\学号\); columnNames.add(\姓名\); columnNames.add(\性别\); rowData=new Vector(); sql=sql1; try{ Connection dbConn1=CONN(); stmt=(Statement)dbConn1.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery(sql); while(rs.next()){ Vector hang = new Vector(); hang.add(rs.getString(\));System.out.print(rs.getString(\)); hang.add(rs.getString(\));System.out.print(rs.getString(\)); hang.add(rs.getString(\));System.out.println(rs.getString(\)); rowData.add(hang);} jt=new JTable(rowData,columnNames); jsp=new JScrollPane(jt); this.add(jsp); this.setSize(400,300); this.setVisible(true); }catch(SQLException e1){ System.out.print(\+e1.getMessage()); } }} //添加学生

package search_10_3;

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

import java.awt.event.*;

public class Addstu extends JPanel implements ActionListener{ JTextField 学号,姓名,系别; JButton 录入;

public Addstu(){ try {UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());} catch(Exception e){System.err.println(\不能设置外观: \+e);} 学号=new JTextField(12); 姓名=new JTextField(12); 系别=new JTextField(12); 录入=new JButton(\录入\); 录入.addActionListener(this); Box box1=Box.createHorizontalBox();//横放box Box box2=Box.createHorizontalBox(); Box box3=Box.createHorizontalBox(); Box box4=Box.createHorizontalBox(); box1.add(new JLabel(\学号:\/*,JLabel.CENTER*/)); box1.add(学号); box2.add(new JLabel(\姓名:\/*,JLabel.CENTER*/)); box2.add(姓名); box3.add(new JLabel(\系别:\/*,JLabel.CENTER*/)); box3.add(系别);