warrant.java

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

package downreg;
import java.io.*;
import java.sql.*;
public class warrant
{
    int Id;
    String name,password,freeze,type;
    Connection conn;
    Statement stmt;
    ResultSet rs;
    public warrant()
    {
       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();
       conn=DriverManager.getConnection(url);
       stmt=conn.createStatement();
       }
     catch(Exception e){}
    }
    public void setId(int id)
    {
    Id=id;
    }
    public void setName(String na)
    {
     name=na;
    }
    public void setPassword(String pa)
    {
     password=pa;
    }

    public void setFreeze(String t)
    {
    freeze=t;
    }
    public void setType(String ty)
    {
    type=ty;
    }
    public int getId()
    {
    return Id;
    }
    public String getName()
    {
     return name;
    }
    public String getPassword()
    {
     return password;
    }
    public String getFreeze()
    {
    return freeze;
    }
    public String getType()
    {
    return type;
    }

 public ResultSet LookUser()
{
try{

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

    public String newWarrant(String n,String pwd,String type)
    {
      try{

    System.err.println("mmmmmmmm");
      String s="select * from warrant where W_name="+"'"+n+"'";
      rs=stmt.executeQuery(s);




      if(!rs.next())
        {

           String f="active";
          String s1="'"+Id+"'"+","+"'"+n+"'"+","+"'"+pwd+"'"+","+"'"+f+"'"+","+"'"+type+"'";
          String condition="insert into warrant values"+"("+s1+")";
          stmt.executeUpdate(condition);
          return "添加成功";

         }
      else
          return "用户以存在";
      }
    catch(Exception e)
        {
           System.err.println("ERROR:"+e);
          //System.err.print(""+e);
          return "添加失败";
        }
   }

  public String freeze(String na)
  {
   String t="freeze";
   try{

        String s="UPDATE warrant set W_Freeze='"+t+"' where W_Name='"+na+"'";
        stmt.executeUpdate(s);
        return "冻结成功";
       }
    catch(SQLException e)
      {
        System.err.println("ERROR:"+e);
        return "冻结失败";
      }


  }
  public String active(String na)
  {
   String t="active";
   try{

        String s="UPDATE warrant set W_Freeze='"+t+"' where W_Name='"+na+"'";
        stmt.executeUpdate(s);
        return "解冻成功";
       }
    catch(SQLException e)
      {
        System.err.println("ERROR:"+e);
        return "解冻失败";
      }


  }
   public String deleteWarrant(String n)
   {

     try
         {
          String s="select * from warrant where W_name="+"'"+n+"'";
          rs=stmt.executeQuery(s);
          }
     catch(SQLException e)
      {
        System.err.println("ERROR:"+e);
      }
      try{
          if(rs.next())
          {
          String s2="delete  from warrant where W_name="+"'"+n+"'" ;
          stmt.executeUpdate(s2);
          return "删除成功" ;
          }
          else
          {
          return "用户不存在";
          }
        }
      catch(Exception e)
      {
      return "删除失败" ;
      }
   }

   public boolean login(String name1,String pass1)
   {
    String s="active";
     try{
     //String s2="select * from warrant where W_Name='"+name1+"'";
     String s2="select * from warrant where W_Name='"+name1+"' and W_Freeze='"+s+"' and W_Type=1";
     rs=stmt.executeQuery(s2);
     }
     catch(SQLException e)
      {
        System.err.println("ERROR:"+e);
      }
      try
     {
      rs.next();
      password=rs.getString("W_Password");
      }
      catch(SQLException e)
       {
           System.err.println("ERROR:"+e);
        }
      if(pass1.equals(password))
      {
          return true;
       }
        else
      { return false;}
    }
     public String changepass(String name2,String pass2)
   {
     try{
         String s3="UPDATE  warrant set W_Password='"+pass2+"' where W_name='"+name2+"'";
         stmt.executeUpdate(s3);
         return  "修改成功";
        }
       catch(SQLException e)
       {
         //System.err.println("ERROR:"+ex);
         return "修改失败";
       }

   }

 public void close()
 {
try
{
if(rs!=null)
{
  rs.close();
}
if(stmt!=null)
{
  stmt.close();
}
if(conn!=null)
{
  conn.close();
}
}
  catch(SQLException e)
   {
   System.err.println("ERROR:"+e);
   }
 }
}