学生信息管理系统代码.doc

import java.awt.BorderLayout;import java.awt.CardLayout;import java.awt.Container;import java.awt.Font;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.Icon;import javax.swing.ImageIcon;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JMenu;import javax.swing.JMenuBar;import javax.swing.JMenuItem;import javax.swing.JPanel;import javax.swing.JToolBar;import javax.swing.SwingConstants;public class MainFrame extends JFrame implements ActionListener InsertPanel ip = null; SelectPanel sp = null; JPanel pframe; JButton jb1,jb2,jb3; JMenuItem jm11,jm21,jm22,jm23,jm31,jm32,jm41,jm42; CardLayout clayout; public MainFrame(String s) super(s); JMenuBar mb = new JMenuBar(); this.setJMenuBar(mb); JMenu m1 = new JMenu(系统); JMenu m2 = new JMenu(基本信息); JMenu m3 = new JMenu(成绩); JMenu m4 = new JMenu(奖惩); mb.add(m1); mb.add(m2); mb.add(m3); mb.add(m4); jm11 = new JMenuItem(退出系统); jm21 = new JMenuItem(输入); jm22 = new JMenuItem(查询); jm23 = new JMenuItem(更改); jm31 = new JMenuItem(输入成绩); jm32 = new JMenuItem(查询成绩); jm41 = new JMenuItem(奖励); jm42 = new JMenuItem(处分); m1.add(jm11); m2.add(jm21); m2.add(jm22); m2.add(jm23); m3.add(jm31); m3.add(jm32); m4.add(jm41); m4.add(jm42); Icon i1 = new ImageIcon(); Icon i2 = new ImageIcon(); Icon i3 = new ImageIcon(); jb1 = new JButton(i1); jb1.setToolTipText(输入); jb2 = new JButton(i2); jb2.setToolTipText(查询); jb3 = new JButton(i3); jb3.setToolTipText(退出); JToolBar tb = new JToolBar(系统工具); tb.add(jb1); tb.add(jb2); tb.add(jb3); add(tb,BorderLayout.NORTH); jm11.addActionListener(this); jm21.addActionListener(this); jm22.addActionListener(this); jb1.addActionListener(this); jb2.addActionListener(this); jb3.addActionListener(this); clayout = new CardLayout(); pframe = new JPanel(clayout); add(pframe); JPanel mainp = new JPanel(new BorderLayout(); JLabel mainl = new JLabel(学生信息管理平台,SwingConstants.CENTER); mainl.setFont(new Font(serif,Font.BOLD,30); mainp.add(mainl); pframe.add(mainp,main); clayout.show(pframe, main); public void actionPerformed(ActionEvent e) if(e.getSource() = jm21 | e.getSource() = jb1) if(ip = null) ip= new InsertPanel(); pframe.add(ip,insert); clayout.show(pframe, insert); this.setTitle(输入学生信息); else if(e.getSource() = jm22 | e.getSource() = jb2) if(sp = null) sp= new SelectPanel(); pframe.add(sp,select); clayout.show(pframe, select); this.setTitle(查询学生信息); else if(e.getSource() = jm11 | e.getSource() = jb3) System.exit(0); 第二个：import javax.swing.JFrame;public class MainTest public static void main(String args) MainFrame f = new MainFrame(学生信息管理平台); f.setSize(400,300); f.setLocation(350,250); f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); f.setVisible(true); 第二个：import java.sql.Connection;import java.sql.DriverManager;public class MySQLConnection static Connection getCon() Connection con = null; try Class.forName(com.mysql.jdbc.Driver); con = DriverManager.getConnection(jdbc:mysql:/localhost/test,root,123); catch(Exception e) System.out.println(建立数据库连接遇到异常！); return con; 第四个：import java.awt.BorderLayout;import java.awt.GridLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JButton;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JTextField;import javax.swing.SwingConstants;public class SelectPanel extends JPanel implements ActionListener JButton jb; JTextField jt; JTextField jt1,jt2,jt3,jt4; public SelectPanel() JLabel jl = new JLabel(请输入学号:,SwingConstants.CENTER); jt = new JTextField(); jb = new JButton(确定); JPanel jp1 = new JPanel(new GridLayout(1,3); jp1.add(jl); jp1.add(jt); jp1.add(jb); JLabel j1,j2,j3,j4; j1 = new JLabel(学号:,SwingConstants.CENTER); j2 = new JLabel(姓名:,SwingConstants.CENTER); j3 = new JLabel(性别:,SwingConstants.CENTER); j4 = new JLabel(年龄:,SwingConstants.CENTER); jt1 = new JTextField(6); jt1.setEditable(false); jt2 = new JTextField(6); jt2.setEditable(false); jt3 = new JTextField(6); jt3.setEditable(false); jt4 = new JTextField(6); jt4.setEditable(false); JPanel jp2 = new JPanel(new BorderLayout(); JPanel jp3 = new JPanel(new GridLayout(4,2); jp2.add(new JLabel(),BorderLayout.NORTH); jp3.add(j1); jp3.add(jt1); jp3.add(j2); jp3.add(jt2); jp3.add(j3); jp3.add(jt3); jp3.add(j4); jp3.add(jt4); jp2.add(jp3); this.setLayout(new BorderLayout(); add(jp1,BorderLayout.NORTH); add(jp2); jb.addActionListener(this); public void actionPerformed(ActionEvent e) if(e.getSource() = jb) String stuNo = jt.getText().trim(); Student s = new Student(); boolean b = true; try b = s.selectByStuNo(stuNo); catch(Exception ex) System.out.println(查询学生信息遇到异常!); if(b) jt1.setText(s.getStuNo(); jt2.setText(s.getName(); jt3.setText(s.getGender(); int a = s.getAge(); Integer i = new Integer(a); jt4.setText(i.toString(); else JOptionPane.showMessageDialog(null, 无此学生!); 第五个：import javax.swing.JFrame;public class SelectTest public static void main(String args) JFrame f = new JFrame(查询学生信息); SelectPanel p = new SelectPanel(); f.add(p); f.setSize(400,300); f.setLocation(300,250); f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); f.setVisible(true); 第六个：import java.sql.Connection;import java.sql.ResultSet;import java.sql.Statement;public class Student String stuNo; String name; String gender; int age; public Student() public Student(String stuNo,String name,String gender, int age) this.stuNo = stuNo; = name; this.gender = gender; this.age = age; public String getStuNo() return stuNo; public void setStuNo(String stuNo) this.stuNo = stuNo; public String getName() return name; public void setName(String name) = name; public String getGender() return gender; public void setGender(String gender) this.gender = gender; public int getAge() return age; public void setAge(int age) this.age = age; public boolean insertStudent() boolean b = true; try Connection con = MySQLConnection.getCon(); Statement statement = con.createStatement(); String sql = insert into student values( + stuNo + , + name +, + gender + , + age + ); sql = new String(sql.getBytes(gb2312),ISO8859_1); statement.executeUpdate(sql); con.close(); catch(