java - 當刪除選定列時，如何儲存進database
你好，各位大神，我卡关了，当我删除所选列时，并按下删除按钮，Jtable确实是把该列删了，但当我再次开启时，其删除列并没有删除，我想原因是其变动并没有储存进数据库，请问各位大神具体实作方式要怎麽做?
我是用MVC去实作的，数据库使用Sqlite，另外想请问各位大神当我要做修改的动作时，按下修改钮时，Jtable可以进行修改，且储存进资料库，想请问各位大神具体实作方式是怎麽实现?
//以下为Model
package model;
import java.sql.*;
import entities.*;
import java.util.*;
import javax.swing.JTable;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;
public class ClientModel extends AbstractTableModel {
private List<Client> listClient = new ArrayList<Client>();
//Search all data
public List<Client> findAll() {
List<Client> listClient = new ArrayList<>();
try {
PreparedStatement ps = ConnectDB.getConn().prepareStatement("select * from client");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
Client c = new Client();
c.setCategory(rs.getString("category"));
c.setOrganization(rs.getString("organization"));
c.setName(rs.getString("name"));
c.setNo(rs.getInt("no"));
c.setZip(rs.getString("zip"));
c.setAddress(rs.getString("address"));
c.setCellnumber(rs.getString("cellnumber"));
c.setFax(rs.getString("fax"));
c.setEmail(rs.getString("email"));
c.setBirthday(rs.getDate("birthday"));
listClient.add(c);
}
return listClient;
} catch (Exception e) {
e.printStackTrace();
System.out.println(e);
return null;
}
}
//Search data
public Client find(int no) {
Client c = null;
try {
PreparedStatement ps = ConnectDB.getConn().prepareStatement("select * from client" + "where category = ?, where organization = ?"
+ "where name = ?, where no = ?, where zip = ?, where address = ?, where landline = ?, where cellnumber = ?, where fax = ?, where email = ?, where birthday = ?");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
c = new Client();
c.setCategory(rs.getString("category"));
c.setOrganization(rs.getString("organization"));
c.setName(rs.getString("name"));
c.setNo(rs.getInt("no"));
c.setZip(rs.getString("zip"));
c.setAddress(rs.getString("address"));
c.setCellnumber(rs.getString("cellnumber"));
c.setFax(rs.getString("fax"));
c.setEmail(rs.getString("email"));
c.setBirthday(rs.getDate("birthday"));
}
} catch (Exception e) {
c = null;
}
return c;
}
//add data
public boolean create(Client client) {
boolean result = true;
try {
PreparedStatement ps = ConnectDB.getConn().prepareStatement(
"insert into client(category, organization, name, no, zip, address, cellnumber, fax, email, birthday) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
ps.setString(1, client.getCategory());
ps.setString(2, client.getOrganization());
ps.setString(3, client.getName());
ps.setInt(4, client.getNo());
ps.setString(5, client.getZip());
ps.setString(6, client.getAddress());
ps.setString(7, client.getCellnumber());
ps.setString(8, client.getFax());
ps.setString(9, client.getEmail());
ps.setDate(10, new java.sql.Date(client.getBirthday().getTime()));
result = ps.executeUpdate() > 0;
} catch (Exception e) {
result = false;
}
return result;
}
// delete data
public void removeSelectedFromTable(JTable clientTable) {
int[] rows = clientTable.getSelectedRows();
TableModel tm = (DefaultTableModel) clientTable.getModel();
for (int row : rows) {
((DefaultTableModel) tm).removeRow(clientTable.convertRowIndexToModel(row));
}
clientTable.setModel(tm);
}
package model;
import java.sql.*;
public class ConnectDB {
private static Connection connection = null;
public static Connection getConn() {
try {
Class.forName("org.sqlite.JDBC");
System.out.println("驅動載入成功");
connection = DriverManager.getConnection("jdbc:sqlite:D:\\work\\sileai2\\sileai_db\\sileai.db");
System.out.println("連接到資料庫");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return connection;
}
public static void closeConn() {
try {
if (connection != null) {
connection.close();
}
connection = null;
} catch (Exception e) {
e.printStackTrace();
}
}
}
//以下为Entities
package entities;
import java.text.SimpleDateFormat;
import java.util.*;
public class Client {
private String category;
private String organization;
private String name;
private int no;
private String zip;
private String address;
private String cellnumber;
private String fax;
private String email;
private Date birthday;
public Client(String category, String organization, String name, int no, String zip, String address,
String landline, String cellnumber, String fax, String email, Date birthday) {
super();
this.category = category;
this.organization = organization;
this.name = name;
this.no = no;
this.zip = zip;
this.address = address;
this.cellnumber = cellnumber;
this.fax = fax;
this.email = email;
this.birthday = birthday;
}
public Client() {
super();
}
public String getCategory() {
return category;
}
public void setCategory(String category) {
this.category = category;
}
public String getOrganization() {
return organization;
}
public void setOrganization(String organization) {
this.organization = organization;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getNo() {
return no;
}
public void setNo(int no) {
this.no = no;
}
public String getZip() {
return zip;
}
public void setZip(String zip) {
this.zip = zip;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getLandline() {
return landline;
}
public void setLandline(String landline) {
this.landline = landline;
}
public String getCellnumber() {
return cellnumber;
}
public void setCellnumber(String cellnumber) {
this.cellnumber = cellnumber;
}
public String getFax() {
return fax;
}
public void setFax(String fax) {
this.fax = fax;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
}
//以下为demo
package demo;
import java.awt.*;
import javax.swing.*;
import javax.swing.border.EmptyBorder;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableColumn;
import java.util.*;
import java.text.*;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import javax.swing.border.LineBorder;
import com.toedter.calendar.JCalendar;
import com.toedter.calendar.JDayChooser;
import com.toedter.components.JSpinField;
import model.*;
import entities.*;
import com.toedter.components.JLocaleChooser;
import com.toedter.calendar.JDateChooser;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.beans.*;
@SuppressWarnings("serial")
public class SileaiFrame extends JFrame {
// 宣告
private ClientModel cm = new ClientModel();
private JPanel contentPane;
private JTable jfta_ResultTable;
private JTabbedPane jftp_0;
private JLayeredPane clientLayeredPane;
private JTextField organizationTextField;
private JTextField addressTextField;
private JTextField nameTextField;
private JLabel organizationLabel;
private JLabel nameLabel;
private JLabel addressLabel;
private JScrollPane clientScrollPane;
private JLabel categoryLabel;
private JLayeredPane jflp_1;
private JTabbedPane jftp_10;
private JLayeredPane jflp_10;
private JLayeredPane jflp_11;
private JLayeredPane jflp_3;
private JComboBox DeliveryComboBox;
private JLayeredPane activityLayeredPane;
private JLabel ActivityDatelabel;
private JLabel label_1;
private JComboBox comboBox_3;
private JLabel label_2;
private JComboBox comboBox_4;
private JLabel label_3;
private JTextField textField;
private JLabel label_4;
private JTextArea textArea;
private JLabel label_5;
private JTextField textField_1;
private JLabel label_6;
private JTextArea textArea_1;
private JButton button;
private JButton button_1;
private JLabel label_7;
private JTextField textField_2;
private JButton btnNewButton;
private JButton btnNewButton_1;
private JLabel label_13;
private JLabel noLabel;
private JTextField noTextField;
private JLabel landlineLabel;
private JTextField landlineTextField;
private JLabel cellnumberLabel;
private JLabel faxLabel;
private JTextField cellnumberTextField;
private JLabel emailLabel;
private JLabel zipLabel;
private JTextField zipTextField;
private JTextField emailTextField;
private JLabel Label;
private JComboBox categoryComboBox;
private JMenuBar exportMenuBar;
private JMenu exportMenu;
private JMenuItem pdfMenuItem;
private JMenuItem csvMenuItem;
private JTextField faxTextField;
private JCalendar calendar;
private JDateChooser search1DateChooser;
private JLabel label;
private JDateChooser dateChooser_3;
private JDateChooser dateChooser_4;
private JTable clientTable;
private JLayeredPane searchLayeredPane;
private JButton readButton;
private JButton deleteButton;
private JButton updateButton;
/**
* Launch the application.
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
SileaiFrame Jframe = new SileaiFrame();
Jframe.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
System.out.print(e);
}
}
});
}
/**
* Create the frame.
*
* @throws ParseException
*/
@SuppressWarnings("rawtypes")
// Swing主體
public SileaiFrame() throws ParseException {
setTitle("資料管理系統");
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 793, 477);
exportMenuBar = new JMenuBar();
setJMenuBar(exportMenuBar);
exportMenu = new JMenu("匯出");
exportMenuBar.add(exportMenu);
pdfMenuItem = new JMenuItem("PDF");
exportMenu.add(pdfMenuItem);
csvMenuItem = new JMenuItem("CSV");
exportMenu.add(csvMenuItem);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
contentPane.setLayout(new BorderLayout(0, 0));
setContentPane(contentPane);
jftp_0 = new JTabbedPane(JTabbedPane.TOP);
contentPane.add(jftp_0, BorderLayout.CENTER);
jfta_ResultTable = new JTable();
clientLayeredPane = new JLayeredPane();
jftp_0.addTab("基本資料", null, clientLayeredPane, null);
GridBagLayout gbl_clientLayeredPane = new GridBagLayout();
gbl_clientLayeredPane.columnWidths = new int[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
gbl_clientLayeredPane.rowHeights = new int[] { 0, 0, 0, 0, 0, 0, 0 };
gbl_clientLayeredPane.columnWeights = new double[] { 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 0.0, 1.0, 0.0,
Double.MIN_VALUE };
gbl_clientLayeredPane.rowWeights = new double[] { 0.0, 0.0, 0.0, 0.0, 0.0, 1.0, Double.MIN_VALUE };
clientLayeredPane.setLayout(gbl_clientLayeredPane);
categoryLabel = new JLabel("類別");
GridBagConstraints gbc_categoryLabel = new GridBagConstraints();
gbc_categoryLabel.insets = new Insets(0, 0, 5, 5);
gbc_categoryLabel.gridx = 0;
gbc_categoryLabel.gridy = 0;
clientLayeredPane.add(categoryLabel, gbc_categoryLabel);
categoryComboBox = new JComboBox();
categoryComboBox.setEditable(true);
categoryComboBox.setModel(new DefaultComboBoxModel(new String[] { "活動", "捐物", "捐款", "會員", "客戶", "廠商", "政商" }));
GridBagConstraints gbc_categoryComboBox = new GridBagConstraints();
gbc_categoryComboBox.fill = GridBagConstraints.HORIZONTAL;
gbc_categoryComboBox.insets = new Insets(0, 0, 5, 5);
gbc_categoryComboBox.gridx = 1;
gbc_categoryComboBox.gridy = 0;
clientLayeredPane.add(categoryComboBox, gbc_categoryComboBox);
organizationLabel = new JLabel("單位");
GridBagConstraints gbc_organizationLabel = new GridBagConstraints();
gbc_organizationLabel.insets = new Insets(0, 0, 5, 5);
gbc_organizationLabel.gridx = 2;
gbc_organizationLabel.gridy = 0;
clientLayeredPane.add(organizationLabel, gbc_organizationLabel);
organizationTextField = new JTextField();
GridBagConstraints gbc_organizationTextField = new GridBagConstraints();
gbc_organizationTextField.fill = GridBagConstraints.HORIZONTAL;
gbc_organizationTextField.insets = new Insets(0, 0, 5, 5);
gbc_organizationTextField.gridx = 3;
gbc_organizationTextField.gridy = 0;
clientLayeredPane.add(organizationTextField, gbc_organizationTextField);
organizationTextField.setColumns(10);
nameLabel = new JLabel("客戶姓名");
GridBagConstraints gbc_nameLabel = new GridBagConstraints();
gbc_nameLabel.insets = new Insets(0, 0, 5, 5);
gbc_nameLabel.gridx = 4;
gbc_nameLabel.gridy = 0;
clientLayeredPane.add(nameLabel, gbc_nameLabel);
nameTextField = new JTextField();
GridBagConstraints gbc_nameTextField = new GridBagConstraints();
gbc_nameTextField.fill = GridBagConstraints.HORIZONTAL;
gbc_nameTextField.insets = new Insets(0, 0, 5, 5);
gbc_nameTextField.gridx = 5;
gbc_nameTextField.gridy = 0;
clientLayeredPane.add(nameTextField, gbc_nameTextField);
nameTextField.setColumns(10);
noLabel = new JLabel("客戶代號");
GridBagConstraints gbc_noLabel = new GridBagConstraints();
gbc_noLabel.insets = new Insets(0, 0, 5, 5);
gbc_noLabel.gridx = 6;
gbc_noLabel.gridy = 0;
clientLayeredPane.add(noLabel, gbc_noLabel);
noTextField = new JTextField();
GridBagConstraints gbc_noTextField = new GridBagConstraints();
gbc_noTextField.insets = new Insets(0, 0, 5, 5);
gbc_noTextField.fill = GridBagConstraints.HORIZONTAL;
gbc_noTextField.gridx = 7;
gbc_noTextField.gridy = 0;
clientLayeredPane.add(noTextField, gbc_noTextField);
noTextField.setColumns(10);
zipLabel = new JLabel("郵區");
GridBagConstraints gbc_zipLabel = new GridBagConstraints();
gbc_zipLabel.insets = new Insets(0, 0, 5, 5);
gbc_zipLabel.gridx = 0;
gbc_zipLabel.gridy = 1;
clientLayeredPane.add(zipLabel, gbc_zipLabel);
zipTextField = new JTextField();
GridBagConstraints gbc_zipTextField = new GridBagConstraints();
gbc_zipTextField.insets = new Insets(0, 0, 5, 5);
gbc_zipTextField.fill = GridBagConstraints.HORIZONTAL;
gbc_zipTextField.gridx = 1;
gbc_zipTextField.gridy = 1;
clientLayeredPane.add(zipTextField, gbc_zipTextField);
zipTextField.setColumns(10);
addressLabel = new JLabel("地址");
GridBagConstraints gbc_addressLabel = new GridBagConstraints();
gbc_addressLabel.insets = new Insets(0, 0, 5, 5);
gbc_addressLabel.gridx = 2;
gbc_addressLabel.gridy = 1;
clientLayeredPane.add(addressLabel, gbc_addressLabel);
addressTextField = new JTextField();
GridBagConstraints gbc_addressTextField = new GridBagConstraints();
gbc_addressTextField.fill = GridBagConstraints.HORIZONTAL;
gbc_addressTextField.gridwidth = 2;
gbc_addressTextField.insets = new Insets(0, 0, 5, 5);
gbc_addressTextField.gridx = 3;
gbc_addressTextField.gridy = 1;
clientLayeredPane.add(addressTextField, gbc_addressTextField);
addressTextField.setColumns(10);
landlineLabel = new JLabel("市話");
GridBagConstraints gbc_landlineLabel = new GridBagConstraints();
gbc_landlineLabel.insets = new Insets(0, 0, 5, 5);
gbc_landlineLabel.gridx = 5;
gbc_landlineLabel.gridy = 1;
clientLayeredPane.add(landlineLabel, gbc_landlineLabel);
landlineTextField = new JTextField();
GridBagConstraints gbc_landlineTextField = new GridBagConstraints();
gbc_landlineTextField.gridwidth = 2;
gbc_landlineTextField.insets = new Insets(0, 0, 5, 5);
gbc_landlineTextField.fill = GridBagConstraints.HORIZONTAL;
gbc_landlineTextField.gridx = 6;
gbc_landlineTextField.gridy = 1;
clientLayeredPane.add(landlineTextField, gbc_landlineTextField);
landlineTextField.setColumns(10);
cellnumberLabel = new JLabel("手機");
GridBagConstraints gbc_cellnumberLabel = new GridBagConstraints();
gbc_cellnumberLabel.insets = new Insets(0, 0, 5, 5);
gbc_cellnumberLabel.gridx = 0;
gbc_cellnumberLabel.gridy = 2;
clientLayeredPane.add(cellnumberLabel, gbc_cellnumberLabel);
cellnumberTextField = new JTextField();
cellnumberTextField.setColumns(10);
GridBagConstraints gbc_cellnumberTextField = new GridBagConstraints();
gbc_cellnumberTextField.fill = GridBagConstraints.HORIZONTAL;
gbc_cellnumberTextField.anchor = GridBagConstraints.WEST;
gbc_cellnumberTextField.insets = new Insets(0, 0, 5, 5);
gbc_cellnumberTextField.gridx = 1;
gbc_cellnumberTextField.gridy = 2;
clientLayeredPane.add(cellnumberTextField, gbc_cellnumberTextField);
faxLabel = new JLabel("傳真");
GridBagConstraints gbc_faxLabel = new GridBagConstraints();
gbc_faxLabel.insets = new Insets(0, 0, 5, 5);
gbc_faxLabel.gridx = 2;
gbc_faxLabel.gridy = 2;
clientLayeredPane.add(faxLabel, gbc_faxLabel);
faxTextField = new JTextField();
GridBagConstraints gbc_faxTextField = new GridBagConstraints();
gbc_faxTextField.insets = new Insets(0, 0, 5, 5);
gbc_faxTextField.fill = GridBagConstraints.HORIZONTAL;
gbc_faxTextField.gridx = 3;
gbc_faxTextField.gridy = 2;
clientLayeredPane.add(faxTextField, gbc_faxTextField);
faxTextField.setColumns(10);
emailLabel = new JLabel("信箱");
GridBagConstraints gbc_emailLabel = new GridBagConstraints();
gbc_emailLabel.insets = new Insets(0, 0, 5, 5);
gbc_emailLabel.gridx = 4;
gbc_emailLabel.gridy = 2;
clientLayeredPane.add(emailLabel, gbc_emailLabel);
emailTextField = new JTextField();
GridBagConstraints gbc_emailTextField = new GridBagConstraints();
gbc_emailTextField.insets = new Insets(0, 0, 5, 5);
gbc_emailTextField.fill = GridBagConstraints.HORIZONTAL;
gbc_emailTextField.gridx = 5;
gbc_emailTextField.gridy = 2;
clientLayeredPane.add(emailTextField, gbc_emailTextField);
emailTextField.setColumns(10);
Label = new JLabel("生日");
GridBagConstraints gbc_Label = new GridBagConstraints();
gbc_Label.insets = new Insets(0, 0, 5, 5);
gbc_Label.gridx = 0;
gbc_Label.gridy = 3;
clientLayeredPane.add(Label, gbc_Label);
JDateChooser birthdayDateChooser = new JDateChooser();
birthdayDateChooser.setDateFormatString("yyyy-MM-dd");
GridBagConstraints gbc_birthdayDateChooser = new GridBagConstraints();
gbc_birthdayDateChooser.fill = GridBagConstraints.HORIZONTAL;
birthdayDateChooser.setBounds(20, 20, 200, 20);
gbc_birthdayDateChooser.insets = new Insets(0, 0, 5, 5);
gbc_birthdayDateChooser.gridx = 1;
gbc_birthdayDateChooser.gridy = 3;
clientLayeredPane.add(birthdayDateChooser, gbc_birthdayDateChooser);
label = new JLabel("~");
GridBagConstraints gbc_label = new GridBagConstraints();
gbc_label.insets = new Insets(0, 0, 5, 5);
gbc_label.gridx = 2;
gbc_label.gridy = 3;
clientLayeredPane.add(label, gbc_label);
search1DateChooser = new JDateChooser();
GridBagConstraints gbc_search1DateChooser = new GridBagConstraints();
gbc_search1DateChooser.fill = GridBagConstraints.HORIZONTAL;
gbc_search1DateChooser.insets = new Insets(0, 0, 5, 5);
gbc_search1DateChooser.gridx = 3;
gbc_search1DateChooser.gridy = 3;
clientLayeredPane.add(search1DateChooser, gbc_search1DateChooser);
JButton createButton = new JButton("新增");
createButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
Client c = new Client();
if (!noTextField.getText().trim().equals("")) {
c.setCategory(categoryComboBox.getSelectedItem().toString());
c.setOrganization(organizationTextField.getText());
c.setName(nameTextField.getText());
c.setNo(Integer.parseInt(noTextField.getText()));
c.setZip(zipTextField.getText());
c.setAddress(addressTextField.getText());
c.setCellnumber(cellnumberTextField.getText());
c.setEmail(emailTextField.getText());
c.setFax(faxTextField.getText());
c.setBirthday(birthdayDateChooser.getDate());
if (cm.create(c)) {
JOptionPane.showMessageDialog(null, "新增客戶資料成功");
LoadData();
} else
JOptionPane.showMessageDialog(null, "新增客戶資料失敗");
} else {
JOptionPane.showMessageDialog(null, "客戶編號不得為空");
}
}
});
GridBagConstraints gbc_createButton = new GridBagConstraints();
gbc_createButton.insets = new Insets(0, 0, 5, 5);
gbc_createButton.gridx = 4;
gbc_createButton.gridy = 4;
clientLayeredPane.add(createButton, gbc_createButton);
readButton = new JButton("查詢");
readButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
}
});
GridBagConstraints gbc_readButton = new GridBagConstraints();
gbc_readButton.insets = new Insets(0, 0, 5, 5);
gbc_readButton.gridx = 5;
gbc_readButton.gridy = 4;
clientLayeredPane.add(readButton, gbc_readButton);
deleteButton = new JButton("刪除");
deleteButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
cm.removeSelectedFromTable(clientTable);
categoryComboBox.setSelectedItem("");
organizationTextField.setText("");
nameTextField.setText("");
noTextField.setText("");
zipTextField.setText("");
addressTextField.setText("");
cellnumberTextField.setText("");
faxTextField.setText("");
emailTextField.setText("");
birthdayDateChooser.setDate(null);
}
});
GridBagConstraints gbc_deleteButton = new GridBagConstraints();
gbc_deleteButton.insets = new Insets(0, 0, 5, 5);
gbc_deleteButton.gridx = 6;
gbc_deleteButton.gridy = 4;
clientLayeredPane.add(deleteButton, gbc_deleteButton);
updateButton = new JButton("修改");
updateButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
DefaultTableModel dtm = (DefaultTableModel) clientTable.getModel();
//Client c = new Client();
//if (cm.edit(c)) {
cm.editSelectedFromTable(clientTable);
categoryComboBox.getSelectedItem().toString();
organizationTextField.getText();
nameTextField.getText();
Integer.parseInt(noTextField.getText());
zipTextField.getText();
addressTextField.getText();
cellnumberTextField.getText();
emailTextField.getText();
faxTextField.getText();
birthdayDateChooser.getDate();
}
});
GridBagConstraints gbc_updateButton = new GridBagConstraints();
gbc_updateButton.insets = new Insets(0, 0, 5, 5);
gbc_updateButton.gridx = 7;
gbc_updateButton.gridy = 4;
clientLayeredPane.add(updateButton, gbc_updateButton);
clientScrollPane = new JScrollPane();
GridBagConstraints gbc_clientScrollPane = new GridBagConstraints();
gbc_clientScrollPane.gridwidth = 9;
gbc_clientScrollPane.fill = GridBagConstraints.BOTH;
gbc_clientScrollPane.gridx = 0;
gbc_clientScrollPane.gridy = 5;
clientLayeredPane.add(clientScrollPane, gbc_clientScrollPane);
clientTable = new JTable();
clientTable.addMouseListener(new MouseAdapter() {
@Override
public void mouseClicked(MouseEvent arg0) {
categoryComboBox.setSelectedItem(clientTable.getValueAt(clientTable.getSelectedRow(), 0).toString());
organizationTextField.setText(clientTable.getValueAt(clientTable.getSelectedRow(), 1).toString());
nameTextField.setText(clientTable.getValueAt(clientTable.getSelectedRow(), 2).toString());
noTextField.setText(clientTable.getValueAt(clientTable.getSelectedRow(), 3).toString());
zipTextField.setText(clientTable.getValueAt(clientTable.getSelectedRow(), 4).toString());
addressTextField.setText(clientTable.getValueAt(clientTable.getSelectedRow(), 5).toString());
landlineTextField.setText(clientTable.getValueAt(clientTable.getSelectedRow(), 6).toString());
cellnumberTextField.setText(clientTable.getValueAt(clientTable.getSelectedRow(), 7).toString());
faxTextField.setText(clientTable.getValueAt(clientTable.getSelectedRow(), 8).toString());
emailTextField.setText(clientTable.getValueAt(clientTable.getSelectedRow(), 9).toString());
birthdayDateChooser.setDate((java.util.Date) clientTable.getValueAt(clientTable.getSelectedRow(), 10));
}
});
clientScrollPane.setViewportView(clientTable);
LoadData();
activityLayeredPane = new JLayeredPane();
jftp_0.addTab("活動紀錄", null, activityLayeredPane, null);
activityLayeredPane.setForeground(Color.GRAY);
activityLayeredPane.setBackground(SystemColor.menu);
GridBagLayout gbl_activityLayeredPane = new GridBagLayout();
gbl_activityLayeredPane.columnWidths = new int[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
gbl_activityLayeredPane.rowHeights = new int[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
gbl_activityLayeredPane.columnWeights = new double[] { 0.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 0.0 };
gbl_activityLayeredPane.rowWeights = new double[] { 1.0, 1.0, 1.0, 1.0, 0.0, 1.0, 1.0, 1.0, 1.0, 0.0,
Double.MIN_VALUE };
activityLayeredPane.setLayout(gbl_activityLayeredPane);
activityLayeredPane.setOpaque(true);
ActivityDatelabel = new JLabel("日期");
GridBagConstraints gbc_ActivityDatelabel = new GridBagConstraints();
gbc_ActivityDatelabel.insets = new Insets(0, 0, 5, 5);
gbc_ActivityDatelabel.gridx = 1;
gbc_ActivityDatelabel.gridy = 0;
activityLayeredPane.add(ActivityDatelabel, gbc_ActivityDatelabel);
dateChooser_3 = new JDateChooser();
GridBagConstraints gbc_dateChooser_3 = new GridBagConstraints();
gbc_dateChooser_3.insets = new Insets(0, 0, 5, 5);
gbc_dateChooser_3.fill = GridBagConstraints.HORIZONTAL;
gbc_dateChooser_3.gridx = 2;
gbc_dateChooser_3.gridy = 0;
activityLayeredPane.add(dateChooser_3, gbc_dateChooser_3);
label_5 = new JLabel("負責人員");
GridBagConstraints gbc_label_5 = new GridBagConstraints();
gbc_label_5.insets = new Insets(0, 0, 5, 5);
gbc_label_5.gridx = 3;
gbc_label_5.gridy = 0;
activityLayeredPane.add(label_5, gbc_label_5);
textField_1 = new JTextField();
GridBagConstraints gbc_textField_1 = new GridBagConstraints();
gbc_textField_1.fill = GridBagConstraints.HORIZONTAL;
gbc_textField_1.gridwidth = 2;
gbc_textField_1.insets = new Insets(0, 0, 5, 5);
gbc_textField_1.gridx = 4;
gbc_textField_1.gridy = 0;
activityLayeredPane.add(textField_1, gbc_textField_1);
textField_1.setColumns(10);
label_2 = new JLabel("參與方式");
GridBagConstraints gbc_label_2 = new GridBagConstraints();
gbc_label_2.insets = new Insets(0, 0, 5, 5);
gbc_label_2.gridx = 6;
gbc_label_2.gridy = 0;
activityLayeredPane.add(label_2, gbc_label_2);
comboBox_4 = new JComboBox();
GridBagConstraints gbc_comboBox_4 = new GridBagConstraints();
gbc_comboBox_4.fill = GridBagConstraints.HORIZONTAL;
gbc_comboBox_4.insets = new Insets(0, 0, 5, 5);
gbc_comboBox_4.gridx = 7;
gbc_comboBox_4.gridy = 0;
activityLayeredPane.add(comboBox_4, gbc_comboBox_4);
label_1 = new JLabel("活動類型");
GridBagConstraints gbc_label_1 = new GridBagConstraints();
gbc_label_1.insets = new Insets(0, 0, 5, 5);
gbc_label_1.gridx = 1;
gbc_label_1.gridy = 1;
activityLayeredPane.add(label_1, gbc_label_1);
comboBox_3 = new JComboBox();
GridBagConstraints gbc_comboBox_3 = new GridBagConstraints();
gbc_comboBox_3.fill = GridBagConstraints.HORIZONTAL;
gbc_comboBox_3.insets = new Insets(0, 0, 5, 5);
gbc_comboBox_3.gridx = 2;
gbc_comboBox_3.gridy = 1;
activityLayeredPane.add(comboBox_3, gbc_comboBox_3);
label_3 = new JLabel("活動名稱");
GridBagConstraints gbc_label_3 = new GridBagConstraints();
gbc_label_3.fill = GridBagConstraints.VERTICAL;
gbc_label_3.insets = new Insets(0, 0, 5, 5);
gbc_label_3.gridx = 1;
gbc_label_3.gridy = 2;
activityLayeredPane.add(label_3, gbc_label_3);
textField = new JTextField();
GridBagConstraints gbc_textField = new GridBagConstraints();
gbc_textField.insets = new Insets(0, 0, 5, 5);
gbc_textField.fill = GridBagConstraints.HORIZONTAL;
gbc_textField.gridx = 2;
gbc_textField.gridy = 2;
activityLayeredPane.add(textField, gbc_textField);
textField.setColumns(10);
textArea = new JTextArea();
GridBagConstraints gbc_textArea = new GridBagConstraints();
gbc_textArea.gridwidth = 4;
gbc_textArea.gridheight = 3;
gbc_textArea.insets = new Insets(0, 0, 5, 5);
gbc_textArea.fill = GridBagConstraints.BOTH;
gbc_textArea.gridx = 6;
gbc_textArea.gridy = 1;
activityLayeredPane.add(textArea, gbc_textArea);
label_4 = new JLabel("說明");
GridBagConstraints gbc_label_4 = new GridBagConstraints();
gbc_label_4.insets = new Insets(0, 0, 5, 5);
gbc_label_4.gridx = 5;
gbc_label_4.gridy = 2;
activityLayeredPane.add(label_4, gbc_label_4);
textArea_1 = new JTextArea();
GridBagConstraints gbc_textArea_1 = new GridBagConstraints();
gbc_textArea_1.gridheight = 3;
gbc_textArea_1.gridwidth = 3;
gbc_textArea_1.insets = new Insets(0, 0, 5, 5);
gbc_textArea_1.fill = GridBagConstraints.BOTH;
gbc_textArea_1.gridx = 2;
gbc_textArea_1.gridy = 3;
activityLayeredPane.add(textArea_1, gbc_textArea_1);
label_6 = new JLabel("備註");
GridBagConstraints gbc_label_6 = new GridBagConstraints();
gbc_label_6.insets = new Insets(0, 0, 5, 5);
gbc_label_6.gridx = 1;
gbc_label_6.gridy = 4;
activityLayeredPane.add(label_6, gbc_label_6);
button = new JButton("搜尋");
GridBagConstraints gbc_button = new GridBagConstraints();
gbc_button.insets = new Insets(0, 0, 5, 5);
gbc_button.gridx = 7;
gbc_button.gridy = 5;
activityLayeredPane.add(button, gbc_button);
button_1 = new JButton("新增");
GridBagConstraints gbc_button_1 = new GridBagConstraints();
gbc_button_1.insets = new Insets(0, 0, 5, 5);
gbc_button_1.gridx = 8;
gbc_button_1.gridy = 5;
activityLayeredPane.add(button_1, gbc_button_1);
JScrollPane scrollPane_1 = new JScrollPane();
GridBagConstraints gbc_scrollPane_1 = new GridBagConstraints();
gbc_scrollPane_1.gridheight = 4;
gbc_scrollPane_1.gridwidth = 8;
gbc_scrollPane_1.insets = new Insets(0, 0, 0, 5);
gbc_scrollPane_1.fill = GridBagConstraints.BOTH;
gbc_scrollPane_1.gridx = 2;
gbc_scrollPane_1.gridy = 6;
activityLayeredPane.add(scrollPane_1, gbc_scrollPane_1);
JTabbedPane tabbedPane_2 = new JTabbedPane(JTabbedPane.TOP);
scrollPane_1.setColumnHeaderView(tabbedPane_2);
label_7 = new JLabel("搜尋結果");
GridBagConstraints gbc_label_7 = new GridBagConstraints();
gbc_label_7.insets = new Insets(0, 0, 5, 5);
gbc_label_7.gridx = 1;
gbc_label_7.gridy = 7;
activityLayeredPane.add(label_7, gbc_label_7);
jflp_1 = new JLayeredPane();
jftp_0.addTab("交易資料", null, jflp_1, null);
jflp_1.setLayout(new BorderLayout(0, 0));
jftp_10 = new JTabbedPane(JTabbedPane.TOP);
jflp_1.add(jftp_10, BorderLayout.CENTER);
jflp_10 = new JLayeredPane();
jftp_10.addTab("查詢", null, jflp_10, null);
GridBagLayout gbl_jflp_10 = new GridBagLayout();
gbl_jflp_10.columnWidths = new int[] { 0, 0, 0, 0, 0 };
gbl_jflp_10.rowHeights = new int[] { 0, 0, 0, 0, 0 };
gbl_jflp_10.columnWeights = new double[] { 0.0, 0.0, 0.0, 1.0, Double.MIN_VALUE };
gbl_jflp_10.rowWeights = new double[] { 0.0, 0.0, 1.0, 0.0, Double.MIN_VALUE };
jflp_10.setLayout(gbl_jflp_10);
jflp_11 = new JLayeredPane();
jftp_10.addTab("資料", null, jflp_11, null);
jflp_3 = new JLayeredPane();
jftp_0.addTab("捐款紀錄", null, jflp_3, null);
JPanel ContactPanel = new JPanel();
jftp_0.addTab("聯絡紀錄", null, ContactPanel, null);
GridBagLayout gbl_ContactPanel = new GridBagLayout();
gbl_ContactPanel.columnWidths = new int[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
gbl_ContactPanel.rowHeights = new int[] { 0, 0, 0, 0, 0, 0, 0 };
gbl_ContactPanel.columnWeights = new double[] { 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0,
Double.MIN_VALUE };
gbl_ContactPanel.rowWeights = new double[] { 0.0, 0.0, 1.0, 1.0, 1.0, 0.0, Double.MIN_VALUE };
ContactPanel.setLayout(gbl_ContactPanel);
JLabel label_8 = new JLabel("日期");
GridBagConstraints gbc_label_8 = new GridBagConstraints();
gbc_label_8.insets = new Insets(0, 0, 5, 5);
gbc_label_8.gridx = 0;
gbc_label_8.gridy = 0;
ContactPanel.add(label_8, gbc_label_8);
dateChooser_4 = new JDateChooser();
GridBagConstraints gbc_dateChooser_4 = new GridBagConstraints();
gbc_dateChooser_4.gridwidth = 2;
gbc_dateChooser_4.insets = new Insets(0, 0, 5, 5);
gbc_dateChooser_4.fill = GridBagConstraints.BOTH;
gbc_dateChooser_4.gridx = 1;
gbc_dateChooser_4.gridy = 0;
ContactPanel.add(dateChooser_4, gbc_dateChooser_4);
JLabel label_9 = new JLabel("聯繫方式");
GridBagConstraints gbc_label_9 = new GridBagConstraints();
gbc_label_9.insets = new Insets(0, 0, 5, 5);
gbc_label_9.gridx = 6;
gbc_label_9.gridy = 0;
ContactPanel.add(label_9, gbc_label_9);
JComboBox comboBox_9 = new JComboBox();
GridBagConstraints gbc_comboBox_9 = new GridBagConstraints();
gbc_comboBox_9.fill = GridBagConstraints.HORIZONTAL;
gbc_comboBox_9.gridwidth = 3;
gbc_comboBox_9.insets = new Insets(0, 0, 5, 5);
gbc_comboBox_9.gridx = 8;
gbc_comboBox_9.gridy = 0;
ContactPanel.add(comboBox_9, gbc_comboBox_9);
JLabel label_10 = new JLabel("負責人");
GridBagConstraints gbc_label_10 = new GridBagConstraints();
gbc_label_10.insets = new Insets(0, 0, 5, 5);
gbc_label_10.gridx = 11;
gbc_label_10.gridy = 0;
ContactPanel.add(label_10, gbc_label_10);
textField_2 = new JTextField();
GridBagConstraints gbc_textField_2 = new GridBagConstraints();
gbc_textField_2.insets = new Insets(0, 0, 5, 0);
gbc_textField_2.fill = GridBagConstraints.HORIZONTAL;
gbc_textField_2.gridx = 12;
gbc_textField_2.gridy = 0;
ContactPanel.add(textField_2, gbc_textField_2);
textField_2.setColumns(10);
JLabel label_11 = new JLabel("實體寄送物");
GridBagConstraints gbc_label_11 = new GridBagConstraints();
gbc_label_11.insets = new Insets(0, 0, 5, 5);
gbc_label_11.gridx = 0;
gbc_label_11.gridy = 1;
ContactPanel.add(label_11, gbc_label_11);
JRadioButton radioButton = new JRadioButton("有");
GridBagConstraints gbc_radioButton = new GridBagConstraints();
gbc_radioButton.insets = new Insets(0, 0, 5, 5);
gbc_radioButton.gridx = 1;
gbc_radioButton.gridy = 1;
ContactPanel.add(radioButton, gbc_radioButton);
JRadioButton radioButton_1 = new JRadioButton("無");
GridBagConstraints gbc_radioButton_1 = new GridBagConstraints();
gbc_radioButton_1.insets = new Insets(0, 0, 5, 5);
gbc_radioButton_1.gridx = 2;
gbc_radioButton_1.gridy = 1;
ContactPanel.add(radioButton_1, gbc_radioButton_1);
JLabel lblNewLabel = new JLabel("聯絡狀態");
GridBagConstraints gbc_lblNewLabel = new GridBagConstraints();
gbc_lblNewLabel.insets = new Insets(0, 0, 5, 5);
gbc_lblNewLabel.gridx = 6;
gbc_lblNewLabel.gridy = 1;
ContactPanel.add(lblNewLabel, gbc_lblNewLabel);
JComboBox comboBox_8 = new JComboBox();
comboBox_8.setModel(new DefaultComboBoxModel(new String[] { "正常", "暫停通信", "失聯" }));
GridBagConstraints gbc_comboBox_8 = new GridBagConstraints();
gbc_comboBox_8.gridwidth = 2;
gbc_comboBox_8.insets = new Insets(0, 0, 5, 5);
gbc_comboBox_8.fill = GridBagConstraints.HORIZONTAL;
gbc_comboBox_8.gridx = 8;
gbc_comboBox_8.gridy = 1;
ContactPanel.add(comboBox_8, gbc_comboBox_8);
JLabel label_12 = new JLabel("通聯狀況說明");
GridBagConstraints gbc_label_12 = new GridBagConstraints();
gbc_label_12.insets = new Insets(0, 0, 5, 5);
gbc_label_12.gridx = 0;
gbc_label_12.gridy = 2;
ContactPanel.add(label_12, gbc_label_12);
JTextArea textArea_2 = new JTextArea();
GridBagConstraints gbc_textArea_2 = new GridBagConstraints();
gbc_textArea_2.gridwidth = 8;
gbc_textArea_2.insets = new Insets(0, 0, 5, 5);
gbc_textArea_2.fill = GridBagConstraints.BOTH;
gbc_textArea_2.gridx = 1;
gbc_textArea_2.gridy = 2;
ContactPanel.add(textArea_2, gbc_textArea_2);
btnNewButton = new JButton("新增");
GridBagConstraints gbc_btnNewButton = new GridBagConstraints();
gbc_btnNewButton.anchor = GridBagConstraints.SOUTH;
gbc_btnNewButton.insets = new Insets(0, 0, 5, 5);
gbc_btnNewButton.gridx = 10;
gbc_btnNewButton.gridy = 2;
ContactPanel.add(btnNewButton, gbc_btnNewButton);
btnNewButton_1 = new JButton("查詢");
GridBagConstraints gbc_btnNewButton_1 = new GridBagConstraints();
gbc_btnNewButton_1.anchor = GridBagConstraints.SOUTH;
gbc_btnNewButton_1.insets = new Insets(0, 0, 5, 5);
gbc_btnNewButton_1.gridx = 11;
gbc_btnNewButton_1.gridy = 2;
ContactPanel.add(btnNewButton_1, gbc_btnNewButton_1);
label_13 = new JLabel("搜尋結果");
GridBagConstraints gbc_label_13 = new GridBagConstraints();
gbc_label_13.insets = new Insets(0, 0, 5, 5);
gbc_label_13.gridx = 0;
gbc_label_13.gridy = 3;
ContactPanel.add(label_13, gbc_label_13);
JScrollPane scrollPane = new JScrollPane();
GridBagConstraints gbc_scrollPane = new GridBagConstraints();
gbc_scrollPane.gridheight = 3;
gbc_scrollPane.gridwidth = 12;
gbc_scrollPane.fill = GridBagConstraints.BOTH;
gbc_scrollPane.gridx = 1;
gbc_scrollPane.gridy = 3;
ContactPanel.add(scrollPane, gbc_scrollPane);
JTabbedPane tabbedPane_1 = new JTabbedPane(JTabbedPane.TOP);
scrollPane.setColumnHeaderView(tabbedPane_1);
searchLayeredPane = new JLayeredPane();
jftp_0.addTab("查詢頁面", null, searchLayeredPane, null);
}
private void LoadData() {
DefaultTableModel dtm = new DefaultTableModel();
dtm.addColumn("分類");
dtm.addColumn("單位");
dtm.addColumn("姓名");
dtm.addColumn("客戶編號");
dtm.addColumn("郵區");
dtm.addColumn("地址");
dtm.addColumn("手機");
dtm.addColumn("傳真");
dtm.addColumn("信箱");
dtm.addColumn("生日");
for (Client client : cm.findAll()) {
dtm.addRow(new Object[] { client.getCategory(), client.getOrganization(), client.getName(), client.getNo(),
client.getZip(), client.getAddress(), client.getCellnumber(), client.getFax(),
client.getEmail(), client.getBirthday() });
}
this.clientTable.setModel(dtm);
}
}