Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JDBC how to featch data form db?

Have Programming Question? Ask it here!
 
 
 


Mumbai
how to featch data form db?
2 Answer(s)      a year and 3 months ago
Posted in : JDBC


how to featch data form db?


Advertisement
View Answers

May 22, 2013 at 9:26 AM


/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package com.tcs.ignite.app.servlets;

import com.tcs.ignite.app.dao.ProductDAO; import java.io.IOException; import java.io.PrintWriter; import java.util.ArrayList; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;

/** * * @author 495944 */ public class getData extends HttpServlet {

/**
 * Processes requests for both HTTP
 * <code>GET</code> and
 * <code>POST</code> methods.
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    response.setContentType("text/html;charset=UTF-8");
    PrintWriter out = response.getWriter();
    try {
        /*
         * TODO output your page here. You may use following sample code.
         */
        out.println("<html>");
        out.println("<head>");
        out.println("<title>Servlet getData</title>");
        out.println("</head>");
        out.println("<body>");
        out.println("<h1>Servlet getData at " + request.getContextPath() + "</h1>");
        out.println("</body>");
        out.println("</html>");
    } finally {
        out.close();
    }
}

// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
 * Handles the HTTP
 * <code>GET</code> method.
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    String action = request.getParameter("act");
    if ("all".equalsIgnoreCase(action)) {
        PrintWriter out = response.getWriter();
        response.setContentType("application/json");
        out.print(new ProductDAO().getAllCatBrandSize());
    } else if ("cat".equalsIgnoreCase(action)) {
        PrintWriter out = response.getWriter();
        response.setContentType("application/json");
        String vals = request.getParameter("cat");
        if ("".equalsIgnoreCase(vals)) {
            out.print(new ProductDAO().getAllProducts());
        } else {
            List<Integer> ids = new ArrayList<Integer>();
            for (String val : vals.split(",")) {
                ids.add(Integer.parseInt(val));
            }
            out.print(new ProductDAO().getAllProductsFromSelectedCategory(ids));
        }
    }

}

/**
 * Handles the HTTP
 * <code>POST</code> method.
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    processRequest(request, response);
}

/**
 * Returns a short description of the servlet.
 *
 * @return a String containing servlet description
 */
@Override
public String getServletInfo() {
    return "Short description";
}// </editor-fold>

}



May 22, 2013 at 9:31 AM


jsp

<%-- 
    Document   : TCSBLUE
    Created on : Jan 8, 2013, 1:54:03 PM
    Author     : ignite415
--%>

<%@page import="com.tcs.ignite.app.beans.User"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Online Mens Shoes.com</title>
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <link rel="stylesheet" href="Bootstrap2.2/css/bootstrap.css" />
        <link rel="stylesheet" href="Bootstrap2.2/css/bootstrap-responsive.css" />
        <link rel="stylesheet" href="Bootstrap2.2/css/sticky.css" />
        <link rel="stylesheet" href="CSS/style.css" />
        <style>
            body{

                background: url('Bootstrap2.2/img/background-homenew.png');
                background-repeat: repeat-x;
                background-color: #E3E3E3;
            }
        </style>
        <!--[if IE]><link rel="stylesheet" type="text/css" href="Bootstrap2.2/css/ie.css" /><![endif]-->
        <style>
            input[type=checkbox]{
                margin-left: 50px;
            }
            .thumbnail img{
                width: 300px;
                height: 200px;
            }
        </style>
        <script type="text/javascript" src="jquery.js"></script>
        <script type="text/javascript" src="bootstrap/js/bootstrap.min.js"></script>
        <script type="text/javascript">
            $(document).ready(function(){

                $.getJSON('get','act=all',function(data){
                    var cats = data.cat;
                    for(var i=0;i<cats.length;i++){
                        $('#category').find('.controls').append('<input type="checkbox" name="cat" value="'+cats[i].id+'">&nbsp;'+cats[i].name+'&nbsp;(<a href="#">'+cats[i].count+'</a>)<br>');
                    }


                    var products = data.products;
                    for(var i=0;i<products.length;i++){
                        if(i%3==0){
                        var li = '<li style="margin-left:-0%" class="span4">'
                            +'<div class="thumbnail">'
                            +'<img data-src="holder.js/300x200" alt="" src="products/'+products[i].path+'">'
                            +'<h4>'+products[i].name+'</h4>'
                            + '<p>'+products[i].desc+'</p>'
                        +'<p>'+products[i].price+'</p>'
                        +'<input type="button" class="btn btn-primary" value="add to cart"/>'+'</div></li>';
 //+'<input type="button"value="view details"/>'
                        +'<input type="button" class="btn btn-primary" value="add to cart"/>'+'</div></li>';
                        $('.thumbnails').append(li);
                        }else
                            {
                                var li = '<li style="margin-left:-0%"  class="span4">'
                            +'<div class="thumbnail">'
                            +'<img data-src="holder.js/300x200" alt="" src="products/'+products[i].path+'">'
                            +'<h4>'+products[i].name+'</h4>'
                            + '<p>'+products[i].desc+'</p>'
                            +'<p>'+products[i].price+'</p>'

                         //+'<input type="button"value="view details"/>'
                        +'<input type="button" class="btn btn-primary" value="add to cart"/>'+'</div></li>';
$('.thumbnails').append(li);

                            }
                    }
                    $('.collapse').collapse();
                });
                $('#category').on('change','input[type=checkbox]',function(){
                    var val = new Array();
                    $('#category').find('input[type=checkbox]:checked').each(function(){
                        val[val.length] = $(this).val();
                    });
                    $.getJSON('get','act=cat&cat='+val.toString(),function(data){
                        $('ul.thumbnails').html('');
                        for(var i=0;i<data.length;i++){

                            var li = '<li style="margin-left:-0%" class="span4">'
                                +'<div class="thumbnail">'
                                +'<img data-src="holder.js/300x200" alt="" src="products/'+data[i].path+'">'
                                +'<h4>'+data[i].name+'</h4>'
                                + '<p>'+data[i].desc+'</p>'
                                  //+'<input type="button" value="view details"/>'
                        +'<input type="button" class="btn btn-primary"value="add to cart"/>'+'</div></li>';
                            $('.thumbnails').append(li);


                        }
                    });
                });
            });
        </script>


    </head>
    <body>
        <div class="navbar navbar-fixed-top">

            <div class="navbar-inner">
                <div class="container"> 

                    <a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse-header" style="margin-top: 12px;">
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                    </a>
                    <a class="brand" href="#">
                            <div class="logo"><img src="images/logo.jpg"></div>
                        Stylish.com <BR>
                        <div id="indian"> India's Largest Online Shoe Store</div>
                    </a>
                   <div class="search" <form class="form-search">
                        <div class="input-append">    
                            </div>
                    </from> </div>

                    <div class=" nav-collapse nav-collapse-header collapse navbar-responsive-collapse">
                        <ul class="nav ">

                            <li><a href="home.jsp"  rel="tooltip" data-placement="bottom" data-original-title=""><i class="icon-home"></i>&nbsp;Home</a></li>

                            <li><a href="next2.jsp" rel="tooltip" data-placement="bottom" data-original-title=""><i class="icon-bullhorn"></i> &nbsp;Men's</a></li>
                            <li><a href="aboutus.jsp" rel="tooltip" data-placement="bottom" data-original-title=""><i class="icon-font"></i> &nbsp;About us</a></li>
                          <li><a href="#myfeedback" data-toggle="modal" rel="tooltip" data-placement="bottom" data-original-title="Sign in"><i class="icon-user"></i> &nbsp;Feedback</a></li>

                        </ul>

                        <ul class="nav pull-right">
                                  <%
                                    User user = (User) request.getSession().getAttribute("user");
                                    String msg = (String) request.getAttribute("msg");
                                    if (msg != null) {
                                        out.print("<script>alert('" + msg + "')</script>");
                                    }
                                    if (user == null) {
                                %>



                                <ul class="nav pull-right">
                                    <li><a href="#myModal" data-toggle="modal" rel="tooltip" data-placement="bottom" data-original-title="Sign in"><i class="icon-user"></i> &nbsp;Sign in</a></li>
                                    <li><a href="register.jsp" data-placement="bottom" data-original-title="Sign Up"><i class="icon-thumbs-up"></i> &nbsp;Sign Up</a></li>
                                    </ul>
                                <%} else {%>
                                <h4>Welcome <%= user.getName()%></h4><br>
                                <a href="Login1">Logout</a>
                                <%}%>
                             <li class="dropdown">


                            </li>
                        </ul>
                    </div><!-- /.nav-collapse -->
                </div>
            </div>
        </div>
        <div class="container">
            <div class="content">

                <div class="wrapper">
                    <div class="proper-content">
                        <div class="row">
                            <div class="span12">
                                <div class="row-fluid">
                                    <div class="well" styln-height:e="mi 640px; margin-bottom: 66px; margin-top: 71px; height: 1387px; width: 894px; margin-left: 95px;" >
                                   <div class="row-fluid">
            <div class="span12">
                <div class="span8 pull-right">
                    <div class="products">
                        <ul class="thumbnails">

                        </ul>
                    </div>
                </div>
                <div class="span4">
                    <div class="accordion" id="accordion1">
                        <div class="accordion-group">
                            <div class="accordion-heading">
                                <a href="#category" data-parent="#accordion1" class="accordion-toggle" data-toggle="collapse">Category</a>
                            </div>
                            <div class="accordion-body collapse in" id="category">
                                <div class="controls">

                                </div>
                            </div>
                        </div>

<!--                        <div class="accordion-group">
                            <div class="accordion-heading">
                                <a href="#size" data-parent="#accordion1" class="accordion-toggle" data-toggle="collapse">Size</a>
                            </div>
                            <div class="accordion-body collapse in" id="size">
                                <div class="controls">

                                </div>
                            </div>
                        </div>-->
                    </div>
                </div>
            </div>
        </div>
                                </div>
                            </div>
                        </div>
                    </div><!-- /.proper-content -->

                    <div class="push"></div>

                </div><!-- /.wrapper -->

                <div class="footer-wrapper">
                    <footer>
                      <div style="width: 901px; margin-top: -72px; margin-bottom: 5px; margin-left: 92px;" class="navbar-inner">

                            <div class="pull-left">
                                <small>&copy; 2010-2013 Tata Consultancy Services Limited. All Rights Reserved</small>
                                <br/>
                                <small>
                                    <a rel="nofollow" target="_blank" href="http://www.tcs.com/contact/Pages/default.aspx">Contact us</a>&nbsp;|&nbsp;
                                    <a rel="nofollow" target="_blank" href="http://www.tcs.com/disclaimer/Pages/default.aspx">Disclaimer</a>&nbsp;|&nbsp;
                                    <a rel="nofollow" target="_blank" href="http://www.tcs.com/privacy/Pages/default.aspx">Privacy Policy</a>
                                </small>
                                <br/>
                            </div>
                            <div class="pull-right">
                                <a target="_blank" style="cursor: pointer;" href="http://www.tcs.com"><img src="Bootstrap2.2/img/icon-tata-white.png"/></a>
                            </div>



                        </div>
                    </footer>
                </div>
            </div>
        </div>

         <!--Modals-->

        <!--Sign in-->

        <div id="myModal" class="modal hide fade in" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="false">
                <div class="modal-header">
                    <a class="pull-right" data-dismiss="modal" aria-hidden="true"><i class="icon-remove" style="cursor: pointer"></i></a>
                    <h3><i class="icon-th-large  pull-left" style="margin-right: 10px;margin-top: 8px"></i>sign In</h3>
                </div>
                <div class="modal-body">
                    <form id="fbForm2" class="form-horizontal cmxform" name="fbForm2" method="post" action='Login1'>

                        <div class="control-group">
                            <label class="control-label" for="inputEmail">Email:</label>
                            <div class="controls">
                                <input type="text" id="inputEmail" name="inputEmail" placeholder="Email" class="required email">
                            </div>
                        </div>
                        <div class="control-group" style="margin-bottom: 15px;">
                            <label class="control-label" for="inputPassword">Password:</label>
                            <div class="controls">
                                <input type="password" id="inputPassword1" name="inputPassword1" placeholder="Password" class="required" minlength="8" style="margin-bottom: 10px;">
                                <br>
                                <input type="checkbox"> Remember me

                            </div>
                        </div>
                        <div class="control-group">
                            <div class="controls">
                                <button id="signIn" type="submit" class="btn btn-primary" style="margin-right: 10px;">Sign In</button>
                                <!--<button class="btn" href="fbForm2">Sign Up</button>-->
                            </div>
                        </div>
                        <div class="control-group">
                            <div class="controls">

                            </div>
                        </div>
                        <div class="register"> <a href="register.jsp">  for new user </a></div>
                    </form>
                </div>

            </div>  

            <div class="modal-footer">

<div class="register"> <a href="register.jsp">  for new user </a> <div>
            </div>
        </div>
        <script src="JQuery/jQuery1.8.3.js"></script>
        <script src="Bootstrap2.2/js/bootstrap.js"></script>
        <script>
            $(function() {
                $('li a').tooltip({delay:{show: 750,  hide: 100}});
            });
        </script>
    </body>
</html>


Related Tutorials/Questions & Answers:
DB2
Advertisements
Advertisements
 

 

 

DMCA.com