unpasssoftware.java

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

package downreg;
import java.sql.*;
public class unPassSoftware
{  //int   i=0;//序列号，自动加1
  int    L_Id;
  int    S_Id=0;
  String S_Name="";
  String  S_Size="";
  String S_Language="";
  String S_Environment="";
  String S_Type="";
  String S_Function="";
  int    I_Id=0;
  String S_PassTime="0000-00-00 00:00:00";
  String S_SavePath="";
  String S_Developer="";
  String S_DHomepage="";
  String S_DEmail="";
  String tableName="software_0";
   Connection con = null;
   Statement stmt = null;
   ResultSet rs = null;
  public unPassSoftware()
  {
   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 setS_Name(String name)
  {
   S_Name=name;
  }
  public void setS_Size(String size)
  {
  S_Size=size;
  }
  public void setS_Language(String language)
  {
  S_Language=language;
  }
  public void setS_Environment(String environment)
  {
  S_Environment=environment;
  }
  public void setS_Type(String type)
  {
  S_Type=type;
  }
  public void setS_Function(String function)
  {
  S_Function=function;
  }
  public void setI_Id(int id)
  {
  I_Id=id;
  }
  public void setS_PassTime(String passtime)
  {
  S_PassTime=passtime;
  }
  public void setS_SavePath(String savepath)
  {
  S_SavePath=savepath;
  }
  public void setS_Developer(String developer)
  {
  S_Developer=developer;
  }
  public void setS_DHomepage(String DHomepage)
  {
  S_DHomepage=DHomepage;
  }
  public void setS_DEmail(String Demail)
  {
  S_DEmail=Demail;
  }

  public int getL_Id()
  {
   return L_Id;
  }

 public int getS_Id()
  {
   return S_Id;
  }
  public String getS_Name()
  {
   return S_Name;
  }
  public String getS_Size()
  {
  return S_Size;
  }
  public String getS_Language()
  {
  return S_Language;
  }
  public String getS_Environment()
  {
  return S_Environment;
  }
  public String getS_Type()
  {
  return S_Type;
  }
  public String getS_Function()
  {
  return S_Function;
  }
  public int getI_Id()
  {
  return I_Id;
  }
  public String getS_PassTime()
  {
  return S_PassTime;
  }
  public String  getS_SavePath()
  {
  return S_SavePath;
  }
  public String getS_Developer()
  {
  return S_Developer;
  }
  public String getS_DHomepage()
  {
  return S_DHomepage;
  }
  public String getS_DEmail()
  {
  return S_DEmail;
  }


public void deleteAll() //删除所有不合格软件
{
try{

  String deleteAll="delete from "+tableName;
  stmt.executeUpdate(deleteAll);
  }
  catch(Exception e)
  {
  }
}
public void delete(int id)//删除单个不合格软件
{
try
{

 String condition="delete from "+tableName+" where L_Id='"+id+"'" ;
 stmt.executeUpdate(condition);

}
catch(Exception e)
{
}
}
public ResultSet unpassSW(int id) //查看合格软件
{
try
{

String condition="select * from "+tableName+" where L_Id='"+id+"'";
rs=stmt.executeQuery(condition);

}
catch(Exception e)
{
}
 return rs ;
}
public void close()
{
try
{
if(rs!=null)
{
  rs.close();
}
if(stmt!=null)
{
  stmt.close();
}
if(con!=null)
{
  con.close();
}
}
catch (SQLException e)
{
}
}
}