operate.java

软件设计大赛的作品,学生登陆系统.包含数据库

package wsbm.run;
import java.sql.*;

import wsbm.util.*;
public class operate extends DataBase
{
    private javax.servlet.http.HttpServletRequest  request;
    public ResultSet ors;
    public boolean opreate(javax.servlet.http.HttpServletRequest res)
    {
    DataBase db=new DataBase();
       request=res;
       String  id=request.getParameter("id");
       String  password=request.getParameter("password");
       System.out.println("id="+id);
       System.out.println("password="+password);
       //System.out.print(id);
       try{

           ors=stmt.executeQuery("select * from 管理员密码  where ID='"+dataFormat.toSql(id)+"' and password='"+dataFormat.toSql(password)+"' ");

           //System.out.print();

           if(ors.next())
           {
               // System.out.print(ors.getString("password"));
               //System.out.print("password");
                          // String  pw=ors.getString("password");
                           String  ide=ors.getString("ID");
                           String  pw=ors.getString("password");

                           System.out.println("rstid="+ide);
                           System.out.println("rstpw="+pw);
                 if(password.equals(pw)&&ide.equals(id))

                     return true;
           }
                 else
                  return  false;

          }
           catch(SQLException el){
                   el.printStackTrace();
                 return false ;
         }
                return false;
   }

}