java学生学籍管理系统

package studentmanage; import java.awt.BorderLayout; import java.awt.Dimension; import javax.swing.JFrame; import javax.swing.JPanel; import com.borland.jbcl.layout.XYLayout; import com.borland.jbcl.layout.*; import javax.swing.JLabel; import javax.swing.JTextField; import javax.swing.JComboBox; import java.awt.Font; import javax.swing.JButton; import java.awt.*; import javax.swing.BorderFactory; import javax.swing.border.EtchedBorder; import javax.swing.border.Border; import javax.swing.border.TitledBorder; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Statement; import javax.swing.JOptionPane; import java.sql.Connection; import java.sql.SQLException; import java.sql.ResultSet; import javax.swing.border.BevelBorder; import javax.swing.UIManager; /** * <p>Title: </p> * * <p>Description: </p> * * <p>Copyright: Copyright (c) 2010</p> * * <p>Company: </p> * * @author not attributable * @version 1.0 */ public class Score_EditF extends JFrame { JPanel contentPane; XYLayout xYLayout1 = new XYLayout(); JLabel jLabel1 = new JLabel(); JLabel jLabel2 = new JLabel(); JTextField jTextField1 = new JTextField(); JTextField jTextField2 = new JTextField(); JLabel jLabel3 = new JLabel(); JLabel jLabel4 = new JLabel(); JTextField jTextField3 = new JTextField(); String[] arrChoose = {"数据结构","java程序设计","网络数据库技术","c/c++程序设计"}; JComboBox jComboBox1 = new JComboBox(arrChoose); JButton jButton1 = new JButton(); JButton jButton2 = new JButton(); JButton jButton3 = new JButton(); JButton jButton4 = new JButton(); JButton jButton5 = new JButton(); JButton jButton6 = new JButton(); JPanel jPanel1 = new JPanel(); XYLayout xYLayout2 = new XYLayout(); Border border1 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED, Color.white, new Color(148, 145, 140)); Border border2 = new TitledBorder(border1, "学生成绩信息"); TitledBorder titledBorder1 = new TitledBorder(""); Border border3 = BorderFactory.createEtchedBorder(Color.white, new Color(148, 145, 140)); Border border4 = new TitledBorder(border3, "学生考试信息"); JPanel jPanel2 = new JPanel(); Border border5 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED, Color.white, new Color(148, 145, 140)); Border border6 = new TitledBorder(border5, "选择操作"); XYLayout xYLayout3 = new XYLayout(); JLabel jLabel5 = new JLabel(); JTextField jTextField4 = new JTextField(); JLabel jLabel6 = new JLabel(); JTextField jTextField5 = new JTextField(); JPanel jPanel3 = new JPanel(); XYLayout xYLayout4 = new XYLayout(); Border border7 = BorderFactory.createBevelBorder(BevelBorder.RAISED, Color.white, Color.white, new Color(107, 111, 115), new Color(153, 159, 165)); Border border8 = BorderFactory.createBevelBorder(BevelBorder.RAISED, Color.white, Color.white, new Color(107, 111, 115), new Color(153, 159, 165)); Border border9 = new TitledBorder(border8, "请输入学号进行操作"); Border border10 = BorderFactory.createBevelBorder(BevelBorder.LOWERED, Color.white, Color.white, new Color(107, 111, 115), new Color(153, 159, 165)); Border border11 = new TitledBorder(border10, "请输入学号进行操作"); public Score_EditF() { try { setDefaultCloseOperation(EXIT_ON_CLOSE); jbInit(); } catch (Exception exception) { exception.printStackTrace(); } } /** * Component initialization. * * @throws java.lang.Exception */ private void jbInit() throws Exception { contentPane = (JPanel) getContentPane(); contentPane.setLayout(xYLayout1); setSize(new Dimension(388, 384)); setTitle("学生成绩管理"); jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jLabel1.setText("学 号："); jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jLabel2.setText("姓 名："); jTextField2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jLabel3.setText("课 程："); jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jLabel4.setText("成 绩："); jTextField3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jTextField1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jTextField1.addActionListener(new Score_EditF_jTextField1_actionAdapter(this)); jComboBox1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jButton1.setText("查询该生成绩"); jButton1.addActionListener(new Score_EditF_jButton1_actionAdapter(this)); jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jButton2.setText("修改该生成绩"); jButton2.addActionListener(new Score_EditF_jButton2_actionAdapter(this)); jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jButton3.setText("添加学生成绩"); jButton3.addActionListener(new Score_EditF_jButton3_actionAdapter(this)); jButton4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jButton4.setText("删除该生成绩"); jButton4.addActionListener(new Score_EditF_jButton4_actionAdapter(this)); jButton5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jButton5.setText("重 置"); jButton5.addActionListener(new Score_EditF_jButton5_actionAdapter(this)); jButton6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jButton6.setText("退 出"); jButton6.addActionListener(new Score_EditF_jButton6_actionAdapter(this)); jPanel1.setLayout(xYLayout2); jPanel1.setBackground(new Color(210, 230, 255)); jPanel1.setBorder(border4); jPanel2.setBackground(new Color(210, 230, 255)); jPanel2.setBorder(border6); jPanel2.setLayout(xYLayout3); jButton3.addActionListener(new Score_EditF_jButton3_actionAdapter(this)); jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jLabel5.setText("班 级："); jTextField4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jLabel6.setText("课程编号："); jTextField5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); jPanel3.setLayout(xYLayout4); jPanel3.setBackground(new Color(190, 223, 255)); jPanel3.setBorder(border11); contentPane.setBackground(new Color(210, 223, 249)); jPanel2.add(jButton5, new XYConstraints(36, 219, 71, -1)); jPanel2.add(jButton6, new XYConstraints(36, 259, 71, -1)); jPanel2.add(jButton3, new XYConstraints(20, 110, 107, -1)); jPanel2.add(jButton2, new XYConstraints(20, 61, -1, -1)); jPanel2.add(jButton4, new XYConstraints(20, 160, 107, -1)); jPanel1.add(jLabel5, new XYConstraints(9, 108, 55, 27)); jPanel1.add(jTextField4, new XYConstraints(57, 108, 118, 25)); jPanel1.add(jLabel6, new XYConstraints(0, 208, 65, 27)); jPanel1.add(jTextField5, new XYConstraints(57, 208, 118, 25)); jPanel1.add(jLabel4, new XYConstraints(9, 258, 55, 27)); jPanel1.add(jTextField3, new XYConstraints(57, 258, 118, 25)); contentPane.add(jPanel1, new XYConstraints(168, 11, 202, 328)); contentPane.add(jPanel2, new XYConstraints(13, 10, 150, 328)); jPanel2.add(jButton1, new XYConstraints(20, 9, 105, 27)); jPanel1.add(jLabel2, new XYConstraints(9, 158, 55, 27)); jPanel1.add(jTextField2, n