Action
_______________
public ActionForward adminQueryByLogin_code(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
LoginForm loginForm = (LoginForm) form;
System.out.println("进入adminQuery");
String login_code = loginForm.getLogin_code();
UserDao userDao = new UserDao();
//UserDto userDto = new UserDto();
//userDto.setLogin_code(login_code);
ArrayList list2 = userDao.queryUserByLogin_code(login_code);;
request.setAttribute("list2", list2);
HttpSession session = request.getSession();
/*
try {
ArrayList list = userDao.queryAllUser();
request.setAttribute("list", list);
request.getRequestDispatcher("admin.jsp").forward(request,response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
*/
//return mapping.findForward("loginAdmin");
return mapping.findForward("adminQueryTest"); }
}
_____________________________________
查询函数queryUserByLogin_code(login_code)
——————————————————————
public ArrayList queryUserByLogin_code(String login_code) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
ArrayList<UserDto> list2 =new ArrayList<UserDto>(); try {
// 获得Connection连接对象
conn = DBConnection.getConnection();
ps = conn.prepareStatement("select * from user_info where login_code = ?");
ps.setString(1, login_code);
//System.out.println(ps);
rs = ps.executeQuery();
while (rs.next()) {
UserDto userDto = new UserDto();
userDto.setId(rs.getInt("id"));
userDto.setLogin_code(rs.getString("login_code"));
userDto.setPassword(rs.getString("password"));
userDto.setType(rs.getString("type"));
list2.add(userDto); }
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("数据库操作错误");
} finally {
// 释放资源
DBConnection.clear(conn, ps, rs);
}
System.out.println("进入到adminQuerByLogin_code()");
return list2;
}
_______________
public ActionForward adminQueryByLogin_code(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
LoginForm loginForm = (LoginForm) form;
System.out.println("进入adminQuery");
String login_code = loginForm.getLogin_code();
UserDao userDao = new UserDao();
//UserDto userDto = new UserDto();
//userDto.setLogin_code(login_code);
ArrayList list2 = userDao.queryUserByLogin_code(login_code);;
request.setAttribute("list2", list2);
HttpSession session = request.getSession();
/*
try {
ArrayList list = userDao.queryAllUser();
request.setAttribute("list", list);
request.getRequestDispatcher("admin.jsp").forward(request,response);
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
*/
//return mapping.findForward("loginAdmin");
return mapping.findForward("adminQueryTest"); }
}
_____________________________________
查询函数queryUserByLogin_code(login_code)
——————————————————————
public ArrayList queryUserByLogin_code(String login_code) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
ArrayList<UserDto> list2 =new ArrayList<UserDto>(); try {
// 获得Connection连接对象
conn = DBConnection.getConnection();
ps = conn.prepareStatement("select * from user_info where login_code = ?");
ps.setString(1, login_code);
//System.out.println(ps);
rs = ps.executeQuery();
while (rs.next()) {
UserDto userDto = new UserDto();
userDto.setId(rs.getInt("id"));
userDto.setLogin_code(rs.getString("login_code"));
userDto.setPassword(rs.getString("password"));
userDto.setType(rs.getString("type"));
list2.add(userDto); }
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("数据库操作错误");
} finally {
// 释放资源
DBConnection.clear(conn, ps, rs);
}
System.out.println("进入到adminQuerByLogin_code()");
return list2;
}
解决方案 »
- Hibernate,SQL里面删除出现列名 'OrderType_18603477058015' 无效。
- jsp页面里<%=%>怎么使用sturts action类里的对象属性,如user.gender 用EL表达式不能被解释
- doGet 为什么是回调方法
- ssh开发中,对象属性值注入的问题 ,为什么他没有实例化就可以给他赋值
- 关于struts2的timer拦截器的问题
- 在线等答案,帮帮忙
- c:forEache循环显示的表格能否进行分组显示?
- 帮帮忙呀!
- 如何在Tomcat下配置jdbc驱动????在线等待。。。。
- 通过cxf的wsdl2java生成的java代码里面的注解能去掉吗?
- IE8环境下 APPLET不能正常工作!
- 郁闷的乱码问题?
“浏览器和服务器支持EL表达式”这个是可以保证的,我还有个list是可以用的,
你在页面显示是要使用STRUTS标签显示 还是普通循环就行啊?
我现在是通过登录明来查询用户信息,要把查询到的用户信息显示到页面上,
如果用request只能取到login_code登录名,其他信息都获取不到,
再下来应该要用页面的标签把数据显示出来了。<c:foreach 把好像是记不太清了。
你用${list2.id}肯定取不到的
你需要使用循环将其中的值取出来
你如果用JSTL的话
就用foreach
取出list中的对象后再用${obj.id}什么的