大家快快帮看看这个登录验证的bean对不对,急用,急死拉,多谢,100分
package tom.jiafei;
import java.sql.*;
public class Login
{ String logname,
password,
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 pas)
{ pas=password;
}
public String getPassword()
{return password;
}
//查询数据库的member表:
public String getMessage()
{
try{
con=DriverManager.getConnection("jdbc:odbc:redsun","sa","sa");
sql=con.createStatement();
String condition="SELECT password FROM Nmanage WHERE logname = "+"'"+logname+"'";
rs=sql.executeQuery(condition);
if(rs.next())
{
String pas= rs.getString("password");
if(password.equals(pas.trim()))
{message="ok";
}
else
{ message="error";
}
con.close();
return message;
}
}
catch(SQLException e)
{ message= "输入的用户名或密码不正确";
return message;
}
return message;
}
}