Struts

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" 
xmlns="http://java.sun.com/xml/ns/javaee" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
  <welcome-file-list>
  <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  <filter>
  <filter-name>struts2</filter-name>
  <filter-class>org.apache.struts2.dispatcher
  .ng.filter.StrutsPrepareAndExecuteFilter
  </filter-class>
  </filter>  <filter-mapping>
  <filter-name>struts2</filter-name>
  <url-pattern>/*</url-pattern>
  </filter-mapping></web-app>

index.jsp

<html>
<head><title>R4R User List</title></head>
<body><br><br><center>
<a href="fetch">User List Data Fetch</a>
</center>
</body>
</html>

struts.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC "-
//Apache Software Foundation//DTD Struts Configuration 
2.1//EN" "http://struts.apache.org/dtds/struts-2.1.dtd">
<struts>
<package name="damo" extends="struts-default">
<action name="fetch" class="org.r4r.UserListAction">
<result name="success">/fetch.jsp</result>
</action>
</package>
</struts>

UserListAction.java

package org.r4r;
import java.util.List;
public class UserListAction {
private UserList userlist;
private List<UserList> userlistlist;
DAO dao=new DAO();
public String execute(){
userlistlist=dao.fetch();
return "success";
}
public UserList getUserlist() {
return userlist;
}
public void setUserlist(UserList userlist) {
this.userlist = userlist;
}
public List<UserList> getUserlistlist() {
return userlistlist;
}
public void setUserlistlist(List<UserList> 
	userlistlist) {
this.userlistlist = userlistlist;
}
}

UserList.java

package org.r4r;
public class UserList {	 	
String name;
String address;
String city;
String state;
public UserList() { 		
super(); 		
// TODO Auto-generated constructor stub
}	
public UserList(String name, String address,
	String city, String state) {
super();		
this.name = name;	
this.address = address;	
this.city = city;	
this.state = state;
}
public String getName() {	
return name;
}
public void setName(String name) {
this.name = name;
} 	
public String getAddress() {	
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getCity() {		
return city;
}
public void setCity(String city) {
this.city = city;
}
public String getState() {	
return state;
}
public void setState(String state) {
this.state = state;
}
}

DAO.java

package org.r4r;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.*;
public class DAO {
public List<UserList> fetch(){
try{
Connection con=ConnectionProvider.getConnection();
PreparedStatement stmt=con.prepareStatement
	("select *from userlist");
ResultSet rset=stmt.executeQuery();
UserList userlist;
List<UserList> list=new ArrayList<UserList>();
while(rset.next()){
userlist=new UserList();
userlist.setName(rset.getString(1));
userlist.setAddress(rset.getString(2));
userlist.setCity(rset.getString(3));
userlist.setState(rset.getString(4));
list.add(userlist);
}
return list;		
}catch(Exception e){
System.out.println(e);
}
return null;
}
}

ConnectionProvider.java

package org.r4r;
import java.sql.Connection;
import java.sql.DriverManager;
public class ConnectionProvider {
public static Connection getConnection(){
Connection con=null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:xe",
	"system","system");
}catch(Exception e){
System.out.println(e);
}
return con;
}
}

fetch.jsp

<%@taglib uri="/struts-tags" prefix="s"%>
<html>
<head><title>User Data Fetch in Tabular Form
</title></head>
<body>
<table cellpadding="0" cellspacing="0" border="2">
<tr><th>Name</th><th>Address</th><th>City</th>
<th>State</th></tr>
<s:iterator value="userlistlist" var="userlist">
<tr><td><s:property value="name"/></td>
<td><s:property value="address"/></td>
<td><s:property value="city"/></td><td>
<s:property value="state"/></td></tr>
</s:iterator>
</table>
</body>
</html>