zclbbean.java~6~

一个看上去不错的JAVA毕业设计作品

package zcgl;

import javax.swing.*;
import java.sql.*;
public class ZcLbBean extends JPanel {
    private int zlId;
    private String zlName;
    private int subId;
    private String subName;
    private Connection con=null;
    public int getZlId() {
        return zlId;
    }

    public String getZlName() {
        return zlName;
    }

    public int getSubId() {
        return subId;
    }

    public String getSubName() {
        return subName;
    }

    public void setZlId(int zlId) {
        this.zlId = zlId;
    }

    public void setZlName(String zlName) {
        this.zlName = zlName;
    }

    public void setSubId(int subId) {
        this.subId = subId;
    }

    public void setSubName(String subName) {
        this.subName = subName;
    }
    public boolean insert(){
        con = new DbCon().getConnection();
        PreparedStatement pstm = null;
        try {
            pstm = con.prepareStatement("insert into CATEGORY values(?,?,?,?)");
            pstm.setInt(1,zlId);
            pstm.setString(2,zlName);
            pstm.setInt(3,subId);
            pstm.setString(4,subName);
            pstm.executeUpdate();
            return true;
        } catch (Exception ex) {
            return false;
        }

    }
}