zgbean.java~11~

来自「一个经典的java编写的固定资定管理源码。值得下载！」· JAVA~11~ 代码 · 共 76 行

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 zgId=?");
        } catch (SQLException ex) {
        }
    }

}