package zcgl;

import java.sql.*;

import javax.swing.*;

public class ZcBean extends JPanel {
    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 String 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 String 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(String lender) {
        this.lender = lender;
    }

    public void setLendDate(String lendDate) {
        this.lendDate = lendDate;
    }

    public boolean insert() {
        ZcBean bean = new ZcBean();

        try {
            con = new DbCon().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 DbCon().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 DbCon().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 boolean lend() {
           ZcBean bean = new ZcBean();

           try {
               con = new DbCon().getConnection();
               PreparedStatement pstm = con.prepareStatement(
                       "insert into LEND 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 isNull() {

        con = new DbCon().getConnection();
        Statement smt = null;
        try {
            smt = con.createStatement();
            ResultSet rs=smt.executeQuery("select * from ASSET where assetid="+zcId);
            if(rs.next())
                return false;


        } catch (SQLException ex) {
        }

        return true;
    }
}