qydb.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 qydb {
    private int ID;
    private String djbh;
    private int yck;
    private int mck;
    private String Fdate;
    private int ygbh;
    private String memo;
    private boolean isError = false;
    private String StrError = "";
    private String yckname;
    private String name;
    private String ckname;

    public void qydb() {
    }

    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 getYck() {
        return yck;
    }

    public void setYck(int anew) {
        this.yck = anew;
    }

    public int getMck() {
        return mck;
    }

    public void setMck(int anew) {
        this.mck = anew;
    }

    public String getFdate() {
        return Fdate;
    }

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

    public int getYgbh() {
        return ygbh;
    }

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

    public String getMemo() {
        return memo;
    }

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

    public boolean getIsError() {
        return this.isError;
    }

    public String getStrError() {
        return this.StrError;
    }

    public boolean excute() throws Exception {
        String Str = "Select * From qydb 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");
                yck = rs.getInt("yck");
                mck = rs.getInt("mck");
                Fdate = rs.getString("Fdate");
                ygbh = rs.getInt("ygbh");
                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");
        yck = StrFun.getInt(request, "yck");
        mck = StrFun.getInt(request, "mck");
        Fdate = StrFun.getString(request, "Fdate");
        ygbh = StrFun.getInt(request, "ygbh");
        name = StrFun.getString(request, "name");
        memo = StrFun.getString(request, "memo");
        if (yck != mck) {
            String Str = "Select * From qydb where djbh='" + djbh + "'";
            DBConnect dbc = new DBConnect();
            ResultSet rs = dbc.executeQuery(Str);
            if (rs.next()) {
                isError = true;
                StrError = StrError + "已有相同单据号，请重新编号！  <br>";
            } else {
//                Str = "Update qydb set djbh='" + djbh + "' ,yck=" + yck + " ,mck=" + mck + " ,Fdate='" + Fdate + "' ,ygbh=" + ygbh + " ,memo='" + memo + "'  where id=" + ID;
                Str = "Update qydblist set djbh='" + djbh + "', name='" + name + "' ,Fdate='" + Fdate + "' ,ygbh=" + ygbh + " ,memo='" + memo + "'  where id=" + ID;
                dbc.executeUpdate(Str);
            }
            // rs.close();
            dbc.close();
        } else {
            isError = true;
            StrError = StrError + "源仓库与目的仓库相同，不能进行调拨！  <br>";
        }
    }

    public void Add(HttpServletRequest request) throws Exception {
        djbh = StrFun.getString(request, "djbh");
        yck = StrFun.getInt(request, "yck");
        yckname = StrFun.getString(request, "yckname");
        name = StrFun.getString(request, "name");
        ckname = StrFun.getString(request, "ckname");
        mck = StrFun.getInt(request, "mck");
        Fdate = StrFun.getString(request, "Fdate");
        ygbh = StrFun.getInt(request, "ygbh");
        memo = StrFun.getString(request, "memo");
        if (yck != mck) {
            String Str = "Select * From qydb where djbh='" + djbh + "'";
            DBConnect dbc = new DBConnect();
            ResultSet rs = dbc.executeQuery(Str);
            if (rs.next()) {
                isError = true;
                StrError = StrError + "已有相同单据号，请重新编号！  <br>";
            } else {
//                Str = "Insert into qydb(djbh,yck,mck,Fdate,ygbh,memo) values('" + djbh + "'," + yck + "," + mck + ",'" + Fdate + "'," + ygbh + ",'" + memo + "')";
                Str = "Insert into qydblist(djbh,yck,yckname,ygbh,name,mck,ckname,Fdate,memo) " +
                        " values('" + djbh + "'," + yck + ",'" + yckname + "'," + ygbh
                        + ",'" + name + "'," + mck + ",'" + ckname + "','" + Fdate + "','" + memo
                        + "')";
                System.out.println("==qydb.java===Add==sql==" + Str);
                dbc.executeUpdate(Str);
            }
            // rs.close();
            dbc.close();
        } else {
            isError = true;
            StrError = StrError + "源仓库与目的仓库相同，不能进行调拨！  <br>";
        }
        System.out.println("==qydb.java===Add==isError=" + isError + "====StrError==" + StrError);
    }

    public void Del(HttpServletRequest request) throws Exception {
        ID = StrFun.getInt(request, "id");
        String Str = "Select * From qydbmxb where djbh=" + ID;
        System.out.println("===qydb.java===Del==ID==" + ID);
        DBConnect dbc = new DBConnect();
        ResultSet rs = dbc.executeQuery(Str);
        if (rs.next()) {
            isError = true;
            StrError = StrError + "需先将明细表中数据删除后方可进行该项操作！ <br>";
        } else {
//            Str = "Delete From qydb where Id=" + ID;
            Str = "Delete From qydblist where Id=" + ID;
            System.out.println("===qydb.java===Del==sql==" + Str);
            dbc.executeUpdate(Str);
        }
        dbc.close();
    }

}