This post illustrate how to connect struts application with mysql database.
Problem:
1). Create NStudent database in mysql
2). Create NStudent table in mysql
3). To insert the data into the NStudent table in mysql.
Procedure:
Step_1:
Create NStudent Database
use create database database_name;
We use database name as NStudent.
Step_2:
Use database name
Use keyword is used to use already created database.
Step_3:
Create NStudent Table
Use Create table table_name(stu_name varchar(40),stu_rollno int);
Step_4:
Create Struts Project (I have used project name as NStudent)
Already I have explained how to create Struts Project using netbean.
Step_5:
Create Folder for
1). Actionforms
2). Actions
3). Vo
4). Bl
5). Dbcon
Step_6:
Create java class for dbcon.
Select dbcon and right click and New and Other. Where you select java under categories and java class under file types and click Next . where New java class window will open. You give java class name.(I have used as Dbcon) and Finish.
You insert below code in Dbcon
package dbcon;
import java.sql.*;
public class Dbcon
{
public static Connection getConnection()throws SQLException
{
Connection con=null;
Statement stmt=null;
try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e)
{
System.out.println("Class Load Error");
}
try
{
Org.apache.struts.actions.LookUpDispatchAction is a built in action in struts framework.
This class enables a user to perform different task using a single action class. It eliminate for creating multiple action class for each task.
DispatchAction and LookupDispatchAction are same But LookupDispatchAction uses java Map interface and ApplicationResources.properties to dispatch method.
Procedure:
Step_1:
Creating action class.
When you create action class you select configuration file into
Dispatch Action enables us to perform the related several action in single action class.
Example:
We have several buttons and that button will perform separate function or task.
We have a jsp page that page many button or many links such as one and two and three. If we select one, the one.jsp page will open. If we select two, the two.jsp page will open. If we select three, the three.jsp page will open.
Problem:
Dispatch.jsp page have three link. One is one and second is second andthree is three.
Algorithm:
Step_1:
Creating actionforms.
Step_2:
Creating actions
Step_3:
Configure Struts-config.xml
Step_4:
Creating jsp file
Procedure:
Step_1:
Creating actionform(I have used actionforms name is disForm)
Right Click on actionforms folder.
NewOther. The New File window will open.
NOTE:
Do You forget how to create actionform?. Please see Struts
Application First Struts Application.
Under categories
Select Struts
Under file types
Select Struts ActionForm Bean
Next.
New Struts ActionForm Bean windowl will open. Where you give class name (I have used actionform as disForm)
Finish.
Now the disForm class Successfully created.
We include
Private String method;
And generate setter and getter for method;
Note: I already have said how to create setter and getter .
Step_2:
Note: Do You want how to create action class with picture. Please see Struts
Applicaton-First Struts Application.
Creating action class ( I have used action class as disAction)
Right click on actions folder.
New and Other.
The New File window will open.
Where you select Struts and Struts action class.
where you give action class name and change configuration file to
org.apache.struts.actions.DispatchAction.
Next and Finish.
Now disAction class created successfully.
After Removing coding that occur between comment line.
You get like below.
package actions;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.actions.DispatchAction;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForward;
public class disAction extends DispatchAction
{
public ActionForward myAction1(ActionMapping mapping, ActionForm form,
Step_6: Run the Home.jsp Right click on Home.jsp and Run file or Shift+f6 Conclusion: From this post you have learned dispatch action and forward action. This actions are build in actions in struts framework.
