Untitled

WEBSERVICES/JSP/Servlet/PHP/JDBC:

Develop a web application for a Library Management System using JSP. Note: Your application must access a database.
DB creation

mysql> create database library; Query OK, 1 row affected (0.02 sec)
mysql> use library;
Database changed

mysql> create table book (accno integer, title varchar(20),author varchar(20), publisher varchar(20),edition integer, price integer, primary key (accno) );

Query OK, 0 rows affected (0.09 sec)


mysql> insert into book values ( 2, 'C++', 'Balagurusamy', 'Tata', 4, 300); Query OK, 1 row affected (0.03 sec)
mysql> insert into book values (3, 'OS', 'Weiss', 'Pearson', 3, 250); Query OK, 1 row affected (0.01 sec)
mysql> insert into book values (4, 'Internet', 'Deitel','Pearson',3, 500); Query OK, 1 row affected (0.02 sec)
mysql> insert into book values (5, 'Java', 'Arun', 'Pearson', 3, 400); Query OK, 1 row affected (0.03 sec)

mysql> select * from book;


// IndBook:Info.html

<!DOCTYPE html>
<html>
<head>
<title>Insert title here</title>
</head>
<body>
<form method= "post" action= "BookInfo.jsp">
<center>
<h2>Library Management System</h2>
</center>
<hr>
Enter the Acc No.
<input type= "text" name= "accno ">
<input type="submit" value= "Get Details">
</form>
</body>
</html>


//BookInfo.jsp

<%@ page language="java" contentType="text/html; import= "java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<title>Book info</title>
</head>
<body>
<%
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try
{
Class.forName ( "com.mysql.jdbc.Driver");
String URL ="jdbc:mysql://localhost:3306/library?";
conn = DriverManager.getConnection(URL, "root", "root");
ps= conn.prepareStatement(" select * from book where accno = ?");
String accno = request.getParameter("accno");
ps.setString(1, accno);
rs = ps.executeQuery();
while(rs.next())
{
out.println("Acc. No. :" + rs.getInt(1));
out.println("<br>");
out.println("Title :" + rs.getString(2));
out.println ( "<br>");
out.println("Author :" +rs.getString(3));
out.println ( "<br>");
out.println("Publisher ·" + rs.getString(4));
out.println ( "<br>");
out.println("Edition :" + rs.getInt(5));
out.println ( "<br>");
out.println("Price :" + rs.getInt(6));
out.println("<br>");
}
rs .close ();
ps.close();
conn.close();
}
catch(Exception e)
 {
out.println(e);
}
%>

</body>
</html>


Servlet:

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**

*/ @WebServlet("/Bookinfo")
public class Bookinfo extends HttpServlet
{
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;

protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

response. setContentType ( "text/html") ;
PrintWriter out = response.getWriter();

try
{

program