I want to know where to put jsp code to make an dynamic html page.

Hi;

I want to know where to put jsp code to make an dynamic html page.

I wrote like that but still not working

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  <meta name="generator" content="NoteTab Light 4.9">
  <meta name="author" content="TengYong Ng">
    
<title>fare</title>

<%
 	String tno = request.getParameter("tno");
	Integer trno = parseInt(tno);
	String dat = request.getParameter("dt");
	String src = request.getParameter("src");
	String dst = request.getParameter("dst");
	String cls = request.getParameter("class");
	String ag = request.getParameter("age");
	String consc = request.getParameter("concsn");
	
	
	try
	{
		Class.forName("sun.jdbc.JdbcOdbcDriver");
        Connection con = DriverManager.getConnection("jdbc:odbc:Database1");
        Statement st = con.createStatement();
       st.executeUpdate("insert into fare(trainno,tdate,sourcestation,destinationstation,classcat,agecat,concission) values('"+trno+"','"+dat+"','"+src+"','"+dst+"','"+cls				          +"','"+ag+"','"+consc+"')");
        con.close();
        out.println("Data is successfully inserted into database.");
	}
	catch(NumberFormatException e)
	{
    	System.out.println(e);
	}

%>

<form method="post" action="../jsp/fare.jsp" name="frm" onsubmit="return fare(this);">
<caption align="center" style="font-size:24px; font-family:Arial, Helvetica, sans-serif;background-color:#0033FF; color:#FF9966; font-style:italic;">
	Enter Following Details To View Fare Details</caption>
	
 
<tr>
<th>Train no</th>
<td><input type="text" name="tno" /></td>
</tr>

<tr>
<th> Date </th>
<td><input type="text" name="dt" id="date1" size="25" maxlength="25" /> 
	<a href="javascript:NewCal('date1','ddmmmyyyy')">
	<img src="../rlyimgs/calendar.gif" alt="Pick a date" border="0"/> </a> </td>
</tr>
<tr>
  <th>Source station code</th>
   <td><input type="text" name="src" /></td>
</tr>
<tr>
   <th>Destination station code</th>
   <td><input type="text" name="dst" /></td>
</tr>
<tr>
     <th>Class</th>
     <td><select name="class">  
    <option selected="" value="default">(Please select a class)</option>  
    <option value="FIC">First AC</option>  
    <option value="SA">Second AC</option>  
    <option value="TA">Third Ac</option>  
    <option value="3AE">3AC Economy</option>  
    <option value="FC">First Class</option>
	<option value="SC">Sleeper Class</option>
	<option value="SEC">Second Class</option>
	</select> </td>
</tr>
<tr>
	<th>Age</th>
   <td><select name="age">  
    <option selected="" value="agedefault">(Please select a age)</option>  
    <option value="FIC">Child Age[5-11]</option>  
    <option value="SA">Adult Age[12 and above]</option>  
    <option value="TA">Senior Citizen Female Age[58 and above]</option>  
    <option value="3AE">Senior Citizen Male Age[58 and above]</option>  
    </select> </td>
</tr>
	
<tr>
	<th>Concenssion</th>
    <td><select name="concsn">  
    <option selected="" value="concsndefault">(Please select a class)</option>  
    <option value="FIC">Article Clerk[ARTCLK (50%)]</option>  
    <option value="SA">Artist Lower Class [ARTISF (75%)]</option>  
    <option value="TA">Artist Upper Class  [ARTIUF (50%)]</option>  
    <option value="3AE">ward 50% -> [AWD50 (50%)]y</option>  
    <option value="FC">Award 75% -> [AWD75 (75%)]</option>
	<option value="SC">Award 100% -> [AWD100 (100%)]</option>
	<option value="SEC">Bharat Scouts/Guides -> [BSGUDF (50%)]</option>
	</select> </td>
</tr>
<tr>
    <td align="right"><input type="submit" name="Get Fare" value="Get Fare" /></td>
    <td align="left"> <input type="reset" value="clear" /></td>
</tr>
</table>

</form>

</body>

</html>

Please help me.
Thanks.

I've added code tags to make this easier to read. What do you mean by "not working"? See TellTheDetails for examples of what information to provide.

Some general comments:

JSPs shouldn't have Java code in them. This is a decade out of date practice. (read about MVC for why)

Consider using a PreparedStatement (read about SQL injection for why)

Double check the book you got this code/pattern from. The JDBC code has a resource leak

problem has solved.

thanks.