action
package com.action;
import com.dao.UserDao;
import com.impl.UserImpl;
import com.model.User;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import java.util.List;
import java.util.Map;
public class LoAction extends ActionSupport {
private User user;
public User getUser(){
return user;
}
public void setUser(User user){
this.user=user;
}
public String execute() throws Exception{
Integer uid=user.getUid();
String pwd=user.getPwd();
boolean validated=false;
ActionContext context=ActionContext.getContext();
Map session=context.getSession();
User user1=null;
user1=(User)session.get("user");
if(user1==null)
{
UserDao userDao =new UserImpl();
user1= userDao.validateUser(uid,pwd);
if(user1!=null)
{
session.put("user",user1);
validated=true;
}
}else{
validated=true;
}if(validated) {
return SUCCESS;
}else{
return ERROR;
}
}
public String getUserList()throws Exception{
UserDao userDao=new UserImpl();
List userList=userDao.getUserList();
Map request=(Map)ActionContext.getContext().get("request");
request.put("userList",userList);
return "ulist";
}
}
Struts.xml
successpage.jsp
index.jsp
uselist.jsp
adminpage.jsp
admin.jsp
uselist.jsp
Dao
public interface UserDao {
User validateUser(Integer uid,String pwd);
List getUserList();
}
Impl
public List getUserList()
{
try {
Session session=HibernateSessionFactory.getSession();
Transaction ts=session.beginTransaction();
List usersList=session.createQuery("from User order by uid").list();
ts.commit();
return usersList;
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
显示页面
点击 按钮可以对表格进行编辑,点击 按钮可以将该表格行删除。
姓名 | 专业 | ID |
控制台显示:
Hibernate:
select
user0_.uid as uid1_2_,
user0_.pwd as pwd2_2_,
user0_.name as name3_2_,
user0_.zy as zy4_2_
from
user user0_
order by
user0_.uid
Hibernate:
select
user0_.uid as uid1_2_,
user0_.pwd as pwd2_2_,
user0_.name as name3_2_,
user0_.zy as zy4_2_
from
user user0_
order by
user0_.uid
首先看数据库中是否有数据,可以打个断点调试一下。
然后判断是否是SQL的问题,将打印的日志中的SQL复制到数据库中执行一下看看是否正确并含有值。
确认一下页面是否做了该数据的渲染,是否渲染正确。
断点调试,看数据库返回是否有值。返回页面后是否存在错误。
看数据库,打断点,多测几次