Intilization of form data

[Mohammad Akon]

Hi all,

Is it possible to initialize a form's fields with the information retrieved from a datasource?? If so.... how?

- mohammad

[Mohammad Akon]

Actually I am trying to create a edit profile page.....

my configurations are as follows:

struts-config.xml

    
    <data-sources>
        <data-source>
            <set-property property="driverClass" value="com.mysql.jdbc.Driver" />
            <set-property property="url" value="jdbc:mysql://localhost/test?autoReconnect=true" />
            <set-property property="maxCount" value="5"/>
            <set-property property="minCount" value="1"/>
            <set-property property="user" value="root"/>
            <set-property property="password" value="test001"/>
        </data-source>
    </data-sources>
    <form-beans>
        .........
        <form-bean name="editProfileForm" type="com.admin.EditProfileForm" />
        .........
    </form-beans>
.........
.........
        <action path="/editProfile" 
                type="com.admin.EditProfileAction" 
                name="editProfileForm" 
                scope="request" 
                input="/editProfile.jsp" 
                validate="false" > 
            <forward name="success" path="/profile.jsp"/> 
            <forward name="failure" path="/updateFailure.jsp"/> 
        </action>
.........
.........
 

EditProfileForm.java

package com.admin;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts.action.*;
 
import java.sql.*;
import javax.servlet.ServletContext;
import javax.servlet.http.*;
import javax.sql.DataSource;
 
public class EditProfileForm extends ActionForm {
 
    private String name;
    private String address;
    private String phone;
    private String email;
    
    public EmailForm(){
 
            name = profileRetrieve("Mohammad");
            address = " ";
            phone = " ";
            email = " ";
    }
 
    public void setName(String name){
        this.name = name;
    }
    public String getname(){
        return this.name;
    }
        
    public void setAddress(String address){
        this.address = address;
    }
    public String getAddress(){
        return this.address;
    }
    
    public void setPhone(String phone){
        this.phone = phone;
    }
    public String getPhone(){
        return this.phone;
    }
    
    public void setEmail(String email){
        this.email = email;
    }
    public String getEmail(){
        return this.email;
    }
    
     public ActionErrors validate(ActionMapping mapping, HttpServletRequest request) {
       
        ActionErrors errors = new ActionErrors();
        
        if (getEmail() == null || getEmail().length() < 1) {
            errors.add("Email ", new ActionError("error.email"));
        }
        ........
        ........
        return errors;
    }
    
   
    private String profileRetrieve(String column){
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
 
        ServletContext context = servlet.getServletContext();
        DataSource dataSource = (DataSource)context.getAttribute("org.apache.struts.action.DATA_SOURCE");
        
        try {
            conn = dataSource.getConnection();
            stmt = conn.createStatement();
            String db_query = "select lastName from profile where firstName='" + column + "'";
            
            
            rs = stmt.executeQuery(db_query);
            
            return (column + " " + rs.getString("lastName"));
        }
        catch(SQLException e){
            System.out.printf("errors: ", e.toString());
        }
        catch(Exception e){
            System.out.println("errors: " + e.toString());
        }
        finally{
            try{
                if(rs != null)
                    rs.close();
                if(stmt != null)
                    stmt.close();
                if(conn != null)
                    conn.close();
            }
            catch(SQLException e){
                e.printStackTrace();
            }
        }
        
        return "";
    }

EditProfileAction.java

package com.admin;
 
import java.io.IOException;
import java.sql.*;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import javax.sql.DataSource;
import org.apache.struts.action.*;
 
public class EditProfileAction extends Action{
 
    protected void updateProfile(ActionForm form) {
         .........        
         .........
         // this fnc was working fine
         .........
         .........
    }
 
    @Override
    public ActionForward perform(ActionMapping mapping, 
                                 ActionForm form, 
                                 HttpServletRequest request, 
                                 HttpServletResponse response)throws IOException, ServletException{
        
        String target = new String("success");
 
        if(isCancelled(request)){
            return mapping.findForward("main");
        }
        
 
        EmailForm eForm = (EmailForm)form;
        System.out.println(request.getParameter("emailToAdmin"));
        
        updateProfile(eForm);
            
        
        return (mapping.findForward(target));
    }
}

editProfile.jsp

<%@ page language="java" contentType="text/html" %>
<%@ page import="java.util.*, javax.mail.*, javax.mail.internet.*" %>
<%@ page import="java.lang.String, java.io.*, java.io.FileReader" %> 
<%@ page import="org.apache.regexp.*" %>  
<%@ page import="java.lang.*, java.lang.Number, java.text.NumberFormat, java.text.DecimalFormat" %>
<%@ page import="com.admin.EmailForm" %>
 
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>
<%@ taglib prefix="ora" uri="orataglib" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jstl/fmt" %>
 
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<HTML>
<BODY>

<h1>EDIT YOUR PROFILE</h1> <br>

<html:form action="/editProfile" name="editProfileForm" type="com.admin.EditProfileForm" scope="request"> 
<html:errors/>
<table>
<tr>
<td>Name:</td>
<td><html:text property = "name" size="150" maxlength="150"/></td>
</tr>
<tr>
<td>Address:</td>
<td><html:text property = "address" size="150" maxlength="150"/></td>
</tr>
<tr>
<td>Phone:</td> 
<td><html:text property = "phone" size="150" maxlength="150" /></td>
</tr>
<tr>
<td>Email Address:</td> 
<td><html:text property = "email" size="150" maxlength="150" /></td>
</tr>
<tr>
<td><html:submit/></td>
<td><html:cancel>Cancel</html:cancel></td>
</tr>
</table>
</html:form>
</BODY>
</HTML>

While trying to load the page I am getting the following error:

org.apache.jasper.JasperException: An exception occurred processing JSP page /editProfile.jsp at line 21
 
20: 
21: <html:form action="/editProfile" name="editProfileForm" type="com.admin.EditProfileForm" scope="request"> 
22: <html:errors/>
23: <table>
24: <tr>
 
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 
root cause
 
javax.servlet.ServletException: javax.servlet.jsp.JspException: Exception creating bean of class com.admin.EditProfileForm: java.lang.NullPointerException
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.editProfile_jsp._jspService(editProfile_jsp.java:151)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
........
........

[ February 19, 2008: Message edited by: Mohammad Akon ]

[ February 19, 2008: Message edited by: Mohammad Akon ]
[ February 19, 2008: Message edited by: Mohammad Akon ]

[Joe Ess]

javax.servlet.ServletException: javax.servlet.jsp.JspException: Exception creating bean of class com.admin.EditProfileForm: java.lang.NullPointerException

This line in the stack trace says you had a null pointer exception in EditProfileForm. You didn't give us enough of the stack trace to see the source line so I can't tell you exactly where it is, but the problem is in your code.