Java Mailing List Archive

http://www.gg3721.com/

Home » Struts Users Mailing List »

I cant load Select Box dynamically

vinodh r

2010-08-27

Replies: Find Java Web Hosting

Author LoginPost Reply
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>



©2008 gg3721.com - Jax Systems, LLC, U.S.A.