how to featch data form db?
how to featch data form db?
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+'"> '+cats[i].name+' (<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> Home</a></li>
<li><a href="next2.jsp" rel="tooltip" data-placement="bottom" data-original-title=""><i class="icon-bullhorn"></i> Men's</a></li>
<li><a href="aboutus.jsp" rel="tooltip" data-placement="bottom" data-original-title=""><i class="icon-font"></i> 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> 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> Sign in</a></li>
<li><a href="register.jsp" data-placement="bottom" data-original-title="Sign Up"><i class="icon-thumbs-up"></i> 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>© 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> |
<a rel="nofollow" target="_blank" href="http://www.tcs.com/disclaimer/Pages/default.aspx">Disclaimer</a> |
<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:
Advertisements
Ads