我现在有个a.jsp,它上面有2个文本框和1个确定按钮.我现在能点击按钮把这2个文本框的数据提交到数据库.
我现在需要在打开a.jsp的时候从数据库查出数据并且显示在这2个文本框.
我是新手,请提供a.jsp,aAction.java,aActionForm.java这3个东西的代码,不然我看不懂
我现在需要在打开a.jsp的时候从数据库查出数据并且显示在这2个文本框.
我是新手,请提供a.jsp,aAction.java,aActionForm.java这3个东西的代码,不然我看不懂
楼主去看看 mvc 模式,就明白了
<form action="servlet?" method="post">
<input type="text" name="username"><input type="text" name="password">
</form>在servlet的代码
import java.io.IOException;
import java.io.PrintWriter;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class PageServelt extends HttpServlet {
public PageServelt() {
super();
}
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { Class.forname("....");
Connection conn=DriverManager.getConnection(url,username,password);
Statement stmt=conn.createStatement(); stmt.executeupdate("select * from table where username='"+request.getParameter("username")+"'"); ArrayList array=new ArrayList();
while(rs.next()){
JavaBean bean=new JavaBean();
bean.set(..);
array.add(bean);}
request.setAttribute("array",array);
response.sendRedirect("/a.jsp");
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { } public void init() throws ServletException { }}
代码网上教程好多,搜搜就是了。
List houlist = null;
String hql = "From HouseRents ORDER BY id DESC";
houlist = houImp.find(hql);
request.setAttribute("houlist", houlist);
return mapping.findForward("ok");jsp页面.
<logic:iterate id="ho" name="supresult">
<tr align="center" style="height: 25px" onmouseover="this.bgColor='#FFFFFF'" onmouseout="this.bgColor='#F6F6F6'" bgcolor="#F6F6F6">
<td>
<input type="checkbox" name="selects"
value="<bean:write name="ho" property="id" />" />
</td>
<td>
<a href="houserentSeleUp.do?id=<bean:write name="ho" property="id" />&type=ck" title="查看详细信息"><bean:write name="ho" property="title" /></a>
</td>
<td>
<bean:write name="ho" property="id"></bean:write>
</td>
<td>
<bean:write name="ho" property="estateIid"></bean:write>
</td>
<td>
<bean:write name="ho" property="address"></bean:write>
</td>
<td>
<bean:write name="ho" property="propertyname"></bean:write>
</td>
</tr>
</logic:iterate>