cglist.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;

/**
 * Title:       明细单信息
 * Description:
 * Copyright:    Copyright (c) 2003
 * Company:      torch
 *
 * @version 1.0
 * @author: wind
 */
public class cglist {
    private int ID;
    private String djbh;
    private int csbh;
    private String csname;
    private int ygbh;
    private String name;
    private int ckbh;
    private String ckname;
    private String Fdate;
    private int fkfs;
    private float je;
    private String memo;

    public void cglist() {
    }

    public int getID() {
        return ID;
    }

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

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

    public String getDjbh() {
        return djbh;
    }

    public void setDjbh(String anew) {
        this.djbh = anew;
    }

    public int getCsbh() {
        return csbh;
    }

    public void setCsbh(int anew) {
        this.csbh = anew;
    }

    public String getCsname() {
        return csname;
    }

    public void setCsname(String anew) {
        this.csname = anew;
    }

    public int getYgbh() {
        return ygbh;
    }

    public void setYgbh(int anew) {
        this.ygbh = anew;
    }

    public String getName() {
        return name;
    }

    public void setName(String anew) {
        this.name = anew;
    }

    public int getCkbh() {
        return ckbh;
    }

    public void setCkbh(int anew) {
        this.ckbh = anew;
    }

    public String getCkname() {
        return ckname;
    }

    public void setCkname(String anew) {
        this.ckname = anew;
    }

    public String getFdate() {
        return Fdate;
    }

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

    public int getFkfs() {
        return fkfs;
    }

    public void setFkfs(int anew) {
        this.fkfs = anew;
    }

    public float getJe() {
        return je;
    }

    public void setJe(float anew) {
        this.je = anew;
    }

    public String getMemo() {
        return memo;
    }

    public void setMemo(String anew) {
        this.memo = anew;
    }

    public boolean excute() throws Exception {
        String Str = "Select * From cglist 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");
                csname = rs.getString("csname");
                ygbh = rs.getInt("ygbh");
                name = rs.getString("name");
                ckbh = rs.getInt("ckbh");
                ckname = rs.getString("ckname");
                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 Edit(HttpServletRequest request) throws Exception {
        ID = StrFun.getInt(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");
        ckbh = StrFun.getInt(request, "ckbh");
        ckname = StrFun.getString(request, "ckname");
        Fdate = StrFun.getString(request, "Fdate");
        fkfs = StrFun.getInt(request, "fkfs");
        je = StrFun.getFloat(request, "je");
        memo = StrFun.getString(request, "memo");
        String Str = "Update cglist set djbh='" + djbh
                + "' ,csbh=" + csbh + ",csname='" + csname + "' ,ygbh=" + ygbh + ",name='" + name
                + "' ,ckbh=" + ckbh + ",ckname='" + ckname + "',Fdate='" + Fdate + "' ,fkfs=" + fkfs + " ,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");
        ckbh = StrFun.getInt(request, "ckbh");
        ckname = StrFun.getString(request, "ckname");
        Fdate = StrFun.getString(request, "Fdate");
        fkfs = StrFun.getInt(request, "fkfs");
        je = StrFun.getFloat(request, "je");
        memo = StrFun.getString(request, "memo");
        String Str = "Insert into cglist(djbh,csbh,csname,ygbh,name,ckbh,ckname,Fdate,fkfs,je,memo) " +
                " values('" + djbh + "'," + csbh + ",'" + csname + "'," + ygbh + ",'" + name + "'," + ckbh + ",'" + ckname + "','" + Fdate + "'," + fkfs + "," + je + ",'" + memo + "')";
        System.out.println("==cglist.java====add===" + Str);
        DBConnect dbc = new DBConnect();
        dbc.executeUpdate(Str);
        dbc.close();
    }

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

}