unchecksoftware.java

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

package downreg;
import java.sql.*;
public class unCheckSoftware
{  //int   i=0;//序列号，自动加1
  int    S_Id=0;
  String S_Name="";
  String S_Size="";
  String S_Language="";
  String S_Environment="";
  String S_Type="";
  String S_Function="";
  int    U_Id=0;
  String U_Type="";
  String S_PassTime="0000-00-00 00:00:00";
  String S_SavePath="";
  String S_Developer="";
  String S_DHomepage="";
  String S_DEmail="";

   Connection con = null;
   Statement stmt = null;
   ResultSet rs = null;
   String tableName="software";
   public unCheckSoftware()
   {
       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();
          }
      catch (Exception e)
         {
         }
   }

  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 setU_Id(int id)
  {
  U_Id=id;
  }
  public void setU_Type(String type)
  {
  U_Type=type;
  }
  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 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 getU_Id()
  {
  return U_Id;
  }
  public String getU_Type()
  {
  return U_Type;
  }
  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 ResultSet check()
{
try{
String sql="select * from "+tableName+" where S_Id='"+S_Id+"'";
rs=stmt.executeQuery(sql);
}
catch(SQLException e){
System.err.println(e.getMessage());
}
return rs;
}

public boolean checkSoftware(int id,int result)  // 审核软件
{
try
{

String condition1="select * from "+tableName+" where S_Id='"+id+"'" ;
rs=stmt.executeQuery(condition1);
while(rs.next())
{
 S_Id=rs.getInt(1);
 S_Name=rs.getString(2);
 S_Size=rs.getString(3);
 S_Language=rs.getString(4);
 S_Environment=rs.getString(5);
 S_Type=rs.getString(6);
 S_Function=rs.getString(7);
 U_Id=rs.getInt(8);
 U_Type=rs.getString(9);
 S_PassTime=rs.getString(10);
 S_SavePath=rs.getString(11);
 S_Developer=rs.getString(12);
 S_DHomepage=rs.getString(13);
 S_DEmail=rs.getString(14);

}
if(result==0)
{
   String s1=S_Id+",'"+S_Name+"','"+S_Size+"','"+S_Language+"','"+S_Environment+"','"+S_Type+"','"+S_Function+"',"+U_Id+",'"+U_Type+"','"+S_PassTime+"','"+S_SavePath+"','"+S_Developer+"','"+S_DHomepage+"','"+S_DEmail+"'" ;
   String sql="insert into software_0(S_Id,S_Name,S_Size,S_Language,S_Environment,S_Type,S_Function,U_Id,U_Type,S_PassTime,S_SavePath,S_Developer,S_DHomepage,S_DEmail) values("+s1+")" ;
   stmt.executeUpdate(sql);
   String sq="delete from "+tableName+" where S_Id='"+id+"'";
   stmt.executeUpdate(sq);
}
else if(result==1)
 {
   String s2=""+S_Id+",'"+S_Name+"','"+S_Size+"','"+S_Language+"','"+S_Environment+"','"+S_Type+"','"+S_Function+"',"+U_Id+",'"+U_Type+"','"+S_PassTime+"','"+S_SavePath+"','"+S_Developer+"','"+S_DHomepage+"','"+S_DEmail+"'";
   String sql="insert into software_1(S_Id,S_Name,S_Size,S_Language,S_Environment,S_Type,S_Function,U_Id,U_Type,S_PassTime,S_SavePath,S_Developer,S_DHomepage,S_DEmail) values("+s2+")" ;
   stmt.executeUpdate(sql);
   String sq="delete from "+tableName+" where S_Id='"+id+"'";
   stmt.executeUpdate(sq);
 }
}
catch(Exception e)
{
}
return true;
}
public void close()
{
try
{
if(rs!=null)
{
  rs.close();
}
if(stmt!=null)
{
  stmt.close();
}
if(con!=null)
{
  con.close();
}
}
catch (SQLException e)
{
}
}
}