import?java.awt.GridBagLayout;
import?javax.swing.JPanel;
import?java.awt.Dimension;
import?javax.swing.JLabel;
import?java.awt.Rectangle;
import?javax.swing.JTextField;
import?javax.swing.JButton;
import?javax.swing.JScrollPane;
import?javax.swing.JTable;
import?javax.swing.ListSelectionModel;

import?java.awt.Color;
import?java.awt.GridBagConstraints;
import?java.awt.Insets;
import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.awt.event.MouseEvent;
import?java.awt.event.MouseListener;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.SQLException;
import?java.sql.Statement;

public?class?CBrouthForm?extends?JPanel?implements?ActionListenerMouseListener?{

	private?static?final?long?serialVersionUID?=?1L;
	private?JLabel?jLabel?=?null;
	private?JLabel?jLabel1?=?null;
	private?JLabel?jLabel2?=?null;
	private?JLabel?jLabel3?=?null;
	private?JLabel?jLabel4?=?null;
	private?JLabel?jLabel5?=?null;
	private?JLabel?jLabel6?=?null;
	private?JTextField?jTextField?=?null;
	private?JTextField?jTextField1?=?null;
	private?JTextField?jTextField2?=?null;
	private?JTextField?jTextField3?=?null;
	private?JTextField?jTextField4?=?null;
	private?JTextField?jTextField5?=?null;
	private?JButton?jButton?=?null;
	private?JButton?jButton1?=?null;
	private?JButton?jButton2?=?null;
	private?JScrollPane?jScrollPane?=?null;
	private?JTable?jTable?=?null;
	private?String[]?rowName={“記錄編號““ISBN““書名““作者““出版社““數量““是否已取“};
	private?object[][]?rowData;
	private?ListSelectionModel?selectionmodel=null;
	private?Statement?stmt;
	ResultSetmetaData?rsmd;
	private?PreparedStatement?prep;?
	int?row;
	int?column;
	Connection?connection=LoadSql.getlink（）;??//??@jve:decl-index=0:
	
	??private?object[][]?p?=?{?{?““?““?““?““?““?““?““}
				{?““?““?““?““?““?““?““}?{?““?““?““?““?““?““?““}
				{?““?““?““?““?““?““?““?}?{?““?““?““?““?““?““?““?}
				{?““?““?““?““?““?““?““}?{?““?““?““?““?““?““?““?}
				{?““?““?““?““?““?““?““?}?};
	/**
	?*?This?is?the?default?constructor
	?*/
	public?CBrouthForm（）?{
		super（）;
		initialize（）;
		setData（）;
	}
	public?void?setData（）{
		
		try?{
			
			stmt=connection.createStatement（java.sql.ResultSet.TYPE_SCROLL_INSENSITIVEjava.sql.ResultSet.CONCUR_UPDATABLE）;
			
			
		
		
		String?sql?=?“select?brouth_book_numbrouth_book_ISBNbrouth_book_namebrouth_book_authorbrouth_book_publishbrouth_book_amoutprepar_book_give?from?brouth_book“;

		
			
			ResultSet?result=stmt.executeQuery（sql）;
			?rsmd?=?result.getmetaData（）;
			if（result.next（））{
				result.beforeFirst（）;?//?指回第一條記錄
			int?q?=?1;
			
			while?（result.next（））?{//?計算記錄數
				q++;
			}
			
	?????????????rowData?=?new?object[q][7];//?用q和numberOfColumns初始化p1
			int?k?=?0;
			
			result.beforeFirst（）;?//?指回第一條記錄
			while?（result.next（

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????273??2007-11-28?15:19??教材管理系統\.classpath

?????文件????????356??2007-12-30?10:17??教材管理系統\.fatjar

?????文件????????514??2007-11-28?15:16??教材管理系統\.project

?????文件??????11128??2007-12-30?10:16??教材管理系統\bin\CBrouthForm.class

?????文件???????5503??2007-12-30?10:16??教材管理系統\bin\CBuyForm.class

?????文件???????2618??2007-12-30?10:16??教材管理系統\bin\CFlashScreen.class

?????文件???????3089??2007-12-30?10:16??教材管理系統\bin\CMainframe.class

?????文件????????923??2007-12-30?10:16??教材管理系統\bin\KMainframe.class

?????文件???????1128??2007-12-30?11:56??教材管理系統\bin\LoadSql.class

?????文件???????7580??2007-12-30?10:24??教材管理系統\bin\Login.class

?????文件??????59925??2007-11-29?18:45??教材管理系統\bin\Login.gif

?????文件???????1345??2007-12-30?10:16??教材管理系統\bin\MyTable.class

?????文件???????2618??2007-12-30?10:16??教材管理系統\bin\SFlashScreen.class

?????文件???????3442??2007-12-30?10:16??教材管理系統\bin\SMainframe.class

?????文件???????5880??2007-12-30?10:16??教材管理系統\bin\SNeedForm.class

?????文件??????12978??2007-12-30?10:16??教材管理系統\bin\SPreparForm.class

?????文件??????11330??2007-12-30?10:16??教材管理系統\bin\SSearchStore.class

?????文件??????53488??2007-12-28?10:45??教材管理系統\bin\start.wav

?????文件????????675??2007-12-30?10:16??教材管理系統\bin\TipSound.class

?????文件??????13526??2007-12-30?10:16??教材管理系統\bin\XAddForm.class

?????文件???????2618??2007-12-30?10:15??教材管理系統\bin\XFlashScreen.class

?????文件???????3184??2007-12-30?10:15??教材管理系統\bin\XMainframe.class

?????文件???????6010??2007-12-30?10:15??教材管理系統\bin\XPreparForm.class

?????文件????????188??2006-04-04?16:06??教材管理系統\pic\exit.gif

?????文件????????636??2006-04-04?22:29??教材管理系統\pic\key.gif

?????文件????????403??2006-04-19?19:27??教材管理系統\pic\refurbish.gif

????..A.SH.?????76800??2007-11-28?22:41??教材管理系統\pic\Thumbs.db

?????文件??????15806??2007-12-06?19:37??教材管理系統\src\CBrouthForm.java

?????文件???????5737??2007-12-02?22:14??教材管理系統\src\CBuyForm.java

?????文件???????1832??2007-12-02?22:25??教材管理系統\src\CFlashScreen.java

............此處省略24個文件信息