Scribd
Upload
33 views

Servlet With JDBC-Code

The document contains code for a student form validation web application. It includes HTML and Java code defining servlets to handle form submission and display. The Dispatch servlet validates login credentials and forwards to the Table servlet if correct. Table servlet displays a form to enter student details and submit to the Store servlet, which inserts records into a database table.

Uploaded by

shanthi.ceg
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
33 views

Servlet With JDBC-Code

The document contains code for a student form validation web application. It includes HTML and Java code defining servlets to handle form submission and display. The Dispatch servlet validates login credentials and forwards to the Table servlet if correct. Table servlet displays a form to enter student details and submit to the Store servlet, which inserts records into a database table.

Uploaded by

shanthi.ceg
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

<!

DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<form action="abcd" method="post">
<table border="1" bgcolor="A9A9A9">
<tr>
<th>Enter username:</th>
<td><input type="text" name="user"></td>
</tr>
<tr>
<th>Enter password:</th>
<td><input type="text" name="pwd"></td>
</tr>
<tr>
<td><input type="submit" value="Sign in"></td>
</tr>
</table>
</form>
</body>
</html>

<?xml version="1.0" encoding="UTF-8"?>


<web-app version="2.4"
xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

<servlet>
<servlet-name>abc</servlet-name>
<servlet-class>Dispatch</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>abc</servlet-name>
<url-pattern>/servlet/abcd</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>xyz</servlet-name>
<servlet-class>Table</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>xyz</servlet-name>
<url-pattern>/servlet/table</url-pattern>
</servlet-mapping>

import jakarta.servlet.RequestDispatcher;
import jakarta.servlet.ServletException;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.Arrays;

public class Dispatch extends HttpServlet {


public void doPost(HttpServletRequest req, HttpServletResponse res) {
try {
res.setContentType("text/html");
PrintWriter out = res.getWriter();
String name = req.getParameter("user");
String pwd = req.getParameter("pwd");
if (name.equals("Jayachitra") && pwd.equalsIgnoreCase("hi")) {
RequestDispatcher rd = req.getRequestDispatcher("table");
rd.forward(req, res);
} else
{
out.println("<font color='red'><b>You have entered incorrect
password</b></font>");
RequestDispatcher rd = req.getRequestDispatcher("Sign.html");
rd.include(req, res);

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

import jakarta.servlet.RequestDispatcher;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Arrays;

public class Table extends HttpServlet {


public void doPost(HttpServletRequest req, HttpServletResponse res) {
try {
res.setContentType("text/html");
PrintWriter out = res.getWriter();

out.println("<html>");
out.println("<head><center><h2>Student form
validation</h2></center></head>");
out.println("<body bgcolor=\"#FFE4C4\"> ");
out.println(" <form action=\"validation\" method=\"post\">");
out.println("<table border=\"1\" bgcolor=\"A9A9A9\"> ");
out.println(" <tr><th>Enter student number : </th>");
out.println("<td><input type=\"text\"
name=\"sno\"></td></tr>");
out.println(" <tr><th>Enter student name : </th>");
out.println("<td><input type=\"text\"
name=\"sname\"></td></tr>");
out.println(" <tr><th>Enter student CGPA : </th>");
out.println("<td><input type=\"text\"
name=\"smarks\"></td></tr>");
out.println("<tr>");
out.println("<table>");
out.println("<tr>");
out.println("<td><input type=\"submit\" name=\"insert\"
value=\"Insert\"></td>");
out.println("<td><input type=\"reset\" name=\"clear\"
value=\"Clear\"></td>");
out.println("</tr>");
out.println("</table>");
out.println("</tr> ");
out.println("</table>");
out.println("</form>");
out.println("</body>");
out.println("</html>");

}
catch (Exception e) {
System.out.println(e);
}
/*int sno=Integer.parseInt(sno.getText());
String sname=sname.getText();
double smarks=smarks.getText();
req.setAttribute("sno",sno);
req.setAttribute("sname", sname);
req.setAttribute("smarks",smarks);
RequestDispatcher rd= req.getRequestDispatcher("store");
rd.forward(req,res);*/
}
}

import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.io.PrintWriter;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Arrays;
public class Store extends HttpServlet{
public void doPost(HttpServletRequest req, HttpServletResponse res) {
try {
res.setContentType("text/html");
PrintWriter out = res.getWriter();
int sno = Integer.parseInt(req.getParameter("sno"));
String sname = req.getParameter("sname");
double smarks = Double.parseDouble(req.getParameter("smarks"));
out.println("sno"+sno);
out.println("sname"+sname);
out.println("CGPA"+smarks);
try (Connection con =
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl",
"system", "Oracle123")) {
if (con == null) out.println("Database server not
connected");
else {
out.println("Database server connected");
Statement st = con.createStatement();
int count = st.executeUpdate("insert into Students
values(" + sno + ",'" + sname + "'," + smarks + ")");
out.println("rows affected" + count);

}
} catch (SQLException e) {
}

} catch (Exception e) {
}
}
}

You might also like