Database Accessing Data Using Struts 1.3

Core java OOPs Tutorial

Core Java Interview Materials

Database Accessing Data using Struts 1.3 the following tool are required for run this example
JDK 1.5
MyEclipse IDE
Server Tomcat 6.0
Struts 1.3 jar file
MySql 5.0 Database Server
Directory Structure of AccessingDatabaseExample in Struts 1.3 Using MyEclipse IDE

 index.jsp

<%@taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
<%@taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>
<html>
<head>
<title><bean:message key="label.title"/></title>
</head>
<body>
<h3><bean:message key="label.header"/></h3>
<html:link action="/accessDataAction">
Accessing Database Example
</html:link>
</body>
</html>

web.xml

<!DOCTYPE web-app PUBLIC
 "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
 "http://java.sun.com/dtd/web-app_2_3.dtd" > 
<web-app>
  <display-name>Maven Struts Examples</display-name> 
  <servlet>
    <servlet-name>action</servlet-name>
    <servlet-class>
        org.apache.struts.action.ActionServlet
    </servlet-class>
    <init-param>
        <param-name>config</param-name>
        <param-value>
         /WEB-INF/struts-config.xml
        </param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet> 
  <servlet-mapping>
       <servlet-name>action</servlet-name>
       <url-pattern>*.do</url-pattern>
  </servlet-mapping> 
</web-app>

struts-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC 
"-//Apache Software Foundation//DTD Struts Configuration 1.3//EN"
"http://struts.apache.org/dtds/struts-config_1_3.dtd">
<struts-config>
  <form-beans />
  <global-exceptions />
  <global-forwards />
  <action-mappings>
  <action path="/accessDataAction" type="org.r4r.struts.AccessDataAction">
  <forward name="success" path="/success.jsp"/>
  </action>
  </action-mappings>
  <message-resources parameter="org.r4r.struts.ApplicationResources" />
</struts-config>

AccessDataAction.java

package org.r4r.struts;

import java.util.ArrayList;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

public class AccessDataAction extends Action {
	DAO dao;
	ArrayList<AccessData> dataList;
	public ActionForward execute(ActionMapping mapping,
		ActionForm form,HttpServletRequest request,HttpServletResponse response)
		throws Exception{
		dao=new DAO();
		dataList=dao.find();
		request.setAttribute("dataList",dataList);
		return mapping.findForward("success");
	}
	public ArrayList<AccessData> getDataList() {
		return dataList;
	}
	public void setDataList(ArrayList<AccessData> dataList) {
		this.dataList = dataList;
	}
}

AccessData.java

package org.r4r.struts;
public class AccessData{
	private String name;
	private String password;
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public AccessData(String name, String password) {
		super();
		this.name = name;
		this.password = password;
	}
	public AccessData() {
		super();
		// TODO Auto-generated constructor stub
	}
}

DAO.java

package org.r4r.struts;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

public class DAO {	
	public ArrayList<AccessData> find(){
	try{
		Class.forName("com.mysql.jdbc.Driver");
		Connection con=DriverManager.getConnection("jdbc:mysql://localhost/test","root","root");
		PreparedStatement stmt=con.prepareStatement("select * from user");
		ResultSet rset=stmt.executeQuery();
		ArrayList<AccessData> list=new ArrayList<AccessData>();
		while(rset.next()){
			list.add(new AccessData(rset.getString(1),rset.getString(2)));
		}
		return list;		
	}catch(Exception e){
		System.out.println(e);
	}
	return null;
}
}

ApplicationResources.properties

# Resources for parameter 'org.r4r.struts.ApplicationResources'
label.title=Struts 1.3 Accessing Data Using Database Example
label.header=Struts 1.3 Accessing Data Using Database Example

success.jsp

<%@taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>
<%@taglib uri="http://struts.apache.org/tags-logic" prefix="logic"%>
<html>
<head>
<title><bean:message key="label.title"/></title>
</head>
<body>
<h3><bean:message key="label.header"/></h3>
<h4><logic:iterate id="accessData" name="dataList">
<ul><li><bean:write name="accessData" property="name"/>
---<bean:write name="accessData" property="password"/></li></ul>
</logic:iterate>
</h4>
</body>
</html>

Output




Struts 2.0 Tutorial and Example
Spring 2.5 Tutorial and Example
Spring 2.5 MVC Tutorial
Spring 2.5 MVC Example