logbean.java

jsp2.0动态网站开发实例指南原代码

package shop;
import java.sql.*;
public class logBean{
  String id="";
  String name="";
  String pwd="";
  String sex="";
  String mail="";
  String addr="";
  String call="";
  String intr="";
  String success="false";
  String islog="false";
  Connection con;
  Statement sql;
  ResultSet rs;
  public logBean(){
    try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }catch(ClassNotFoundException e){}
  }
  public void setId(String s){id=s;}
  public void setName(String s){name=s;}
  public void setPwd(String s){pwd=s;}
  public void setSex(String s){sex=s;}
  public void setMail(String s){mail=s;}
  public void setAddr(String s){addr=s;}
  public void setCall(String s){call=s;}
  public void setIntr(String s){intr=s;}
  public String getId(){return id;}
  public String getName(){return name;}
  public String getPwd(){return pwd;}
  public String getSex(){return sex;}
  public String getMail(){return mail;}
  public String getAddr(){return addr;}
  public String getCall(){return call;}
  public String getIntr(){return intr;}
  public String getIslog(){return islog;}
  public String getSuccess(){
    success="false";
    islog="false";
    if(id.equals("")){
      return success;
    }
    try{
      con=DriverManager.getConnection("jdbc:odbc:myshop","","");
      sql=con.createStatement();
      String condition="SELECT * FROM user WHERE id="+"'"+id+"'";
      rs=sql.executeQuery(condition);
      int rowcount=0;
      String ps=null;
      while(rs.next()){
        rowcount++;
        name=rs.getString("name");
        ps=rs.getString("pwd");
        sex=rs.getString("sex");
        mail=rs.getString("mail");
        addr=rs.getString("addr");
        call=rs.getString("call");
        intr=rs.getString("intr");
      }
      if((rowcount==1)&&(pwd.equals(ps))){
        islog="true";
        success="true";
      }
      con.close();
      return success;
    }catch(SQLException e){
      return success;
    }
  }
}