Monday, 19 November 2012

How to Insert and Retrieve data from database using JSF


1) How to Insert and Retrieve data from database using JSF example structure

Table Structure :

DROP TABLE IF EXISTS customer;

CREATE TABLE  customer (id  number(5) NOT NULL, name VARCHAR(10) NOT NULL,city VARCHAR(10) NOT NULL,PRIMARY KEY (id));  

 

 

     



2).index.html

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>index.html</title>
    <meta http-equiv="Refresh" content="0; URL=index.faces"/>
  </head>  
</html> 

3). index.jsp

 

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h" %>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
   <title>Insert and Retrieve data from database using JSF</title>
  </head>  
  <body> 
    <f:view>
        <h:form enctype="multipart/form-data">

           <table bgcolor="orange" border="0">
        <tr>
            <td>
                <b><h:outputText value="ID:"></h:outputText></b>
            </td>
            <td>
                <h:inputText id="id" value="#{bean.id}">
                <f:validateLength minimum="2" maximum="25"></f:validateLength>
                </h:inputText>
            </td>
            <td>
                <h:messages style="color: red;"></h:messages>   
            </td>
        </tr>
        <tr>
            <td>
                <b><h:outputText value="NAME:"></h:outputText></b>
            </td>
            <td>
                <h:inputText id="name" value="#{bean.name}">
                <f:validateLength minimum="2" maximum="25"></f:validateLength>
                </h:inputText>
            </td>
            <td>
                <h:messages style="color: red;"></h:messages>   
            </td>
        </tr>
        <tr>
            <td>
                <b><h:outputText value="City:"></h:outputText></b>
            </td>
            <td>
                <h:selectOneMenu id="city" value="#{bean.city }" title="Select City" >
                        <f:selectItem itemLabel="- Select City -"/>
                        <f:selectItem itemLabel="Vijayadada" itemValue="vijayawada"/>
                        <f:selectItem itemLabel="Hyderabad" itemValue="Hyderabad"/>
                        <f:selectItem itemLabel="Bhadrak" itemValue="Bhadrak"/>
                        <f:selectItem itemLabel="Guntur" itemValue="Guntur"/>
                </h:selectOneMenu>
            </td>
            <td>
                <h:messages style="color: red;"></h:messages>   
            </td>
        </tr>
        <tr>
            <td></td>
            <td>&nbsp;&nbsp;&nbsp;
                <h:commandButton action="#{customer.insert}" value="Insert"></h:commandButton>
            </td>
        </tr>
        </table>    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <h:graphicImage value="images/wheel.PNG" width="150" height="100"/>
            <br>
            <h:dataTable id="dt" value="#{datatable.alldata}" var="datatable" bgcolor="green" border="1"
                cellpadding="8"    width="30%" styleClass="order-table" headerClass="order-table-header"
                rowClasses="order-table-odd-row,order-table-even-row">
                <h:column>
                    <f:facet name="header"><h:outputText value="Id" />
                    </f:facet>
                        <b><h:outputText value="#{datatable.id}"/></b>
                </h:column>
                <h:column>
                    <f:facet name="header">
                        <h:outputText value="Name" />
                    </f:facet>
                        <b><h:outputText value="#{datatable.name}"/></b>
                </h:column>
                <h:column>
                    <f:facet name="header">
                        <h:outputText value="City" />
                    </f:facet>
                        <b><h:outputText value="#{datatable.city}"/></b>
                </h:column>
            </h:dataTable><br>
        </h:form>
    </f:view>
  </body>
</html>

 

4). web.xml

 

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.5"xsi:schemaLocation="http://java.sun.com/xml/ns/javaee   http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
  <servlet>
    <servlet-name>Faces Servlet</servlet-name>
    <servlet-class>javax.faces.webapp.FacesServlet</servlet-class>
    <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>Faces Servlet</servlet-name>
    <url-pattern>*.jsf</url-pattern>
  </servlet-mapping>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
  </welcome-file-list>
</web-app>

                                            


5). faces-config.xml

 

<?xml version='1.0' encoding='UTF-8'?>
<faces-config 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-facesconfig_1_2.xsd"
    version="1.2">  

 <managed-bean>
        <managed-bean-name>bean</managed-bean-name>
        <managed-bean-class>com.satyamsoft.Bean</managed-bean-class>
        <managed-bean-scope>session</managed-bean-scope>
    </managed-bean>
    <managed-bean>
        <managed-bean-name>customer</managed-bean-name>
        <managed-bean-class>com.satyamsoft.customer</managed-bean-class>
        <managed-bean-scope>session</managed-bean-scope>
    </managed-bean> 
    <navigation-rule>
        <from-view-id>/index.jsp</from-view-id>
        <navigation-case>
            <from-action>#{customer.insert}</from-action>
            <from-outcome>success</from-outcome>  
            <to-view-id>/index.jsp</to-view-id>
        </navigation-case>
        <navigation-case>
            <from-outcome>fail</from-outcome>  
            <to-view-id>/fail.jsp</to-view-id>
        </navigation-case>
    </navigation-rule>
    <managed-bean>
        <managed-bean-name>datatable</managed-bean-name>
        <managed-bean-class>com.satyamsoft.DataTable</managed-bean-class>
        <managed-bean-scope>request</managed-bean-scope>
    </managed-bean>
</faces-config>

 

      

6). Bean.java

 

package com.satyamsoft;
import java.util.List;
public class Bean {
    public int id;
    public String name;
    public String city;
    public List<?> allData;
   
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getCity() {
        return city;
    }
    public void setCity(String city) {
        this.city = city;
    }
    public List<?> getAllData() {
        return allData;
    }
    public void setAllData(List<?> allData) {
        this.allData = allData;
    }   
}    


7). DBConnect.java

 

  package com.satyamsoft;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBConnect {
    Connection con = null;
    public Connection getConnection()
    {
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","123456");
        }catch (ClassNotFoundException e){
                System.err.println("ClassNotFoundException in getConnection,"  + e.getMessage());
        }
        catch (SQLException e)
        {
            System.err.println("SQLException in getConnection, " + e.getMessage());
        }
        return con;
    }
  
    public void setConnectionClose() throws SQLException
    {
        con.close();
    }
}

 

 

8). customer.java

 

 package com.satyamsoft;
import java.sql.*;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;
public class customer {
    public String insert() throws Exception
    {
        HttpSession session =(HttpSession)FacesContext.
        getCurrentInstance().getExternalContext().getSession(true);
        Bean b=(Bean)session.getAttribute("bean");
        Connection con=DBConnect.getConnection();
        String sql="insert into customer values(?,?,?)";
        PreparedStatement ps=con.prepareStatement(sql);
        ps.setInt(1,b.getId());
        ps.setString(2,b.getName());
        ps.setString(3,b.getCity());
        if(ps.executeUpdate()==1)
            return "success";
        else
            return "fail";
    }
}

 

9). DataTable.java

 

package com.satyamsoft;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
public class DataTable {
    Connection con=null;
    Statement st=null;
    ResultSet rs=null;   
    public List<Bean> getAlldata() throws Exception
    {
        List<Bean> alldata=new ArrayList<Bean>();
        con=DBConnect.getConnection();
        try {
            st=con.createStatement();
            String sql="select * from customer";
            rs=st.executeQuery(sql);
            while(rs.next())
            {
                Bean b=new Bean();
                b.setId(rs.getInt("id"));
                b.setName(rs.getString("name"));
                b.setCity(rs.getString("city"));
                alldata.add(b);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return alldata;
    }
} 

 

 

10).Table Data:

 

  

 

11).OutPut:

 


 

 

Posted by at

1 comment:

  1. Unknown27 February 2015 at 02:57

    error on following line
    Connection con=DBConnect.getConnection();
    non static method getConnection(); cannot be referenced from a static context

    ReplyDelete

Subscribe to: Post Comments (Atom)