Struts iteraor

Hi, I am making a program in Struts 1.3.8 in which i have to access data from mysql. I am able to access data but data is not coming in tabular form. These are my action class and jsp page with iterator.

SearchDataAction.java

package com.myapp.struts;

import java.util.ArrayList;
import java.util.List;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;

public class SearchDataForm extends org.apache.struts.action.ActionForm {
              class user {
              String users;
              String value;
          }
       int userId;
       Connection con ;
       ResultSet rs = null ;
       public int getuserId() {
        return userId;
    }

    public void setuserId(int userId) {
        this.userId = userId;
    }  
    public SearchDataForm() {
        super();
     }

   @Override
    public ActionErrors validate(ActionMapping mapping, HttpServletRequest request)
   {
        ActionErrors errors = new ActionErrors();
         if (userId < 1) {
            errors.add("userId", new ActionMessage("error.userId.required"));
        } 
                       List<String> listMsg = new ArrayList<String>();

             try {
             String str = "select * from emp where userId = ? " ;
             Class.forName("com.mysql.jdbc.Driver").newInstance();
             con = DriverManager.getConnection("jdbc:mysql:///employee", "root", "1234");
             PreparedStatement  ps = (PreparedStatement) con.prepareStatement(str);

             ps.setInt(1,userId);
             rs = ps.executeQuery();
             int count = 0;
             while(rs.next()) {
             count++;

             listMsg.add("UserId"+" "+ rs.getInt("userId"));
             listMsg.add("FirstName"+" "+ rs.getString("firstName"));
             listMsg.add("LastName"+" "+ rs.getString("lastName"));
             listMsg.add("Age"+" "+ rs.getInt("age"));
             listMsg.add("Number"+" " +rs.getLong("number"));

             }
             if(count==0)
             {
                 listMsg.add("userId"+"\t\t"+userId+"\t\t"+"not found");
             }

                 rs.close();
                 ps.close();
                 con.close();
             }
             catch(SQLException e)
             {
                 errors.add("SQLException", new ActionMessage("error.SQLException"));
             }
             catch(Exception ex)
             {
                ex.printStackTrace();
             }

            request.setAttribute("listMsg", listMsg);

           return errors;
    }
}

search.jsp

<%@taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>
<%@taglib uri="http://struts.apache.org/tags-logic" prefix="logic"%>
<html>
    <head> <title> Search </title>
</head>
<body>
<h1> Search </h1>
<table> <tbody> 
<logic:iterate name="listMsg" id="listMsgId">
    <tr>
   <bean:write name="listMsgId"/><br>
   </tr>
</logic:iterate>

</tbody>
</table>
 <p> Now, return back to <a style="cursor : auto; color: green" href="welcomeStruts.jsp"> home </a>page</p>
</body>
</html>

thanks.

View Answers

Advertisements

STRUTS
STRUTS MAIN DIFFERENCES BETWEEN STRUTS 1 AND STRUTS 2

Struts
Struts what is SwitchAction in struts

Struts
Struts how to learn struts

STRUTS
STRUTS Request context in struts? SendRedirect () and forward how to configure in struts-config.xml

struts
struts in industry, struts 1 and struts 2. which is the best? which is useful as a professuional Have a look at the following link: Struts Tutorials

Struts
Struts Tell me good struts manual

struts
struts what are the 4 methods of struts framework

struts
struts shopping cart project in struts with oracle database connection shopping cart project in struts with oracle database connection Have a look at the following link: Struts Shopping Cart using MySQL

Struts
Struts When Submit a Form and while submit is working ,press the Refresh , what will happen in Struts

struts
struts Hi what is struts flow of 1.2 version struts? i have struts applicatin then from jsp page how struts application flows Thanks Kalins Naik Please visit the following link: Struts Tutorial

struts
struts how to write Dao to select data from the database

struts
struts why doc type is not manditory in struts configuration file

Struts
Struts Hi i am new to struts. I don't know how to create struts please in eclipse help me

struts
struts Hi how struts flows from jsp page to databae and also using validation ? Thanks Kalins Naik

Struts
Setter methods of form bean class in Struts applications who calls the setter methods of form bean class in struts applications

Struts
Struts What is called properties file in struts? How you call the properties message to the View (Front End) JSP Pages

Struts
Struts in struts I want two struts.xml files. Where u can specify that xml files location and which tag u specified

struts
struts which is the best book to study struts on own? please tell me You can learn struts through the following books: 1)Programming Jakarta Struts By Chuck Cavaness 2)Professional Jakarta Struts By James Goodwill

Struts
Struts How Struts is useful in application development? Where to learn Struts? Thanks Hi, Struts is very useful in writing web... performance Java web applications that runs on Java enabled application servers. Struts

Struts - Struts
Struts for beginners struts for beginners example

struts
struts how to start struts? Hello Friend, Please visit the following links:ADS_TO_REPLACE_1 http://www.roseindia.net/struts/ http... through which you can easily learn the struts. ThanksADS_TO_REPLACE_2

struts
struts i have no any idea about struts.please tell me briefly about struts?** Hi Friend, You can learn struts from the given link:ADS_TO_REPLACE_1 Struts Tutorials Thanks

struts
struts hi i would like to have a ready example of struts using "action class,DAO,and services" for understanding.so please guide for the same. thanks Please visit the following link: Struts Tutorials

Struts
Struts Am newly developed struts applipcation,I want to know how to logout the page using the strus Please visit the following link: Struts Login Logout Application

Struts
Struts 1)in struts server side validations u are using programmatically validations and declarative validations? tell me which one is better ? 2) How to enable the validator plug-in file

struts
struts please send me a program that clearly shows the use of struts with jsp

struts
struts Hi, 1) can we write two controller classes in struts

struts
struts Hi,... please help me out how to store image in database(mysql) using struts

struts
struts how to generate bar code for continuous numbers in a loop using struts ... or atleast for a given number

Struts
Struts How will you retrieve a collection of records from business logic to presentation logic in framework

STRUTS
STRUTS 1)Have you used struts tag libraries in your application? 2)What are the various types of tag libraries in struts? Elaborate each of them? 3)How can you implement custom tag libraries in your application

struts
struts Hi, Here my quation is can i have more than one validation-rules.xml files in a struts application

struts
struts we have the concept of jsp's and servlets right we can develop the web-pages each and everything then why what for struts inturdouced

STRUTS
STRUTS 1) Difference between Action form and DynaActionForm? 2) How the Client request was mapped to the Action file? Write the code and explain

STRUTS
STRUTS Validation: user entered as 123.34567 I want the value as 123.34 once the user submits. How you will validate

struts
struts hi i would like to have a ready example of struts using"action class,DAO,and services" so please help me

struts
technologies like servlets, jsp,and struts. i am doing one struts application where i... the following links: http://www.roseindia.net/struts/StrutsCustomValidator.shtml http://www.roseindia.net/struts/addressstrutsvalidator.shtml http

Struts
Struts What is Struts? Hi hriends, Struts is a web page... web applications quickly and easily. Struts combines Java Servlets, Java Server..., Struts is a web page development framework and an open source software that helps

struts
struts i have one textbox for date field.when i selected date from datecalendar then the corresponding date will appear in textbox.i want code for this in struts.plz help me

struts - Struts
Struts s property tag Struts s property tag

Struts - Struts
Struts examples for beginners Struts tutorial and examples for beginners

Struts
Struts why in Struts ActionServlet made as a singleton what is the specific reason how it useful in the webapplication development? Basically in Struts we have only Two types of Action classes. 1.BaseActions

Struts
Struts Why struts rather than other frame works? Struts is used into web based enterprise applications. Struts2 cab be used with Spring... by the application. There are several advantages of Struts that makes it popular

Struts iteraor

Questions by Category