selllist.java

软件上传下载网站,上传用户经过注册成为本站会员就可将将软件上传到本网站

package downreg;
import java.sql.*;
public class sellList
{
 int L_Id;
 int S_Id=0;
 int I_Id=0;
 String S_Name="";
 String I_Name="";
 String  RegisterType="";
 String  BuyTime="";
 String  BuyMount="";
 String  TotalMoney="";


   Connection con = null;
   Statement stmt = null;
   ResultSet rs = null;
   public  sellList()
   {
   String url="";
   String driverName="com.mysql.jdbc.Driver";
   String userName="root";
   String userPasswd="324802";
   String dbName="downreg";
   try
     {
       Class.forName(driverName).newInstance();
       url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd+"&useUnicode=true&characterEncoding=gb2312";
       con= DriverManager.getConnection(url);
       stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
     }
   catch (Exception e)
     {
     }
   }

 public void setL_Id(int id)
 {
 L_Id=id;
 }
 public void setS_Id(int id)
 {
 S_Id=id;
 }
 public void setI_Id(int id)
 {
 I_Id=id;
 }
 public void setS_Name(String name)
 {
 S_Name=name;
 }
 public void setI_Name(String name)
 {
 I_Name=name;
 }

 public void setRegisterType(String type)
{
 RegisterType=type;
}
 public void setBuyTime(String time)
{
 BuyTime=time;
}
public void setBuyMount(String  mount)
{
 BuyMount=mount;
}
public void setTotalMoney(String money)
{
 TotalMoney=money;
}
 public int getL_Id()
 {
 return L_Id;
 }
 public int getS_Id()
 {
 return S_Id;
 }
 public int getI_Id()
 {
 return I_Id;
 }
 public String getS_Name()
 {
 return S_Name;
 }
 public String getI_Name()
 {
 return I_Name;
 }
 public String getRegisterType()
 {
 return RegisterType;
 }
 public String getBuyTime()
 {
 return BuyTime;
 }
 public String getBuyMount()
 {
 return BuyMount;
 }
  public String getTotalMoney()
 {
 return TotalMoney;
 }

public ResultSet LookSell_List() //查看销售列表
{
try{

 String condition="select * from sell_list" ;
 rs=stmt.executeQuery(condition);
}
catch(Exception e)
{
}
return rs;
}

public String deleteAll()
{
try
{

String condition="delete from sell_list" ;
stmt.executeUpdate(condition);
return "删除成功" ;
}
catch(Exception e)
{
return "删除失败" ;
}
}

public ResultSet LookPresentedSW()//查看已赠送软件
{
 String s="0";
try{

 String condition="select * from sell_list where RegisterType="+"'"+s+"'";
 rs=stmt.executeQuery(condition);
}
catch(Exception e)
{
}
return rs;
}

public ResultSet LookTeamBuySW()//查看团购软件
{
 String s="1";
try{

 String condition="select * from sell_list where RegisterType="+"'"+s+"'";
 rs=stmt.executeQuery(condition);
}
catch(Exception e)
{
}
return rs;
}
public ResultSet CS(int id,String s)
{ //String s="1";
try{

 String condition="select * from sell_list where S_Id="+"'"+id+"'"+"and RegisterType="+"'"+s+"'";
 rs=stmt.executeQuery(condition);
}
catch(Exception e)
{
}
return rs;
}
public void close()
{
try
{ if(rs!=null)
{
rs.close();
}
if(con!=null)
{
con.close();
}
if(stmt!=null)
{
stmt.close();
}

}
catch (SQLException e)
{
}
}


}