SEARCH CODE:
NOTE: YOU HAVE TO WRITE YOUR OWN JAVA CODE AND THEN CONNECT IT TO YOUR JSP WHICH HAS POSTGRESQL IN IT.
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.HashMap"%>
<%
if(session.getAttribute("authData")==null){
response.sendRedirect("/adminconsole/login.jsp");
return;
}
%>
<html>
<head>
<%@ include file="../general/styles.css"%>
<%@ include file="../general/header.jsp"%>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<style type="text/css">
.odd {
background-color: #E4FAE6;
}
.even {
background-color: #F1FCF2;
}
.head {
background-color: silver;
}
</style>
</head>
<body>
<form name="searchmanagerform" action="searchManager.jsp" method="POST">
<table align="center" border="1">
<tr><td>
<table>
<tr><td>Search By</td></tr>
<tr><td></td></tr>
<tr>
<td><input type="checkbox" name="mgrselect" value="fname"></td>
<td>First Name</td>
<td><input type="text" name="firstname" size="21"></td>
</tr>
<tr>
<td><input type="checkbox" name="mgrselect" value="lname"></td>
<td> Last Name</td>
<td><input type="text" name="lastname" size="21"></td>
</tr>
<tr>
<td><input type="checkbox" name="mgrselect" value="eid"></td>
<td> Email Id</td>
<td><input type="text" name="email" size="21"></td>
</tr>
<tr>
<td colspan="3" align="center"><input type="submit" name="accsearch" value="Search"></td>
</tr>
</table>
</td></tr>
</table>
</form>
<%! String[] selectList;
%>
<%
DBManager dbmanager=new DBManager();
String query="select first_name,last_name,email,gender,country,ref_by,ref_source,promotioncode,created_at,user_id from user_profile ";
String fname=request.getParameter("firstname");
if (fname == null) fname = "";
String firstname=fname.toLowerCase();
String lname=request.getParameter("lastname");
if (lname == null) lname = "";
String lastname=lname.toLowerCase();
System.out.println(""+firstname+""+lastname);
String emailid=request.getParameter("email");
if (emailid == null) emailid = "";
String emailid1=emailid.toLowerCase();
System.out.println("email is"+emailid1);
selectList = request.getParameterValues("mgrselect");
ArrayList list=new ArrayList();
if (selectList != null) {
for (int i = 0; i < selectList.length; i++) {
if(i==0){
query=query+" where ";
}
else
query=query+" and ";
if(selectList[i].equals("fname")){
query=query+"lower(first_name)like '%"+firstname.trim()+"%'";
//list.add(firstname.trim());
}
if(selectList[i].equals("lname")){
query=query+"lower(last_name)like '%"+lastname.trim()+"%'";
//list.add(lastname.trim());
}
if(selectList[i].equals("eid")){
query=query+"lower(email)like '%"+emailid1.trim()+"%'";
//list.add(email.trim());
}
}
System.out.println("query is:"+query);
StatusObj statobj = dbmanager.executeSelectQuery(query,null);
System.out.println("sbcount"+statobj.getCount());
if(statobj.getStatus()){
%>
<table align="center" border="1" cellpadding="5" cellspacing="5"
style="border-collapse: collapse; border-style: solid"
bordercolor="black">
<tr class="head">
<th>First Name</th>
<th>Last Name</th>
<th>Email id</th>
<th>Gender</th>
<th>Country</th>
<th>ref_by</th>
<th>ref_source</th>
<th>Promotion Code</th>
<th>Created at</th>
<th>User Id</th>
</tr>
<%
String cls="";
for(int i=0;i<statobj.getCount();i++) {
if(i%2==0){
cls="even";
}
else{
cls="odd";
}
%>
<tr class="<%=cls%>">
<td><%=dbmanager.getValue(i,"first_name","")%></td>
<td><%=dbmanager.getValue(i,"last_name","")%></td>
<td><%=dbmanager.getValue(i,"email","")%></td>
<td><%=dbmanager.getValue(i,"gender","")%></td>
<td><%=dbmanager.getValue(i,"country","")%></td>
<td><%=dbmanager.getValue(i,"ref_by","")%></td>
<td><%=dbmanager.getValue(i,"ref_source","")%></td>
<td><%=dbmanager.getValue(i,"promotioncode","")%></td>
<td><%=dbmanager.getValue(i,"created_at","")%></td>
<td><%=dbmanager.getValue(i,"user_id","")%></td>
</tr>
<%
}
%>
</table>
<% }
else{
if(statobj.getCount()==0){
out.println("<center>invalid details</center>");
}
}
}
%>
</body>
</html>
NOTE: YOU HAVE TO WRITE YOUR OWN JAVA CODE AND THEN CONNECT IT TO YOUR JSP WHICH HAS POSTGRESQL IN IT.
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.HashMap"%>
<%
if(session.getAttribute("authData")==null){
response.sendRedirect("/adminconsole/login.jsp");
return;
}
%>
<html>
<head>
<%@ include file="../general/styles.css"%>
<%@ include file="../general/header.jsp"%>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<style type="text/css">
.odd {
background-color: #E4FAE6;
}
.even {
background-color: #F1FCF2;
}
.head {
background-color: silver;
}
</style>
</head>
<body>
<form name="searchmanagerform" action="searchManager.jsp" method="POST">
<table align="center" border="1">
<tr><td>
<table>
<tr><td>Search By</td></tr>
<tr><td></td></tr>
<tr>
<td><input type="checkbox" name="mgrselect" value="fname"></td>
<td>First Name</td>
<td><input type="text" name="firstname" size="21"></td>
</tr>
<tr>
<td><input type="checkbox" name="mgrselect" value="lname"></td>
<td> Last Name</td>
<td><input type="text" name="lastname" size="21"></td>
</tr>
<tr>
<td><input type="checkbox" name="mgrselect" value="eid"></td>
<td> Email Id</td>
<td><input type="text" name="email" size="21"></td>
</tr>
<tr>
<td colspan="3" align="center"><input type="submit" name="accsearch" value="Search"></td>
</tr>
</table>
</td></tr>
</table>
</form>
<%! String[] selectList;
%>
<%
DBManager dbmanager=new DBManager();
String query="select first_name,last_name,email,gender,country,ref_by,ref_source,promotioncode,created_at,user_id from user_profile ";
String fname=request.getParameter("firstname");
if (fname == null) fname = "";
String firstname=fname.toLowerCase();
String lname=request.getParameter("lastname");
if (lname == null) lname = "";
String lastname=lname.toLowerCase();
System.out.println(""+firstname+""+lastname);
String emailid=request.getParameter("email");
if (emailid == null) emailid = "";
String emailid1=emailid.toLowerCase();
System.out.println("email is"+emailid1);
selectList = request.getParameterValues("mgrselect");
ArrayList list=new ArrayList();
if (selectList != null) {
for (int i = 0; i < selectList.length; i++) {
if(i==0){
query=query+" where ";
}
else
query=query+" and ";
if(selectList[i].equals("fname")){
query=query+"lower(first_name)like '%"+firstname.trim()+"%'";
//list.add(firstname.trim());
}
if(selectList[i].equals("lname")){
query=query+"lower(last_name)like '%"+lastname.trim()+"%'";
//list.add(lastname.trim());
}
if(selectList[i].equals("eid")){
query=query+"lower(email)like '%"+emailid1.trim()+"%'";
//list.add(email.trim());
}
}
System.out.println("query is:"+query);
StatusObj statobj = dbmanager.executeSelectQuery(query,null);
System.out.println("sbcount"+statobj.getCount());
if(statobj.getStatus()){
%>
<table align="center" border="1" cellpadding="5" cellspacing="5"
style="border-collapse: collapse; border-style: solid"
bordercolor="black">
<tr class="head">
<th>First Name</th>
<th>Last Name</th>
<th>Email id</th>
<th>Gender</th>
<th>Country</th>
<th>ref_by</th>
<th>ref_source</th>
<th>Promotion Code</th>
<th>Created at</th>
<th>User Id</th>
</tr>
<%
String cls="";
for(int i=0;i<statobj.getCount();i++) {
if(i%2==0){
cls="even";
}
else{
cls="odd";
}
%>
<tr class="<%=cls%>">
<td><%=dbmanager.getValue(i,"first_name","")%></td>
<td><%=dbmanager.getValue(i,"last_name","")%></td>
<td><%=dbmanager.getValue(i,"email","")%></td>
<td><%=dbmanager.getValue(i,"gender","")%></td>
<td><%=dbmanager.getValue(i,"country","")%></td>
<td><%=dbmanager.getValue(i,"ref_by","")%></td>
<td><%=dbmanager.getValue(i,"ref_source","")%></td>
<td><%=dbmanager.getValue(i,"promotioncode","")%></td>
<td><%=dbmanager.getValue(i,"created_at","")%></td>
<td><%=dbmanager.getValue(i,"user_id","")%></td>
</tr>
<%
}
%>
</table>
<% }
else{
if(statobj.getCount()==0){
out.println("<center>invalid details</center>");
}
}
}
%>
</body>
</html>