how to display mysql table datas in jsp using struts2

Hi i have made this code for getting the values present in my users table and display those values in a jsp using struts2.

My java code:

package net.viralpatel.struts2;

import com.opensymphony.xwork2.ActionSupport;
import java.util.*;
import java.sql.*;

public class Usertable extends ActionSupport {
	private List users;

public List getUsers() {
		return users;
	}

private List passwords;

public List getPasswords() {
		return passwords;
	}

public String execute() throws Exception {
		users = new ArrayList();
		passwords = new ArrayList();

String url = "jdbc:mysql://192.168.27.111:3306/";
		String dbName = "test";
		String driverName = "org.gjt.mm.mysql.Driver";
		Connection con = null;
		Statement stmt = null;
		ResultSet rs = null;
		try {
			Class.forName(driverName).newInstance();
			con = DriverManager.getConnection(url + dbName);
			stmt = con.createStatement();
		} catch (Exception e) {
			System.out.println(e.getMessage());
		}

rs = stmt.executeQuery("select * from user");
		while (rs.next()) {
			users.add(rs.getString("Username"));
			passwords.add(rs.getString("Password"));

}

return SUCCESS;

}

and my jsp code:

But when i run this code, i'm getting all the users values in 1x1 cell and all passwords values in 1x2 cell...
I want each users value and passwords value in a single row as a pair...
What must i do??? Pl help....
Thanks in advance!

Struts2 having inbuilt mechanism to display the content if you want to customize it Use simple theme and customize it how to want it to display.

Struts2 Themes

Thanks Mohan Rao for your help...
Since I'm a beginner in Struts2 and also since i havn't worked in Struts1 I can't able to understand neither what you are telling nor the link you posted..
If you don't mind can I hav a sample code of tat Struts2 themes what you are mentioning???

Thank you!

My above answer is not relevant to your query. I think you are expecting this.

But Mohan Rao, the code you gave is same as the code i used...
I'm getting the same output as I got before...
I need output of Users in one column and their corresponding passwords in next column...
Can you help me in how to achieve that???
Thanks!

Refer to the below link

http://www.vaannila.com/struts-2/struts-2-example/struts-2-control-tags-example1.html

HTH

Thank you vishwas gopala...

Now it got worked...!

Hi,
you could do it by using the keyword "status" in the iterator tag..
in your example you could do like...
<table><s:iterator status="indice">
<tr><td>
<s:property value="username[#indice.index]"/></td>
<td>
<s:property value="password[#indice.index]"/></td>
<td>
</tr></s:iterator></table>