package?xxx;

import?java.util.*;
import?javax.swing.*;
import?java.awt.*;
import?java.awt.event.*;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.Statement;
import?java.text.SimpleDateFormat;

public?class?Deposit?extends?JDialog?{
	TextField?money=new?TextField（10）;//金額
	public?Deposit（Jframe?mString?s）{
????super（ms）;
	setDefaultCloseOperation（WindowConstants.HIDE_ON_CLOSE）;
	setBounds（400250400200）;
	setVisible（true）;
	setResizable（false）;?
	setLayout（null）;?

	JLabel?label1=new?JLabel（“請輸入存款的金額“）;
	label1.setFont（new?Font（“Serif“Font.BOLD20））;
	JLabel?label2=new?JLabel（“金額：“）;
	label2.setFont（new?Font（“Serif“Font.BOLD13））;
	
	JButton?button1=new?JButton（“確認“）;
	BHandler?h=new?BHandler（）;
	button1.addActionListener（h）;
	
	JPanel?p1=new?JPanel（）;??
	JPanel?p2=new?JPanel（）;??

	p1.setBounds（0020070）;?
	p1.add（label1）;
	p2.setBounds（257040050）;?
	p2.add（label2）;
	p2.add（money）;
	p2.add（button1）;
	
	add（p1）;
	add（p2）;
	setVisible（true）;
	
	}
	public?static?int?deposit（int?kdouble?j）{
		try{
			
	????	//1.注冊驅動??
			?String?driverClassName?=?“com.mysql.jdbc.Driver“;??
		?????Class.forName（“com.mysql.jdbc.Driver“）;??
					?//2.連接數據庫???
		?????Connection?conn?=?DriverManager.getConnection（“jdbc:mysql://localhost:3306/bank““root“““）;?
		?????Statement?stmt=conn.createStatement（）;
		?????ResultSet?rs=stmt.executeQuery（“select?*?from?user?where?card_no=‘“+k+“‘“）;
		?
		?????if（rs.next（））?{????
		????	?j=rs.getInt（“balance“）+j;
		????	?stmt.executeUpdate（“Update?user?set??balance=‘“+j+“‘where?card_no=‘“+k+“‘“）;
				?rs.close（）;
			?????stmt.close（）;
			?????conn.close（）;
			?????return?1;
		?????}
		?????
		}
	????catch（Exception?sqle）{
	????????System.err.println（sqle）;
	????????return?2;
	????}
		return?0;
	}
	public?static?int?dInsertIntoOperation（int?kdouble?jdouble?b）{
		try{
			//1.注冊驅動??
			?String?driverClassName?=?“com.mysql.jdbc.Driver“;??
			?Class.forName（“com.mysql.jdbc.Driver“）;??
			?//2.連接數據庫???
			?Connection?conn?=?DriverManager.getConnection（“jdbc:mysql://localhost:3306/bank““root“““）;?
			?Statement?stmt=conn.createStatement（）;
			?String?time=new?SimpleDateFormat（“yyyy-MM-dd?HH:mm:ss“）.format（Calendar.getInstance（）.getTime（））;
			?String?sql=“insert?into?operation?values（?????）“;
			?PreparedStatement?ps=（PreparedStatement）?conn.prepareStatement（sql）;
			?ps.setInt（1k）;
			?ps.setString（2time）;
			?ps.setString（3“存款“）;
			?ps.setDouble（4j）;
			?ps.setDouble（5b）;
			?ps.executeUpdate（）;
			?ps.close（）;
			?stmt.close（）;
			?conn.close（）;
			?return?1;
		?}
		catch（Exception?sqle）{
????????????System.err.println（sqle）;
??????????return?3;
		}
	}
	public?class?BHandler?implements?ActionListener?{
		public?void?actionPerformed?（ActionEvent?event）?{
			if（!（money.getText（）.equals（““）））{
				int?i=0;
				int?k=Integer

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

?????文件?????509669??2018-06-27?16:53??銀行管理系統\bank-UML圖.uml

?????文件???????2816??2018-06-27?16:26??銀行管理系統\bank-數據庫.sql

?????文件????????436??2018-06-03?23:10??銀行管理系統\bank代碼\.classpath

?????文件????????377??2018-05-26?22:16??銀行管理系統\bank代碼\.project

?????文件????????598??2018-05-26?22:16??銀行管理系統\bank代碼\.settings\org.eclipse.jdt.core.prefs

?????文件???????1808??2018-06-27?16:05??銀行管理系統\bank代碼\bin\xxx\Deposit$BHandler.class

?????文件???????4387??2018-06-27?16:05??銀行管理系統\bank代碼\bin\xxx\Deposit.class

?????文件????????624??2018-06-27?14:08??銀行管理系統\bank代碼\bin\xxx\Display$BHandler.class

?????文件???????3815??2018-06-27?14:08??銀行管理系統\bank代碼\bin\xxx\Display.class

?????文件???????1413??2018-06-27?16:18??銀行管理系統\bank代碼\bin\xxx\HomePage$BHandler.class

?????文件???????2684??2018-06-27?16:18??銀行管理系統\bank代碼\bin\xxx\HomePage.class

?????文件???????1786??2018-06-18?17:01??銀行管理系統\bank代碼\bin\xxx\Login.class

?????文件???????1947??2018-06-27?16:05??銀行管理系統\bank代碼\bin\xxx\Menu$BHandler.class

?????文件???????4555??2018-06-27?16:05??銀行管理系統\bank代碼\bin\xxx\Menu.class

?????文件???????1604??2018-06-27?16:05??銀行管理系統\bank代碼\bin\xxx\ModifyPassword$BHandler.class

?????文件???????3964??2018-06-27?16:05??銀行管理系統\bank代碼\bin\xxx\ModifyPassword.class

?????文件???????2168??2018-06-26?21:52??銀行管理系統\bank代碼\bin\xxx\Register$BHandler.class

?????文件???????4686??2018-06-26?21:52??銀行管理系統\bank代碼\bin\xxx\Register.class

?????文件???????1340??2018-06-18?17:04??銀行管理系統\bank代碼\bin\xxx\SelectModify$BHandler.class

?????文件???????5019??2018-06-18?17:04??銀行管理系統\bank代碼\bin\xxx\SelectModify.class

?????文件????????690??2018-06-27?14:42??銀行管理系統\bank代碼\bin\xxx\TransactionDetails$BHandler.class

?????文件???????4439??2018-06-27?14:42??銀行管理系統\bank代碼\bin\xxx\TransactionDetails.class

?????文件???????2035??2018-06-27?14:09??銀行管理系統\bank代碼\bin\xxx\Transfer$BHandler.class

?????文件???????4925??2018-06-27?14:09??銀行管理系統\bank代碼\bin\xxx\Transfer.class

?????文件???????1878??2018-06-27?14:42??銀行管理系統\bank代碼\bin\xxx\Withdraw$BHandler.class

?????文件???????4468??2018-06-27?14:42??銀行管理系統\bank代碼\bin\xxx\Withdraw.class

?????文件???????3499??2018-06-27?16:05??銀行管理系統\bank代碼\src\xxx\Deposit.java

?????文件???????2214??2018-06-27?14:08??銀行管理系統\bank代碼\src\xxx\Display.java

?????文件???????2909??2018-06-27?16:18??銀行管理系統\bank代碼\src\xxx\HomePage.java

?????文件???????1032??2018-06-18?17:01??銀行管理系統\bank代碼\src\xxx\Login.java

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