【Java开源代码栏目提醒】:网学会员为需要Java开源代码的朋友们搜集整理了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.getEscape
HTMLParameter(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;
saveToD