Struts Application-Jdbc Select
Aim:
This post will show you how to retrieve the data from database( I have used database mysql).
Procedure:
Step_1:
Create Database ( I have used NStudent).
Already I have explained how to create database in previous post
Step_2:
Create Table ( I have used NStudent).
Already I have Explained how to create table in previous post.
Step_3:
Create Project using netbean.(I have used project name as JdbcSelectPro).
Step_4:
Create Folder ( under source packages)
a). actionforms
b). actions
c). bl
d). vo
e). Dbcon
Step_5:
Create java class for database connection.
I have used dbcon as java class.
Include following coding in dbcon.java
package Dbcon;
import java.sql.*;
public class dbcon
{
public static Connection getConnection()
{
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e)
{
System.out.println("Driver Load Driver");
}
try
{
String url="jdbc:mysql://localhost/NStudent","root","sure";
String url="jdbc:mysql://localhost/NStudent","root","sure";
con=DriverManager.getConnection(url);
}
catch(Exception e)
{
System.out.println("Connection Create Error");
}
return con;
}
}
Step_6:
Create actionforms such as stuForms
Include following code
package actionforms;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;
public class stuForms extends org.apache.struts.action.ActionForm
{
private String stu_name;
private int stu_rollno;
public String getStu_name()
{
return stu_name;
}
public void setStu_name(String stu_name)
{
this.stu_name = stu_name;
}
public int getStu_rollno()
{
return stu_rollno;
}
public void setStu_rollno(int stu_rollno)
{
this.stu_rollno = stu_rollno;
}
}
Step_7:
Create action (I have used stuAction)
Include following coding
package actions;
import bl.stubl;
import java.util.Vector;
import java.util.Vector;
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.ActionMapping;
import org.apache.struts.action.ActionForward;
public class stuAction extends org.apache.struts.action.Action
{
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception
{
stubl bl=new stubl();
Vector v =bl.select();
request.setAttribute("list", v);
return mapping.findForward("select");
}
}
Step_8:
Create java class for ValueObject(vo)
I have used as stuvo under Folder vo.
Include following coding
package vo;
import java.io.Serializable;
public class stuvo implements Serializable
{
private String stu_name;
private int stu_rollno;
public String getStu_name()
{
return stu_name;
}
public void setStu_name(String stu_name)
{
this.stu_name = stu_name;
}
public int getStu_rollno()
{
return stu_rollno;
}
public void setStu_rollno(int stu_rollno)
{
this.stu_rollno = stu_rollno;
}
}
Step_9:
Create Java class for Business Logic(bl)(I have used as stubl)
Include following coding
package bl;
import Dbcon.dbcon;
import java.sql.*;
import java.util.Vector;
import vo.stuvo;
public class stubl
{
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
Vector v=new Vector();
public Vector select()
{
Vector v;
v=new Vector();
try
{
Connection con=dbcon.getConnection();
Statement stmt=con.createStatement();
String sql="select * from NStudent";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
stuvo vo=new stuvo();
vo.setStu_name(rs.getString(1));
vo.setStu_rollno(rs.getInt(2));
v.add(vo);
}
}
catch(Exception e)
{
}
return v;
}
}
Step_10:
Create Home.jsp
Include
< %@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" % >
< %@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" % >
< %@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" % >
< html >
< head > < title > JSP Page < /title >
< body >
< html:form action="/stu" >
< html:submit value="OK"/ >
< /html:form >
< /body >
< /html >
Create list.jsp
< %@page import="java.util.*"% >
< %@ page import="vo.stuvo" % >
< %@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" % >
< %@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" % >
< %@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" % >
< html >
< head > < title > JSP Page < /title >
< body >
< %
Vector v=(Vector)request.getAttribute("list");
for(int i=0;i
{
stuvo vo=(stuvo)v.get(i);
out.println(vo.getStu_name());
out.println(vo.getStu_rollno());
}
% >
< /body >
< /html >
Step_11:
Configure struts-config.xml
….
….
< action-mappings >
< action
input="/"
name="stuForms"
path="/stu"
scope="session"
validate="false"
type="actions.stuAction" >
< forward name="select" path="/jsp/list.jsp"/ >
< /action >
< /action-mappings >
….
….
Step_12:
Run home.jsp
Conclusion:
From this post how to get data from database. Struts application with Database is very important when we are going to create web based project.
Do you have any doubt about this post you can post comments
