contactsdemo.java

Java程序设计实用案例教程源代码

package database;

import java.awt.BorderLayout;
import java.awt.GridLayout;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;

public class ContactsDemo extends JFrame {
	private DBConnection dbconn = null;

	private JPanel jContentPane = null;

	private JPanel jPanelInput = null;

	private JScrollPane jScrollPane = null;

	private JLabel jLabelName = null;

	private JTextField jTextFieldName = null;

	private JButton jButtonInsert = null;

	private JLabel jLabelBirthday = null;

	private JTextField jTextFieldBirthday = null;

	private JButton jButtonUpdate = null;

	private JLabel jLabelTel = null;

	private JTextField jTextFieldTel = null;

	private JButton jButtonDelete = null;

	private JLabel jLabelEmail = null;

	private JTextField jTextFieldEmail = null;

	private JButton jButtonQuery = null;

	private JLabel jLabelRemark = null;

	private JTextField jTextFieldRemark = null;

	private JButton jButtonClear = null;

	private JTextArea jTextArea = null;

	// 初始化jPanelInput, 返回类型为javax.swing.JPanel
	private JPanel getJPanelInput() {
		if (jPanelInput == null) {
			jLabelRemark = new JLabel();
			jLabelRemark.setText("备注:");
			jLabelRemark
					.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
			jLabelEmail = new JLabel();
			jLabelEmail.setText("Email:");
			jLabelEmail
					.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
			jLabelTel = new JLabel();
			jLabelTel.setText("电话:");
			jLabelTel.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
			jLabelBirthday = new JLabel();
			jLabelBirthday.setText("生日:");
			jLabelBirthday
					.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
			jLabelName = new JLabel();
			jLabelName.setText("姓名:");
			jLabelName
					.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
			jLabelName.setFont(new java.awt.Font("Dialog", java.awt.Font.BOLD,
					12));
			GridLayout gridLayout1 = new GridLayout(5, 3, 10, 10);
			jPanelInput = new JPanel();
			jPanelInput.setLayout(gridLayout1);
			jPanelInput.add(jLabelName, null);
			jPanelInput.add(getJTextFieldName(), null);
			jPanelInput.add(getJButtonInsert(), null);
			jPanelInput.add(jLabelBirthday, null);
			jPanelInput.add(getJTextFieldBirthday(), null);
			jPanelInput.add(getJButtonUpdate(), null);
			jPanelInput.add(jLabelTel, null);
			jPanelInput.add(getJTextFieldTel(), null);
			jPanelInput.add(getJButtonDelete(), null);
			jPanelInput.add(jLabelEmail, null);
			jPanelInput.add(getJTextFieldEmail(), null);
			jPanelInput.add(getJButtonQuery(), null);
			jPanelInput.add(jLabelRemark, null);
			jPanelInput.add(getJTextFieldRemark(), null);
			jPanelInput.add(getJButtonClear(), null);
		}
		return jPanelInput;
	}

	// 初始化jScrollPane, 返回类型为javax.swing.JScrollPane
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setViewportView(getJTextArea());
		}
		return jScrollPane;
	}

	// 初始化jTextFieldName, 返回类型为javax.swing.JTextField
	private JTextField getJTextFieldName() {
		if (jTextFieldName == null) {
			jTextFieldName = new JTextField();
		}
		return jTextFieldName;
	}

	// 初始化jButtonInsert, 返回类型为javax.swing.JButton
	private JButton getJButtonInsert() {
		if (jButtonInsert == null) {
			jButtonInsert = new JButton();
			jButtonInsert.setPreferredSize(new java.awt.Dimension(25, 20));
			jButtonInsert.setText("插入数据");
			jButtonInsert.addMouseListener(new java.awt.event.MouseAdapter() {
				public void mouseReleased(java.awt.event.MouseEvent e) {
					System.out.println("插入数据成功!");
					Contacts c = new Contacts();
					c.setName(jTextFieldName.getText());
					c.setBirthday(jTextFieldBirthday.getText());
					c.setTel(jTextFieldTel.getText());
					c.setEmail(jTextFieldEmail.getText());
					c.setRemark(jTextFieldRemark.getText());
					dbconn.insert(c);
					jTextArea.setText(jTextArea.getText() + "插入数据成功!\n");
				}
			});
		}
		return jButtonInsert;
	}

	// 初始化jTextFieldBirthday, 返回类型为javax.swing.JTextField
	private JTextField getJTextFieldBirthday() {
		if (jTextFieldBirthday == null) {
			jTextFieldBirthday = new JTextField();
		}
		return jTextFieldBirthday;
	}

	// 初始化jButtonUpdate, 返回类型为javax.swing.JButton
	private JButton getJButtonUpdate() {
		if (jButtonUpdate == null) {
			jButtonUpdate = new JButton();
			jButtonUpdate.setText("修改数据");
			jButtonUpdate.addMouseListener(new java.awt.event.MouseAdapter() {
				public void mouseReleased(java.awt.event.MouseEvent e) {
					Contacts c = new Contacts();
					int cnt = 0;
					c.setName(jTextFieldName.getText());
					c.setBirthday(jTextFieldBirthday.getText());
					c.setTel(jTextFieldTel.getText());
					c.setEmail(jTextFieldEmail.getText());
					c.setRemark(jTextFieldRemark.getText());
					cnt = dbconn.Update(c);
					jTextArea.setText(jTextArea.getText() + "修改数据成功, "
							+ "影响数据行数为" + cnt + "\n");
					System.out.println("mouseReleased()");
				}
			});
		}
		return jButtonUpdate;
	}

	// 初始化jTextFieldTel, 返回类型为javax.swing.JTextField
	private JTextField getJTextFieldTel() {
		if (jTextFieldTel == null) {
			jTextFieldTel = new JTextField();
		}
		return jTextFieldTel;
	}

	// 初始化jButtonDelete, 返回类型为javax.swing.JButton
	private JButton getJButtonDelete() {
		if (jButtonDelete == null) {
			jButtonDelete = new JButton();
			jButtonDelete.setText("删除数据");
			jButtonDelete.addMouseListener(new java.awt.event.MouseAdapter() {
				public void mouseReleased(java.awt.event.MouseEvent e) {
					Contacts c = new Contacts();
					c.setName(jTextFieldName.getText());
					c.setBirthday(jTextFieldBirthday.getText());
					c.setTel(jTextFieldTel.getText());
					c.setEmail(jTextFieldEmail.getText());
					c.setRemark(jTextFieldRemark.getText());
					int temp = dbconn.Delete(c);
					if (temp > 0) {
						jTextArea.setText(jTextArea.getText() + "删除数据成功!"
								+ "影响数据行数为" + temp + "\n");
						System.out.println("删除数据成功");
					} else {
						jTextArea.setText(jTextArea.getText() + "无法删除数据!\n");
						System.out.println("删除数据失败!");
					}
				}
			});
		}
		return jButtonDelete;
	}

	// 初始化jTextFieldEmail, 返回类型为javax.swing.JTextField
	private JTextField getJTextFieldEmail() {
		if (jTextFieldEmail == null) {
			jTextFieldEmail = new JTextField();
		}
		return jTextFieldEmail;
	}

	// 初始化jButtonQuery, 返回类型为javax.swing.JButton
	private JButton getJButtonQuery() {
		if (jButtonQuery == null) {
			jButtonQuery = new JButton();
			jButtonQuery.setText("查询数据");
			jButtonQuery.addMouseListener(new java.awt.event.MouseAdapter() {
				public void mouseReleased(java.awt.event.MouseEvent e) {
					jTextArea.setText(jTextArea.getText() + "查询数据:\n");
					Contacts c = new Contacts();
					c.setName(jTextFieldName.getText());
					c.setBirthday(jTextFieldBirthday.getText());
					c.setTel(jTextFieldTel.getText());
					c.setEmail(jTextFieldEmail.getText());
					c.setRemark(jTextFieldRemark.getText());
					List<Contacts> list = new ArrayList<Contacts>();
					list = dbconn.Query(c);
					if (list.size() > 0) {
						Iterator<Contacts> it = list.iterator();
						while (it.hasNext()) {
							Contacts tempc = (Contacts) it.next();
							String str = "";
							str += "  |* 姓名: " + tempc.getName();
							str += "  |* 生日: " + tempc.getBirthday();
							str += "  |* 联系电话: " + tempc.getTel();
							str += "  |* Email: " + tempc.getEmail();
							str += "  |* 备注: " + tempc.getRemark();
							jTextArea.setText(jTextArea.getText() + str + "\n");
						}
					} else {
						jTextArea.setText(jTextArea.getText() + "没有所要的数据!\n");
					}
					System.out.println("查询数据 mouseReleased()");
				}
			});
		}
		return jButtonQuery;
	}

	// 初始化jTextFieldRemark, 返回类型为javax.swing.JTextField
	private JTextField getJTextFieldRemark() {
		if (jTextFieldRemark == null) {
			jTextFieldRemark = new JTextField();
		}
		return jTextFieldRemark;
	}

	// 初始化jButtonClear, 返回类型为javax.swing.JButton
	private JButton getJButtonClear() {
		if (jButtonClear == null) {
			jButtonClear = new JButton();
			jButtonClear.setText("清除输入");
			jButtonClear.addMouseListener(new java.awt.event.MouseAdapter() {
				public void mouseReleased(java.awt.event.MouseEvent e) {
					System.out.println("清除输入 mouseReleased()");
					jTextFieldName.setText("");
					jTextFieldBirthday.setText("");
					jTextFieldTel.setText("");
					jTextFieldEmail.setText("");
					jTextFieldRemark.setText("");
					jTextArea.setText(jTextArea.getText() + "清除输入成功!\n");
				}
			});
		}
		return jButtonClear;
	}

	// 初始化jTextArea, 返回类型为javax.swing.JTextArea
	private JTextArea getJTextArea() {
		if (jTextArea == null) {
			jTextArea = new JTextArea();
		}
		return jTextArea;
	}

	// main方法 新建一个ContactsDemo对象
	public static void main(String[] args) {
		new ContactsDemo();
	}

	// 构造方法, 初始化
	public ContactsDemo() {
		super();
		initialize();
	}

	// 初始化方法
	private void initialize() {
		// 实例化数据库操作类对象
		dbconn = DBConnection.getInstance();
		// 设置大小
		this.setSize(473, 471);
		this.setContentPane(getJContentPane());
		// 设置标题
		this.setTitle("简单通讯录");
		this.setVisible(true);
		this.addWindowListener(new java.awt.event.WindowAdapter() {
			public void windowClosing(java.awt.event.WindowEvent e) {
				System.out.println("windowClosing()");
				// 关闭数据库
				dbconn.close();
				dbconn = null;
				// 退出
				System.exit(0);
			}
		});
	}

	// 初始化jContentPane, 返回类型为javax.swing.JPanel
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jContentPane = new JPanel();
			jContentPane.setLayout(new BorderLayout());
			jContentPane.add(getJPanelInput(), java.awt.BorderLayout.NORTH);
			jContentPane.add(getJScrollPane(), java.awt.BorderLayout.CENTER);
		}
		return jContentPane;
	}

}