user.java

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

package downreg;
import java.sql.*;
public class User
{
   int I_Id=0;
   String I_Name="";
   String I_Password="";
   String I_PwdQuestion="";
   String I_PwdKey="";
   String I_RealName="";
   String I_Sex="";
   String I_IdCard="";
   String I_Homepage="";
   String I_Email="";
   int    I_Post=0;
   String I_Address ="";
   String I_Telephone="";
   String I_Type="";
   String I_Account="0";
   String I_RegTime="0000-00-00 00:00:00";
   String I_RegIpAddress="";
     int  I_TotalTime=0;
   String I_LastLoginTime="0000-00-00 00:00:00" ;
   String I_LastLoginIp="";
   String I_CheckResult="";

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



   public void setI_Id(int id)
   {
      I_Id=id;
   }
   public void setI_Name(String name)
   {
     I_Name=name;
   }
   public void setI_Password(String password)
   {
     I_Password=password;
   }

   public void setI_PwdQuestion(String pwdQuestion)
   {
    I_PwdQuestion=pwdQuestion;
   }
   public void setI_PwdKey(String pwdKey)
   {
    I_PwdKey=pwdKey;
   }
   public void setI_RealName(String realName)
   {
    I_RealName=realName;
   }
   public void setI_Sex(String sex)
   {
    I_Sex=sex;
   }
   public void setI_IdCard(String card)
   {
    I_IdCard=card;
   }
   public void setI_Homepage(String homepage)
   {
    I_Homepage=homepage;
   }
   public void setI_Email(String email)
    {
    I_Email=email;
    }
   public void setI_Post(int post)
    {
     I_Post=post;
    }
   public void setI_Address(String address)
   {
   I_Address=address;
   }
   public void setI_Telephone(String telephone)
   {
   I_Telephone=telephone;
   }
   public void setI_Type(String type)
   {
   I_Type=type;
   }
   public void setI_Account(String account)
   {
   I_Account=account;
   }
   public void setI_RegTime(String regTime)
   {
   I_RegTime=regTime;
   }
   public void setI_RegIpAddress(String ip)
   {
    I_RegIpAddress=ip;
   }
   public void setI_TotalTime(int totalTime)
   {
   I_TotalTime=totalTime;
   }
   public void setI_LastLoginTime(String lastLoginTime)
   {
    I_LastLoginTime=lastLoginTime;
   }
   public void setI_LastLoginIp(String LoginIp)
   {
   I_LastLoginIp=LoginIp;
   }
   public void setI_CheckResult(String checkResult)
   {
   I_CheckResult=checkResult;
   }



    public int getI_Id()
   {
     return I_Id;
   }
   public String getI_Name()
   {
     return I_Name;
   }
   public String getI_Password()
   {
    return I_Password;
   }

   public String getI_PwdQuestion()
   {
    return I_PwdQuestion;
   }
   public String getI_PwdKey()
   {
    return I_PwdKey;
   }
   public String getI_RealName()
   {
    return I_RealName;
   }
   public String getI_Sex()
   {
    return I_Sex;
   }
   public String getI_IdCard()
   {
    return I_IdCard;
   }
   public String getI_Homepage()
   {
    return I_Homepage;
   }
   public String getI_Email()
    {
    return I_Email;
    }
   public int getI_Post()
    {
     return I_Post;
    }
   public String getI_Address()
   {
   return I_Address;
   }
   public String getI_Telephone()
   {
   return I_Telephone;
   }
   public String getI_Type()
   {
   return I_Type;
   }
   public String getI_Account()
   {
   return I_Account;
   }
   public String  getI_RegTime()
   {
   return I_RegTime;
   }
   public String getI_RegIpAddress()
   {
    return I_RegIpAddress;
   }
   public int getI_TotalTime()
   {
   return I_TotalTime;
   }
   public String getI_LastLoginTime()
   {
    return I_LastLoginTime;
   }
   public String getI_LastLoginIp()
   {
   return I_LastLoginIp;
   }
   public String getI_CheckResult()
   {
   return I_CheckResult;
   }

public ResultSet executeQuery(String sql)
{
rs=null;
try{
rs=stmt.executeQuery(sql);
}
catch(SQLException e){
System.err.println(e.getMessage());
}
return rs;
}

public boolean Check(String name)  //审核个人用户
{
try
{
String condition="update "+tableName+" set I_CheckResult=1 where I_Name='"+name+"'";
stmt.executeUpdate(condition);
}
catch(Exception e)
{
}
return true;
}

public ResultSet LookUser() //查看个人用户
{
try{

 String condition="select * from "+tableName;
 rs=stmt.executeQuery(condition);
}
catch(Exception e)
{
}
return rs;
}
public ResultSet LookUpPassUsers()//查看可以上传软件的用户
{
 String s="通过";
try
{

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

}
catch(Exception e)
{
}
return rs;
}
public ResultSet LookDLoadUsers() //查看只能下载的用户
{
 String s="未通过";
try
{

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

}
catch(Exception e)
{
}
return rs;
}

public boolean deleteSingle(String name)//删除单个用户
{
try
{

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

}
catch(Exception e)
{
}
return true;
}
public boolean setVIP(String name)  //set VIP 用户
{
  String s="VIP用户";
  try{

     String condition="update "+tableName+" set I_Type='"+s+"' where I_Name='"+name+"'";
     stmt.executeUpdate(condition);
      }
  catch(Exception e)
  {
  return false;
  }
  return true;
}

public boolean freeze(String name)  //冻结用户
{
  int s1=0;
  try{

     String condition="update "+tableName+" set I_State='"+s1+"' where I_Name='"+name+"'";
     stmt.executeUpdate(condition);
      }
  catch(Exception e)
  {
  return false;
  }
  return true;
}

public boolean charge(String name,float m)  //给用户冲值
{
   float b,c;
   String a="",d="";
  try{
     String s="select * from "+tableName+" where I_Name='"+name+"'";
     rs=stmt.executeQuery(s);
     if(rs.next())
     {
      d=rs.getString("I_Account");
      c=Float.parseFloat(d);
      b=c+m;
      a=String.valueOf(b);
      String condition="update "+tableName+" set I_Account='"+a+"' where I_Name='"+name+"'";
      stmt.executeUpdate(condition);
      return true;
     }
     else
     {return false;}
    }
  catch(Exception e)
  {
  return false;
  }

}

public boolean active(String name)  //解冻用户
{
  int s2=1;
  try{

     String condition="update "+tableName+" set I_State='"+s2+"' where I_Name='"+name+"'";
     stmt.executeUpdate(condition);
      }
  catch(Exception e)
  {
  return false;
  }
return true;
}

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