package userLogin;
import connection.Databasecon;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Random;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class AddBookRecord extends HttpServlet
{
//private String
id = null;
private String
bname = null;
private String
bauthor = null;
private String
selectbranch = null;
private Connection
con = null;
private Statement
stmt = null;
private ResultSet
rs = null;
Databasecon dbcon
= new Databasecon();
@Override
public void
doPost(HttpServletRequest request, HttpServletResponse response)throws
ServletException, IOException
{
response.setContentType("text/html;charset=UTF-8");
PrintWriter
out = response.getWriter();
HttpSession
session = request.getSession(true);
RequestDispatcher rds;
String status;
long bid;
status="Active";
Random rnd =
new Random();
bid =
rnd.hashCode();
//if(request.getParameter("bname")!=null)
// {
// }
//System.out.println(id);
if(dbcon!=null)
{
try
{
con
= dbcon.getConnection();
stmt = con.createStatement();
String query = "insert into
book_library(bookid,bookname,authorname,selectbranch,status)
values('"+bid+"','"+request.getParameter("bname")+"','"+request.getParameter("bauthor")+"','"+request.getParameter("selectbranch")+"','"+status+"')";
stmt.executeUpdate(query);
String qry = "select bookid from book_library where Bookname =
'"+request.getParameter("bname")+"'";
rs
= stmt.executeQuery(qry);
///////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
out.println("<html><head><meta
http-equiv='Content-Type' content='text/html; charset=iso-8859-1'
/><title>Link Software - Bhopal</title><link
href='css/first.css' rel='stylesheet' />");
out.println("</head><body>");
out.println("<div id='header'><table width='80%'
height='147' border='0' align='center' cellpadding='0' cellspacing='0'
bgcolor='#FFFFFF'><!--DWLayoutTable--><tr><td width='141' bgcolor='#F10403'><div
align='center'></div></td><td width='475' height='19'
background='Images/bg-1.gif'><div align='center'><span
class='style2'>LIBRARY MANAGEMENT SOFTWARE
</span></div></td><td width='180'
background='Images/bg-1.gif'><div align='center'><span class='style11'><strong><a
href='/LMS/UserControl/signout.jsp' class='menu1'>Sign
Out</a></strong></span>
</div></td></tr><tr><td
bgcolor='#990000'><!--DWLayoutEmptyCell--> </td><td
height='19' colspan='2' bgcolor='#990000'><!--DWLayoutEmptyCell--> </td></tr><tr><td
width='141' rowspan='3' bgcolor='#990000'><!--DWLayoutEmptyCell--> </td><td
height='42' colspan='2' bgcolor='#990000'><div align='center'
class='style1 style26'>Bundelkhand Mahavidhyalaya, BKD Jhansi
</div></td></tr><tr><td height='14' colspan='2'
bgcolor='#990000'><div align='right' class='menu1'>");
out.println(new
java.util.Date());
out.println("</div></td></tr><tr><td
height='14' colspan='2' bgcolor='#990000'><div align='center'
class='style22'><a href='/LMS/index.jsp' class='menu1'>Home</a>
| <a href='/LMS/aboutus.jsp' class='menu1'>About us</a> | <a
href='/LMS/gallary.jsp' class='menu1'>Gallery </a>| <a
href='/LMS/sitemap.jsp' class='menu1'>Sitemap </a>|<a
href='/LMS/contact.jsp' class='menu1'> Contact us </a></div></td></tr><tr><td
height='29' colspan='3' valign='top' bgcolor='#990000'
style='border-bottom:#F10403 thick
solid;'> </td><tr><td height='29' colspan='3'
valign='top' bgcolor='#FFFFCC'><h4>");
out.println(session.getAttribute("username"));
out.println("</h4></td>
<!-- <tr><td height='29' colspan='3' valign='top' bgcolor='#990000'
style='border-bottom:#F10403 thick
solid;'> </td>--></table></div>");
//out.println("<br />");
out.println("<br /><br /><br /><br /><br
/>");
//////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////
if(rs.next()==true)
{
out.println("<div align='center'");
out.println("<h1 class='menu'>The Book DDC Unique Code is:
<br />");
out.println("<img src='/LMS/UserControl/Images/barcode.jpg'
width = '110' height='50'><br>");
out.println("<h1
class='menu'>"+rs.getString(1)+"</h1>");
out.println("</div>");
out.println("<br /><br /><br /><br
/>");
out.println("<div align='center'><table
width='80%'><tr><td>");
out.println("<a href='UserControl/Addbookrecord.jsp'
class='menu'>Add More Record</a></td></tr><tr><td>");
out.println("<a href='/LMS/UserControl/LibrarianLogin.jsp'
class='menu'>Exit</a></td></tr></table></div>");
}
else
{
rds =
request.getRequestDispatcher("UserControl/ErrorRecord.jsp");
rds.forward(request,response);
}
out.println("<br /><br /><br /><br
/>");
out.println("<div id='footer'><table width='80%'
border='0' align='center' cellpadding='0' cellspacing='0'
bgcolor='#FFFFFF'><tr><td
colspan='3'> </td></tr><tr><td height='26'
colspan='3' bgcolor='#990000'><div align='center'><span
class='style22'><a href='index.jsp' class='menu1'>Home</a> |
<a href='aboutus.jsp' class='menu1'>About us</a> | <a
href='gallary.jsp' class='menu1'>Gallery </a>| <a
href='sitemap.jsp' class='menu1'>Sitemap </a>|<a href='contact.jsp'
class='menu1'> Contact us </a>
</span></div></td></tr><tr><td width='24%'
bgcolor='#990000'><div align='center'><span
class='style15'>Copyright © 2017. Link Software -
Bhopal</span> </div></td><td width='56%'><div
align='center'><span class='style17'><strong>Best
view:</strong> 1024x724 Pixel (Resolution) </span></div></td><td
width='20%' bgcolor='#990000'><div align='center'
class='style23'><span class='style19'><strong><u>Created
& Designed by:</u> <br /></strong>Balwant Chandel
</span></div></td></tr><tr><td
bgcolor='#990000'> </td><td bgcolor='#990000'> </td><td
bgcolor='#990000'> </td></tr></table></div></body></html>");
}
catch(Exception ex)
{
System.out.println("The Database Exception : "+ex);
}
}
else
{
System.out.println("This is a Connection Error");
}
}
}
Now we create mapping on this activity...
<servlet>
<servlet-name>AddStudentRecord</servlet-name>
<servlet-class>userLogin.AddStudentRecord</servlet-class>
</servlet>
<servlet>
<servlet-name>AddBookRecord</servlet-name>
<servlet-class>userLogin.AddBookRecord</servlet-class>
</servlet>
If this information is important to you , and you want to , I will continue writing some more details About Java, Servlet's, Android Programming Language, so click on the advertising, available on this page. This is motivate me for writing some more useful stuff, Thank's
Comments
Post a Comment