zgbean.java~1~

代码是自己我的代码不是网上down的。是自己写的。里面有很多值得学习的知识点。还有一些javabean组件。不算自己写的JAR文件

package zcgl;

import java.awt.BorderLayout;
import java.sql.*;
import javax.swing.*;
import java.awt.*;
import javax.swing.JPanel;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class ZgBean extends JPanel {
    BorderLayout borderLayout1 = new BorderLayout();
    private int zgId;
    private String zgName;
    private String zgWork;
    private String zgContext;
    private Connection con=null;

    public ZgBean() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    public void setZgId(int zgId)
    {
        this.zgId=zgId;
    }
    public void setZgName(String zgName) {
        this.zgName = zgName;
    }

    public void setZgwork(String zgWork) {
        this.zgWork = zgWork;
    }

    public void setZgContext(String zgContext) {
        this.zgContext = zgContext;
    }

    public int getZgId() {
        return zgId;
    }

    public String getZgName() {
        return zgName;
    }

    public String getZgwork() {
        return zgWork;
    }

    public String getZgContext() {
        return zgContext;
    }
    public boolean insert() throws ClassNotFoundException {
       con = new DBConn().getConnection();
       try {
           PreparedStatement psmt = con.prepareStatement(
                   "insert into EMPLOYEE values(?,?,?,?)");
           psmt.setInt(1,zgId);
           psmt.setString(2,zgName);
           psmt.setString(3,zgWork);
           psmt.setString(4,zgContext);
           psmt.executeUpdate();
           return true;
       } catch (Exception ex) {
           return false;
       }


   }
   public boolean del() throws ClassNotFoundException {
          con = new DBConn().getConnection();
          try {
              PreparedStatement psmt = con.prepareStatement(
                      "delete from EMPLOYEE where empno=?");
              psmt.setInt(1,zgId);
              psmt.executeUpdate();
              return true;
          } catch (Exception ex) {
              return false;
          }
    }

    private void jbInit() throws Exception {
        setLayout(borderLayout1);
    }
}