package?com.supermk;

import?javax.swing.*;


import?java.awt.*;
import?java.awt.event.*;
import?java.awt.*;
import?java.awt.event.*;
import?java.sql.*;

public?class?Add?extends?JDialog?implements?ActionListener
{

	public?static?final?String?Statement?=?null;
	
	JPanel?p?=?new?JPanel（）;
	JLabel?name=?new?JLabel（“會員卡號:“）;
	JTextField?t1?=?new?JTextField（）;
	JLabel?department?=?new?JLabel（“姓名:“）;
	JTextField?t2?=?new?JTextField（）;
	JLabel?phone?=??new?JLabel（“金額:“）;
	JTextField?t3?=?new?JTextField（）;
	JButton?b1=new?JButton（“提交“）;
	JButton?b2?=?new?JButton（“退出“）;

	
	public?Add（main?cString?titleboolean?modal）
	{
		super（ctitlemodal）;	
		this.setLayout（null）;//設置窗口布局管理器??
		this.setSize（300250）;
		name.setBounds（50606020）;
		this.add（name）;
		t1.setBounds（120608020）;
		this.add（t1）;
		department.setBounds（501006020）;
		this.add（department）;
		t2.setBounds（1201008020）;
		this.add（t2）;
		phone.setBounds（501406220）;
		this.add（phone）;
		t3.setBounds（1201408020）;
		this.add（t3）;
		
		b1.setBounds（801806020）;
		this.add（b1）;
		b2.setBounds（1601806020）;
		this.add（b2）;
		b1.addActionListener（this）;//給登陸按鈕添加監聽器?
		b2.addActionListener（this）;
		this.setVisible（true）;//設置窗口的可見性?
		this.setSize（300250）;//設置窗口的大小??????
	}
	

?	
	public?void?actionPerformed（ActionEvent?e）
	{
		String?driverName=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;//?定義數據庫驅動程序
		String?dbURL=“jdbc:sqlserver://localhost:1433;DatabaseName=Supermk“;//?定義數據庫的連接地址
		String?userName=“sa“;
		String?userPwd=“941118“;
		try
		{
			Class.forName（driverName）;//加載數據庫驅動
		}catch（java.lang.ClassNotFoundException?eee）
		{}
		
		
		if（e.getSource（）==b1）//處理登陸事件???????????
		{
			String?name=t1.getText（）;
			String?department=t2.getText（）;
			String?phone?=?t3.getText（）;
			if（t1.getText（）.equals（““）?||?t2.getText（）.equals（““）?||?t3.getText（）.equals（““））
			{
				JOptionPane.showMessageDialog（null“數據不完善，存在未填!“）;
				t1.setText（null）;
				t2.setText（null）;
				t3.setText（null）;
			}
			else
			{
				try{
					Connection?con=DriverManager.getConnection（dbURLuserNameuserPwd）;
					String?sql=“insert?into?vip（vipnuvipnayuer）?values（???）“;
					PreparedStatement?stmt=con.prepareStatement（sql）;//使用PreparedStatement接口來實現，是Statement子接口，實例化一個對象
					
					stmt.setString（1name）;//第一個問號的內容
					stmt.setString（2department）;//第二個
					stmt.setString（3phone）;//第三個
					
					stmt.execute（）;//執行數據庫更新操作
					
					stmt.close（）;//關閉操作
					con.close（）;//關閉數據庫
				}catch（Exception?e1）{
					System.out.println（e1.getMessage（））;
					JOptionPane.showMessageDialog（this?“插入出現問題請重新填寫數據“）;
					t1.setText（null）;
					t2.setText（null）;
					t3.setText（null）;
					return;
				}
				JOptionPane.showMessageDialog（this?“添加成功“）;
				dispose（）;??????
			}?????????????????????????
		}????
		
		if（e.getSource（）==b2）
		{
			dispose（）;
		}
	}
	
	
}

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

?????文件?????563117??2012-02-29?17:11??chaoshishouyin\sqljdbc.jar

?????文件?????584207??2012-02-29?17:11??chaoshishouyin\sqljdbc4.jar

?????文件????????440??2016-12-22?11:07??chaoshishouyin\supermk\.classpath

?????文件????????383??2016-12-22?10:20??chaoshishouyin\supermk\.project

?????文件????????116??2016-12-22?18:16??chaoshishouyin\supermk\.settings\org.eclipse.core.resources.prefs

?????文件????????598??2016-12-22?10:20??chaoshishouyin\supermk\.settings\org.eclipse.jdt.core.prefs

?????文件???????4066??2016-12-22?18:25??chaoshishouyin\supermk\bin\com\supermk\Add.class

?????文件???????5805??2016-12-22?18:45??chaoshishouyin\supermk\bin\com\supermk\main.class

?????文件?????317816??2013-06-08?12:27??chaoshishouyin\supermk\lib\jtds-1.3.1.jar

?????文件???????3307??2016-12-22?18:25??chaoshishouyin\supermk\src\com\supermk\Add.java

?????文件???????5503??2016-12-22?18:45??chaoshishouyin\supermk\src\com\supermk\main.java

?????文件????5242880??2016-12-22?18:53??chaoshishouyin\Supermk.mdf

?????文件????1048576??2016-12-22?18:53??chaoshishouyin\Supermk_log.ldf

?????文件?????232538??2016-12-22?19:49??chaoshishouyin\報告.docx

?????目錄??????????0??2016-12-22?18:54??chaoshishouyin\supermk\bin\com\supermk

?????目錄??????????0??2016-12-22?18:54??chaoshishouyin\supermk\src\com\supermk

?????目錄??????????0??2016-12-22?18:54??chaoshishouyin\supermk\bin\com

?????目錄??????????0??2016-12-22?18:54??chaoshishouyin\supermk\src\com

?????目錄??????????0??2016-12-22?18:54??chaoshishouyin\supermk\.settings

?????目錄??????????0??2016-12-22?18:54??chaoshishouyin\supermk\bin

?????目錄??????????0??2016-12-22?18:54??chaoshishouyin\supermk\lib

?????目錄??????????0??2016-12-22?18:54??chaoshishouyin\supermk\src

?????目錄??????????0??2016-12-22?18:54??chaoshishouyin\supermk

?????目錄??????????0??2016-12-22?19:54??chaoshishouyin

-----------?---------??----------?-----??----

??????????????8009352????????????????????24