examframe.java

学生管理系统。使用java编程

package com.hb.exammanager;
import com.cloudgarden.layout.AnchorConstraint;
import com.cloudgarden.layout.AnchorLayout;
import com.hb.jdbcconnct.JdbcConnct;

import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.PreparedStatement;
import javax.swing.JButton;
import javax.swing.JPanel;
import javax.swing.JTable;
import javax.swing.JTextField;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import com.hb.jdbcconnct.JdbcConnct;

import javax.swing.WindowConstants;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;

/**
* This code was edited or generated using CloudGarden's Jigloo
* SWT/Swing GUI Builder, which is free for non-commercial
* use. If Jigloo is being used commercially (ie, by a corporation,
* company or business for any purpose whatever) then you
* should purchase a license for each developer using Jigloo.
* Please visit www.cloudgarden.com for details.
* Use of Jigloo implies acceptance of these licensing terms.
* A COMMERCIAL LICENSE HAS NOT BEEN PURCHASED FOR
* THIS MACHINE, SO JIGLOO OR THIS CODE CANNOT BE USED
* LEGALLY FOR ANY CORPORATE OR COMMERCIAL PURPOSE.
*/
public class ExamFrame extends javax.swing.JFrame {
	private JPanel examPanel;
	private JButton examFind;
	private JTable examTable;
	private JTextField examIdTextField;
	static JdbcConnct jdbcconn = new JdbcConnct();
	static Connection conn= jdbcconn.fetchConnection();

	/**
	* Auto-generated main method to display this JFrame
	*/
	public static void main(String[] args) {
		ExamFrame inst = new ExamFrame();
		inst.setVisible(true);
	}
	
	public ExamFrame() {
		super();
		initGUI();
	}
	
	private void initGUI() {
		try {
			setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
			{
				examPanel = new JPanel();
				getContentPane().add(examPanel, BorderLayout.CENTER);
				AnchorLayout examPanelLayout = new AnchorLayout();
				examPanel.setLayout(examPanelLayout);
				{
					TableModel examTableModel = new DefaultTableModel(
						new String[][] { { "One", "Two" },
								{ "Three", "Four" } },
						new String[] { "kaoshi", " mincheng" });
					examTable = new JTable();
					examPanel.add(examTable, new AnchorConstraint(283, 572, 98, 108, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_ABS, AnchorConstraint.ANCHOR_REL));
					examTable.setModel(examTableModel);
					examTable.setPreferredSize(new java.awt.Dimension(182, 98));
				}
				{
					examIdTextField = new JTextField();
					examPanel.add(examIdTextField, new AnchorConstraint(53, 269, 155, 108, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL));
					examIdTextField.setPreferredSize(new java.awt.Dimension(63, 28));
				}
				{
					examFind = new JButton();
					examPanel.add(examFind, new AnchorConstraint(53, 519, 130, 322, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL, AnchorConstraint.ANCHOR_REL));
					examFind.setText("\u67e5\u8be2");
					examFind.setPreferredSize(new java.awt.Dimension(77, 21));
					examFind.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							examFindActionPerformed(evt);
						}
					});
				}
			}
			pack();
			setSize(400, 300);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public int getExamId(){
		String regularE = "\\d{1,9}";
		String exFieldStr = this.examIdTextField.getText().trim();
		if(exFieldStr.matches(regularE))
		{
			int examId = Integer.parseInt(exFieldStr);
			return examId;
		}
		else 
			return -1;
	}
	public  void selectEx(){
		try
		{
			String sql = "select * from \"exam\" where \"examId\"=?";
			PreparedStatement stmt = conn.prepareStatement(sql);
			//String sql = "select * from \"exam\" ";
			ResultSet rs = stmt.executeQuery(sql);
			stmt.setInt(1,getExamId());
			while(rs.next())
			{
				int examId = rs.getInt("examId");
				//System.out.println(examId);
			}
		}catch(Exception e)
		{
			e.printStackTrace();
		}
		}
	
	private void examFindActionPerformed(ActionEvent evt) {
		//System.out.println("examFind.actionPerformed, event=" + evt);
		//TODO add your code for examFind.actionPerformed
		
	}

}