無(wú)論輸入什么帳號(hào)密碼都沒(méi)有通過(guò)action成功轉(zhuǎn)跳
提交表單后控制臺(tái)輸出語(yǔ)句
WARN: [DEPRECATION] Encountered positional parameter near line 1, column 34 in HQL: [from entity.Users where username=? and password=? ].? Positional parameter are considered deprecated; use named parameters or JPA-style positional parameters instead.
三月 01, 2018 6:34:23 下午 org.hibernate.hql.internal.ast.HqlSqlWalker generatePositionalParameter
WARN: [DEPRECATION] Encountered positional parameter near line 1, column 49 in HQL: [from entity.Users where username=? and password=? ].? Positional parameter are considered deprecated; use named parameters or JPA-style positional parameters instead.
Hibernate:?
? ? select
? ? ? ? users0_.uid as uid1_1_,
? ? ? ? users0_.username as username2_1_,
? ? ? ? users0_.password as password3_1_?
? ? from
? ? ? ? USERS users0_?
? ? where
? ? ? ? users0_.username=??
? ? ? ? and users0_.password=?
public?class?UserDAOImpl?implements?UsersDAO{ ? ????@Override ????public?boolean?usersLogin(Users?u)?{ ????????//?TODO?Auto-generated?method?stub ????????//創(chuàng)建事物對(duì)象 ????????//事務(wù)(Transaction)是訪問(wèn)并可能更新數(shù)據(jù)庫(kù)中各種數(shù)據(jù)項(xiàng)的一個(gè)程序執(zhí)行單元(unit) ????????Transaction?ts?=?null; ????????String?hql?=?""; ????????? ????????try?{ ????????????Session?session?=?MyHibernateSessionFactory.getSessionFactory().getCurrentSession(); ????????????//開(kāi)啟事物 ????????????ts?=session.beginTransaction(); ????????????//hql查詢(xún)語(yǔ)句 ????????????hql?=?"from?Users?where?username=??and?password=??"; ????????????//Query是Hibernate的查詢(xún)接口,用于從數(shù)據(jù)存儲(chǔ)源查詢(xún)對(duì)象及控制執(zhí)行查詢(xún)的過(guò)程,Query包裝了一個(gè)HQL查詢(xún)語(yǔ)句 ????????????org.hibernate.Query?query?=session.createQuery(hql); ????????????//傳遞參數(shù) ????????????query.setParameter(0,?u.getUsername()); ????????????query.setParameter(1,?u.getPassword()); ????????????//調(diào)用其中的方法得到結(jié)果?? ????????????List?list?=query.list(); ????????????ts.commit(); ????????????if?(list.size()>0)?{ ????????????????return?true; ????????????}?else?{ ????????????????return?false; ????????????} ????????} ????????catch?(Exception?ex)?{ ????????????//?TODO:?handle?exception??? ????????????//打印異常對(duì)象 ????????????ex.printStackTrace(); ????????????return?false; ????????} ????????finally{ ????????????//釋放事物對(duì)象資源 ????????????if?(ts!=null)?{ ????????????????ts=null; ????????????} ????????} ????? ????} ????????? } ? ? public?class?UsersAction?extends?superAction?implements?ModelDriven<Users>{ ????? ????/** ?????*? ?????*/ ????private?static?final?long?serialVersionUID?=?1L; ????private?Users?user?=?new?Users(); ????? ????//用戶(hù)登錄動(dòng)作 ????public?String?login()?{ ????????UsersDAO?udao?=new?UserDAOImpl(); ????????if?(udao.usersLogin(user))?{ ????????????return?"login_success"; ????????} ????????else?{ ????????????return?"login_failure"; ????????} ????????? ????} ????@Override ????public?Users?getModel()?{ ????????//?TODO?Auto-generated?method?stub ????????return?this.user; ????} ? }
2018-03-09
換一種查詢(xún)方式就對(duì)了