contactsdemo.java

通讯录 用java做的带图形界面的 一个简单通讯录 数据库有MYSQL支持 可以进行 查找 添加 删除 等

package tongxinglu;
import java.awt.*;
import javax.swing.*;
import java.util.List;
import java.util.Iterator;
import java.util.ArrayList;
import java.awt.event.*;

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.Updata(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()+"\n";
							str +="	|*生日: " + tempc.getBirthday()+"\n";
							str +="	|*联系电话: " + tempc.getTel()+"\n";
							str +="	|*Email：" + tempc.getEmail()+"\n";
							str +=" |*备注: " + tempc.getRemark()+"\n";
							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)
				{
					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.setLocation(300, 50);
		this.setContentPane(getJContenPane());
		//设置标题
		this.setTitle("简单通讯录");
		this.setVisible(true);
		this.addWindowListener(new java.awt.event.WindowAdapter(){
			public void windowClosing(java.awt.event.WindowEvent e){
				//关闭数据库
				dbconn.close();
				dbconn = null;
				//退出
				System.exit(0);
			}
		});
	}
	
	//初始化jContentPane,返回类型为javax.swing.JPanel
	private JPanel getJContenPane(){
		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;
	}
}