发布时间 : 2024/5/20 18:01:43 星期一 文章java实验报告 - - 129074更新完毕开始阅读b98b446eb7360b4c2e3f64f5

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(系别);

box4.add(录入); Box boxH=Box.createVerticalBox();//竖放box boxH.add(box1); boxH.add(box2); boxH.add(box3); boxH.add(box4); boxH.add(Box.createVerticalGlue()); JPanel messPanel=new JPanel(); messPanel.add(boxH); setLayout(new BorderLayout()); add(messPanel,BorderLayout.CENTER); validate(); }

public void actionPerformed(ActionEvent c){ Object obj=c.getSource(); if(obj==录入){ if(学号.getText().equals(\)||姓名.getText().equals(\)||系别.getText().equals(\)){ JOptionPane.showMessageDialog(this,\学生信息请填满再录入！\ ); } Statement stmt=null; ResultSet rs1=null; String sql,sql1; sql1=\+学号.getText()+\; sql=\+学号.getText()+\+姓名.getText()+\+系别.getText()+\; try{ Connection dbConn1=CONN(); stmt=(Statement)dbConn1.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); rs1=stmt.executeQuery(sql1); if(rs1.next()){JOptionPane.showMessageDialog(this,\该学号以存在，无法添加\);} else{ stmt.executeUpdate(sql); JOptionPane.showMessageDialog(this,\添加成功\); } rs1.close(); stmt.close(); } catch(SQLException e){ System.out.print(\+e.getMessage()); } }}}

//查询学生

package search_10_3; import java.awt.*;

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

import javax.swing.*;

public class Selstu extends JPanel implements ActionListener{ /** * */ private static final long serialVersionUID = 1L; JTextField 学号,姓名,系别; JButton 查找; JTextField 课号,课名; JButton 查找1; JTextField 课号1,学号1,成绩; JButton 查找2; public Selstu (){