JspDynPage with Client Side Eventing and Database

[Former Member]

The blog enlighten a user how to create a JspDynPage, what precisely happens when we create a JspDynPage? And what Bean Should we choose? using client side eventing the jsp page , accessing a database from the application.

A JspDynPage consists of three types of file.

• .java file
• 
  
• Bean file
• 
  
• Jsp file
• 
  
  

The most significant thing when we create a JspDynPage is what kind of Bean should be used .The answer to this is “ it depends what exactly your application want “

1. 
   
2. Create a JspDynPage
3. 
   .While Creating a Jsp Dynpage you need to choose the type of the Bean. The Details about the scope of bean is explained very methodically at
   

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/c87f41849d030de10000000a1550b0/frameset.htm
Methods of JSPDYNPAGE

Our objective now is to fetch the data entered in the UI. Following Code Snippet shows how to pick data for the elements defined in the HTMLB in JAVA file.

<span>InputField ifFirstName = (InputField) getComponentByName("FirstName");InputField ifAge = (InputField) getComponentByName("Age");DropdownListBox dlbUnit = (DropdownListBox) getComponentByName("Unit");this.sFname = ifFirstName.getValueAsDataType().toString() ;this.sUnit = dlbUnit.getSelection().toString() ;this.sAge = ifAge.getValueAsDataType().toString() ;</span>

Here the value obtained is stored inside the variable sFname which is defined globally .( that is why we are using "this" operator)

.

1. 
   Storing Data in the database. Please Once go through the concepts of Prepared and callable statements .(NOTE :- The code uses prepared statement as we are trying to insert a value in the database.insert is a DDL statement.)
   
   
   
   
   <span>Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");connection con = DriverManager.getConnection("jdbc:odbc:Test");/* */String query="insert into UserData values(?,?,?)";/* */PreparedStatement prestat=con.prepareStatement(query);/* setting the values to be inserted into the user table */ prestat.setString(1,sFname); prestat.setString(2,sAge);                  prestat.setString(3,sUnit);         /* */ prestat.executeUpdate() ; /* */      prestat.close();         /* */      con.close();                       }   catch(Exception sqle)  {         myNameContainer.setErrMessage("Update failed ! Please try again."      );</span>
   
2. 
   

I have more or else covered what I intended to do so .I have not put in all the codes since the basic intension of mine was to make user aware of the way .

I may have missed on Certain aspects .Please let me know so that next time I can rectify these.