inputframe.java

学生成绩查询系统

package 学生成绩;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.JLabel;
import javax.swing.BoxLayout;
import javax.swing.JTextField;
import javax.swing.JButton;

public class InputFrame extends JPanel{
	 DataBaseManager db=new DataBaseManager();

	private JLabel jLabel1 = null;
	private JLabel jLabel2 = null;
	private JTextField jTextField = null;
	private JLabel jLabel = null;
	private JTextField jTextField1 = null;
	private JTextField jTextField2 = null;
	private JLabel jLabel3 = null;
	private JLabel jLabel4 = null;
	private JTextField jTextField3 = null;
	private JLabel jLabel5 = null;
	private JTextField jTextField4 = null;
	private JButton jButton = null;
	private JButton jButton1 = null;
	private JButton jButton2 = null;

	/**
	 * This method initializes 
	 * 
	 */
	public InputFrame() {
		super();
		initialize();
		this.setVisible(true);
	}

	/**
	 * This method initializes this
	 * 
	 */
	private void initialize() {
        jLabel5 = new JLabel();
        jLabel5.setBounds(new java.awt.Rectangle(46,231,53,31));
        jLabel5.setText("语文：");
        jLabel4 = new JLabel();
        jLabel4.setBounds(new java.awt.Rectangle(48,181,50,29));
        jLabel4.setText("英语：");
        jLabel3 = new JLabel();
        jLabel3.setBounds(new java.awt.Rectangle(49,128,52,32));
        jLabel3.setText("数学：");
        jLabel = new JLabel();
        jLabel.setBounds(new java.awt.Rectangle(48,93,49,26));
        jLabel.setText("姓名：");
        jLabel2 = new JLabel();
        jLabel2.setBounds(new java.awt.Rectangle(50,58,49,28));
        jLabel2.setText("学号：");
        jLabel1 = new JLabel();
        jLabel1.setBounds(new java.awt.Rectangle(46,5,143,42));
        jLabel1.setToolTipText("");
        jLabel1.setText("请录入学生信息和成绩：");
        this.setLayout(null);
        this.setSize(new java.awt.Dimension(527,272));
        this.add(jLabel1, null);
        this.add(jLabel2, null);
        this.add(getJTextField(), null);
        this.add(jLabel, null);
        this.add(getJTextField1(), null);
        this.add(getJTextField2(), null);
        this.add(jLabel3, null);
        this.add(jLabel4, null);
        this.add(getJTextField3(), null);
        this.add(jLabel5, null);
        this.add(getJTextField4(), null);
        this.add(getJButton(), null);
        this.add(getJButton1(), null);
        this.add(getJButton2(), null);
			
	}

	/**
	 * This method initializes jTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField() {
		if (jTextField == null) {
			jTextField = new JTextField();
			jTextField.setLocation(new java.awt.Point(118,60));
			jTextField.setSize(new java.awt.Dimension(150,30));
		}
		return jTextField;
	}

	/**
	 * This method initializes jTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField1() {
		if (jTextField1 == null) {
			jTextField1 = new JTextField();
			jTextField1.setLocation(new java.awt.Point(118,93));
			jTextField1.setSize(new java.awt.Dimension(150,30));
		}
		return jTextField1;
	}

	/**
	 * This method initializes jTextField2	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextField2() {
		if (jTextField2 == null) {
			jTextField2 = new JTextField();
			jTextField2.setLocation(new java.awt.Point(118,135));
			jTextField2.setSize(new java.awt.Dimension(150,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(118,179));
			jTextField3.setSize(new java.awt.Dimension(150,30));
		}
		return jTextField3;
	}

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

	/**
	 * 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(150,40));
			jButton.setLocation(new java.awt.Point(333,56));
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
				  try {
					write();
				} catch (SQLException e1) {
					// TODO 自动生成 catch 块
					e1.printStackTrace();
				}
				
				JOptionPane.showMessageDialog(null,"录入成绩成功");
				jTextField.setText("");
				jTextField1.setText("");
				jTextField2.setText("");
				jTextField3.setText("");
				jTextField4.setText("");
				
				}
			});
		}
		return jButton;
	}

	/**
	 * This method initializes jButton1	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton1() {
		if (jButton1 == null) {
			jButton1 = new JButton();
			jButton1.setText("重置");
			jButton1.setSize(new java.awt.Dimension(150,40));
			jButton1.setLocation(new java.awt.Point(333,116));
			jButton1.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					jTextField.setText("");
					jTextField1.setText("");
					jTextField2.setText("");
					jTextField3.setText("");
					jTextField4.setText("");
				}
			});
		}
		return jButton1;
	}

	/**
	 * This method initializes jButton2	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButton2() {
		if (jButton2 == null) {
			jButton2 = new JButton();
			jButton2.setLocation(new java.awt.Point(333,176));
			jButton2.setText("返回");
			jButton2.setSize(new java.awt.Dimension(150,40));
		}
		return jButton2;
	}
	
	
	  public void write() throws SQLException {
			String strSQL;
			strSQL="insert into result  values('"+jTextField.getText().trim()+"','"+
			jTextField1.getText().trim()+"','"+jTextField2.getText().trim()+"','"+
			jTextField3.getText().trim()+"','"+ jTextField4.getText().trim()+  "')";
			db.updateSql(strSQL);
		    }


}  //  @jve:decl-index=0:visual-constraint="185,21"