Database Connection with Struts 2.0 Framework

Core java OOPs Tutorial

Core Java Interview Materials

The database table data fetch in tabular form through struts 2.0 and JDBC application example.Tools Required to connect the database in struts 2.0 framework. Following tools are required to connect database 
1.   Struts 2.0.9
2.   Database: Oracle10g
3.   Tomcat 6.0

 Directory Structure of Database connection Example in Struts 2.0 Using MyEclipse IDE



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>

web.xml

<?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>

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>

Output




Struts 1.3 Tutorial and Example
Spring 2.5 Tutorial and Example
Spring 2.5 MVC Tutorial
Spring 2.5 MVC Example