login.java

一个同学录系统

package bean;
import java.sql.*;
public class Login
{   String logname,
	   password,
	   success="false",
           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 setPassword(String pw)
	  {    password=pw;
	  }
	public String getPassword()
	  {  return password;
	  }
	public String getSuccess()
	{ return success;
	}
	//查询数据库的user表
	public String getMessage()
	 {try{
	      con=DriverManager.getConnection("jdbc:odbc:sjk");
		  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");
		   ps=rs.getString("password");
                 }
		 if((rowcount==1)&&(password.equals(ps)))
		    { message="OK";
		      success="OK";
		    }
		else
		   {message="输入的用户名或密码不正确";
		    success="false";
		   }
		   con.close();
		   return message;
		 }
	  catch(SQLException e)
	    { message="输入的用户名或密码不正确";
		  success="false";
		  return message;
		 }
	}
}