yww.java

企业办公自动化管理系统

// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi 
// Source File Name:   Dbproduct.java

package electric.dbs;

import electric.electricUtils.*;
import java.io.PrintStream;
import java.sql.*;
import javax.servlet.http.HttpServletRequest;

// Referenced classes of package electric.dbs:
//            ProductNotFoundException

public class Dbproduct
{

    private static final String LOAD_PRODUCT_BY_ID = "SELECT * FROM [PRODUCT] WHERE [ID]=?";
    private static final String INSERT_PRODUCT = "INSERT INTO [PRODUCT] ([Id],[Productname],[Productprice],[Productform],[Productnote],[Pic],[Status]) VALUES (?,?,?,?,?,?,?)";
    private static final String UPDATE_PRODUCT = "UPDATE [PRODUCT] SET [Productname]=?,[Productprice]=?,[Productform]=?,[Productnote]=?,[Status]=? WHERE [Id]=?";
    private static final String CLEAR_PRODUCT = "DELETE FROM [PRODUCT] WHERE STATUS=1";
    private int Id;
    private String Productname;
    private String Productprice;
    private String Productform;
    private String Productnote;
    private String Pic;
    private int Status;

    public Dbproduct()
    {
    }

    public Dbproduct(HttpServletRequest request)
    {
        Id = DbSequenceManager.nextID(5);
        Productname = ParamUtils.getEscapeHTMLParameter(request, "productname");
        Productprice = ParamUtils.getEscapeHTMLParameter(request, "productprice");
        Productform = ParamUtils.getEscapeHTMLParameter(request, "productform");
        Productnote = ParamUtils.getEscapeHTMLParameter(request, "productnote");
        Pic = ParamUtils.getEscapeHTMLParameter(request, "pic");
        Status = 0;
        insertIntoDb();
    }

    public Dbproduct(int Id)
        throws ProductNotFoundException
    {
        this.Id = Id;
        if(Id <= 0)
        {
            return;
        } else
        {
            loadFromDb();
            return;
        }
    }

    protected static Dbproduct getInstance(int Id)
        throws ProductNotFoundException
    {
        return new Dbproduct(Id);
    }

    protected void delete()
    {
        setStatus(1);
    }

    protected static void clear()
    {
        Connection con;
        PreparedStatement pstmt;
        con = null;
        pstmt = null;
        con = DbConnectionManager.getConnection();
        pstmt = con.prepareStatement("DELETE FROM [PRODUCT] WHERE STATUS=1");
        pstmt.executeUpdate();
        try
        {
            pstmt.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        try
        {
            con.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        break MISSING_BLOCK_LABEL_171;
        SQLException sqle;
        sqle;
        System.err.println("SQLException in DbTChatRooms.java:clearTChatRooms(): " + sqle);
        sqle.printStackTrace();
        try
        {
            pstmt.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        try
        {
            con.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        break MISSING_BLOCK_LABEL_171;
        Exception exception;
        exception;
        try
        {
            pstmt.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        try
        {
            con.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        throw exception;
    }

    public int getId()
    {
        return Id;
    }

    public String getProductname()
    {
        return Productname;
    }

    public String getProductprice()
    {
        return Productprice;
    }

    public String getProductform()
    {
        return Productform;
    }

    public String getProductnote()
    {
        return Productnote;
    }

    public String getPic()
    {
        return Pic;
    }

    public int getStatus()
    {
        return Status;
    }

    public void setId(int Id)
    {
        this.Id = Id;
        saveToDb();
    }

    public void setProductname(String Productname)
    {
        this.Productname = Productname;
        saveToDb();
    }

    public void setProductprice(String Productprice)
    {
        this.Productprice = Productprice;
        saveToDb();
    }

    public void setProductform(String Productform)
    {
        this.Productform = Productform;
        saveToDb();
    }

    public void setProductnote(String Productnote)
    {
        this.Productnote = Productnote;
        saveToDb();
    }

    public void setPic(String Pic)
    {
        this.Pic = Pic;
        saveToDb();
    }

    public void setStatus(int Status)
    {
        this.Status = Status;
        saveToDb();
    }

    public void modify(HttpServletRequest request)
    {
        Id = ParamUtils.getIntParameter(request, "Id");
        Productname = ParamUtils.getEscapeHTMLParameter(request, "productname");
        Productprice = ParamUtils.getEscapeHTMLParameter(request, "productprice");
        Productform = ParamUtils.getEscapeHTMLParameter(request, "productform");
        Productnote = ParamUtils.getEscapeHTMLParameter(request, "productnote");
        Status = 0;
        saveToDb();
    }

    private void loadFromDb()
        throws ProductNotFoundException
    {
        Connection con;
        PreparedStatement pstmt;
        Exception exception;
        con = null;
        pstmt = null;
        try
        {
            con = DbConnectionManager.getConnection();
            pstmt = con.prepareStatement("SELECT * FROM [PRODUCT] WHERE [ID]=?");
            pstmt.setInt(1, Id);
            ResultSet rs = pstmt.executeQuery();
            if(!rs.next())
                throw new ProductNotFoundException("从数据表[PRODUCT]中读取用户数据失败,欲读取的用户ID:[ " + Id + "]!");
            Id = rs.getInt("Id");
            Productname = rs.getString("Productname");
            Productprice = rs.getString("Productprice");
            Productform = rs.getString("Productform");
            Productnote = rs.getString("Productnote");
            Pic = rs.getString("Pic");
            Status = rs.getInt("Status");
        }
        catch(SQLException sqle)
        {
            throw new ProductNotFoundException("从数据表[PRODUCT]中读取用户数据失败,欲读取的用户ID:[ " + Id + "]!");
        }
        finally { }
        try
        {
            pstmt.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        try
        {
            con.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        break MISSING_BLOCK_LABEL_279;
        try
        {
            pstmt.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        try
        {
            con.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        throw exception;
    }

    private void insertIntoDb()
    {
        Connection con;
        PreparedStatement pstmt;
        con = null;
        pstmt = null;
        con = DbConnectionManager.getConnection();
        pstmt = con.prepareStatement("INSERT INTO [PRODUCT] ([Id],[Productname],[Productprice],[Productform],[Productnote],[Pic],[Status]) VALUES (?,?,?,?,?,?,?)");
        pstmt.setInt(1, Id);
        pstmt.setString(2, StringUtils.toChinese(Productname));
        pstmt.setString(3, StringUtils.toChinese(Productprice));
        pstmt.setString(4, StringUtils.toChinese(Productform));
        pstmt.setString(5, StringUtils.toChinese(Productnote));
        pstmt.setString(6, StringUtils.toChinese(Pic));
        pstmt.setInt(7, Status);
        pstmt.executeUpdate();
        try
        {
            pstmt.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        try
        {
            con.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        break MISSING_BLOCK_LABEL_269;
        SQLException sqle;
        sqle;
        System.err.println("错误位置: DbProduct:insertIntoDb()-" + sqle);
        sqle.printStackTrace();
        try
        {
            pstmt.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        try
        {
            con.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        break MISSING_BLOCK_LABEL_269;
        Exception exception;
        exception;
        try
        {
            pstmt.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        try
        {
            con.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        throw exception;
    }

    private void saveToDb()
    {
        Connection con;
        PreparedStatement pstmt;
        con = null;
        pstmt = null;
        con = DbConnectionManager.getConnection();
        pstmt = con.prepareStatement("UPDATE [PRODUCT] SET [Productname]=?,[Productprice]=?,[Productform]=?,[Productnote]=?,[Status]=? WHERE [Id]=?");
        pstmt.setString(1, StringUtils.toChinese(Productname));
        pstmt.setString(2, StringUtils.toChinese(Productprice));
        pstmt.setString(3, StringUtils.toChinese(Productform));
        pstmt.setString(4, StringUtils.toChinese(Productnote));
        pstmt.setInt(5, Status);
        pstmt.setInt(6, Id);
        pstmt.executeUpdate();
        try
        {
            pstmt.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        try
        {
            con.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        break MISSING_BLOCK_LABEL_254;
        SQLException sqle;
        sqle;
        System.err.println("错误位置: DbProduct.java:saveToDb(): " + sqle);
        sqle.printStackTrace();
        try
        {
            pstmt.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        try
        {
            con.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        break MISSING_BLOCK_LABEL_254;
        Exception exception;
        exception;
        try
        {
            pstmt.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        try
        {
            con.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        throw exception;
    }
}