<%
Connection con=null;
PreparedStatement ps;
ResultSet rs=null;
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con=DriverManager.getConnection("jdbc:sqlserver://LAPTOP-H4J2MPV1\\SACHIN:1433;databaseName=SarikaProducts;userName=sa;password=1112");
%>
All Products
<%
String sqlCat="select * from SarikaCategory";
ps=con.prepareStatement(sqlCat);
rs=ps.executeQuery();
while(rs.next())
{
%>
" class="list-group-item list-group-item-action"><%= rs.getString("categoryTitle") %>
<%
}
%>
<%
String cat_url=request.getParameter("category");
int cat_current;
String sqlPod;
if(cat_url==null)
{
sqlPod="select * from SarikaProduct";
}
else if(!cat_url.trim().equals("all") )
{
cat_current=Integer.parseInt(cat_url);
sqlPod="select * from SarikaProduct where PcategoryId="+cat_current;
}
else
{
sqlPod="select * from SarikaProduct";
}
ps=con.prepareStatement(sqlPod);
rs=ps.executeQuery();
while(rs.next())
{
String des_sort=rs.getString("pDesc");
%>
" style="max-height: 200px;max-width: 100%;width: auto;" class="card-img-top m-2" alt="...">
<%
}
%>
<%= rs.getString("pTitle") %>
<%= Helper.get10Words(des_sort) %>