modifyframe.java

学生成绩查询系统

package 学生成绩;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;

import java.sql.*;
import java.util.Vector;
import javax.swing.JButton;
import javax.swing.JTextField;
import javax.swing.BoxLayout;
import javax.swing.JLabel;
import javax.swing.JPanel;
import java.awt.CardLayout;
import javax.swing.JOptionPane;

public class ModifyFrame extends JPanel {

	 DataBaseManager db=new DataBaseManager();

	private JTextField jTextField1 = null;
	private JLabel jLabel = null;
	private JButton jButton = null;
	private JPanel jPanel = null;
	private JLabel jLabel2 = null;
	private JTextField jTextField2 = null;
	private JTextField jTextField3 = null;
	private JTextField jTextField4 = null;
	private JLabel jLabel3 = null;
	private JLabel jLabel4 = null;
	private JLabel jLabel5 = null;
	private JButton jButton1 = null;
	private JLabel jLabel6 = null;

	/**
	 * This method initializes 
	 * 
	 */
	public ModifyFrame() {
		super();
		initialize();
	}

	/**
	 * This method initializes this
	 * 
	 */
	private void initialize() {
        jLabel2 = new JLabel();
        jLabel2.setBounds(new java.awt.Rectangle(176,9,81,16));
        jLabel2.setText("修改成绩 ");
        jLabel = new JLabel();
        jLabel.setBounds(new java.awt.Rectangle(102,38,45,23));
        jLabel.setText("学号:");
        this.setLayout(null);
        this.setSize(new java.awt.Dimension(527,317));
        this.add(getJTextField1(), null);
        this.add(jLabel, null);
        this.add(getJButton(), null);
        this.add(getJPanel(), null);
        this.add(jLabel2, null);
			
	}

	/**
	 * This method initializes jTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			jTextField1 = new JTextField();
			jTextField1.setLocation(new java.awt.Point(166,38));
			jTextField1.setSize(new java.awt.Dimension(110,25));
		}
		return jTextField1;
	}

	/**
	 * This method initializes jButton	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setText("查询 ");
			jButton.setSize(new java.awt.Dimension(110,35));
			jButton.setLocation(new java.awt.Point(332,35));
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
                        try {
							find();
						} catch (SQLException e1) {
							// TODO 自动生成 catch 块
							e1.printStackTrace();
						}
				}
			});
		}
		return jButton;
	}

	/**
	 * This method initializes jPanel	
	 * 	
	 * @return javax.swing.JPanel	
	 */
	private JPanel getJPanel() {
		if (jPanel == null) {
			jLabel6 = new JLabel();
			jLabel6.setBounds(new java.awt.Rectangle(92,10,117,28));
			jLabel6.setText("请修改成绩:");
			jLabel5 = new JLabel();
			jLabel5.setBounds(new java.awt.Rectangle(37,152,47,26));
			jLabel5.setText("语文:");
			jLabel4 = new JLabel();
			jLabel4.setBounds(new java.awt.Rectangle(38,101,42,27));
			jLabel4.setText("英语:");
			jLabel3 = new JLabel();
			jLabel3.setBounds(new java.awt.Rectangle(36,53,43,26));
			jLabel3.setText("数学:");
			jPanel = new JPanel();
			jPanel.setLayout(null);
			jPanel.setBounds(new java.awt.Rectangle(27,85,462,215));
			jPanel.add(getJTextField2(), null);
			jPanel.add(getJTextField3(), null);
			jPanel.add(getJTextField4(), null);
			jPanel.add(jLabel3, null);
			jPanel.add(jLabel4, null);
			jPanel.add(jLabel5, null);
			jPanel.add(getJButton1(), null);
			jPanel.add(jLabel6, null);

		}
		jPanel.setVisible(false);
		return jPanel;
	}

	/**
	 * This method initializes jTextField2	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField2() {
		if (jTextField2 == null) {
			jTextField2 = new JTextField();
			jTextField2.setLocation(new java.awt.Point(96,52));
			jTextField2.setSize(new java.awt.Dimension(120,30));
		}
		return jTextField2;
	}

	/**
	 * This method initializes jTextField3	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField3() {
		if (jTextField3 == null) {
			jTextField3 = new JTextField();
			jTextField3.setLocation(new java.awt.Point(96,100));
			jTextField3.setSize(new java.awt.Dimension(120,30));
		}
		return jTextField3;
	}

	/**
	 * This method initializes jTextField4	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField4() {
		if (jTextField4 == null) {
			jTextField4 = new JTextField();
			jTextField4.setLocation(new java.awt.Point(96,150));
			jTextField4.setSize(new java.awt.Dimension(120,30));
		}
		return jTextField4;
	}

	/**
	 * This method initializes jButton1	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setLocation(new java.awt.Point(315,53));
			jButton1.setText("确认修改 ");
			jButton1.setSize(new java.awt.Dimension(110,35));
			jButton1.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
				try {
					modify();
				} catch (SQLException e1) {
					// TODO 自动生成 catch 块
					e1.printStackTrace();
				}
				
				JOptionPane.showMessageDialog(null,"修改数据成功！");
				}
			});
		}
		return jButton1;
	}
	
	  public void find() throws SQLException {
			String strSQL;
			strSQL="select * from result where studentID="+
			jTextField1.getText().trim();
			db.getResult(strSQL);
			if(db.res.first()){ 
				jPanel.setVisible(true);
				jTextField2.setText(db.res.getString(3));
			jTextField3.setText(db.res.getString(4));
			jTextField4.setText(db.res.getString(5));
			}
			
		    }
	  
	  void modify() throws SQLException
	  {
			String strSQL;
			strSQL="Update result set math="+jTextField2.getText().trim()+",english="+
			jTextField3.getText().trim()+",chinese="+jTextField4.getText().trim()
			+" where studentID="	+jTextField1.getText().trim();
			db.updateSql(strSQL);
	  }

}  //  @jve:decl-index=0:visual-constraint="143,20"