dbmanager.java

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

package downreg;
import java.io.*;
import java.sql.*;
public class dbManager
{
    int id;
    String name,password;
    Connection conn;
    Statement stmt;
    ResultSet rs;
    public dbManager()
    {
       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 setName(String na)
    {
     name=na;
    }
    public void setPassword(String pa)
    {
     password=pa;
    }
    public String getName()
    {
     return name;
    }
    public String getPassword()
    {
     return password;
    }



   public boolean login(String name1,String pass1)
   {
     try{
     String s2="select * from dbmanager where M_Name='"+name1+"'";
     rs=stmt.executeQuery(s2);
     }
     catch(SQLException e)
      {
        System.err.println("ERROR:"+e);
      }
      try
     {
      rs.next();
      password=rs.getString("M_Password");
      }
      catch(Exception 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  dbmanager set M_Password='"+pass2+"' where M_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);
   }
 }
}