package?admin;

import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

import?javax.swing.JDialog;
import?javax.swing.Jframe;
import?javax.swing.JPanel;
import?javax.swing.border.EmptyBorder;
import?javax.swing.JTextArea;
import?javax.swing.JButton;

public?class?AdminCard?extends?Jframe?implements?ActionListener?{

	private?JPanel?contentPane;
	private?JTextArea?setdata;
	private?JButton?btnReturn;

	/**
	?*?Create?the?frame.
	?*/
	public?AdminCard（）?{
		setDefaultCloseOperation（Jframe.EXIT_ON_CLOSE）;
		setBounds（600?200?448?476）;
		contentPane?=?new?JPanel（）;
		contentPane.setBorder（new?EmptyBorder（5?5?5?5））;
		setContentPane（contentPane）;
		contentPane.setLayout（null）;

		setdata?=?new?JTextArea（）;
		setdata.setBounds（49?37?325?155）;
		contentPane.add（setdata）;

		btnReturn?=?new?JButton（“\u8FD4\u56DE“）;
		btnReturn.setBounds（164?214?93?23）;
		contentPane.add（btnReturn）;
		btnReturn.addActionListener（this）;

		String?JDriver?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
		String?connectDB?=?“jdbc:sqlserver://127.0.0.1:1433;DatabaseName=javaapp“;
		try?{
			String?user?=?“sa“;
			String?password?=?“123“;
			Connection?con?=?DriverManager.getConnection（connectDB?user
					password）;
			Statement?stmt?=?con.createStatement（）;
			ResultSet?rs?=?stmt.executeQuery（“select?*?from?UserCard“）;
			while?（rs.next（））?{
				setdata.append（“卡號:“?+?rs.getString（“Numberno“）?+?“???姓名:“
						+?rs.getString（“Username“）?+?“???余額:“
						+?rs.getString（“Usercash“）?+?“??是否凍結:“
						+?rs.getString（“Congeal“）?+?“\r\n“）;
			}

		}?catch?（SQLException?e2）?{
			e2.printStackTrace（）;
			System.exit（0）;
		}
	}

	public?void?actionPerformed（ActionEvent?e）?{
		if?（e.getSource（）?==?btnReturn）?{
			AdminD?t?=?new?AdminD（）;
			t.setDefaultCloseOperation（JDialog.DISPOSE_ON_CLOSE）;
			t.setVisible（true）;
			this.setVisible（false）;
		}

	}
}

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

?????文件????????401??2015-07-14?22:31??ATM最終版\.classpath

?????文件????????388??2015-07-12?15:32??ATM最終版\.project

?????文件????????598??2015-07-12?15:32??ATM最終版\.settings\org.eclipse.jdt.core.prefs

?????文件???????3161??2015-07-14?22:31??ATM最終版\bin\admin\AdminCard.class

?????文件???????4054??2015-07-14?22:31??ATM最終版\bin\admin\AdminCongeal.class

?????文件???????2782??2015-07-14?22:31??ATM最終版\bin\admin\AdminD.class

?????文件???????3956??2015-07-14?23:05??ATM最終版\bin\admin\AdminRecord.class

?????文件????????716??2015-07-14?22:31??ATM最終版\bin\admin\AdminUser$1.class

?????文件???????5036??2015-07-14?22:31??ATM最終版\bin\admin\AdminUser.class

?????文件???????4197??2015-07-14?22:31??ATM最終版\bin\main\MainCha.class

?????文件???????5383??2015-07-14?22:31??ATM最終版\bin\main\MainCun.class

?????文件???????4888??2015-07-14?22:31??ATM最終版\bin\main\MainD.class

?????文件???????4702??2015-07-14?22:31??ATM最終版\bin\main\MainGai.class

?????文件???????6274??2015-07-14?22:31??ATM最終版\bin\main\MainJi.class

?????文件????????692??2015-07-15?18:21??ATM最終版\bin\main\MainL$1.class

?????文件???????4801??2015-07-15?18:21??ATM最終版\bin\main\MainL.class

?????文件???????5368??2015-07-14?22:31??ATM最終版\bin\main\MainQu.class

?????文件???????6128??2015-07-14?22:31??ATM最終版\bin\main\MainZhuan.class

?????文件????3145728??2015-07-12?22:01??ATM最終版\javaapp.mdf

?????文件????1048576??2015-07-12?22:01??ATM最終版\javaapp_log.ldf

?????文件?????448038??2009-03-26?09:31??ATM最終版\sqljdbc.jar

?????文件?????466359??2009-03-26?09:31??ATM最終版\sqljdbc4.jar

?????文件???????2107??2015-07-12?22:21??ATM最終版\src\admin\AdminCard.java

?????文件???????3540??2015-07-12?21:55??ATM最終版\src\admin\AdminCongeal.java

?????文件???????2970??2015-07-12?23:42??ATM最終版\src\admin\AdminD.java

?????文件???????3108??2015-07-14?23:05??ATM最終版\src\admin\AdminRecord.java

?????文件???????4365??2015-07-14?10:49??ATM最終版\src\admin\AdminUser.java

?????文件???????3564??2015-07-14?13:21??ATM最終版\src\main\MainCha.java

?????文件???????3918??2015-07-14?13:21??ATM最終版\src\main\MainCun.java

?????文件???????4288??2015-07-14?14:56??ATM最終版\src\main\MainD.java

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