package?com.jisuanji.basic;

import?java.awt.BorderLayout;
import?java.awt.Container;
import?java.awt.FlowLayout;
import?java.awt.GridLayout;
import?java.awt.TextField;
import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.Vector;

import?javax.swing.JButton;
import?javax.swing.Jframe;
import?javax.swing.JLabel;
import?javax.swing.JOptionPane;
import?javax.swing.JPanel;
import?javax.swing.JScrollPane;
import?javax.swing.JTable;

import?com.jisuanji.util.DBConnection;

public?class?EmployeeChange?extends?Jframe?{

??/**
???*?serialVersionUID:uid。
???*/
??private?static?final?long?serialVersionUID?=?-7365605103752977221L;
??private?Connection?c1;
??private?JTable?display;
??private?JButton?comm_1?comm_2?comm_3;
??private?Statement?stmt1;
??private?ResultSet?rsl1;
??private?ResultSetmetaData?rsmd1;
??private?TextField?text_1?text_2?text_3?text_4?text_5?text_6;
??public?JPanel?panel;

??@SuppressWarnings（“deprecation“）
??public?EmployeeChange（）?{
????
????JPanel?button_con?=?new?JPanel（）;
????button_con.setLayout（new?FlowLayout（））;
????comm_1?=?new?JButton（“增加“）;
????comm_1.addActionListener（new?ActionListener（）?{
??????public?void?actionPerformed（ActionEvent?e）?{
????????addUser（）;
????????getpriceTable（）;
??????}
????}）;

????comm_2?=?new?JButton（“修改“）;
????comm_2.addActionListener（new?ActionListener（）?{
??????public?void?actionPerformed（ActionEvent?e）?{
????????changeUser（）;
????????getpriceTable（）;
??????}
????}）;

????comm_3?=?new?JButton（“刪除“）;
????comm_3.addActionListener（new?ActionListener（）?{
??????public?void?actionPerformed（ActionEvent?e）?{
????????deleteUser（）;
????????getpriceTable（）;
??????}
????}）;

????button_con.add（comm_1）;
????button_con.add（comm_2）;
????button_con.add（comm_3）;
????JPanel?label_con?=?new?JPanel（）;
????label_con.setLayout（new?GridLayout（1?3））;

????JLabel?lab_1?=?new?JLabel（“業務員編號“）;
????JLabel?lab_2?=?new?JLabel（“姓名“）;
????JLabel?lab_3?=?new?JLabel（“性別“）;
????JLabel?lab_4?=?new?JLabel（“年齡“）;
????JLabel?lab_5?=?new?JLabel（“政治面貌“）;
????JLabel?lab_6?=?new?JLabel（“密碼“）;
????label_con.add（lab_1）;
????label_con.add（lab_2）;
????label_con.add（lab_3）;
????label_con.add（lab_4）;
????label_con.add（lab_5）;
????label_con.add（lab_6）;
????JPanel?inputText_con?=?new?JPanel（）;
????inputText_con.setLayout（new?GridLayout（1?6））;
????text_1?=?new?TextField（）;
????text_2?=?new?TextField（）;
????text_3?=?new?TextField（）;
????text_4?=?new?TextField（）;
????text_5?=?new?TextField（）;
????text_6?=?new?TextField（）;
????inputText_con.add（text_1）;
????inputText_con.add（text_2）;
????inputText_con.add（text_3）;
????inputText_con.add（text_4）;
????inputText_con.add（text_5）;
????inputText_con.add（text_6）;
????JPanel?update_con?=?new?JPanel（）;
????update_con.setLay

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

?????文件????????428??2013-10-29?20:20??waterCostAdminSystem\.classpath

?????文件????????396??2013-10-29?19:36??waterCostAdminSystem\.project

?????文件????????598??2013-10-29?19:36??waterCostAdminSystem\.settings\org.eclipse.jdt.core.prefs

?????文件????????782??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\EmployeeChange$1.class

?????文件????????782??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\EmployeeChange$2.class

?????文件????????782??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\EmployeeChange$3.class

?????文件???????7027??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\EmployeeChange.class

?????文件???????2931??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\ShowEmployeeInfo.class

?????文件????????768??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\ShowNoPayUserInfo$1.class

?????文件???????4068??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\ShowNoPayUserInfo.class

?????文件????????762??2013-12-13?20:04??waterCostAdminSystem\bin\com\jisuanji\basic\ShowUserCostInfo$1.class

?????文件???????4105??2013-12-13?20:04??waterCostAdminSystem\bin\com\jisuanji\basic\ShowUserCostInfo.class

?????文件???????2896??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\ShowUserInfo.class

?????文件???????2899??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\ShowWaterInfo.class

?????文件???????2859??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\ShowWaterTypeInfo.class

?????文件????????782??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\UserCostChange$1.class

?????文件????????782??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\UserCostChange$2.class

?????文件????????782??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\UserCostChange$3.class

?????文件???????8671??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\UserCostChange.class

?????文件????????782??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\UserInfoChange$1.class

?????文件????????782??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\UserInfoChange$2.class

?????文件????????782??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\UserInfoChange$3.class

?????文件???????6800??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\UserInfoChange.class

?????文件????????764??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\WaterChange$1.class

?????文件????????764??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\WaterChange$2.class

?????文件????????764??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\WaterChange$3.class

?????文件???????8076??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\WaterChange.class

?????文件????????788??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\WaterTypeChange$1.class

?????文件????????788??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\WaterTypeChange$2.class

?????文件????????788??2013-12-13?19:56??waterCostAdminSystem\bin\com\jisuanji\basic\WaterTypeChange$3.class

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