Welcome to Sentimentexpress...

<% //using jsp useBean directive to call Database Connection Class %> <%@ page language="java" import="java.sql.*" %> <% int counter; //Creating Connection Calling the useBean (dbBean) Connection myConn = dbBean.getConnection(); //Opening Statement Statement stmt=myConn.createStatement(); //ResultSet from Query ResultSet rSet = null; ///// Data written into site hit table //stmt.executeUpdate("insert into sitehit Values('G', current_date, current_Time)"); %> Welcome to Sentimentexpress...

Welcome to sentiment greetings

You can check your Card here:

Card No:

<% String strArr[][] = new String[4][2]; int intArr[][] = new int [4][3]; rSet = stmt.executeQuery("select CMCat_Id,CSCat_Id,Card_Id,CTitle,Card_Icon from cardmaster where Card_Priority='E'"); //reitializing the variable counter = 0; if (rSet != null) { while (rSet.next()){ if (counter >=4) { break; } strArr[counter][0] = rSet.getString("CTitle"); strArr[counter][1] = rSet.getString("Card_Icon"); intArr[counter][0] = rSet.getInt("CMCat_Id"); intArr[counter][1] = rSet.getInt("CSCat_Id"); intArr[counter][2] = rSet.getInt("Card_Id"); counter++; } } %>


<%=strArr[0][0]%>	<%=strArr[1][0]%>	<%=strArr[2][0]%>	<%=strArr[3][0]%>

<% strArr = new String[2][3]; intArr = new int [2][3]; rSet = stmt.executeQuery("select CMCat_Id,CSCat_Id,Card_Id,CTitle,Card_Icon,Card_Desrp from cardmaster where Card_Priority='N'"); //reitializing the variable counter = 0; if (rSet != null) { while (rSet.next()){ if (counter >=2) { break; } strArr[counter][0] = rSet.getString("CTitle"); strArr[counter][1] = rSet.getString("Card_Icon"); strArr[counter][2] = rSet.getString("Card_Desrp"); intArr[counter][0] = rSet.getInt("CMCat_Id"); intArr[counter][1] = rSet.getInt("CSCat_Id"); intArr[counter][2] = rSet.getInt("Card_Id"); counter++; } } %>

	<% if (strArr[0][2] != null) { %> <%=strArr[0][2]%> <% } %>		<% if (strArr[1][2] != null) { %> <%=strArr[1][2]%> <% } %>
<%=strArr[0][0]%>		<%=strArr[1][0]%>

<% strArr = new String[2][3]; intArr = new int [2][3]; rSet = stmt.executeQuery("select * from csubcat ORDER BY CSCat_Des"); //reitializing the variable int totSize = 0; if (rSet != null) { while (rSet.next()){ totSize++; } } String desArr[] = new String[totSize]; int idArr[][] = new int[totSize][2]; rSet = stmt.executeQuery("select * from csubcat ORDER BY CSCat_Des"); counter =0; if (rSet != null) { while (rSet.next()){ desArr[counter] = rSet.getString("CSCat_Des"); idArr[counter][0] = rSet.getInt("CMCat_Id"); idArr[counter][1] = rSet.getInt("CSCat_Id"); counter++; } } %>

<% if (totSize%2==0) { counter = 0; while (counter <% counter = counter+2; } }else { counter = 0; while (counter <% counter = counter+2; } %> <% } %>

<%=desArr[counter]%>	<%=desArr[counter+1]%>
<%=desArr[counter]%>	<%=desArr[counter+1]%>
<%=desArr[totSize-1]%>

<% strArr = new String[2][3]; intArr = new int [2][3]; rSet = stmt.executeQuery("select CMCat_Id,CSCat_Id,Card_Id,CTitle,Card_Icon from cardmaster where Card_Priority='L'"); //reitializing the variable counter = 0; if (rSet != null) { while (rSet.next()){ if (counter >=2) { break; } strArr[counter][0] = rSet.getString("CTitle"); strArr[counter][1] = rSet.getString("Card_Icon"); intArr[counter][0] = rSet.getInt("CMCat_Id"); intArr[counter][1] = rSet.getInt("CSCat_Id"); intArr[counter][2] = rSet.getInt("Card_Id"); counter++; } } %>


<%=strArr[0][0]%>	<%=strArr[1][0]%>

<% strArr = new String[2][3]; intArr = new int [2][3]; rSet = stmt.executeQuery("select CMCat_Id,CSCat_Id,Card_Id,CTitle,Card_Icon from cardmaster where Card_Priority='P'"); //reitializing the variable counter = 0; if (rSet != null) { while (rSet.next()){ if (counter >=2) { break; } strArr[counter][0] = rSet.getString("CTitle"); strArr[counter][1] = rSet.getString("Card_Icon"); intArr[counter][0] = rSet.getInt("CMCat_Id"); intArr[counter][1] = rSet.getInt("CSCat_Id"); intArr[counter][2] = rSet.getInt("Card_Id"); counter++; } } %>