zgbean.java~16~

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

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=?");
            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;
       }

    }

}