Here I am explaining how to do database operations in struts and how to use dyna action in struts.
DatabaseStudentAction
package com.database;
import java.sql.Connection;
import java.sql.Statement;
import org.apache.struts.action.*;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.DynaActionForm;
import javax.servlet.http.*;
import javax.sql.DataSource;
/**
*
* @author Prasanthi
*
*/
public class DatabaseStudentAction extends Action {
public ActionForward execute(ActionMapping map, ActionForm form,
HttpServletRequest req, HttpServletResponse res) throws Exception {
DynaActionForm dform = (DynaActionForm) form;
String name = (String) dform.get("name");
Integer num = (Integer) dform.get("number");
String course = (String) dform.get("course");
Statement st = null;
Connection con = null;
/* create database name:strutsdb
create table name:student
Fields: name varchar
number int
course varchar
If Any Error put mysql-connector jar in tomcat commons lib.
*/
try {
DataSource data = getDataSource(req);
con = data.getConnection();
st = con.createStatement();
boolean stt = st.execute("insert into student values('" + name + "'," + num + ",'" + course + "')");
} catch (Exception ex) {
ex.printStackTrace();
} finally {
st.close();
con.close();
}
return map.findForward("success");
}
}
struts-config.xml
<struts-config>
<form-beans>
<form-bean name="databasebean" type="org.apache.struts.action.DynaActionForm">
<form-property name="name" type="java.lang.String"/>
<form-property name="number" type="java.lang.Integer"/>
<form-property name="course" type="java.lang.String"/>
</form-bean>
</form-beans>
<action-mappings>
<action name="databasebean"
path="/datastudent"
type="com.database.DatabaseStudentAction"
input="DatabaseStudent.jsp"
validate="true">
<forward name="success" path="/Databasesuccess.jsp" />
</action>
</action-mappings>
<data-sources>
<data-source type="org.apache.tomcat.dbcp.dbcp.BasicDataSource">
<set-property property="driverClassName" value="com.mysql.jdbc.Driver" />
<set-property property="url" value="jdbc:mysql://localhost/strutsdb" />
<set-property property="username" value="root" />
<set-property property="password" value="indian" />
<set-property property="maxActive" value="10" />
<set-property property="maxWait" value="5000" />
<set-property property="defaultAutoCommit" value="true" />
<set-property property="defaultReadOnly" value="false" />
</data-source>
</data-sources>
</struts-config>
web.xml
<web-app>
<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>2</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>action</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>DatabaseStudent.jsp</welcome-file>
</welcome-file-list>
<taglib>
<taglib-uri>/tags/struts-html</taglib-uri>
<taglib-location>/WEB-INF/struts-html.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/tags/struts-bean</taglib-uri>
<taglib-location>/WEB-INF/struts-bean.tld</taglib-location>
</taglib>
</web-app>
DatabaseStudent.jsp
<%@ taglib uri="/tags/struts-html" prefix="html"%>
<html:html>
<body>
<br><br>
<center> <h2><u>Student Form</h2></u>
<html:form action="/datastudent">
Name:<html:text property="name" value="" /><br><br>
Number:<html:text property="number" value="" /><br><br>
Course:<html:text property="course" value="" /><br><br>
<html:submit value="Insert" />
</html:form>
</body>
</html:html>
DatabaseSuccess.jsp
<html>
<body><br><br>
<center>
<h2>Successfully Inserted</h2>
</body>
</html>
No comments:
Post a Comment