Database Integration Example in Struts 2.0
Previous | Home | Next |
Database Integration Example using Struts 2.0 the following tool are required for run this example
- JDK 1.5
- MyEclipse IDE
- Server Tomcat 6.0
- Struts 2.0 jar file
- Ojdbc14.jar
- Oracle 10G Database Server
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.javapackage 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.javapackage 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.javapackage 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.javapackage 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
Previous | Home | Next |