主题:struct2查询所有用户配置多个action及代码
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.0.dtd">
<struts>
<package name="pa" extends="struts-default">
<action name="login" class="cn.com.action.AdminAction">
<result name="yes">/yes.jsp</result>
<result name="no">/no.jsp</result>
</action>
<action name="find" class="cn.com.action.SeaechAction" >
<result type="redirect">/yes.jsp</result></action>
</package>
</struts>
import java.util.ArrayList;
import cn.com.bean.Admin;
public class SearchAdmin extends BaseDAO {
public ArrayList<Admin> search() throws ClassNotFoundException, SQLException{
super.getConnection();
ArrayList list=new ArrayList();
String sql="select * from admin";
st=con.createStatement();
rs=st.executeQuery(sql);
boolean bo=false;
while(rs.next()){
Admin min=new Admin();
String name=rs.getString("username");
String pwd=rs.getString("password");
list.add(name);
list.add(pwd);
}
return list;
}
}
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
<body>
成功!<br>
<a href="add.jsp">添加用户</a>
<table align="center" border="5" >
<tr>
<th>序号</th>
<th>用户名</th>
<th>密码</th>
<th>操作</th>
</tr>
<c:forEach items="${ls}" var="Admin" varStatus="state">
<tr>
<td>${state.index+1 }</td>
<td>${Admin.username }</td>
<td>${Admin.password }</td>
<td>修改|删除</td>
</tr>
</c:forEach>
</table>
</body>
</html>
package cn.com.action;
import java.sql.SQLException;
import cn.com.bean.Admin;
import cn.com.dao.SearchAdmin;
import com.opensymphony.xwork2.ActionSupport;
public class SeaechAction extends ActionSupport {
public Admin seachAll(Admin ad) throws ClassNotFoundException, SQLException{
SearchAdmin sea=new SearchAdmin();
sea.search();
return ad;
}
}
为什查不输出结果?
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.0.dtd">
<struts>
<package name="pa" extends="struts-default">
<action name="login" class="cn.com.action.AdminAction">
<result name="yes">/yes.jsp</result>
<result name="no">/no.jsp</result>
</action>
<action name="find" class="cn.com.action.SeaechAction" >
<result type="redirect">/yes.jsp</result></action>
</package>
</struts>
import java.util.ArrayList;
import cn.com.bean.Admin;
public class SearchAdmin extends BaseDAO {
public ArrayList<Admin> search() throws ClassNotFoundException, SQLException{
super.getConnection();
ArrayList list=new ArrayList();
String sql="select * from admin";
st=con.createStatement();
rs=st.executeQuery(sql);
boolean bo=false;
while(rs.next()){
Admin min=new Admin();
String name=rs.getString("username");
String pwd=rs.getString("password");
list.add(name);
list.add(pwd);
}
return list;
}
}
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
<body>
成功!<br>
<a href="add.jsp">添加用户</a>
<table align="center" border="5" >
<tr>
<th>序号</th>
<th>用户名</th>
<th>密码</th>
<th>操作</th>
</tr>
<c:forEach items="${ls}" var="Admin" varStatus="state">
<tr>
<td>${state.index+1 }</td>
<td>${Admin.username }</td>
<td>${Admin.password }</td>
<td>修改|删除</td>
</tr>
</c:forEach>
</table>
</body>
</html>
package cn.com.action;
import java.sql.SQLException;
import cn.com.bean.Admin;
import cn.com.dao.SearchAdmin;
import com.opensymphony.xwork2.ActionSupport;
public class SeaechAction extends ActionSupport {
public Admin seachAll(Admin ad) throws ClassNotFoundException, SQLException{
SearchAdmin sea=new SearchAdmin();
sea.search();
return ad;
}
}
为什查不输出结果?