Question

用java编写的注册程序，有用户账号和密码，登录时候判断完用户名与数据库中存在的相同之后，

如何写sql语句判定所输入的密码是否与数据库中账号所对应的密码是否匹配，以确定用户输入信息正确而进入界面

Answer 1

select password from tablename where id='***'
然后跟你form的password相比较就行

Answer 2

select pwd from table where userName='userName'
将查询的结果和用户输入的做对比

Answer 3

action类的写法：
MemberDAO mdao = new MemberDAO();
Member member =mdao.getMember(username, password);
if (member!=null){
ActionContext.getContext().getSession().put("user" , member);}
MemberDAO中：
public Member getMember(String userName, String password) {
Session session = null;
Member m = null;

try {
session = HibernateSessionFactory.getSession();
session.beginTransaction();

List members = session
.createQuery(
"select m from Member as m where m.userName=? and m.userPassword=?")
.setParameter(0, userName).setParameter(1, password).list();
m = members.size()>0 ? (Member)members.get(0) :null;

} catch (Exception e) {
e.printStackTrace();
}
return m;
}

然后在前台通过参数user接受用户的登录数据，我用的struts2+Hibernate做的
，相信不管如何都一样的吧，思路是这样的