All about patriot indian

Populating Drop Down From Database

Hii, I want to know how to populate data from database in my drop down box...MY app first of all asks user to fill a registration Form..In registration Form there are fields like cities,country...Now for this i want to prepare a drop down box but the data for the drop down should be fetched from database....There is a direct <html:link> in my homepage for the registration page...Now i am using Struts but since there is no action Class which is called and no session initialized how will i fetch the data from the database....

Please Help....

14 years ago

Struts

Session Management problem in Struts

I am facing a peculiar problem....I am having an application in which there are 2 different types of users...each shown a different page after logging in...I am chacking at each page whther a user has logged in and if he is not logged in am redirecting him to login page...But the problem is Suppose one user logs in and after sometime he is logging out...Now second user logs in...On pressing back button he is redirected to the pages of the other user and he can do all the stuffs..How to prevent him from accessing that data...

14 years ago

Struts

Problem in SessionManagement in Struts

Hey i solved provblem to certain extent instead of jsp:forward i used response.sendRedirect("login.jsp")...but it is not redirecting to the page...Also its not showing any error...What is causing such thing..I am giving my jsp code please help..

<%@page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1" import="com.ibm.ankurstruts.data.*"%>
<%@ page buffer="256k" %>
<%@taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html"%>
<%@taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean"%>
<%
System.out.println("HADDI");
String str;
//String str1=null;
str=((String)session.getAttribute("loggedin"));
if(str!=null){
System.out.println(str+"..");
System.out.println("Session Active");
//System.out.println(e);
}else{
response.sendRedirect("login.jsp");
System.out.println("CHIRKUT");
}
%>
<html:errors />
<br>
<html:form action="/PreAuthorization">
<table>
<tbody>
<tr>
<td align="left"><bean:message key="proposer.id" /></td>
<td width="5"> </td>
<td><html:text property="proposerID"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="proposer.first.name" /></td>
<td width="5"> </td>
<td><html:text property="proposerFirstName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="proposer.middle.name" /></td>
<td width="5"> </td>
<td><html:text property="proposerMiddleName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="proposer.last.name" /></td>
<td width="5"> </td>
<td><html:text property="proposerLastName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="policy.id" /></td>
<td width="5"> </td>
<td><html:text property="policyID"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.first.name" /></td>
<td width="5"> </td>
<td><html:text property="patientFirstName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.middle.name" /></td>
<td width="5"> </td>
<td><html:text property="patientMiddleName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.last.name" /></td>
<td width="5"> </td>
<td><html:text property="patientLastName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.phone.number" /></td>
<td width="5"> </td>
<td><html:text property="patientPhoneNo"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.street" /></td>
<td width="5"> </td>
<td><html:text property="patientStreet"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.city" /></td>
<td width="5"> </td>
<td><html:text property="patientCity"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.state" /></td>
<td width="5"> </td>
<td><html:text property="patientState"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.emailid" /></td>
<td width="5"> </td>
<td><html:text property="patientEmailID"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.dateofadmittance" /></td>
<td width="5"> </td>
<td><html:text property="dateOfAdmittance"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.dateofdischarge" /></td>
<td width="5"> </td>
<td><html:text property="dateOfDicharge"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="ailment.details" /></td>
<td width="5"> </td>
<td><html:textarea property="ailmentDetails"></html:textarea></td>
</tr>
<tr>
<td align="left"><bean:message key="treatment.details" /></td>
<td width="5"> </td>
<td><html:textarea property="treatmentDetails"></html:textarea></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.id" /></td>
<td width="5"> </td>
<td><html:text property="hospitalID"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.name" /></td>
<td width="5"> </td>
<td><html:text property="hospitalName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.street" /></td>
<td width="5"> </td>
<td><html:text property="hospitalStreet"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.city" /></td>
<td width="5"> </td>
<td><html:text property="hospitalCity"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.state" /></td>
<td width="5"> </td>
<td><html:text property="hospitalState"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.pin" /></td>
<td width="5"> </td>
<td><html:text property="hospitalPinCode"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.emailid" /></td>
<td width="5"> </td>
<td><html:text property="hospitalEmailID"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.phoneno" /></td>
<td width="5"> </td>
<td><html:text property="hospitalPhoneNo"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="room.type" /></td>
<td width="5"> </td>
<td><html:text property="roomType"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="doctor.id" /></td>
<td width="5"> </td>
<td><html:text property="doctorID"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="doctor.first.name" /></td>
<td width="5"> </td>
<td><html:text property="doctorFirstName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="doctor.middle.name" /></td>
<td width="5"> </td>
<td><html:text property="doctorMiddleName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="doctor.last.name" /></td>
<td width="5"> </td>
<td><html:text property="doctorLastName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="expenses" /></td>
<td width="5"> </td>
<td><html:text property="estimatedExpenses"></html:text></td>
</tr>
<tr>
<td align="left"><html:submit property="submit">
<bean:message key="button.submit" />
</html:submit></td>
<td width="5"> </td>
<td><html:reset /></td>
</tr>
</tbody>
</table>
</html:form>

.

14 years ago

Struts

Problem in SessionManagement in Struts

Hii,,

I am having a problem doing session management in Struts.....After logging out the user has to be directed to login page. and invalidate the session..This i am doing through logoff action class...Also after logging i need to make sure that user cannot see the contents of jsp page rather be directed to login page...here is m login action class..

package com.ibm.ankurstruts.actions;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
//import java.util.HashMap;
//import java.util.Locale;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
//import javax.mail.*;
//import java.util.Locale;
//import org.apache.struts.util.*;
//import com.ibm.ankurstruts.resources.*;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.util.MessageResources;
import com.ibm.ankurstruts.data.UserDetails;
import com.ibm.ankurstruts.forms.Logonform;
//import com.ibm.ankurstruts.resources.*;
/**
* @version 1.0
* @author
*/
public class LogonAction extends Action
{
public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)
throws Exception {
ActionErrors errors = new ActionErrors();
ActionForward forward = new ActionForward(); // return value
Logonform logonform = (Logonform)form;
String username=logonform.getUsername();
String pass=logonform.getPassword();
String clientID=logonform.getIdtype();
System.out.println(username);
System.out.println(pass);
System.out.println(clientID+"...");
// String lang=logonform.getLanguage();
//String langu=logonform.getLanguage();
//MessageResources msg=getResources(request);
// Locale mylocal=new Locale("en","US");
//MessageResources strutsBundle=getResources(request);
//tring str=strutsBundle.getString("ankur");
// String str=strutsBundle.getMessage("ankur");
//System.out.println(str);
//String str=strutsBundle.getConfig();
// HashMap hm=(HashMap)strutsBundle;
//System.out.println(strutsBundle);
String idtype1="client";
String idtype2="TPA";
String idtype3="TPAAdmin";
//String idtype=logonform.getIdtype();
// String idtype=logonform.getIdtype();
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
String sql;
String str1;
String str2;
String str3;
int flag=0;
String sessionid;
try {
String driver="com.ibm.db2.jcc.DB2Driver";
String url="jdbc:db2:ICEP";
String userID="Administrator";
String password="marc0nig";
Class.forName(driver).newInstance();
conn= DriverManager.getConnection(url, userID, password);
System.out.println("Connection successful..");
sql="select loginid,password,clienttype from schema.allusers";
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
System.out.println("INDYAROCKSSSS");
while(rs.next()){
//System.out.println(username);
str1=rs.getString(3);
str1=str1.trim();
str2=rs.getString(1).trim();
str3=rs.getString(2).trim();
//rs.getString(3)=rs.getString(3).trim();
System.out.println(rs.getString(1)+"...");
System.out.println(rs.getString(2)+"....");
System.out.println(rs.getString(3)+"...");
System.out.println(str1+"....");
if(str1.equalsIgnoreCase(clientID)){
if(rs.getString(1).equals(username) && rs.getString(2).equals(pass)){
System.out.println("The user is correct");
//sessionid=request.getSession().getId();
//System.out.println(sessionid);
//forward = mapping.findForward("success");
flag=1;
if(str1.equalsIgnoreCase(idtype1)){
HttpSession session=request.getSession(true);
UserDetails userinfo=new UserDetails();
if(session.isNew()){
System.out.println("This session is new");
//session=request.getSession();
}else{
System.out.println("WelcomeBack");
}
userinfo.setIdtype(clientID);
userinfo.setPassword(pass);
userinfo.setUsername(username);
session.setAttribute("USER",userinfo);
session.setAttribute("USERNAME",username);
session.setAttribute("loggedin",new String("true"));
// Forward control to the appropriate 'success' URI (change name as desired)
sessionid=session.getId();
System.out.println(sessionid);
forward = mapping.findForward("success");
break;
}
if(str1.equalsIgnoreCase(idtype2)){
System.out.println("HAHAHAHAHA");
HttpSession session=request.getSession(true);
UserDetails userinfo=new UserDetails();
if(session.isNew()){
System.out.println("This session is new");
//session=request.getSession();
}else{
System.out.println("WelcomeBack");
}
// synchronized{
userinfo.setIdtype(clientID);
userinfo.setPassword(pass);
userinfo.setUsername(username);
session.setAttribute("USER",userinfo);
session.setAttribute("USERNAME",username);
session.setAttribute("loggedin",new String("true"));
sessionid=session.getId();
System.out.println(sessionid);
forward = mapping.findForward("success1");
break;
// }
}
if(str1.equalsIgnoreCase(idtype3)){
System.out.println("HEHEHEHEHE");
HttpSession session=request.getSession(true);
UserDetails userinfo=new UserDetails();
if(session.isNew()){
System.out.println("This session is new");
}else{
System.out.println("WelcomeBack");
}
//synchronized{
userinfo.setIdtype(clientID);
userinfo.setPassword(pass);
userinfo.setUsername(username);
session.setAttribute("USER",userinfo);
session.setAttribute("USERNAME",username);
session.setAttribute("loggedin",new String("true"));
forward = mapping.findForward("success2");
break;
//}
}
//break;
}
}
// do something here
}
} catch (Exception e) {
// Report the error using the appropriate name and ID.
errors.add("name", new ActionError("id"));
}
// If a message is required, save the specified key(s)
// into the request for use by the <struts:errors> tag.
if (!errors.isEmpty() || flag==0) {
saveErrors(request, errors);
// Forward control to the appropriate 'failure' URI (change name as desired)
forward = mapping.findForward("failure");
}
// }
// Finish with
return (forward);
}
}

.

My logoff action class is as follows

package com.ibm.ankurstruts.actions;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
/**
* @version 1.0
* @author
*/
public class LogoffAction extends Action
{
public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)
throws Exception {
ActionErrors errors = new ActionErrors();
ActionForward forward = new ActionForward(); // return value
/* try {
// do something here
} catch (Exception e) {
// Report the error using the appropriate name and ID.
errors.add("name", new ActionError("id"));
}
// If a message is required, save the specified key(s)
// into the request for use by the <struts:errors> tag.
if (!errors.isEmpty()) {
saveErrors(request, errors);
// Forward control to the appropriate 'failure' URI (change name as desired)
// forward = mapping.findForward(failure");
} else {*/
// Forward control to the appropriate 'success' URI (change name as desired)
//request.getSession().invalidate();
HttpSession session=request.getSession(false);
String sessionid=request.getSession().getId();
System.out.println(sessionid);
// String s=(String)session.getAttribute("SessionID");
//System.out.println(s);
session.invalidate();
//session.removeAttribute("USERNAME");
// session.removeAttribute("PASSWORD");
//session.removeAttribute("IDTYPE");
//session.removeAttribute("SessionID");
//request.getSession().removeValue(sessionid);
//request.getSession().removeAttribute(sessionid);
//String d=(String)session.getAttribute("SessionID");
//System.out.println(d);
//HttpSession sid1=request.getSession(false);
//String sid=(String)sid1.getId();
//System.out.println(sid);
forward = mapping.findForward("success");
// }
// Finish with
return (forward);
}
}

In all the action classes i am checking whether the (String)session.getAttribute("loggedin")==true...If not i am redirecting it to login page...This works fine...But in my jsp i am trying the same thing...

Its giving Illegal State Exception....Cannot FORWARD..The response already committedI am using a simple tile template for each of my page...one of the page is

PreAuthorization_body.jsp
<%@page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page buffer="256k" %>
<%@taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html"%>
<%@taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean"%>
<%if(((String)session.getAttribute("loggedin")).equals("true")){System.out.println("CHIRKUT");%><jsp:forward page="/login.jsp"/><%}%>
<html:errors />
<br>
<html:form action="/PreAuthorization">
<table>
<tbody>
<tr>
<td align="left"><bean:message key="proposer.id" /></td>
<td width="5"> </td>
<td><html:text property="proposerID"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="proposer.first.name" /></td>
<td width="5"> </td>
<td><html:text property="proposerFirstName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="proposer.middle.name" /></td>
<td width="5"> </td>
<td><html:text property="proposerMiddleName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="proposer.last.name" /></td>
<td width="5"> </td>
<td><html:text property="proposerLastName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="policy.id" /></td>
<td width="5"> </td>
<td><html:text property="policyID"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.first.name" /></td>
<td width="5"> </td>
<td><html:text property="patientFirstName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.middle.name" /></td>
<td width="5"> </td>
<td><html:text property="patientMiddleName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.last.name" /></td>
<td width="5"> </td>
<td><html:text property="patientLastName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.phone.number" /></td>
<td width="5"> </td>
<td><html:text property="patientPhoneNo"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.street" /></td>
<td width="5"> </td>
<td><html:text property="patientStreet"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.city" /></td>
<td width="5"> </td>
<td><html:text property="patientCity"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.state" /></td>
<td width="5"> </td>
<td><html:text property="patientState"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.emailid" /></td>
<td width="5"> </td>
<td><html:text property="patientEmailID"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.dateofadmittance" /></td>
<td width="5"> </td>
<td><html:text property="dateOfAdmittance"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="patient.dateofdischarge" /></td>
<td width="5"> </td>
<td><html:text property="dateOfDicharge"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="ailment.details" /></td>
<td width="5"> </td>
<td><html:textarea property="ailmentDetails"></html:textarea></td>
</tr>
<tr>
<td align="left"><bean:message key="treatment.details" /></td>
<td width="5"> </td>
<td><html:textarea property="treatmentDetails"></html:textarea></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.id" /></td>
<td width="5"> </td>
<td><html:text property="hospitalID"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.name" /></td>
<td width="5"> </td>
<td><html:text property="hospitalName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.street" /></td>
<td width="5"> </td>
<td><html:text property="hospitalStreet"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.city" /></td>
<td width="5"> </td>
<td><html:text property="hospitalCity"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.state" /></td>
<td width="5"> </td>
<td><html:text property="hospitalState"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.pin" /></td>
<td width="5"> </td>
<td><html:text property="hospitalPinCode"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.emailid" /></td>
<td width="5"> </td>
<td><html:text property="hospitalEmailID"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="hospital.phoneno" /></td>
<td width="5"> </td>
<td><html:text property="hospitalPhoneNo"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="room.type" /></td>
<td width="5"> </td>
<td><html:text property="roomType"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="doctor.id" /></td>
<td width="5"> </td>
<td><html:text property="doctorID"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="doctor.first.name" /></td>
<td width="5"> </td>
<td><html:text property="doctorFirstName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="doctor.middle.name" /></td>
<td width="5"> </td>
<td><html:text property="doctorMiddleName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="doctor.last.name" /></td>
<td width="5"> </td>
<td><html:text property="doctorLastName"></html:text></td>
</tr>
<tr>
<td align="left"><bean:message key="expenses" /></td>
<td width="5"> </td>
<td><html:text property="estimatedExpenses"></html:text></td>
</tr>
<tr>
<td align="left"><html:submit property="submit">
<bean:message key="button.submit" />
</html:submit></td>
<td width="5"> </td>
<td><html:reset /></td>
</tr>
</tbody>
</table>
</html:form>

Its giving Illegal State Exception...What is the problem i am unable to understand..I also incresed size of buffer to 256k but still no solution....Please Help as to how to redirect to login page after session is invalidated

Thanks in advance

14 years ago

Struts

Date picker in struts 1.1

Hiii,,

I want to know how can we add date picker in Struts 1.1 while making a form with date fields.....

Also i am using struts validator framneowrk for validating my form fields(i am working on STRUTS 1.1)...Here i have two date fields...
How to check whether the date entered is less than present date and also whether the date enteredin second field is greater than that of first field....

Thanks in advance

14 years ago

Struts

Using Html:radio with logic:iterate

Hiii...i am facing a problem...
I have to get the data from the database into my jsp page...Initially only few fields of the data should be there...Like Suppose there are 10 users..Then first of all the user sees the data of all 10 users

Serial no Field 1 Field2 Fileld3 Select
User1
User2
.
.
.
.
.
User10

Here Field 1,2 and 3 are containing the field values form the database and nbeneath select is a buttowhich on pressing redirects us to a page where user can see the whole record of the user..like if the user clicks on the select button of user2 he should see all the records of user2 ...How to do this problem...I am getting the data in the above mentioned format but how to get data of only one user based on the click he makes is what is baffling me...any thoughts

Please Help...

14 years ago

Struts

Problem using logic:iterate

Can you show me a bit of working some pseudocode sort of thing so that i can use it..

Thanks in advance....

14 years ago

Struts

Problem using logic:iterate

hey thanks for the quick reply...but can you tell me how to solve this problem ...i need to get the entries from the databse into my jsp page...how exactly we will do that...currently i am able to pass the object into the arraylist...now i need to get the attributes(methods) to display them on the jsp...

14 years ago

Struts

Problem using logic:iterate

Hii,

i am a newbie to struts...currently using 1.1 version...i was trying to retrieve the data from database onto my jsp page but am having trouble...please help me out...i have a database and i have to retirve values form there into my jsp page ...here is what i am doing..
Action Class

package com.ibm.ankurstruts.actions;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.commons.beanutils.RowSetDynaClass;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.ibm.ankurstruts.data.Register;
import com.ibm.ankurstruts.data.RegistrationData;
import com.ibm.ankurstruts.forms.RegistrationForm;
import com.ibm.ankurstruts.forms.UserForm;
/**
* @version 1.0
* @author
*/
public class NewUserAction extends Action
{
public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)
throws Exception {
ActionErrors errors = new ActionErrors();
HttpSession session=request.getSession();
ActionForward forward = new ActionForward(); // return value
//RegistrationForm register1=new RegistrationForm();
// RegistrationData DAO=new RegistrationData();
ArrayList list=new ArrayList();
Connection conn=null;
try{
String driver="com.ibm.db2.jcc.DB2Driver";
String url="jdbc:db2:ICEP";
String userID="Administrator";
String password="marc0nig";
Class.forName(driver).newInstance();
conn=DriverManager.getConnection(url, userID, password);
System.out.println("Connection successful..");
String sql="Select proposer_id,password from schema.registration_proposer_entries";
System.out.println(sql);
//String proposerid=null;
//String password=null;
ResultSet rs=null;
Statement stmt=null;
try {
//PreparedStatement pst = conn.prepareStatement(sql);
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
UserForm register=(UserForm)form;
register.setProposerID(rs.getString(1));
System.out.println(rs.getString(1));
register.setPassword(rs.getString(2));
list.add(register);
}
}catch (Exception e) {
System.out.println(e);
e.printStackTrace();
}
} catch (Exception e) {
System.out.println(e);
// Report the error using the appropriate name and ID.
errors.add("name", new ActionError("id"));
}
// If a message is required, save the specified key(s)
// into the request for use by the <struts:errors> tag.
session.setAttribute("mylist",list);
forward = mapping.findForward("success");
return (forward);
}
}

The java bean is

package com.ibm.ankurstruts.forms;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
/**
* Form bean for a Struts application.
* Users may access 2 fields on this form:
* <ul>
* <li>ProposerID - [your comment here]
* <li>Password - [your comment here]
* </ul>
* @version 1.0
* @author
*/
public class UserForm extends ActionForm
{
private String ProposerID = null;
private String Password = null;
/**
* Get ProposerID
* @return String
*/
public String getProposerID() {
return ProposerID;
}
/**
* Set ProposerID
* @param <code>String</code>
*/
public void setProposerID(String p) {
this.ProposerID = p;
}
/**
* Get Password
* @return String
*/
public String getPassword() {
return Password;
}
/**
* Set Password
* @param <code>String</code>
*/
public void setPassword(String p) {
this.Password = p;
}
public void reset(ActionMapping mapping, HttpServletRequest request) {
// Reset values are provided as samples only. Change as appropriate.
ProposerID = null;
Password = null;
}
public ActionErrors validate(ActionMapping mapping,
HttpServletRequest request) {
ActionErrors errors = new ActionErrors();
// Validate the fields in your form, adding
// adding each error to this.errors as found, e.g.
// if ((field == null) || (field.length() == 0)) {
// errors.add("field", new org.apache.struts.action.ActionError("error.field.required"));
// }
return errors;
}
}

and jsp is

On executing this i am getting error
No getter method for property ProposerID of bean collection

Please help me out.....

14 years ago

Struts

patriot indian

Recent posts by patriot indian