学生成绩管理系统（java语言编写的能够快速排名，添加、修改、查询）

package com.pengyongsheng; import java.awt.Color; import java.awt.Container; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.FocusAdapter; import java.awt.event.FocusEvent; import java.sql.CallableStatement; import java.sql.SQLException; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JTextField; public class SHE extends JFrame implements ActionListener{ JTextField id, name, sex, shujuku, os, vb, zucheng, tongxin, singlechip, tcp_ip, java, softproject, maozedong, net, jiekou, graphics, bianyi, jiuyezhidao, juyuwang, wangluoanquan, deyu; Container c; JButton add, exit; Mysql addscore; public SHE() { c = this.getContentPane(); c.setBackground(new Color(100, 125, 136)); c.setLayout(new GridLayout(11, 2)); JLabel ids, names, sexs, shujukus, oss, vbs, zuchengs, tongxins, singlechips, tcp_ips, javas, softprojects, maozedongs, nets, jiekous, graphicss, bianyis, jiuyezhidaos, juyuwangs, wangluoanquans, deyus; ids = new JLabel("学号"); id = new JTextField(); id.addFocusListener(new FocusAdapter(){ public void focusLost(FocusEvent e) { if(id.getText().equals("")){ JOptionPane.showMessageDialog(null,"所选项不能为空！"); } } }); id.setToolTipText("请输入型如‘310609010201’的学号，不要重复！"); names = new JLabel("姓名"); name = new JTextField(); name.addFocusListener(new FocusAdapter(){ public void focusLost(FocusEvent e){ if(name.getText().equals("")){ JOptionPane.showMessageDialog(null,"姓名不能为空！");} } }); sexs = new JLabel("性别"); sex = new JTextField(); sex.addFocusListener(new FocusAdapter(){ public void focusLost(FocusEvent e){ if(sex.getText().equals("")){ JOptionPane.showMessageDialog(null,"性别不能为空！");} } }); shujukus = new JLabel("数据库"); shujuku = new JTextField(); shujuku.addFocusListener(new FocusAdapter(){ public void focusLost(FocusEvent e){ if(shujuku.getText().equals(""))JOptionPane.showMessageDialog(null,"必修课不能为空！"); } }); oss = new JLabel("操作系统"); os = new JTextField(); os.addFocusListener(new FocusAdapter(){ public void focusLost(FocusEvent e){ if(os.getText().equals(""))JOptionPane.showMessageDialog(null,"必修课不能为空！"); } }); vbs = new JLabel("vb程序设计"); vb = new JTextField(); vb.addFocusListener(new FocusAdapter(){ public void focusLost(FocusEvent e){ if(vb.getText().equals(""))JOptionPane.showMessageDialog(null,"必修课不能为空！"); } }); zuchengs = new JLabel("计算机组成原理"); zucheng = new JTextField(); zucheng.addFocusListener(new FocusAdapter(){ public void focusLost(FocusEvent e){ if(zucheng.getText().equals(""))JOptionPane.showMessageDialog(null,"必修课不能为空！"); } }); tongxins = new JLabel("通信原理概论"); tongxin = new JTextField(); tongxin.addFocusListener(new FocusAdapter(){ public void focusLost(FocusEvent e){ if(tongxin.getText().equals("")){JOptionPane.showMessageDialog(null,"必修课不能为空！");} } }); singlechips = new JLabel("单片机原理及其应用"); singlechip = new JTextField(); tcp_ips = new JLabel("TCP/IP协议"); tcp_ip = new JTextField(); javas = new JLabel("JAVA语言程序设计"); java = new JTextField(); softprojects = new JLabel("软件工程"); softproject = new JTextField(); softproject.addFocusListener(new FocusAdapter(){ public void focusLost(FocusEvent e){ if(softproject.getText().equals("")){ JOptionPane.showMessageDialog(null,"必修课不能为空！"); } } }); maozedongs = new JLabel("毛泽东思想和中国特色社会主义概论"); maozedong = new JTextField(); maozedong.addFocusListener(new FocusAdapter(){ public void focusLost(FocusEvent e){ if(maozedong.getText().equals("")){JOptionPane.showMessageDialog(null,"必修课不能为空！");} } }); nets = new JLabel("计算机网络"); net = new JTextField(); net.addFocusListener(new FocusAdapter(){ public void focusLost(FocusEvent e){ if(net.getText().equals("")){JOptionPane.showMessageDialog(null,"必修课不能为空！");} } }); jiekous = new JLabel("微机原理与接口技术"); jiekou=new JTextField(); jiekou.addFocusListener(new FocusAdapter(){ public void focusLost(FocusEvent e){ if(jiekou.getText().equals("")){JOptionPane.showMessageDialog(null,"必修课不能为空！");} } }); graphicss = new JLabel("计算机图形学"); graphics = new JTextField(); bianyis = new JLabel("编译原理"); bianyi = new JTextField(); jiuyezhidaos = new JLabel("就业指导"); jiuyezhidao = new JTextField(); jiuyezhidao.addFocusListener(new FocusAdapter(){ public void focusLost(FocusEvent e){ if(jiuyezhidao.getText().equals(""))JOptionPane.showMessageDialog(null,"必修课不能为空！"); } }); juyuwangs = new JLabel("局域网"); juyuwang = new JTextField(); wangluoanquans = new JLabel("网络安全"); wangluoanquan = new JTextField(); deyus = new JLabel("德育分"); deyu = new JTextField(); c.add(ids); c.add(id); c.add(names); c.add(name); c.add(sexs); c.add(sex); c.add(shujukus); c.add(shujuku); c.add(oss); c.add(os); c.add(vbs); c.add(vb); c.add(zuchengs); c.add(zucheng); c.add(tongxins); c.add(tongxin); c.add(singlechips); c.add(singlechip); c.add(tcp_ips); c.add(tcp_ip); c.add(javas); c.add(java); c.add(softprojects); c.add(softproject); c.add(maozedongs); c.add(maozedong); c.add(nets); c.add(net); c.add(jiekous); c.add(jiekou); c.add(graphicss); c.add(graphics); c.add(bianyis); c.add(bianyi); c.add(jiuyezhidaos); c.add(jiuyezhidao); c.add(juyuwangs); c.add(juyuwang); c.add(wangluoanquans); c.add(wangluoanquan); c.add(deyus); c.add(deyu); singlechip.setText("0"); tcp_ip.setText("0"); java.setText("0"); bianyi.setText("0"); juyuwang.setText("0"); wangluoanquan.setText("0"); graphics.setText("0"); deyu.setText("0"); add = new JButton("添加"); add.addActionListener(this); exit = new JButton("exit"); exit.addActionListener(this); c.add(add); c.add(exit); this.setLocation(200,200); this.setTitle("由于水平有限，暂时做不到字符验证，为保证输入请不要使每选项置空！没有请置0"); this.getRootPane().setDefaultButton(add); this.setSize(400, 400); this.setResizable(false); this.setVisible(true); } public void actionPerformed(ActionEvent e) { if (e.getSource() == exit) { this.dispose(); } String id_s = id.getText(); String name_s = name.getText(); String sex_s = sex.getText(); int shujuku_s = Integer.parseInt(shujuku.getText()); int os_s = Integer.parseInt(os.getText()); int vb_s = Integer.parseInt(vb.getText()); int zucheng_s = Integer.parseInt(zucheng.getText()); int tongxin_s = Integer.parseInt(tongxin.getText()); int singlechip_s = Integer.parseInt(singlechip.getText()); int tcp_ip_s = Integer.parseInt(tcp_ip.getText()); int java_s = Integer.parseInt(java.getText()); int softproject_s = Integer.parseInt(softproject.getText()); int maozedong_s = Integer.parseInt(maozedong.getText()); int net_s = Integer.parseInt(net.getText()); int jiekou_s = Integer.parseInt(jiekou.getText()); int graphics_s = Integer.parseInt(graphics.getText()); int bianyi_s = Integer.parseInt(bianyi.getText()); int jiuyezhidao_s = Integer.parseInt(jiuyezhidao.getText()); int juyuwang_s = Integer.parseInt(juyuwang.getText()); int wangl