package zcgl;

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

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() {

    }

    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(){
        con = new DbCon().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(){
        con = new DbCon().getConnection();
        try {
            PreparedStatement psmt = con.prepareStatement(
                    "delete from EMPLOYEE where empno=?");
            psmt.setInt(1,zgId);
            psmt.executeUpdate();
            return true;
        } catch (Exception ex) {
            return false;
        }
    }
    public boolean modify(){
        con = new DbCon().getConnection();
        int Id=zgId;
       try {
           PreparedStatement psmt = con.prepareStatement(
                   "update  EMPLOYEE set empno=?,ename=?,positions=?,remarks=? where empno="+Id);
           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 isNull() {

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


       } catch (SQLException ex) {
       }

       return true;
   }


}