fkdjb.java

毕业设计源代码

package JXC.web;

import JXC.Com.DBConnect;
import JXC.util.StrFun;

import javax.servlet.http.HttpServletRequest;
import java.sql.ResultSet;
import java.sql.SQLException;

public class fkdjb {
    private int ID;
    private String djbh;
    private int csbh;
    private int ygbh;
    private String Fdate;
    private int fkfs;
    private float je;
    private String memo;
    private String csname;
    private String name;
    private String fkfsname;

    public int getID() {
        return ID;
    }

    public void setID(int newID) {
        this.ID = newID;
    }

    public void setID(String anew) {
        if (anew != null)
            this.ID = Integer.parseInt(anew);
    }

    public String getdjbh() {
        return djbh;
    }

    public void setdjbh(String newdjbh) {
        this.djbh = newdjbh;
    }

    public int getcsbh() {
        return csbh;
    }

    public void setcsbh(int newcsbh) {
        this.csbh = newcsbh;
    }

    public int getygbh() {
        return ygbh;
    }

    public void setygbh(int newygbh) {
        this.ygbh = newygbh;
    }

    public String getFdate() {
        return Fdate;
    }

    public void setFdate(String newFdate) {
        this.Fdate = newFdate;
    }

    public int getfkfs() {
        return fkfs;
    }

    public void setfkfs(int newfkfs) {
        this.fkfs = newfkfs;
    }

    public float getje() {
        return je;
    }

    public void setje(float newje) {
        this.je = newje;
    }

    public String getmemo() {
        return memo;
    }

    public void setmemo(String newmemo) {
        this.memo = newmemo;
    }

    public boolean excute() throws Exception {
        String Str = "Select * From fkdjb where ID=" + ID;
        try {
            DBConnect dbc = new DBConnect(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            ResultSet rs = dbc.executeQuery(Str);
            if (rs.next()) {
                ID = rs.getInt("ID");
                djbh = rs.getString("djbh");
                csbh = rs.getInt("csbh");
                ygbh = rs.getInt("ygbh");
                Fdate = rs.getString("Fdate");
                fkfs = rs.getInt("fkfs");
                je = rs.getFloat("je");
                memo = rs.getString("memo");
            }
            rs.close();
            dbc.close();
            return true;
        }
        catch (SQLException sqle) {
            return false;
        }
    }

    public void Del() throws Exception {
        String Str = "Delete From fkdjlist where ID=" + ID;
        DBConnect dbc = new DBConnect();
        dbc.executeUpdate(Str);
        dbc.close();
    }

    public void Edit(HttpServletRequest request) throws Exception {
        String id = StrFun.getString(request, "id");
        djbh = StrFun.getString(request, "djbh");
        csbh = StrFun.getInt(request, "csbh");
        csname = StrFun.getString(request, "csname");
        ygbh = StrFun.getInt(request, "ygbh");
        name = StrFun.getString(request, "name");
        Fdate = StrFun.getString(request, "Fdate");
        fkfs = StrFun.getInt(request, "fkfs");
        fkfsname = StrFun.getString(request, "fkfsname");
        je = StrFun.getFloat(request, "je");
        memo = StrFun.getString(request, "memo");
        String Str = "Update fkdjlist set djbh='" + djbh + "',csbh=" + csbh + ",csname='" + csname + "',ygbh=" + ygbh + ",name='" + name
                + "',Fdate='" + Fdate + "',fkfs=" + fkfs + ",fkfsname='" + fkfsname + "',je=" + je + ",memo='" + memo + "' where ID=" + id;
        DBConnect dbc = new DBConnect();
        dbc.executeUpdate(Str);
        dbc.close();
    }

    public void Add(HttpServletRequest request) throws Exception {
        djbh = StrFun.getString(request, "djbh");
        csbh = StrFun.getInt(request, "csbh");
        csname = StrFun.getString(request, "csname");
        ygbh = StrFun.getInt(request, "ygbh");
        name = StrFun.getString(request, "name");
        Fdate = StrFun.getString(request, "Fdate");
        fkfs = StrFun.getInt(request, "fkfs");
        fkfsname = StrFun.getString(request, "fkfsname");
        je = StrFun.getFloat(request, "je");
        memo = StrFun.getString(request, "memo");
        String Str = "insert into fkdjlist (djbh,csbh, csname, ygbh, name, je, memo, fkfs, fkfsname, Fdate) " +
                " values('" + djbh + "'," + csbh + ",'" + csname + "'," + ygbh + ",'" + name + "'," + je + ",'" + memo + "'," + fkfs + ",'" + fkfsname + "','" + Fdate + "')";
        System.out.println("====fkdjb.java====add==" + Str);
        DBConnect dbc = new DBConnect();
        dbc.executeUpdate(Str);
        dbc.close();
    }
}