java - Show JDBC ResultSet in HTML in JSP page using MVC and DAO pattern -


i'm implementing mvc using jsp , jdbc. have imported database class file jsp file , show data of db table. don't know how should return resultset java class jsp page , embed in html.

how can achieve this?

in designed mvc approach, jsp file should not contain line of java code , servlet class should not contain line of jdbc code.

assuming want show list of products in webshop, following code needs created.

  • a product class representing real world entity of product, should javabean.

    public class product {      private long id;      private string name;     private string description;     private bigdecimal price;      // add/generate getters/setters/c'tors/equals/hashcode boilerplate. }

  • a dao class nasty jdbc work , returns nice list<product>.

    public class productdao {      private datasource datasource;      public productdao(datasource datasource) {         this.datasource = datasource;     }      public list<product> list() throws sqlexception {         list<product> products = new arraylist<product>();          try (             connection connection = datasource.getconnection();             preparedstatement statement = connection.preparestatement("select id, name, description, price product");             resultset resultset = statement.executequery();         ) {             while (resultset.next()) {                 product product = new product();                 product.setid(resultset.getlong("id"));                 product.setname(resultset.getstring("name"));                 product.setdescription(resultset.getstring("description"));                 product.setprice(resultset.getbigdecimal("price"));                 products.add(product);             }         }          return products;     }  }

  • a servlet class obtains list , puts in request scope.

    @webservlet("/products") public class productsservlet extends httpservlet {      @resource("jdbc/yourdb") // tomcat, define <resource> in context.xml , declare <resource-ref> in web.xml.     private datasource datasource;     private productdao productdao;      @override     public void init() {         productdao = new productdao(datasource);     }      @override     protected void doget(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception {         try {             list<product> products = productdao.list();             request.setattribute("products", products); // available ${products} in jsp             request.getrequestdispatcher("/web-inf/products.jsp").forward(request, response);         } catch (sqlexception e) {             throw new servletexception("cannot obtain products db", e);         }     }  }

  • finally jsp file in /web-inf/products.jsp uses jstl <c:foreach> iterate on list<product> made available in el ${products}, , uses jstl <c:out> escape string properties in order avoid xss holes when concerns user-controlled input.

    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/format" prefix="fmt" %> ... <table>     <c:foreach items="${products}" var="product">         <tr>             <td>${product.id}</td>             <td><c:out value="${product.name}" /></td>             <td><c:out value="${product.description}" /></td>             <td><fmt:formatnumber value="${product.price}" type="currency" currencycode="usd" /></td>         </tr>     </c:foreach> </table>

to work, call servlet url. provided servlet annotated @webservlet("/products") or mapped in web.xml <url-pattern>/products</url-pattern>, can call http://example.com/contextname/products

see also:


Comments

Post a Comment

Popular posts from this blog

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m
Read more

javascript - Z-index in d3.js -

i have map , when hover effect on region of map below yellow line , circle, last ones disappear. how can solve problem? http://jsfiddle.net/ot21n9qx/ var arc = g.append("path") .style("fill", "none") .style("stroke", "yellow") .style("stroke-width", 2) .attr("d", "m" + pathorigin[0] + "," + pathorigin[1] + " q" + svgpoint[0] + "," + pathorigin[1] + " " + svgpoint[0] + "," + svgpoint[1]); var circlesize = d3.scale.linear() .domain([0, 0.5, 1]) .range([4, 10, 4]); svg not have z order draws objects in order created. need create path , circle after create highlight regions. here forked fiddle: http://jsfiddle.net/o00fzgaf/1/
Read more