Monday, 27 July 2015

Postgresql

SELECT QUERY:



<%@page import="java.util.ArrayList"%>
<%@page import="java.util.HashMap"%>
<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>

<%
DBManager dbmanager=new DBManager();
String query="select eventname,email,phone,status,region from eventinfo limit 10";

ArrayList list=new ArrayList();
    System.out.println("query is:"+query);
  StatusObj statobj = dbmanager.executeSelectQuery(query,null);
    System.out.println("sbcount"+statobj.getCount());
  if(statobj.getStatus() && statobj.getCount()>0){
%>
<table align="center" border="1" cellpadding="5" cellspacing="5"
style="border-collapse: collapse; border-style: solid"
bordercolor="black">
<tr class="head">
<th>Event Name</th>
        <th>Email id</th>
        <th>Phone</th>
        <th>Status</th>
<th>Region</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,"eventname","")%></td>
<td><%=dbmanager.getValue(i,"email","")%></td>
        <td><%=dbmanager.getValue(i,"phone","")%></td>
        <td><%=dbmanager.getValue(i,"status","")%></td>
        <td><%=dbmanager.getValue(i,"region","")%></td>

</tr>

<%
}
%>
</table>

<% }
  else{
 if(statobj.getCount()==0){
 out.println("<center>No records found</center>");
 }
  }
 
%>

</body>
</html>