//Call Template File     
<%@ taglib uri='/WEB-INF/struts-template.tld' prefix='template' %>

//If you Get Errot Call ErrorPage.jsp and import 
//all java packages which are needed like java.sql.*
<%@ page language="java" import="java.sql.*" errorPage="ErrorPage.jsp"%>

//Use the Data Base Connection Pool Bean inside BeanDir 
//Directory whose name is DbBean.java compiled into DbBean.class
<jsp:useBean
id="db"
class="BeanDir.DbBean"
scope="request"/>

<jsp:setProperty
name="db"
property="*"/>

<%
//Declare and Capture All Variables which we will 
//be getting from a Previous file in this case modrecresp.jsp
 int numCols;
 ResultSet rs = null;
 ResultSetMetaData rsmd = null;
 String Name = request.getParameter("sname");
 String Address = request.getParameter("saddr");
 String FName = request.getParameter("fname");
 String Sex = request.getParameter("sex");
 String Yearsel = request.getParameter("myclass");
 String Sectionsel = request.getParameter("mysec");
 String SSLC = request.getParameter("SSLC");
 String PHOTO = request.getParameter("PHOTO");
 String CHARCERT = request.getParameter("charCERT");
 String NCCCERT = request.getParameter("nccCERT");
 String imagename = request.getParameter("imname");

//Write an UPDATE SQL Statement please Observe 
//the way i have used Single and Double Quotes
 String sql="UPDATE student_det SET Name='"+Name+"', 
 Address='"+Address+"', FName='"+FName+"', 
 Sex='"+Sex+"', Yearsel='"+Yearsel+"', Sectionsel='"+Sectionsel+"', 
 SSLC="+SSLC+", PHOTO="+PHOTO+", CHARCERT="+CHARCERT+", 
 NCCCERT="+NCCCERT+", imagename='"+imagename+"' 
 WHERE RegistrationNo="+request.getParameter("RegistrationNo"); 

try
{
  //Connect to Database or in other words call connect() 
  //method inside DbBean.java File
  db.connect();
}
catch (ClassNotFoundException e)
{
  //If Unable to Connect to DB Give Error Message 
  //something wrong with DB Driver
  throw new ServletException("Db Driver not found !", e);
}
catch (SQLException e)
{
  //If something wrong with SQL Give Error Message 
  //something wrong with SQL Statement
  throw new ServletException("SQL not correct !", e);
}

try
{
  //If you could connect to DB and SQL is correct 
  //then call execSQLupdate() method with in DbBean.java which Updates DB Record
  db.execSQLupdate(sql);
}
catch (SQLException e)
{
  //Something Really Wrong Please chek out
  throw new ServletException("Your Query is Wrong", e);
}

//First Thing First this is a Part of Java Package 
//named BeanDir so u place this in BeanDir Directory
package BeanDir;     

//Import all that is wanted
import java.util.*;
import java.sql.*;
import java.io.*;

public class DbBean 
{

 //Some Lines about the Bean This can vary from people to people 
 //the way to chose to write it
 //Written by James Smith : mail me at [email protected]
 //my URL http://www.geocities.com/james_smith73
 //Code Date : 07 - July - 2003

 //dbDriver is a String type variable that is initialised 
 //as "sun.jdbc.odbc.JdbcOdbcDriver"
 String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
 //dbURL is a String type variable that is initialised as 
 //"jdbc:odbc:< my datasource name as in ODBC setup >"
 String dbURL = "jdbc:odbc:james";

 //Guys using Oracle may try these lines

 //Oracle oci7 drivers
 //JDBC driver: oracle.jdbc.driver.OracleDriver
 //Database URL: jdbc:oracle:oci7:

 //Oracle oci8 drivers 
 //JDBC driver: oracle.jdbc.driver.OracleDriver
 //Database URL: jdbc:oracle:oci8:@localhost:1521:

 //Oracle thin drivers
 //JDBC driver: oracle.jdbc.driver.OracleDriver
 //Database URL: jdbc:oracle:thin:@localhost:18 

 private Connection dbCon;

 public DbBean()
 {
  super();
 }

 public boolean connect() throws ClassNotFoundException, SQLException
 {
  //Make Database Connection using DriverManager.getConnection
  Class.forName(this.getDbDriver());
  dbCon = DriverManager.getConnection(this.getDbURL());
  return true;
 }
 
 public void close() throws SQLException
 {
  //Good Practice to always to close connection
  dbCon.close();
 }

 public ResultSet execSQL (String sql) throws SQLException
 {
  //You can always see SQL Getting execute while using 
  //SELECT statement of SQL at your command Prompt 
  //This will help u debug SQL Errors
  System.out.println("sql is "+sql);
  Statement s = dbCon.createStatement();
  ResultSet r = s.executeQuery(sql);
  //Return the Result you Get from the 
  //Select Query to the JSP File which called
  return (r == null) ? null : r;
 }

 public void execSQLupdate (String sql) throws SQLException
 {
  //Used for UPDATE and DELETE SQL Statements 
  System.out.println("sql is "+sql);
  Statement s = dbCon.createStatement();
  s.executeUpdate(sql);
  //You need not return anything back Just Execute the statements
 }

 public String getDbDriver()
 {
  //Return the value of variable dbDriver to the one 
  //which call this, see line getConnection(this.getDbURL());
  return this.dbDriver;
 }

 public void setDbDriver(String newValue)
 {   
  this.dbDriver = newValue;
 }

 public String getDbURL()
 {
  return this.dbURL;
 }

 public void setDbURL(String newValue)
 {
  this.dbURL = newValue;
 }
}

<!-- The below lines means in simple english when some one 
types in address bar http://localhost:8080/jamesj2ee/ u actually load the
home page as http://localhost:8080/jamesj2ee/introduction.jsp -->

<welcome-file-list>
	 <welcome-file>introduction.jsp </welcome-file>
</welcome-file-list>

<!-- The below lines means include struts-template.tld file 
for reference -->

<taglib>
	 <taglib-uri>/WEB-INF/struts-template.tld</taglib-uri>
	 <taglib-location>/WEB-INF/struts-template.tld</taglib-location>
</taglib>
				 

<%@ taglib uri='/WEB-INF/struts-template.tld' prefix='template' %>

<template:insert template='/chapterTemplate.jsp'>
  <template:put name='title' content='Templates' direct='true'/>
  <template:put name='header' content='/header.html' />
  <template:put name='sidebar' content='/sidebar.jsp' />
  <template:put name='content' content='/showrec.jsp'/>
  <template:put name='footer' content='/footer.html' />
</template:insert>
			

Error: 500
Location: /jamesj2ee/chosen1resp.jsp
Internal Servlet Error:

org.apache.jasper.JasperException: 
Unable to compile class for JSPD:\tomcat\work\localhost_8080%2Fjamesj2ee\
_0002fchosen_00031resp_0002ejspchosen1resp_jsp_3.java:65: 
Class BeanDirS.mysimplebean not found.
BeanDirS.mysimplebean mybeanid = null;
                        ^
D:\tomcat\work\localhost_8080%2Fjamesj2ee\
_0002fchosen_00031resp_0002ejspchosen1resp_jsp_3.java:68: 
Class BeanDirS.mysimplebean 
not found.
mybeanid= (BeanDirS.mysimplebean)
                                       ^
D:\tomcat\work\localhost_8080%2Fjamesj2ee\
_0002fchosen_00031resp_0002ejspchosen1resp_jsp_3.java:73: 
Class BeanDirS.mysimplebean not found.
mybeanid = (BeanDirS.mysimplebean) 
Beans.instantiate(this.getClass().getClassLoader(), "BeanDirS.mysimplebean");
                                                ^
3 errors

Error: 500
Location: /jamesj2ee/chosen1resp.jsp
Internal Servlet Error:
org.apache.jasper.JasperException: 
Unable to compile class for JSPD:\tomcat\work\localhost_8080%2Fjamesj2ee\
_0002fchosen_00031resp_0002ejspchosen1resp_jsp_4.java:282: 
';' expected.
db.connect()

Error: 500
Location: /jamesj2ee/chosen1resp.jsp
Internal Servlet Error:
org.apache.jasper.JasperException: 
Unable to compile class for JSPD:\tomcat\work\localhost_8080%2Fjamesj2ee
\_0002fchosen_00031resp_0002ejspchosen1resp_jsp_4.java:319: 
Invalid type expression.

rs.getString(3)  
                 ^
D:\tomcat\work\localhost_8080%2Fjamesj2ee\
_0002fchosen_00031resp_0002ejspchosen1resp_jsp_4.java:322: 
Invalid declaration.
out.write("\"> Student Address