Hi, Thanks for reply Mr.Michal Ciasnocha... I cant understand i need some
explanation, i don't know how to set in a attribute.
Also I can't copy the result returned from " Data_Conn.load_country() to
another list or array list. only chance is to use " Data_Conn.load_country()"
as a original.
if you know please do some modification on action page and paste as reply.
Thanks in advance.
Vinodh .R--- On Fri, 8/27/10, Michal Ciasnocha <m...@struts.cz> wrote:
From: Michal Ciasnocha <m...@struts.cz>
Subject: Re: I cant load Select Box dynamically
To: "Struts Users Mailing List" <user@struts.apache.org>
Date: Friday, August 27, 2010, 3:14 AM
Hi,
in class CountryAction you need assign retreived values from database to
countryList attribute, not list (you have in jsp ... list="countryList"
...).
vinodh r wrote on 27.8.2010 7:04:
> Hi,I cant load Select box dynamically. I am new to struts2, but i can do it
> statically in action page so that it will refelect in jsp page. But what i
> have to do modification in action page so that i get display in jsp page i
> loaded array list dynamically from database. Thanks in advance.
>
> Here is the action
> //CountryAction .javapackage com.pac.struts.action;import
> java.sql.SQLException;import java.util.ArrayList;
> import com.opensymphony.xwork2.ActionSupport;import
> com.pac.struts.DataConn.Data_Conn;import com.pac.struts.model.Country;public
> class CountryAction extends ActionSupport{ private static final long
> serialVersionUID = 1L; private String country; private
> ArrayList<Country> countryList; public ArrayList list; public String
> populate() throws Exception{ list = Data_Conn.load_country();
> return "populate"; } public String execute(){ return SUCCESS;
> } public String getCountry(){ return country; } public void
> setCountry(String country){ this.country = country; } public
> ArrayList<Country> getCountryList(){ return countryList; }
> public void setCountryList(ArrayList<Country> countryList){
> this.countryList = countryList; }}
>
>
> /****Data_Conn.java**/package com.pac.struts.DataConn;
> import java.sql.Connection;import java.sql.DriverManager;import
> java.sql.ResultSet;import java.sql.SQLException;import
> java.sql.Statement;import java.util.ArrayList;
> import com.pac.struts.model.Country;
> public class Data_Conn { static Connection con; static Statement st;
> static ResultSet rs; public static void connection_1() throws
> ClassNotFoundException, SQLException{
> Class.forName("com.mysql.jdbc.Driver"); con =
> (Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/test?user=root&password=root");
> st = con.createStatement(); System.out.println("Open Connection
> Initiated"); } public static void close_1() throws SQLException{
> st.close(); con.close(); System.out.println("Close
> Connection Initiated"); } public static ArrayList<Country>
> load_country() throws ClassNotFoundException, SQLException {
> connection_1(); rs = st.executeQuery("select * from
> test.country_tbl"); ArrayList<Country> countryList = null;
> while(rs.next()){ countryList = new ArrayList<Country>();
> countryList.add(new Country(rs.getInt(1), rs.getString(2)));
> } close_1(); System.out.println("List Operation Completed");
> return countryList; }
> }
> /*****Country.java***/package com.pac.struts.model;
> public class Country { private int countryId; private String
> countryName; public Country(int countryId, String countryName){
> this.countryId = countryId; this.countryName = countryName; }
>
> public int getCountryId() { return countryId; }
> public void setCountryId(int countryId) { this.countryId =
> countryId; }
> public String getCountryName() { return countryName; }
> public void setCountryName(String countryName) { this.countryName
> = countryName; }
> }
>
> /*****countryworld.jsp**/<s:form action="CountryAct"><s:select name="country"
> list="countryList" listKey="countryId" listValue="countryName" headerKey="0"
> headerValue="Country" label="Select a country" /></s:form>
>
>
>
>
