Introduction:

 The project “Online book store a CSE Final Year Java Project” has been designed for the sole purpose of selling books on a single platform. The website of the book is www.Techbook.com wherein the books that are mainly sold off are computer and technical books. The customers can access this bookstore via the worldwide web or in simple words the internet. For a particular book they require, they have to simply search through a database and then place the order. Payment can be made through credit cards. Online-Book-Store-a-CSE-Final-Year-Java-Project.

            This bookstore has software that serves a link between two commercial websites. Those commercial websites are bookpools.com and fatbrain.com. The bridge enables users to search through the inventory of these real bookstores and it displays search results like price, title and the availability of books.

Online Book Store Java Project Description:

           In the project online book store a web based interface which is a graphical user interface. A form is present to fill in input queries and this information can be used to search the database. The interface of the user then passes this input to the control function. This is implemented in Java. The control function’s main role is to process the input generated at the user’s end and then carries out the search operation in the database. The result is returned to the user’s interface.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class Login1 extends HttpServlet
{

Connection c;
Statement s;

public void init(ServletConfig cs) throws ServletException
{

try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
c=DriverManager.getConnection("jdbc:odbc:SUS","plms","plms");
s =c.createStatement();
}

catch(Exception e)
{
System.out.println("error in init()");
}
}

public void doGet(HttpServletRequest req,HttpServletResponse res)
{
try
{
res.setContentType("text/html");
PrintWriter pw=res.getWriter();
String uname=req.getParameter("name");
String pwd=req.getParameter("pwd");

System.out.println("select count(*) from pers_pass where p_no=upper('"+uname+"') and password=upper('"+pwd+"')");

ResultSet rs=s.executeQuery("select count(*) from pers_pass where p_no=upper('"+uname+"') and password=upper('"+pwd+"')");
rs.next();

int c=rs.getInt(1);

if(c==1)
{
res.sendRedirect("c:/javawebserver2.0/public_html/frmis.html");
}
else
{
pw.println("<html><body><center>");
pw.println("<h2> Invalid user!</h2>");
pw.println("<form action=c:/javawebserver2.0/public_html/login.html>");
pw.println("<input type=submit value=BACK name=BACK>");
pw.println("</form>");
pw.println("</center></body></html>");
}
}

catch(Exception e)
{
System.out.println(e);
}
}
}

    
  The control functions have bridges by which links are provided to search through external real online bookstores. The query is generated based on the user’s input and passed on to the commercial bookstores available on the web. The bridge also handles response from commercial bookstores and passes on this information and displays it to the user in HTML forms.    

Conclusion:

        The project has used various software’s to design the project. HTML language is used for web page design and implementation. Oracle is used to design the database and for the bride connections Java technology is used.   

download Project Report of CSE Online book store a CSE Final Year Java Project.