%@page import="java.net.URLDecoder"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import = "java.io.*,java.util.*" %> <%@page import="java.sql.Connection"%> <%@page import="model.DBConnect"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.PreparedStatement"%> <% Class.forName("com.mysql.jdbc.Driver"); Connection con = DBConnect.DatabaseConnection(); PreparedStatement pstmt1 = null; ResultSet rs=null; String sql=null; String detail=null; String serviceimg1 = ""; String serviceheading1 = ""; String servicedetail1 = ""; String serviceimg2 = ""; String serviceheading2 = ""; String servicedetail2 = ""; String serviceimg3 = ""; String serviceheading3 = ""; String servicedetail3 = ""; String serviceimg4 = ""; String serviceheading4 = ""; String servicedetail4 = ""; String serviceimg5 = ""; String serviceheading5 = ""; String servicedetail5 = ""; String serviceimg6 = ""; String serviceheading6 = ""; String servicedetail6 = ""; File checkFile=null; sql= "select * from services "; pstmt1 = con.prepareStatement(sql); rs=pstmt1.executeQuery(); if(rs.next()) { detail=rs.getString("detail")==null?"":rs.getString("detail"); serviceimg1=rs.getString("serviceimg1")==null?"":rs.getString("serviceimg1"); serviceheading1=rs.getString("serviceheading1")==null?"":rs.getString("serviceheading1"); servicedetail1=rs.getString("servicedetail1")==null?"":rs.getString("servicedetail1"); serviceimg2=rs.getString("serviceimg2")==null?"":rs.getString("serviceimg2"); serviceheading2=rs.getString("serviceheading2")==null?"":rs.getString("serviceheading2"); servicedetail2=rs.getString("servicedetail2")==null?"":rs.getString("servicedetail2"); serviceimg3=rs.getString("serviceimg3")==null?"":rs.getString("serviceimg3"); serviceheading3=rs.getString("serviceheading3")==null?"":rs.getString("serviceheading3"); servicedetail3=rs.getString("servicedetail3")==null?"":rs.getString("servicedetail3"); serviceimg4=rs.getString("serviceimg4")==null?"":rs.getString("serviceimg4"); serviceheading4=rs.getString("serviceheading4")==null?"":rs.getString("serviceheading4"); servicedetail4=rs.getString("servicedetail4")==null?"":rs.getString("servicedetail4"); serviceimg5=rs.getString("serviceimg5")==null?"":rs.getString("serviceimg5"); serviceheading5=rs.getString("serviceheading5")==null?"":rs.getString("serviceheading5"); servicedetail5=rs.getString("servicedetail5")==null?"":rs.getString("servicedetail5"); serviceimg6=rs.getString("serviceimg6")==null?"":rs.getString("serviceimg6"); serviceheading6=rs.getString("serviceheading6")==null?"":rs.getString("serviceheading6"); servicedetail6=rs.getString("servicedetail6")==null?"":rs.getString("servicedetail6"); } %>