txlframe.java~32~

一个简单的小程序 共人查看希望大家接受因为刚刚学习还有很多的地方不懂

package view;

import java.awt.BorderLayout;
import java.awt.Dimension;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.awt.Font;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import db.DbConn;
import dao.DbCaoZuo;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class TXLFrame extends JFrame {
    JPanel contentPane;
    JLabel lblName = new JLabel();
    JLabel lblPhone = new JLabel();
    JLabel lblAddress = new JLabel();
    JTextField txtName = new JTextField();
    JTextField txtPhone = new JTextField();
    JTextField txtAdress = new JTextField();
    JButton btnAdd = new JButton();
    JButton btnDel = new JButton();
    JButton btnQuery = new JButton();
    JButton btnUpdate = new JButton();
    public TXLFrame() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(null);
        setSize(new Dimension(400, 300));
        setTitle("通讯录的例子");
        lblName.setFont(new java.awt.Font("宋体-方正超大字符集", Font.BOLD, 18));
        lblName.setText("姓名： ");
        lblName.setBounds(new Rectangle(23, 43, 75, 28));
        lblPhone.setFont(new java.awt.Font("宋体-方正超大字符集", Font.BOLD, 18));
        lblPhone.setText("电话：");
        lblPhone.setBounds(new Rectangle(22, 104, 57, 25));
        lblAddress.setFont(new java.awt.Font("宋体-方正超大字符集", Font.BOLD, 18));
        lblAddress.setText("地址：");
        lblAddress.setBounds(new Rectangle(19, 157, 59, 26));
        txtName.setBounds(new Rectangle(113, 42, 193, 31));
        txtPhone.setBounds(new Rectangle(117, 107, 190, 29));
        txtAdress.setBounds(new Rectangle(118, 158, 189, 28));
        btnAdd.setBounds(new Rectangle(13, 216, 78, 25));
        btnAdd.setText("添加");
        btnAdd.addActionListener(new TXLFrame_btnAdd_actionAdapter(this));
        btnDel.setBounds(new Rectangle(102, 217, 77, 25));
        btnDel.setText("删除");
        btnDel.addActionListener(new TXLFrame_btnDel_actionAdapter(this));
        btnQuery.setBounds(new Rectangle(192, 218, 79, 25));
        btnQuery.setText("查询");
        btnQuery.addActionListener(new TXLFrame_btnQuery_actionAdapter(this));
        btnUpdate.setBounds(new Rectangle(286, 218, 74, 24));
        btnUpdate.setText("修改");
        btnUpdate.addActionListener(new TXLFrame_btnUpdate_actionAdapter(this));
        contentPane.add(lblName);
        contentPane.add(lblPhone);
        contentPane.add(lblAddress);
        contentPane.add(txtName);
        contentPane.add(txtPhone);
        contentPane.add(txtAdress);
        contentPane.add(btnAdd);
        contentPane.add(btnDel);
        contentPane.add(btnQuery);
        contentPane.add(btnUpdate);
    }

    public void btnAdd_actionPerformed(ActionEvent e) {
    String name = txtName.getText();
    String phone =txtPhone.getText();
    String address = txtAdress.getText();
    if(name.equals(""))
    {
        JOptionPane.showMessageDialog(this,"名字不能为空","信息提示",JOptionPane.ERROR_MESSAGE);
    }
    else
    {
        //连接数据库，数据插入
        String sql="insert into addressList(name,phone,address)"
                   +"values('"+name+"','"+phone+"','"+address+"')";
        int flag =0;
        flag =new DbCaoZuo().update(sql);
        if(flag!=0)
        {
            JOptionPane.showMessageDialog(this,"成功插入","消息提示",JOptionPane.INFORMATION_MESSAGE);
        }
        else
        {
            //错误提示
        }
    }
     new DbConn().close();
    }

    public void btnDel_actionPerformed(ActionEvent e) {
        String name = txtName.getText();
        String phone =txtPhone.getText();
        String address = txtAdress.getText();
        if(name.equals(""))
        {
            JOptionPane.showMessageDialog(this,"名字不能为空","信息提示",JOptionPane.ERROR_MESSAGE);
        }
        else
        {
            //连接数据库，数据删除
            String sql="delete from addressList where name='"+name+"'";
            int flag =0;
            flag =new DbCaoZuo().update(sql);
            if(flag!=0)
            {
                JOptionPane.showMessageDialog(this,"成功删除","消息提示",JOptionPane.INFORMATION_MESSAGE);
            }
            else
            {
                //错误提示
            }
        }
      new DbConn().close();
    }

    public void btnUpdate_actionPerformed(ActionEvent e) {

    }

    public void btnQuery_actionPerformed(ActionEvent e) {
        String name = txtName.getText();
               String phone =txtPhone.getText();
               String address = txtAdress.getText();
               if(name.equals(""))
               {
                   JOptionPane.showMessageDialog(this,"名字不能为空","信息提示",JOptionPane.ERROR_MESSAGE);
               }
               else
               {
                   //连接数据库，数据查询
                   String sql="select *  from  addressList where name='"+name+"'";
                  ResultSet rs =null;
                  rs =new DbCaoZuo().getQuery(sql);
                  int flag=0;//1表示查询到了,0表示没有查询到
                  try
                  {
                      while (rs.next()) {
                          flag=1;
                          txtName.setText(rs.getString("name"));
                          txtPhone.setText(rs.getString("phone"));
                          txtAdress.setText(rs.getString("address"));
                      }
                  }catch(Exception e2){}
                  if(flag==0)
                  {
                      JOptionPane.showMessageDialog(this,"没有查询到","信息提示 ",JOptionPane.ERROR_MESSAGE);
                  }

        }
        new DbConn().close();
    }

}


class TXLFrame_btnQuery_actionAdapter implements ActionListener {
    private TXLFrame adaptee;
    TXLFrame_btnQuery_actionAdapter(TXLFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnQuery_actionPerformed(e);
    }
}


class TXLFrame_btnDel_actionAdapter implements ActionListener {
    private TXLFrame adaptee;
    TXLFrame_btnDel_actionAdapter(TXLFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnDel_actionPerformed(e);
    }
}


class TXLFrame_btnAdd_actionAdapter implements ActionListener {
    private TXLFrame adaptee;
    TXLFrame_btnAdd_actionAdapter(TXLFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnAdd_actionPerformed(e);
    }
}


class TXLFrame_btnUpdate_actionAdapter implements ActionListener {
    private TXLFrame adaptee;
    TXLFrame_btnUpdate_actionAdapter(TXLFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnUpdate_actionPerformed(e);
    }
}