usermatainframe.java

本系统的设计模拟一般学校特别是高校的图书借阅管理内容

/*
 * Copyright (c) 2006 guodongping. All  Rights Reserved.
 * 
 * E-mail: [e-mail]
 * QQ:     445938759
 */
//package library;
import javax.swing.*;

import java.awt.Dimension;
import java.awt.Rectangle;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import java.awt.GridBagLayout;
import javax.swing.JLabel;
import javax.swing.JTextField;
import java.awt.BorderLayout;
import java.awt.GridLayout;
import javax.swing.JButton;
import java.awt.GridBagConstraints;
import java.awt.Insets;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.JComboBox;
import javax.swing.DefaultComboBoxModel;
import javax.swing.ComboBoxModel;


import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
/**
* This code was 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.
* *************************************
*/

/**
 * @author guodongping
 * 创建日期 2006-1-13
 * 用户维护界面
 */
public class UserMatainFrame extends javax.swing.JInternalFrame {
	private JPanel jPanel1;
	private JButton skimButton;
	private JButton lastButton;
	private JButton nextButton;
	private JButton preButton;
	private JButton closeButton;
	private JButton refreshButton;
	private JLabel jLabel4;
	private JLabel jLabel8;
	private JTextField classText;
	private JTextField deptText;
	private JLabel jLabel9;
	private JTextField inHandText;
	private JLabel jLabel7;
	private JTextField borrowedText;
	private JLabel jLabel6;
	private JComboBox kindText;
	private JLabel jLabel5;
	private JComboBox sexText;
	private JTextField nameText;
	private JLabel jLabel3;
	private JTextField noText;
	private JLabel jLabel2;
	private JButton deleteButton;
	private JButton modifyButton;
	private JButton addButton;
	private JLabel sumLabel;
	private JTextField posText;
	private JLabel jLabel1;
	private JPanel jPanel5;
	private JButton firstButton;
	private JPanel jPanel3;
	private JPanel jPanel4;
	private JPanel jPanel2;
	private String sqlCommand;
	private ResultSet rs;
	private Bridge bridge = new Bridge();
	private DbManage manage = new DbManage();
	private int rowCount = 0;

	public UserMatainFrame() {
		super("用户维护",true,true,true,true);
		initGUI();
	}
	
	private void initGUI() {
		try {
			setPreferredSize(new Dimension(400, 300));
			setBounds(new Rectangle(0, 0, 400, 300));
			setVisible(true);
			{
				jPanel1 = new JPanel();
				BorderLayout jPanel1Layout = new BorderLayout();
				this.getContentPane().add(jPanel1, BorderLayout.CENTER);
				jPanel1.setLayout(jPanel1Layout);
				{
					jPanel2 = new JPanel();
					BorderLayout jPanel2Layout1 = new BorderLayout();
					jPanel1.add(jPanel2, BorderLayout.CENTER);
					GridBagLayout jPanel2Layout = new GridBagLayout();
					jPanel2Layout.columnWidths = new int[] {7,7,7,7};
					jPanel2Layout.rowHeights = new int[] {7,7,7};
					jPanel2Layout.columnWeights = new double[] {0.1,0.1,0.1,0.1};
					jPanel2Layout.rowWeights = new double[] {0.1,0.1,0.1};
					jPanel2.setLayout(jPanel2Layout1);
					{
						jPanel4 = new JPanel();
						GridBagLayout jPanel4Layout1 = new GridBagLayout();
						jPanel4Layout1.columnWidths = new int[] {7,7,7,7};
						jPanel4Layout1.rowHeights = new int[] {7,7,7,7};
						jPanel4Layout1.columnWeights = new double[] {0.1,0.1,0.1,0.1};
						jPanel4Layout1.rowWeights = new double[] {0.1,0.1,0.1,0.1};
						jPanel2.add(jPanel4, BorderLayout.CENTER);
						GridLayout jPanel4Layout = new GridLayout(2, 5);
						jPanel4Layout.setColumns(5);
						jPanel4Layout.setRows(2);
						jPanel4.setLayout(jPanel4Layout1);
						{
							jLabel2 = new JLabel();
							jPanel4.add(jLabel2, new GridBagConstraints(
								0,
								0,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.CENTER,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
							jLabel2.setText("学号:");
						}
						{
							noText = new JTextField(5);
							jPanel4.add(noText, new GridBagConstraints(
								1,
								0,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.WEST,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
						}
						{
							jLabel3 = new JLabel();
							jPanel4.add(jLabel3, new GridBagConstraints(
								2,
								0,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.CENTER,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
							jLabel3.setText("姓名:");
						}
						{
							nameText = new JTextField(5);
							jPanel4.add(nameText, new GridBagConstraints(
								3,
								0,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.WEST,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
						}
						{
							jLabel4 = new JLabel();
							jPanel4.add(jLabel4, new GridBagConstraints(
								0,
								1,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.CENTER,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
							jLabel4.setText("性别:");
						}
						{
							ComboBoxModel sexTextModel = new DefaultComboBoxModel(
								new String[] { "男", "女" });
							sexText = new JComboBox();
							jPanel4.add(sexText, new GridBagConstraints(
								1,
								1,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.WEST,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
							sexText.setModel(sexTextModel);
						}
						{
							jLabel5 = new JLabel();
							jPanel4.add(jLabel5, new GridBagConstraints(
								2,
								1,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.CENTER,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
							jLabel5.setText("类别:");
						}
						{
							ComboBoxModel kindTextModel = new DefaultComboBoxModel(
								new String[] { "本科生", "研究生", "专科生" });
							kindText = new JComboBox();
							jPanel4.add(kindText, new GridBagConstraints(
								3,
								1,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.WEST,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
							kindText.setModel(kindTextModel);
						}
						{
							jLabel6 = new JLabel();
							jPanel4.add(jLabel6, new GridBagConstraints(
								0,
								3,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.CENTER,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
							jLabel6.setText("已借书数:");
						}
						{
							borrowedText = new JTextField(5);
							jPanel4.add(borrowedText, new GridBagConstraints(
								1,
								3,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.WEST,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
						}
						{
							jLabel7 = new JLabel();
							jPanel4.add(jLabel7, new GridBagConstraints(
								2,
								3,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.CENTER,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
							jLabel7.setText("未还书数:");
						}
						{
							inHandText = new JTextField(5);
							jPanel4.add(inHandText, new GridBagConstraints(
								3,
								3,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.WEST,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
						}
						{
							jLabel8 = new JLabel();
							jPanel4.add(jLabel8, new GridBagConstraints(
								0,
								2,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.CENTER,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
							jLabel8.setText("专业:");
						}
						{
							jLabel9 = new JLabel();
							jPanel4.add(jLabel9, new GridBagConstraints(
								2,
								2,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.CENTER,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
							jLabel9.setText("班级:");
						}
						{
							deptText = new JTextField(10);
							jPanel4.add(deptText, new GridBagConstraints(
								1,
								2,
								1,
								1,
								0.0,
								0.0,
								GridBagConstraints.WEST,
								GridBagConstraints.NONE,
								new Insets(0, 0, 0, 0),
								0,
								0));
						}
						{
							classText = new JTextField(8);
							jPanel4.add(classText, new GridBagConstraints(
								3,
								2,
								1,