testpare.java

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

package j0202_05_login;
import java.sql.*;
public class Testpare
{String cus_name,
        cus_pasre,
        cus_pasan,
        
        message="";
 Connection con;
 Statement sql;
 ResultSet rs;
 public Testpare()
 {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_pasre(String pwre)
{cus_pasre=pwre;}
public String getCus_pasre()
{return cus_pasre;}

public void setCus_pasan(String pwan)
{cus_pasan=pwan;}
public String getCus_pasan()
{return cus_pasan;}


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 psre=null,psan=null;
     while(rs.next())
      {rowcount++;
       cus_name=rs.getString("cus_name");
               psre=rs.getString("cus_pasre");
               psan=rs.getString("cus_pasan");
      }
     if((rowcount==1)&&(cus_pasre.equals(psre))&&(cus_pasan.equals(psan)))
       {message="ok";
        }
      else
       {message="输入的密码提问或答案不正确1";
        
       }
      con.close();
      return message;
      }
    catch(SQLException e)
      {message="输入的密码提问或答案不正确2";
       
       return message;
      }
   }
}