hai sir, how to forward the select query result to jso page using java code please help me .its urgent
Hi,
Follow these steps:
1)Create a Java Bean:
package form; import java.sql.*; import java.util.*; public class EmpBean { public List dataList(){ ArrayList list=new ArrayList(); try{ Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from employee"); while(rs.next()){ list.add(rs.getString("name")); list.add(rs.getString("address")); list.add(rs.getString("contactNo")); list.add(rs.getString("email")); } } catch(Exception e){} return list; } }
2)Create a Servlet:
import java.io.*; import java.util.*; import javax.servlet.*; import javax.servlet.http.*; public class BeanInServlet extends HttpServlet{ protected void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException{ form.EmpBean p = new form.EmpBean(); List list=p.dataList(); req.setAttribute("data", list); RequestDispatcher rd = req.getRequestDispatcher("/jsp/beandata.jsp"); rd.forward(req, res); } }
3)In web.xml, do servlet mapping:
<servlet> <servlet-name>BeanInServlet</servlet-name> <servlet-class>BeanInServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>BeanInServlet</servlet-name> <url-pattern>/BeanInServlet</url-pattern> </servlet-mapping>
4)Create a jsp page 'beandata.jsp':
<%@page language="java" import="java.util.*" %> <html> <body> <table border="1" width="303"> <tr> <td width="119"><b>Name</b></td> <td width="168"><b>Address</b></td> <td width="119"><b>Contact no</b></td> <td width="168"><b>Email</b></td> </tr> <%Iterator itr;%> <% List data= (List)request.getAttribute("data"); for (itr=data.iterator(); itr.hasNext(); ){ %> <tr> <td width="119"><%=itr.next()%></td> <td width="168"><%=itr.next()%></td> <td width="168"><%=itr.next()%></td> <td width="168"><%=itr.next()%></td> </tr> <%}%> </table> </body> </html>
Thanks
Ads