login.java

这是用JSP和SQL来开发的,基本完成了一个网上书店所要的功能,有待于加油的是细点

package j0202_05_login;
import java.sql.*;
public class Login
{String cus_name,
        cus_passw,
        success="false",
        message="";
 Connection con;
 Statement sql;
 ResultSet rs;
 public Login()
 {try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     }
  catch(ClassNotFoundException e){}
 }
public void setCus_name(String name)
{cus_name=name;}
public String getCus_name()
{return cus_name;}
public void setCus_passw(String pw)
{cus_passw=pw;}
public String getCus_passw()
{return cus_passw;}
public String getSuccess()
{return success;}
public String getMessage()
{try{
     con=DriverManager.getConnection("jdbc:odbc:LocalServer","sa","");
     sql=con.createStatement();
     String condition=
     "SELECT * FROM cusinf WHERE cus_name="+"'"+cus_name+"'";
     rs=sql.executeQuery(condition);
     int rowcount=0;
     String ps=null;
     while(rs.next())
      {rowcount++;
       cus_name=rs.getString("cus_name");
               ps=rs.getString("cus_passw");
      }
     if((rowcount==1)&&(cus_passw.equals(ps)))
       {message="ok";
        success="ok";
       }
      else
       {message="输入的用户名或密码不正确";
        success="false";
       }
      con.close();
      return message;
      }
    catch(SQLException e)
      {message="输入的用户名或密码不正确";
       success="false";
       return message;
      }
   }
}