Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > retrieve data from database using jsf"

Reply
Thread Tools

retrieve data from database using jsf"

 
 
hib hib is offline
Junior Member
Join Date: Jun 2011
Posts: 1
 
      06-01-2011
Hello
My program is to retrieve data from an oracle database using jsf when I enter the search criteria in the text box and I click on the button , it displays only the elements corresponding

following is my code

Code:
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.SessionScoped;
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
/**
*
* @author utilisateur
*/
public class Beansearch extends HttpServlet {
ResultSet rs;

private List perInfoAll = new ArrayList();

private int i;
public List getperInfoAll(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException, SQLException {
String value = req.getParameter("cond");
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException ex) {
Logger.getLogger(Beansearch.class.getName()).log(Level.SEVERE, null, ex);
}
Connection con = null;
try {
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:gmao", "pfe", "gmao");
} catch (SQLException ex) {
Logger.getLogger(Beansearch.class.getName()).log(Level.SEVERE, null, ex);
}
Statement st = null;
try {
st = con.createStatement();
} catch (SQLException ex) {
Logger.getLogger(Beansearch.class.getName()).log(Level.SEVERE, null, ex);
}
try {
rs = st.executeQuery("select username, jobposition from user_details="+value+"");
/** Creates a new instance of Beansearch */
} catch (SQLException ex) {
Logger.getLogger(Beansearch.class.getName()).log(Level.SEVERE, null, ex);
}

while(rs.next())
{

perInfoAll.add(i,new perInfo(rs.getString(1),rs.getString(2)));

i++;

}
return perInfoAll;
}
public class perInfo {

private String username;
private String jobposition;


public perInfo(String username,String jobposition) {
this.username = username;
this.jobposition = jobposition;


}

public String getusername() {
return username;
}

public String getjobposition() {
return jobposition;
}



}
/** Creates a new instance of Beansearch */
public Beansearch() {
}

}
and I used 2 jsf pages one to enter data and another to display results Here is the code of the page to display the result
resultat.jsp
Code:
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h"%>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<form>


<h:dataTable id="dt1" value="#{Beansearch.perInfoAll}" var="item" bgcolor="#F1F1F1" border="10" cellpadding="5" cellspacing="3" rows="4" width="50%" dir="LTR" frame="hsides" rules="all" summary="This is a JSF code to create dataTable." >



<h:column>
<f:facet name="header">
<h:outputText value="First Name" />
</f:facet>
<h:outputText style="" value="#{item.username}" ></h:outputText>
</h:column>

<h:column>
<f:facet name="header">
<h:outputText value="Last Name"/>
</f:facet>
<h:outputText value="#{item.jobposition}"></h:outputText>
</h:column>


<f:facet name="footer">
<h:outputText value="The End" />
</f:facet>

</h:dataTable><br>
</form>
</body>
</html>
my problem is in the page to input data
following is my code search.jsp
Code:
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h"%>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f"%>
<html>
<f:view>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<form>

<input name="cond" />
<h:commandButton value="Rechercher" action = "search " actionListener="#{Beansearch.getperInfoAll}" />

</form>

</body>
</f:view>
</html>
when I introduce the search criteria in the page search.jsp and I click the search button I can not access the page that displays the result

what that I must add to realize this?
I know that the problem may be in
Code:
<h:commandButton value="Rechercher" action = "search " actionListener="#{Beansearch.getperInfoAll}" />
but I do not know how to correct it
can you help me please
thanks
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Database Database Database scott93727@gmail.com Computer Information 0 09-27-2012 02:43 AM
DataBase DataBase DataBase DataBase scott93727@gmail.com Computer Information 0 09-26-2012 09:40 AM
i need eclipse code for Retrieve data from an oracle database little programmer Software 0 04-19-2007 12:14 PM
retrieve binary data from database and display in browser =?Utf-8?B?c2NvdHRybQ==?= ASP .Net 2 03-23-2007 05:25 PM
retrieve data from 2 database crespoh Python 3 07-28-2005 08:33 PM



Advertisments