81,091
社区成员
发帖
与我相关
我的任务
分享struts的问题
我写一个查询页面，用的是STRUTS架构和ORACLE数据库。如何在JSP页面里显示查询结果啊，JSP页面里最好不要有JAVA代码啊。
package login.bmh.action;
import java.sql.ResultSet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import login.bean.ConnectDB;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
public class BmhAction extends Action {
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
String bmh = request.getParameter("bmh");
if(bmh == null )
{
//request.setAttribute("error","1");
//response.sendRedirect("error.jsp");
return mapping.findForward("fail");
}
else
{
try
{
String sql = "select bmh from t_1_a_41_pyjd where bmh = '"+bmh+"'";
ConnectDB db=new ConnectDB();
ResultSet rs = db.executeQuery(sql);
if(rs != null && rs.next())
{
String ubmh=rs.getString("bmh");
request.setAttribute("bmh",bmh);
request.setAttribute("bmh",rs.getString("bmh"));
System.out.println(bmh);
//response.sendRedirect("sucess.jsp");
return mapping.findForward("success");
}
else
{
request.setAttribute("error","2");
response.sendRedirect("error.jsp");
}
}
catch(Exception e)
{
request.setAttribute("error","3");
response.sendRedirect("error.jsp");
e.printStackTrace();
}
}
package login.bmh.action;
import java.sql.ResultSet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import login.bean.ConnectDB;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
public class BmhAction extends Action {
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
String bmh = request.getParameter("bmh");
if(bmh == null )
{
//request.setAttribute("error","1");
//response.sendRedirect("error.jsp");
return mapping.findForward("fail");
}
else
{
try
{
String sql = "select bmh from t_1_a_41_pyjd where bmh = '"+bmh+"'";
ConnectDB db=new ConnectDB();
ResultSet rs = db.executeQuery(sql);
if(rs != null && rs.next())
{
String ubmh=rs.getString("bmh");
request.setAttribute("bmh",bmh);
request.setAttribute("bmh",rs.getString("bmh"));
System.out.println(bmh);
//response.sendRedirect("sucess.jsp");
return mapping.findForward("success");
}
else
{
request.setAttribute("error","2");
response.sendRedirect("error.jsp");
}
}
catch(Exception e)
{
request.setAttribute("error","3");
response.sendRedirect("error.jsp");
e.printStackTrace();
}
}
...全文
请发表友善的回复…
发表回复
javaboy2006 2008-11-10
- 打赏
- 举报
jstl也可以。
${bmh}
mimi5211 2008-11-10
- 打赏
- 举报
就写这一句话吗
startym 2008-11-10
- 打赏
- 举报
<bean:write name="bmh"/>
结帖率：4.35%
汗！
结帖率：4.35%
汗！
mimi5211 2008-11-09
- 打赏
- 举报
这个是要显示的JSP页面，这个怎么写啊
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
<html:html>
<head>
<title>bmh</title>
</head>
<body>
</body>
</html:html>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
<html:html>
<head>
<title>bmh</title>
</head>
<body>
</body>
</html:html>
