我想用action,从数据库获取内容,然后用显示在jsp页面上,不知道怎么写javabean和action,谢谢,下面是我写的javabean和部分action,但是action不知道具体怎么写,请高手多多帮忙,
javabean:package cn.test.user.web;
import java.sql.*;
public class stuTestForm{
private String qid=null;
private String optionA=null;
private String optionB=null;
private String optionC=null;
private String optionD=null;
public void setQid(String qid)
{
this.qid=qid;
}
public String getQid()
{
return (this.qid);
}
public void setOptionA(String optionA)
{
this.optionA=optionA;
}
public String getOptionA()
{
return(this.optionA);
}
public void setOptionB(String optionB)
{
this.optionB=optionB;
}
public String getOptionB()
{
return(this.optionB);
}
public void setOptionC(String optionC)
{
this.optionC=optionC;
}
public String getOptionC()
{
return(this.optionC);
}
public void setOptionD(String optionD)
{
this.optionD=optionD;
}
public String getOptionD()
{
return(this.optionD);
}}
action:package cn.test.user.web;import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import java.sql.*;
import java.util.*;
public class stuTestAction extends Action { @Override
public ActionForward execute(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response)throws Exception {
ArrayList testList=new ArrayList();
dataPool myData=new dataPool();
try{
Connection myCon=myData.getConnection();
Statement myState=myCon.createStatement();
ResultSet mySet=myState.executeQuery("select * from single_select_table");
while(mySet.next())
{
stuTestForm test=new stuTestForm();
test.setQid(mySet.getString("question_id"));
test.setOptionA(mySet.getString("optionA"));
test.setOptionA(mySet.getString("optionB"));
test.setOptionA(mySet.getString("optionC"));
test.setOptionA(mySet.getString("optionD"));
testList.add(test);
}
mySet.close();
myState.close();
myCon.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}}
还有就是jsp迭代不知道怎么写?
javabean:package cn.test.user.web;
import java.sql.*;
public class stuTestForm{
private String qid=null;
private String optionA=null;
private String optionB=null;
private String optionC=null;
private String optionD=null;
public void setQid(String qid)
{
this.qid=qid;
}
public String getQid()
{
return (this.qid);
}
public void setOptionA(String optionA)
{
this.optionA=optionA;
}
public String getOptionA()
{
return(this.optionA);
}
public void setOptionB(String optionB)
{
this.optionB=optionB;
}
public String getOptionB()
{
return(this.optionB);
}
public void setOptionC(String optionC)
{
this.optionC=optionC;
}
public String getOptionC()
{
return(this.optionC);
}
public void setOptionD(String optionD)
{
this.optionD=optionD;
}
public String getOptionD()
{
return(this.optionD);
}}
action:package cn.test.user.web;import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import java.sql.*;
import java.util.*;
public class stuTestAction extends Action { @Override
public ActionForward execute(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response)throws Exception {
ArrayList testList=new ArrayList();
dataPool myData=new dataPool();
try{
Connection myCon=myData.getConnection();
Statement myState=myCon.createStatement();
ResultSet mySet=myState.executeQuery("select * from single_select_table");
while(mySet.next())
{
stuTestForm test=new stuTestForm();
test.setQid(mySet.getString("question_id"));
test.setOptionA(mySet.getString("optionA"));
test.setOptionA(mySet.getString("optionB"));
test.setOptionA(mySet.getString("optionC"));
test.setOptionA(mySet.getString("optionD"));
testList.add(test);
}
mySet.close();
myState.close();
myCon.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}}
还有就是jsp迭代不知道怎么写?
request.setAttribute("testList",testList);
Jsp:
<c:forEach items="${testList}" var="list">
${list.stuTestForm中的属性}比如:${list.question_id}
</c:forEach>
request.setAttribute("testList", testList);
页面:
<%
ArrayList testList = (ArrayList)request.getAttribute("testList");
for(int i = 0; i < testList.size(); i++){
stuTestForm test = (stuTestForm)testList.get(i);
%>
<%=test.getOptionA() %> //${test.optionA}也行
以此类推
<% } %>
你使用的是struts1,这个就可以了