(LMS)
AddStudentRecord.java
/*
* To change this template, choose Tools |
Templates
* and open the template in the editor.
*/
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.ServletException;
import
javax.servlet.http.HttpServlet;
import
javax.servlet.http.HttpServletRequest;
import
javax.servlet.http.HttpServletResponse;
import
javax.servlet.http.HttpSession;
public class AddStudentRecord
extends HttpServlet
{
private Connection con = null;
private Statement stmt = null;
private ResultSet rs = null;
// private String id = null;
private String selectbranch = null;
private String selectyear = null;
private String name = null;
private String lname = null;
private String fname = null;
private String presentaddr = null;
private String permanentaddr = null;
private String hcontect = null;
private String mobileno = 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);
long sid;
Random rnd = new Random();
sid = rnd.hashCode();
//////////////////////////////////////////////////////////
out.println("<html><head><meta
http-equiv='Content-Type' content='text/html; charset=iso-8859-1'
/><title>Library Management System - LINK SOFTWARE BHOPAL</title><link
href='css/first.css' rel='stylesheet' /></head>");
out.println("<body><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>");
out.println("<td width='180'
background='Images/bg-1.gif'><div align='center'><span class='style11'><strong><a
href='signin.jsp' class='menu1'>Sign in</a></strong> (For
members)</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>");
out.println("</tr><tr><td height='14' colspan='2'
bgcolor='#990000'> </td></tr><tr><td
height='14' colspan='2' bgcolor='#990000'><div align='center'
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></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'> </td><!-- <tr><td height='29'
colspan='3' valign='top' bgcolor='#990000' style='border-bottom:#F10403 thick
solid;'> </td>--></table></div><br
/>");
out.println("<br /><br
/><br /><br />");
//////////////////////////////////////////////////////////
if(dbcon!=null)
{
try
{
con = dbcon.getConnection();
stmt = con.createStatement();
String query = "insert
into studentinfo
(studentid,studentbranch,studentyear,FirstName,lastname,fathername,presentaddr,permanentaddr,homecontect,mobileno)
values('"+sid+"','"+request.getParameter("selectbranch")+"','"+request.getParameter("selectyear")+"','"+request.getParameter("name")+"','"+request.getParameter("lname")+"','"+request.getParameter("fname")+"','"+request.getParameter("presentaddr")+"','"+request.getParameter("permanentaddr")+"','"+request.getParameter("hcontect")+"','"+request.getParameter("mobileno")+"')";
stmt.executeUpdate(query);
//out.println("<table
width='100%' border='0' class='menu'><tr><td
align='center'>Records is successfully Inserted. <br />The Student Id
is: </td></tr></table>");
////////////////////////////////////////////////////////////////////////////////////
String qry = "select *
from studentinfo where FirstName = '"+request.getParameter("name")+"'";
rs = stmt.executeQuery(qry);
if(rs.next()==true)
{
out.println("<table width='100%' border='0'
class='menu'><tr><td align='center'>Records is successfully
Inserted. <br />The Student Id is:
"+rs.getString("studentid")+"
</td></tr></table>");
out.println("<div align='left'><table width = '80%'
align='center'><tr><td>");
out.println("<a href='UserControl/Addsturecord.jsp' class='menu'>Add
More Record</a>");
out.println("<br /><a
href='/LMS/UserControl/LibrarianLogin.jsp'
class='menu'>Exit</a></td></tr></table></div>");
}
else
{
out.println("Failed");
}
}
catch(Exception ex)
{
System.out.println("The
Database Exception : "+ex);
}
}
else
{
System.out.println("This is a
Connection Error");
}
///////////////////////////////////////////////////////////////////////////////////
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>");
////////////////////////////////////////////////////////////////////////
}
}
Now create mapping in web.xml file
<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