how to display data from database according to entered value in search field

Ads

 
 

Share on Google+Share on Google+

ena
how to display data from database according to entered value in search field
1 Answer(s)      5 years and 4 months ago
Posted in : JavaScript Questions
this is my search.jsp file

<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>

<%@page import="java.sql.*"%>


<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Healthy Preggers</title>
<meta name="keywords" content="css templates, healthy living, diet, nutrition, fitness, web design" />
<meta name="description" content="Healthy Living - free CSS template provided by templatemo.com" />
<link href="css/templatemo_style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style1 {
    color: #999999
}
.style2 {color: #BF3E3E}
-->
</style>
</head>
<body>
<%@include file = "header.jsp" %>
<%@include file = "menu.jsp" %>


<%   Class.forName("oracle.jdbc.OracleDriver");
     Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "health", "health"); 
       %> 
<body>

<html>
<head>
</head>
<body>
<br><br><br><br><br><br>
<form method="post" name="form1" action="viewsearch.jsp">
<table border="1" width="300" align="center" bgcolor="FFA3B3">
<tr><td colspan=2 style="font-size:12pt;color:#00000;" align="center">
<h3>Enter BMI Value</h3></td></tr>
<tr><td ><b>Enter BMI </b></td>
<td>: <input  type="text" name="bmi_value" id="BMI_VALUE">
</td></tr>

<tr><td colspan=2 align="center">
<input  type="submit" name="submit" value="Search">  
                        <input type="reset" value="Reset" name="Reset" /></td></tr>
</table>
</form>


</body>
</html>

</table>
</form>
</body>
</html>
<br><br><br>

<div id="templatemo_footer">
    Copyright  2012| 
    Designed by:Fara Zati Aina</a> | 
    For: CSC 444</div> 
</center></body>
</html>



this is my searchview.jsp file where it does the process

<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>

<%@page import="java.sql.*"%>


<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Healthy Preggers</title>
<meta name="keywords" content="css templates, healthy living, diet, nutrition, fitness, web design" />
<meta name="description" content="Healthy Living - free CSS template provided by templatemo.com" />
<link href="css/templatemo_style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style1 {
    color: #999999
}
.style2 {color: #BF3E3E}
-->
</style>
</head>
<body>
<%@include file = "header.jsp" %>
<%@include file = "menu.jsp" %>


<%   Class.forName("oracle.jdbc.OracleDriver");
     Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "health", "health"); 
       %> 
<body>

<html>
<head>
</head>
<body>
<br><br><br><br><br><br>
<form method="post" name="form1" action="viewsearch.jsp">
<table border="1" width="300" align="center" bgcolor="FFA3B3">
<tr><td colspan=2 style="font-size:12pt;color:#00000;" align="center">
<h3>Enter BMI Value</h3></td></tr>
<tr><td ><b>Enter BMI </b></td>
<td>: <input  type="text" name="bmi_value" id="BMI_VALUE">
</td></tr>

<tr><td colspan=2 align="center">
<input  type="submit" name="submit" value="Search">  
                        <input type="reset" value="Reset" name="Reset" /></td></tr>
</table>
</form>


</body>
</html>

</table>
</form>
</body>
</html>
<br><br><br>

<div id="templatemo_footer">
    Copyright  2012| 
    Designed by:Fara Zati Aina</a> | 
    For: CSC 444</div> 
</center></body>
</html>



this is my searchview2.jsp file where it display the result


<%-- 
    Document   : viewSearch2
    Created on : Jun 18, 2012, 8:21:02 PM
    Author     : Asus
--%>


<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>

<%@page import="java.sql.*"%>


<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Healthy Preggers</title>
<meta name="keywords" content="css templates, healthy living, diet, nutrition, fitness, web design" />
<meta name="description" content="Healthy Living - free CSS template provided by templatemo.com" />
<link href="css/templatemo_style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style1 {
    color: #999999
}
.style2 {color: #BF3E3E}
-->
</style>
</head>
<body>
<%@include file = "header.jsp" %>
<%@include file = "menu.jsp" %>


<%   Class.forName("oracle.jdbc.OracleDriver");
     Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "health", "health"); 
       %> 
<body>
<html>
    <body>
<h1 align="left">VIEW SEARCH</h1>



                <%
                 Statement st=con.createStatement();
                 ResultSet rs3=st.executeQuery("SELECT M.MEMBER_ID, M.FNAME,M.LNAME,M.AGE,B.HEIGHT,B.WEIGHT, B.BMI_VALUE FROM MEMBER M , BMI B   WHERE M.MEMBER_ID=B.MEMBER_ID");
                %>
                    <table  align="center"  border="1">

                    <tr  bgcolor="ACFA58"> 
                           <th class="listingContent" witdth="10">No</th>
                          <th class="listingContent" width="100">ID</th>
                          <th class="listingContent" width="1000">FIRST NAME</th>
                          <th class="listingContent" width="1000">LASTNAME</th>
                          <th class="listingContent" width="1000">AGE</th>
                          <th class="listingContent" width="1000">HEIGHT</th>
                          <th class="listingContent" width="1000">WEIGHT</th>
                          <th class="listingContent" width="300">BMI VALUE</th>

                    </tr>


             <% String data=request.getParameter("bmi_value"); 
             if(data != "bmi_value"){ %>

             <script language="javascript">
             alert("There is no data.");
             window.location.href = "searchBMI.jsp";
             </script> 
            <% } 
          else{

    %>  <%
            int y= 1;
            while(rs3.next())
              { %>

                <tr bgcolor="D0F5A9"  onclick="form1">
                <td class="listingContent" align="center"><%= y%></td>
                <td class="listingContent" width="10" align="center"><%= rs3.getString("member_id") %></td>
               <td class="listingContent" width="10" align="center"><%= rs3.getString("fname") %></td>
               <td class="listingContent" width="10" align="center"><%= rs3.getString("lname")%></td>
               <td class="listingContent" width="10" align="center"><%= rs3.getString("age")%></td>
               <td class="listingContent" width="10" align="center"><%= rs3.getString("height")%></td>
               <td class="listingContent" width="10" align="center"><%= rs3.getString("weight")%></td>
               <td class="listingContent" width="10" align="center"><%= rs3.getString("bmi_value")%></td>
                </tr> 

                <% 
                y++;
                }%>
                   } </table>

    </body>
</html>


i suppose to get this table, but it shows wrong value .i want it to be the same with what i have entered in the search field. let say i entered 17, so i want the data of user who have 17 as their bmi value to appear. help me please. i don't know which line i have to add or change my code. thank you :)
Ads
View Answers

June 20, 2012 at 4:00 PM


Here is a simple JSP search application where user is allowed to enter BMI value and display the results accordingly.

1)search.jsp:

<html>
<head>
</head>
<body>
<br><br><br><br><br><br>
<form method="post" name="frm" action="..//search">
<table border="0" width="300" align="center" bgcolor="#CDFFFF">
<tr><td colspan=2 style="font-size:12pt;color:#00000;" align="center">
<h3>Search Form</h3></td></tr>
<tr><td ><b>Enter BMI</b></td>
<td>: <input type="text" name="bmi" id="bmi">
</td></tr>
<tr><td colspan=2 align="center">
<input type="submit" name="submit" value="Search"></td></tr>
</table>
</form>
</body>
</html>

2) Search.java:

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.*;
import java.sql.*;
import java.util.*;

public class Search extends HttpServlet{

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException,IOException{
response.setContentType("text/html");
PrintWriter out = response.getWriter();

System.out.println("MySQL Connect Example.");
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";
String dbName = "register";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "root";


Statement st;
try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+dbName,userName,password);
System.out.println("Connected to the database");
String bmi = request.getParameter("bmi");
String query = "select * from item where bmi='"+bmi+"'";
st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
out.println("<table border='1'><tr><th>Member ID</th><th>First Name</th><th>Last Name</th><th>Age</th><th>BMI Value</th></tr>");
while(rs.next()){

out.println("<tr><td>"+rs.getString(1)+"</td><td>"+rs.getString(2)+"</td><td>"+rs.getString(3)+"</td><td>"+rs.getString(4)+"</td><td>"+rs.getString(5)+"</td></tr>");
}
out.println("</table>");
conn.close();
System.out.println("Disconnected from database");
} catch (Exception e) {
e.printStackTrace();
}
}
}

3)web.xml:

<servlet-name>Search</servlet-name>
<servlet-class>Search</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Search</servlet-name>
<url-pattern>/search</url-pattern>
</servlet-mapping>

Ads









Related Tutorials/Questions & Answers:
how to display data from database according to entered value in search field
how to display data from database according to entered value in search... it to be the same with what i have entered in the search field. let say i entered 17...; <input type="submit" name="submit" value="Search">
display data from database in textbox when id entered in textbox
display data from database in textbox when id entered in textbox  i wanted to enter data in textbox .depending on entered data in textbox data from database should be displayed dynamically in textbox
Advertisements
how to display data from database in jsp
how to display data from database in jsp  how to display data from database in jsp
how to display data from jsp file into database
how to display data from jsp file into database  this is a jsp file...+",'"+email+"')"); out.println("Data is successfully inserted into database...(); in the below example. the error is "cannot convert from java.sql.Statement
How to display data from database in a TableView
How to display data from database in a TableView  I need to populate a TableView (JavaFx) with database items. I designed the TableView in JavaFx... at this. The classes: This is the Class that creates the database data object: import
how to display data into textboxes which is retrieved from the database
how to display data into textboxes which is retrieved from the database  I would like to know how to display data into textboxes which is retrieved from database in jsf. could you please provide a small example of how to do
how to display data into textboxes which is retrieved from the database
how to display data into textboxes which is retrieved from the database  I would like to know how to display data into textboxes which is retrieved from database in jsf. could you please provide a small example of how to do
how to display data into textboxes which is retrieved from the database
how to display data into textboxes which is retrieved from the database  I would like to know how to display data into textboxes which is retrieved from database in jsf. could you please provide a small example of how to do
Search data from database - Java Beginners
to user name. (means search all field from database and display using...Search data from database  Hi Deepak, This is not correct code... in the previous page, then according to that, use the sql command as delete * from
how to get the data from database&how to display the database data in jsf - Java Server Faces Questions
how to get the data from database&how to display the database data in jsf  Hi, 1.how to get the data from database. 2.how to display the database... and to display the data from database in jsf visit to : http://www.roseindia.net/jsf
How to display data from database in a TableView via Hibernate
How to display data from database in a TableView via Hibernate  I need to populate a TableView (JavaFx) with database items. I designed the TableView... at this. The classes: This is the Class that creates the database data object
Display Data from Database in JSP
; <html> <head> <title>display data from...;To display all the data from the table click here...</h2></TD>..., to show data from the database click on the link that calls another .jsp file named
How to display data fom MySQL DataBase-table in to JSP file by submitting a value in combobox.
How to display data fom MySQL DataBase-table in to JSP file by submitting a value in combobox.   I have the same problem.plz help me. I have MySQL... have to display the Nodename and packageno. i.e.,select nodename,packageno from
change color according to the database value
change color according to the database value  any one know how to get values from database ( 1 or 0 ) and according to that change the color ( red or green) of given list
Display Data from Database in JSF Application
Display Data from Database in JSF Application  ... data from database in JSF application. Developing JSF  Application In this section, we are going to display data from database in JSF based web
how to display records from database
how to display records from database  I want to display records from database in tables, the database is having 2000 records and i want to display 20 records at a time and to use next and previous link buttons to show
how to retrieve data from database using combobox value without using request.getParameter in jsp - JSP-Servlet
how to retrieve data from database using combobox value without using request.getParameter in jsp  Answer pl
how to retrieve data from database ?????/
how to retrieve data from database ?????/  how to retrieve data from database
how to retrieve data from database ?????/
how to retrieve data from database ?????/  how to retrieve data from database
how to retrieve data from database ?????/
how to retrieve data from database ?????/  how to retrieve data from database
how to retrieve data from database ?????/
how to retrieve data from database ?????/  how to retrieve data from database
display data from database on selecting option of dropdownlist
display data from database on selecting option of dropdownlist   Sir I want to display data from database by just selecting option of dropdown list... is that to display image from database in a grid format or in a fixed column and row
display data from database on selecting option of dropdownlist
display data from database on selecting option of dropdownlist   Sir I want to display data from database by just selecting option of dropdown list... is that to display image from database in a grid format or in a fixed column and row
display data from database on selecting option of dropdownlist
display data from database on selecting option of dropdownlist   Sir I want to display data from database by just selecting option of dropdown list... is that to display image from database in a grid format or in a fixed column and row
display data from database on selecting option of dropdownlist
display data from database on selecting option of dropdownlist   Sir I want to display data from database by just selecting option of dropdown list... is that to display image from database in a grid format or in a fixed column and row
how to retrieve data from database
how to retrieve data from database  unable to retrieve data from database using mySQL by using jsp sessions and beans for editing
How To Display both image and data into Swing JTable which is retrieved from ms access database
How To Display both image and data into Swing JTable which is retrieved from ms access database  So far this is my code how can i display both image and data from database.. while (rs.next()) { Vector row = new Vector(columns
display data from a table in Access Database in a HTML page
display data from a table in Access Database in a HTML page  how to display data from a table in Access Database in a HTML page in a Java Program
jfreechart display from access database data.
jfreechart display from access database data.  I have made a database... to retrieve the data from the access database using prepared statement and then display... is to be done in a servlet.. Note that it is a access made database. How can I
How to retrieve and display image from database in Java?
How to retrieve and display image from database in Java?  Hi, I am writing a web application for reading the data from database and displaying.... Please check the it at How to store and retrieve image from database in JSP
data are not display in JSP from database - JSP-Servlet
data are not display in JSP from database   i want to finding some data through a SQL query from SQL server database to a JSP page based on some.... one.jsp value of 'school' request parameter are comming from the link