login.java

可以让初学者有一个感性的认识

import java.sql.*;

public class Login
{
	String logname,realname,password,phone,address;
	String success="false";
	String message="";
	Connection con;
	Statement sql;
	ResultSet rs;

	public Login()
	{	try
			{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			}catch(ClassNotFoundException e){}
	}
	
	public void setLogname(String name)
	{
		logname=name;
	}
	
	public String getLogname()
	{
		return logname;
	}
	
	public void setRealname(String name)
	{
		realname=name;
	}
	
	public String getRealname()
	{
		return realname;
	}
	public void setPassword(String pw)
	{
		password=pw;
	}
	
	public String getPassword()
	{
		return password;
	}
	
	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 getSuccess()
	{
		return success;
	}
	
	public String getMessage()
	{	try
		{ 	con=DriverManager.getConnection("jdbc:odbc:shop","","");
			sql=con.createStatement();
			String condition="SELECT * FROM user 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("password");
				phone=rs.getString("phone");
				address=rs.getString("address");
			}
			if((rowcount==1)&&(password.equals(ps)))
				{message="ok"; success="ok";	}
			else
				{ message="输入的用户名或密码不正确"; success="false";}
			con.close();
			return message;
		}catch(SQLException e)
		{	
			message="输入的用户名或密码不正确2";
			success="false";
			return message;
		}
	}

}