modform.java

这也是我们学完java之后的一个大型的作业

package student;

import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.Toolkit;

import javax.swing.JDesktopPane;
import javax.swing.JTextField;
import java.awt.Rectangle;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.JLabel;
import javax.swing.JButton;

public class ModForm {

	private JFrame jFrame = null;  //  @jve:decl-index=0:visual-constraint="120,-61"
	private JPanel jContentPane = null;
	private JDesktopPane jDesktopPane = null;
	JTextField jTextName = null;
	JTextField jTextNum = null;
	JTextField jTextFexam = null;
	JTextField jTextSexam = null;
	JTextField jTextTexam = null;
	private JLabel jLabelName = null;
	private JLabel jLabelNum = null;
	private JLabel jLabelFexam = null;
	private JLabel jLabelSexam = null;
	private JLabel jLabelTexam = null;
	private JButton jButtonOK = null;
	private JButton jButtonCancel = null;
	int Mark = MainForm.jTable.getSelectedRow();

	/**
	 * This method initializes jFrame	
	 * 	
	 * @return javax.swing.JFrame	
	 */
	JFrame getJFrame() {
		if (jFrame == null) {
			jFrame = new JFrame();
			jFrame.setTitle("修改信息");
			jFrame.setSize(new Dimension(218, 249));
			Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
			screenSize = Toolkit.getDefaultToolkit().getScreenSize();
			jFrame.setLocation((screenSize.width-jFrame.getWidth())/2,(screenSize.height-jFrame.getHeight())/2);
			jFrame.setContentPane(getJContentPane());
		}
		return jFrame;
	}

	/**
	 * This method initializes jContentPane	
	 * 	
	 * @return javax.swing.JPanel	
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jContentPane = new JPanel();
			jContentPane.setLayout(new BorderLayout());
			jContentPane.add(getJDesktopPane(), BorderLayout.CENTER);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jDesktopPane	
	 * 	
	 * @return javax.swing.JDesktopPane	
	 */
	private JDesktopPane getJDesktopPane() {
		if (jDesktopPane == null) {
			jLabelTexam = new JLabel();
			jLabelTexam.setBounds(new Rectangle(10, 140, 38, 18));
			jLabelTexam.setText("成绩3:");
			jLabelSexam = new JLabel();
			jLabelSexam.setBounds(new Rectangle(10, 110, 38, 18));
			jLabelSexam.setText("成绩2:");
			jLabelFexam = new JLabel();
			jLabelFexam.setBounds(new Rectangle(10, 80, 38, 18));
			jLabelFexam.setText("成绩1:");
			jLabelNum = new JLabel();
			jLabelNum.setBounds(new Rectangle(10, 50, 38, 18));
			jLabelNum.setText("学号:");
			jLabelName = new JLabel();
			jLabelName.setBounds(new Rectangle(10, 20, 38, 18));
			jLabelName.setText("姓名:");
			jDesktopPane = new JDesktopPane();
			jDesktopPane.add(getJTextName(), null);
			jDesktopPane.add(getJTextNum(), null);
			jDesktopPane.add(getJTextFexam(), null);
			jDesktopPane.add(getJTextSexam(), null);
			jDesktopPane.add(getJTextTexam(), null);
			jDesktopPane.add(jLabelName, null);
			jDesktopPane.add(jLabelNum, null);
			jDesktopPane.add(jLabelFexam, null);
			jDesktopPane.add(jLabelSexam, null);
			jDesktopPane.add(jLabelTexam, null);
			jDesktopPane.add(getJButtonOK(), null);
			jDesktopPane.add(getJButtonCancel(), null);
		}
		return jDesktopPane;
	}

	/**
	 * This method initializes jTextField	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextName() {
		if (jTextName == null) {
			jTextName = new JTextField();
			jTextName.setBounds(new Rectangle(50, 20, 150, 20));
			jTextName.setText((String) MainForm.jTable.getValueAt(Mark, 0));
		}
		return jTextName;
	}

	/**
	 * This method initializes jTextField1	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextNum() {
		if (jTextNum == null) {
			jTextNum = new JTextField();
			jTextNum.setBounds(new Rectangle(50, 50, 150, 20));
			jTextNum.setText((String) MainForm.jTable.getValueAt(Mark, 1));
		}
		return jTextNum;
	}

	/**
	 * This method initializes jTextField2	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextFexam() {
		if (jTextFexam == null) {
			jTextFexam = new JTextField();
			jTextFexam.setBounds(new Rectangle(50, 80, 150, 20));
			jTextFexam.setText((String) MainForm.jTable.getValueAt(Mark, 2));
		}
		return jTextFexam;
	}

	/**
	 * This method initializes jTextField3	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextSexam() {
		if (jTextSexam == null) {
			jTextSexam = new JTextField();
			jTextSexam.setBounds(new Rectangle(50, 110, 150, 20));
			jTextSexam.setText((String) MainForm.jTable.getValueAt(Mark, 3));
		}
		return jTextSexam;
	}

	/**
	 * This method initializes jTextField4	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextTexam() {
		if (jTextTexam == null) {
			jTextTexam = new JTextField();
			jTextTexam.setBounds(new Rectangle(50, 140, 150, 20));
			jTextTexam.setText((String) MainForm.jTable.getValueAt(Mark, 4));
		}
		return jTextTexam;
	}

	/**
	 * This method initializes jButtonOK	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButtonOK() {
		if (jButtonOK == null) {
			jButtonOK = new JButton();
			jButtonOK.setBounds(new Rectangle(15, 175, 80, 25));
			jButtonOK.setText("提交");
			jButtonOK.addMouseListener(new java.awt.event.MouseAdapter() {
				public void mouseClicked(java.awt.event.MouseEvent e) {
					try {
						MODSQL();
					} catch (Exception e1) {
						// TODO 自动生成 catch 块
						e1.printStackTrace();
					} // TODO Auto-generated Event stub mouseClicked()
				}

				private void MODSQL() throws Exception {
					String str = (String) MainForm.jTable.getValueAt(Mark, 1);
					String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
					String Str="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=Info";
					Connection con=null;
					Statement stmt=null;
					ResultSet rs=null;
					Class.forName(DBDriver);
					con=DriverManager.getConnection(Str);
					stmt=con.createStatement();
					String name = jTextName.getText();
					if(name.equals(""))
					{
						stmt.close();
						con.close();
						JOptionPane.showMessageDialog(new JDialog(),"姓名不能为空!");
						return;
					}
					String num = jTextNum.getText();
					if(num.equals(""))
					{
						stmt.close();
						con.close();
						JOptionPane.showMessageDialog(new JDialog(),"学号不能为空!");
						return;
					}
					else
					{
						if(!str.equals(num))
						{
							rs = stmt.executeQuery("Select * From Info where Num = '"+num+"'");
							if(rs.next())
							{
								stmt.close();
								con.close();
								JOptionPane.showMessageDialog(new JDialog(),"学号重复!");
								return;
							}
						}
					}
					String F = jTextFexam.getText();
					String S = jTextSexam.getText();
					String T = jTextTexam.getText();
					stmt.executeUpdate("Update Info Set Name='"+name+"',Num='"+num+"',Fexam='"+F+"',Sexam='"+S+"',Texam='"+T+"' where Num='"+str+"'");
					stmt.close();
					con.close();
					MainForm.Reflesh();
					getJFrame().dispose();
					JOptionPane.showMessageDialog(new JDialog(),"修改成功!");
				}
			});
		}
		return jButtonOK;
	}

	/**
	 * This method initializes jButtonCancel	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButtonCancel() {
		if (jButtonCancel == null) {
			jButtonCancel = new JButton();
			jButtonCancel.setBounds(new Rectangle(113, 175, 80, 25));
			jButtonCancel.setText("取消");
			jButtonCancel.addMouseListener(new java.awt.event.MouseAdapter() {
				public void mouseClicked(java.awt.event.MouseEvent e) {
					getJFrame().dispose(); // TODO Auto-generated Event stub mouseClicked()
				}
			});
		}
		return jButtonCancel;
	}

}