<%@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="";
String contactno=null;
String companyname=null;
String address1=null;
String city=null;
String pincode=null;
String country=null;
String heading1=null;
String logoimage = "";
String footerlogo = "";
String subheading1 = "";
String serviceimg1 = "";
String serviceheading1 = "";
String servicedetail1 = "";
String serviceimg2 = "";
String serviceheading2 = "";
String servicedetail2 = "";
String serviceimg3 = "";
String serviceheading3 = "";
String servicedetail3 = "";
String aboutsheading = "";
String aboutheading = "";
String aboutdetail = "";
String aboutimg = "";
String howtoorderh1 = "";
String howtoorderd1 = "";
String howtoorderh2 = "";
String howtoorderd2 = "";
String howtoorderimg = "";
File checkFile=null;
int id =0;
id=1;
sql= "select * from homepage where id=?";
pstmt1 = con.prepareStatement(sql);
pstmt1.setInt(1, id);
rs=pstmt1.executeQuery();
if(rs.next())
{
contactno=rs.getString("phone")==null?"":rs.getString("phone");
companyname=rs.getString("companyname")==null?"":rs.getString("companyname");
address1=rs.getString("address1")==null?"":rs.getString("address1");
city=rs.getString("city")==null?"":rs.getString("city");
pincode=rs.getString("pincode")==null?"":rs.getString("pincode");
country=rs.getString("country")==null?"":rs.getString("country");
heading1=rs.getString("heading1")==null?"":rs.getString("heading1");
logoimage=rs.getString("logoimage")==null?"":rs.getString("logoimage");
subheading1=rs.getString("subheading1")==null?"":rs.getString("subheading1");
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");
aboutsheading=rs.getString("aboutsheading")==null?"":rs.getString("aboutsheading");
aboutheading=rs.getString("aboutheading")==null?"":rs.getString("aboutheading");
aboutdetail=rs.getString("aboutdetail")==null?"":rs.getString("aboutdetail");
aboutimg=rs.getString("aboutimg")==null?"":rs.getString("aboutimg");
howtoorderh1=rs.getString("howtoorderh1")==null?"":rs.getString("howtoorderh1");
howtoorderd1=rs.getString("howtoorderd1")==null?"":rs.getString("howtoorderd1");
howtoorderh2=rs.getString("howtoorderh2")==null?"":rs.getString("howtoorderh2");
howtoorderd2=rs.getString("howtoorderd2")==null?"":rs.getString("howtoorderd2");
howtoorderimg=rs.getString("howtoorderimg")==null?"":rs.getString("howtoorderimg");
footerlogo=rs.getString("footerlogo")==null?"":rs.getString("footerlogo");
}
%>
Foreign Language Books - Library Supplier of Foreign Language Publications to libraries across the UK.
<%= heading1 %>
<%= subheading1 %>
<%= aboutsheading %>
<%= aboutheading %>
<%= aboutdetail %>
Read More
