what codes do i have to change to make my result display if only i enter the correct value? suppose if i click search,then the result will be display at the bottom.. if not.. only the header will be shown. i suppose to put an if statement,but im not sure where to put it. before or after my while statement in search.jsp file. please help. thank you so much.
this is my viewsearch.jsp file
<%--
Document : VIEW
Created on : Jun 9, 2012, 11:20:18 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 language ="java" 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">
<%
Class.forName("oracle.jdbc.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "health", "health");
String value= request.getParameter("bmi_value");
%>
<%
double value1= Double.parseDouble(request.getParameter("bmi_value"));
%>
<%
String SQLupdate = "SELECT MEMBER_ID,BMI_VALUE FROM BMI WHERE BMI_VALUE =value1";
PreparedStatement st = con.prepareStatement(SQLupdate);
Statement statement = con.createStatement();
%>
<%
if (value1 < 18.5)
{
statement.executeQuery("SELECT M.MEMBER_ID, M.FNAME,M.LNAME,M.AGE,B.HEIGHT,B.WEIGHT FROM BMI B, MEMBER M WHERE M.MEMBER_ID= B.MEMBER_ID");
}
else
if (value1>=18.5 && value1<=25.0)
{
statement.executeQuery("SELECT M.MEMBER_ID, M.FNAME,M.LNAME,M.AGE,B.HEIGHT,B.WEIGHT FROM BMI B, MEMBER M WHERE M.MEMBER_ID= B.MEMBER_ID");
}
if (value1 > 25.0)
{
statement.executeQuery("SELECT M.MEMBER_ID, M.FNAME,M.LNAME,M.AGE,B.HEIGHT,B.WEIGHT FROM BMI B, MEMBER M WHERE M.MEMBER_ID= B.MEMBER_ID");
}
%>
<script language="javascript">
alert("Successfully Searching.");
window.location.href = "viewSearch2.jsp";
</script>
and 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>
<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>
<%
int y= 1;
while(rs3.next())
{ %>
<tr bgcolor="D0F5A9" style="visibility:hidden" 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>
</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>