login.java

2． 实现用户注册

/*
 * 创建日期 2007-4-21
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */

/**
 * @author Administrator
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package aa;
import java.sql.*;
public class Login {
	
  String logname,realname,pasword,phone,address;
  String success="false",message="";
  Connection con;
  Statement sql;
  ResultSet rs;
  public Login()
  {
  	try{
  		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  		}catch(ClassNotFoundException e){}
  	}
  public void setSuccess(String login)
  {success=login;}
  public String getSuccess()
  {return success;}
  public void setLogname(String name)
  {logname=name;}
  public String getLogname()
  {return logname;}
  public void setPasword(String pw)
  {pasword=pw;}
  public String getPasword()
  {return pasword;}
  public void setRealname(String name)
  {realname=name;}
  public String getRealname()
  {return realname;}
  public void setPhone(String ph)
  {phone=ph;}
  public String getPhone()
  {return phone;}
  public void setAddress(String ad)
  {address=ad;}
  public String getAddress()
  {return address;}
  public String getMessage()
  {
  	try{
  		con=DriverManager.getConnection("jdbc:odbc:shop","sa","");
  		sql=con.createStatement();
  		String condition="select * from user1 where logname="+"'"+logname+"'";
  		rs=sql.executeQuery(condition);
  		int rowcount=0;
  		String ps=null;
  		while(rs.next())
  		{
  			rowcount++;
  			logname=rs.getString("logname");
  			realname=rs.getString("realname");
  			ps=rs.getString("pasword");
  			phone=rs.getString("phone");
  			address=rs.getString("address");
  			}
  		if((rowcount==1)&&(pasword.equals(ps)))
  		{
  			message="ok";
  			success="ok";
  			}else
  			{
  				message="输入正确的用户名或密码不正确";
  				success="false";
  				}
  		con.close();
  		return message;
  		}
  	catch(SQLException e)
	{
  		message="输入用户名或密码不正确";
  		success="false";
  		return message;
  		}
  	}
}