zcbean.java~1~

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

package zcgl;

import java.awt.BorderLayout;
import javax.swing.*;
import java.sql.*;
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 ZcBean extends JPanel {
    BorderLayout borderLayout1 = new BorderLayout();
        private int zcId;
        private String zcName;
        private String zcStyle;
        private float zcPrice;
        private String zcGrDate;
        private String zcStatus;
        private String zcGrR;
        private String zcContext;
        private Connection con;
        private int zcDlId;
        private int zcZlId;
        private String returnDate;
        private int lender;
        private String lendDate;
    public int getZcId()
    {
        return zcId;
    }
    public String getZcName() {
       return zcName;
   }

   public String getZcStyle() {
       return zcStyle;
   }

   public float getZcPrice() {
       return zcPrice;
   }

   public String getZcGrDate() {
       return zcGrDate;
   }
   public String getZcStatus() {
        return zcStatus;
    }

    public String getZcGrR() {
        return zcGrR;
    }

    public String getZcContext() {
        return zcContext;
    }

    public int getZcDlId() {
        return zcDlId;
    }

    public int getZcZlId() {
        return zcZlId;
    }

    public String getReturnDate() {
        return returnDate;
    }
    public int getLender() {
        return lender;
    }

    public String getLendDate() {
        return lendDate;
    }
    public void setZcId(int zcId)
    {
        this.zcId=zcId;
    }
    public void setZcName(String zcName) {
            this.zcName = zcName;
        }

        public void setZcStyle(String zcStyle) {
            this.zcStyle = zcStyle;
        }

        public void setZcPrice(float zcPrice) {
            this.zcPrice = zcPrice;
        }

        public void setZcGrDate(String zcGrDate) {
            this.zcGrDate = zcGrDate;
        }

        public void setZcStatus(String zcStatus) {
            this.zcStatus = zcStatus;
        }

        public void setZcGrR(String zcGrR) {
            this.zcGrR = zcGrR;
        }

        public void setZcContext(String zcContext) {
            this.zcContext = zcContext;
        }

        public void setZcDlId(int zcDlId) {
            this.zcDlId = zcDlId;
        }

        public void setZcZlId(int zcZlId) {
            this.zcZlId = zcZlId;
        }

        public void setReturnDate(String returnDate) {
            this.returnDate = returnDate;
        }

        public void setLender(int lender) {
            this.lender = lender;
        }

        public void setLendDate(String lendDate) {
            this.lendDate = lendDate;
    }
    public boolean insert()
    {
        ZcBean bean=new ZcBean();
        try
        {
         con = new DBConn().getConnection();
        PreparedStatement pstm = con.prepareStatement( "insert into ASSET values(?,?,?,?,?,?,?,?,?,?)");
             pstm.setInt(1, zcId);
            pstm.setString(2, zcName);
            pstm.setInt(3, zcDlId);
            pstm.setInt(4, zcZlId);
            pstm.setString(5, zcStyle);
            pstm.setFloat(6, zcPrice);
            pstm.setString(7, zcGrDate);
            pstm.setString(8, zcStatus);
            pstm.setString(9, zcGrR);
            pstm.setString(10, zcContext);
            pstm.executeUpdate();

           return true;
        }
        catch(Exception ex)
        {
            return false;
        }
    }

    public boolean del() {

           con = new DBConn().getConnection();
           ZcBean bean = new ZcBean();
           try {
               PreparedStatement psmt = con.prepareStatement(
                       "delete from ASSET where assetid=?");
               psmt.setInt(1, zcId);
               psmt.executeUpdate();
               return true;
           } catch (Exception ex) {
               return false;
           }

       }
       public boolean modify() {
              ZcBean bean = new ZcBean();
              int id = zcId;
              try {
                  con = new DBConn().getConnection();
                  PreparedStatement pstm = con.prepareStatement(
                          "update  ASSET set assetid=?,asset_name=?,cateid=?,subcateid=?,model=?,price=?,purchase_date=?,status=?,useby=?,remarks=? where assetid=" +
                          id);

                  pstm.setInt(1, zcId);
                  pstm.setString(2, zcName);
                  pstm.setInt(3, zcDlId);
                  pstm.setInt(4, zcZlId);
                  pstm.setString(5, zcStyle);
                  pstm.setFloat(6, zcPrice);
                  pstm.setString(7, zcGrDate);
                  pstm.setString(8, zcStatus);
                  pstm.setString(9, zcGrR);
                  pstm.setString(10, zcContext);
                  pstm.executeUpdate();
                  return true;
              } catch (Exception ex) {
                  return false;
              }

    }
    public ZcBean() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

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