package?TTMS1;

import?java.awt.*;
import?java.awt.event.*;
import?java.sql.*;
import?java.text.SimpleDateFormat;
import?java.util.Locale;
import?javax.swing.*;
import?javax.swing.table.DefaultTableCellRenderer;


public?class?C_yfksq?extends?JInternalframe?implements?ActionListener{


	private?DBTableModel?model;??
	private?JTable?table;
	private?String?unotno;
	Button?bt_insert?=?new?Button（“增加“）;
	Button?bt_delete?=?new?Button（“刪除“	）;
	Button?bt_update?=?new?Button（“修改“	）;
	Button?bt_save?=?new?Button（“保存“）;
	Button?bt_undo?=?new?Button（“撤消“）;
	Button?bt_exit?=?new?Button（“退出“）;
	java.util.Date?currDate?=?new?java.util.Date?（）;
	SimpleDateFormat?sdf?=?new?SimpleDateFormat?（“yyyy-MM-dd?HH:mm:ss“?Locale.getDefault（））;
	String?d?=?sdf.format?（currDate）;


	C_yfksq?（String?uidString?U）?{
		super?（“預付款申請“?false?true?true?true）;
		setSize?（680?280）;
		uno?=?U;
//-----------------取出最后插入的團隊編號---------------------------------------------------------------------		
		try{
			Connection?conn?=?DriverManager.getConnection（“jdbc:odbc:TTMS““sa“““）;
			Statement?stmt?=?conn.createStatement（）;
			ResultSet?rs?=?stmt.executeQuery（“SELECT?max（TeamID）?FROM?TeamInfo?where?UnitID?=‘“?+?uno+“‘“）;
			if（rs.next（）==?true）{
				tno?=?rs.getString（1）;
			}conn.close（）;
		}catch?（SQLException?e1）{}

//--------------------------------------------------------------------------------------------------------
	try{
			Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;
			Connection?conn?=?DriverManager.getConnection（“jdbc:odbc:TTMS““sa“““）;
			Statement?stmt?=?conn.createStatement（）;
			String?query?=?“select?Load_Account.VoucherID?as?憑證編號“?+
					“?UnitInfo.UnitName?as?單位名稱?“?+
					“Load_Account.LoadSum?as?續費金額ApplyDate?as?申請日期VerifyFlag?as?狀態?from?Load_Account“?+
					“UnitInfo?where?UnitInfo.UnitID?=Load_Account.UnitID?and?VerifyFlag?in?（?02）?and?“?+
					“UnitInfo.UnitName?=?‘“+uid+“‘“;//?UnitInfo.UnitType?in?（?23）“;
			ResultSet?rs?=?stmt.executeQuery（query）;
			model?=?new?DBTableModel（rs）;
			conn.close（）;
			table?=?new?JTable（model）;
	????????table.setPreferredScrollableViewportSize（new?Dimension（500?70））;
	????????table.setFillsViewportHeight（true）;
	????????DefaultTableCellRenderer?renderer?=?new?DefaultTableCellRenderer（）;
	????????renderer.setToolTipText（“0-未審核，1-審核通過，2-審核不通過，3-團隊結束，4-團隊資金結束“）;
	????????table.getColumnModel（）.getColumn（4）.setCellRenderer（renderer）;
	????????
		????

		}
		catch?（Exception?e）{
			System.out.println（e.toString（））;
		}
		
		Panel?p0?=?new?Panel（）;
		p0.add（new?Label（“??????????單位名稱：“））;
		TextField?A?=?new?TextField（25）;
		A.setText（uid）;
		A.setForeground?（Color.red）;
		A.setEditable（false）;
		p0.add（A）;
		p0.setLayout（new?FlowLayout（FlowLayout.LEFT））;
		add（p0BorderLayout.NORTH）;
		Panel?p1?=?new?Panel（）;

		//為按紐注冊監聽器
		bt_insert.addActionListener（this）;
		bt_delete.addActionListener（this）;
		bt_update.addActionListener（this）;
		

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

?????文件????????605??2003-10-27?23:24??image\main.gif

?????文件????????156??2004-06-28?11:57??image\main_1.gif

?????文件???????8654??2010-08-02?12:55??Java源代碼\C_yfksq.java

?????文件???????8057??2010-08-02?09:43??Java源代碼\C_ztsq.java

?????文件???????8438??2010-07-29?11:00??Java源代碼\DBTableModel.java

?????文件??????11940??2010-08-02?01:26??Java源代碼\H_jyqklr.java

?????文件???????8129??2010-08-01?22:38??Java源代碼\H_xfxmjg.java

?????文件???????7799??2010-07-31?23:21??Java源代碼\J_dwxxwh.java

?????文件???????7763??2010-08-02?15:53??Java源代碼\J_jtcl.java

?????文件???????9027??2010-08-02?15:14??Java源代碼\J_jysjsh.java

?????文件???????7408??2010-07-30?22:39??Java源代碼\J_xfxmwh.java

?????文件???????5947??2010-07-31?23:17??Java源代碼\J_yfksh.java

?????文件???????6061??2010-08-02?09:31??Java源代碼\J_ztjhsh.java

?????文件???????5305??2010-07-31?17:37??Java源代碼\login.java

?????文件???????2025??2010-07-28?03:02??Java源代碼\Main_cx.java

?????文件???????4327??2010-07-31?23:52??Java源代碼\Main_cydw.java

?????文件???????3705??2010-08-01?21:18??Java源代碼\Main_hzdw.java

?????文件???????7503??2010-07-30?23:17??Java源代碼\Main_jtzx.java

?????文件????????889??2010-07-26?12:43??Java源代碼\rowChanged.java

?????文件????????703??2010-07-26?12:43??Java源代碼\rowState.java

?????文件???????9856??2010-08-01?00:59??Java源代碼\sa.java

?????文件????1310720??2010-08-02?16:18??數據庫\數據庫分離文件\exp1_Data.MDF

?????文件????1048576??2010-08-02?16:18??數據庫\數據庫分離文件\exp1_Log.LDF

?????文件???????1177??2010-07-10?19:03??數據庫\數據庫源文件\store_procedure.txt

?????文件???????4427??2010-08-02?16:22??數據庫\數據庫源文件\TTMS1.sql

?????文件????????225??2010-08-02?17:59??readme.txt

?????文件?????137457??2010-09-26?21:33??旅游交易平臺.exe

?????文件??????84509??2010-08-02?16:14??旅游交易平臺.jar

?????文件?????152064??2010-08-02?17:52??實習報告.doc

?????目錄??????????0??2010-08-02?16:18??數據庫\數據庫分離文件

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