Scribd
Upload
18 views16 pages

Sample Code

The document consists of multiple JSP files related to a TollGate Management system, including forms for adding vehicle types and user registration. It contains HTML structure, JavaScript validation functions, and SQL queries for database interactions. The files handle user input, validate data, and provide feedback on successful or failed operations.

Uploaded by

Sri M
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
18 views16 pages

Sample Code

The document consists of multiple JSP files related to a TollGate Management system, including forms for adding vehicle types and user registration. It contains HTML structure, JavaScript validation functions, and SQL queries for database interactions. The files handle user input, validate data, and provide feedback on successful or failed operations.

Uploaded by

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

AddVehicleType.

jsp

<%--

Document : AddVehicleTypes

Created on : 15 Feb, 2023, [Link] PM

Author : GKV

--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>

<!DOCTYPE html">

<html xml:lang="en" xmlns="[Link]

<head>

<title>Company Name</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<link href="css/[Link]" rel="stylesheet" type="text/css" />

</head>

<body>

<div id="container">

<h1>TollGate Management</h1>

<div id="intro">

<div id="pageHeader">

<h1><span></span></h1>

</div>

<div id="lmenu">
<ul>

<ul>

<ul>

<li><a href="[Link]">Home</a>&nbsp; </li>

<li><a href="[Link]">Logout</a>&nbsp; </li>

</ul>

</ul>

</ul>

</div>

</div>

<div id="quickintro">

<div id="quickSummary"> </div>

</div>

<div id="development">

<h3><span></span></h3>

<br>

<table>

<td width="150"></td><td>

<form name="s" action="[Link]" onSubmit="return validation()">

<table align="center">

<h1><font color="#3333FF">Add Vehicle Type</font></h1>

<br>

<tr>

<td><font color="#FF0000">Add Vehicle type</font></td>


<td><input type="text" name="vtype" required></td>

</tr>

<td></td>

<td><input type="submit" value="submit"> <input type="reset" value="reset"></td></td>

</table>

</form></td>

</table>

<br>

<br>

<br>

<br>

</div>

<div id="footer">

</div>

</div>

</div>

</body>

</html>

[Link]

<%--

Document : AddTypeAction

Created on : 15 Feb, 2023, [Link] PM


Author : GKV

--%>

<%@ page import="[Link].*,databaseconnection.*"%>

<%

String a=[Link]("vtype");

try

Connection con = [Link]();

Statement st=[Link]();

ResultSet r=[Link]("select count(vehicle_type) from vehicletype where


vehicle_type='"+a+"'");

int c=0;

while([Link]()){

c=[Link](1);

if(c==0){

PreparedStatement ps=[Link]("insert into vehicletype values(null,?)");

[Link](1,a);

int i=[Link]();

if(i>0){

%>

<script type="text/javascript">
[Link]("This Type of Vehicle Added");

[Link]="[Link]";

</script>

<%

}else{

%>

<script type="text/javascript">

[Link]("Failed to Added Vehicle");

[Link]="[Link]";

</script>

<%

}else{

%>

<script type="text/javascript">

[Link]("This Type of Vehicle is Already Exist");

[Link]="[Link]";

</script>

<%

catch(Exception e)
{

[Link]([Link]());

%>

[Link]

<%--

Document : TollAction

Created on : 15 Feb, 2023, [Link] PM

Author : GKV

--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>

<%@ page import="[Link].*,databaseconnection.*"%>

<html>

<head>

<title>Untitled Document</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<link href="[Link]" rel="stylesheet" type="text/css" media="screen" />

</head>

<body>

<%
String a=[Link]("n");

String b=[Link]("p");

try

Connection con = [Link]();//register, connectionn established

PreparedStatement ps=[Link]("select username,password from toll where


username='"+a+"' AND password='"+b+"'");//create statement

ResultSet rs=[Link]();//execute queries

if([Link]())

[Link]("[Link]");

else

[Link]("Enter correct name and password !!!!!!!");

catch(Exception e1)

[Link]([Link]());

%>

</body>
</html>

[Link]

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"


"[Link]

<html xml:lang="en" xmlns="[Link]

<head>

<title>Company Name</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<link href="css/[Link]" rel="stylesheet" type="text/css" />

<script type="text/javascript">

function validation()

var a=[Link];

if(a=="")

alert("Enter your Username!");

[Link]();

return false;

var b=[Link];

if(b=="")
{

alert("Enter your passsword!");

[Link]();

return false;

var c=[Link];

if(c=="")

alert("Enter your Name!");

[Link]();

return false;

var d=[Link];

if (d==null||d=="")

alert("Plese Select the registration state");

[Link]();

return false;

}
var e=[Link];

if(e=="")

alert("Enter your Vehicle No!");

[Link]();

return false;

var g = [Link];

if(g=="")

alert("please Enter the Contact Number");

[Link]();

return false;

if(isNaN(g))

alert("Enter the valid Mobile Number(Like : 9789534737)");

[Link]();

return false;

}
if([Link] != 10)

alert(" Your Mobile Number must be 1 to 10 Integers");

[Link]();

return false;

var h=[Link]["f"]["eid"].value;

var atpos=[Link]("@");

var dotpos=[Link](".");

if (atpos<1 || dotpos<atpos+2 || dotpos+2>=[Link])

alert("Not a valid e-mail address");

[Link]();

return false;

var i=[Link];

if(i=="")

alert("Enter your Address!");

[Link]();
return false;

</script>

</head>

<body>

<div id="container">

<h1>TollGate Management</h1>

<div id="intro">

<div id="pageHeader">

<h1><span></span></h1>

</div>

<div id="lmenu">

<ul>

<li><a href="[Link]">Home</a>&nbsp; </li>

<li><a href="[Link]">Admin Login</a>&nbsp; </li>

<li><a href="[Link]">Toll Setter</a>&nbsp;</li>

<li><a href="[Link]">User</a>&nbsp;</li>

</ul>

</div>

</div>
<div id="quickintro">

<div id="quickSummary"> </div>

</div>

<div id="development">

<form name="f" action="[Link]" onsubmit="return validation()">

<table>

<td width="300"></td><td>

<table bgcolor="#FFFFFF">

<h1><font color="#FF0000">New Registration Form</font></h1></font></td>

<tr>

<th>Username</th>

<td><input type="text" name="name"> </td>

</tr>

<tr>

<th>Password</th>

<td><input type="password" name="pass"> </td>

</tr>

<tr>

<th>Your Name</th>

<td><input type="text" name="yn"> </td>

</tr>

<tr>

<th>Vehicle No</th>

<td><select name="ca">
<option value="">-----</option>

<option value="TS">TS</option>

<option value="TN">TN</option>

<option value="KE">KE</option>

<option value="AP">AP</option>

<option value="AR">AR</option>

<option value="AS">AS</option>

<option value="BR">BR</option>

<option value="CG">CG</option>

<option value="DL">DL</option>

<option value="GA">GA</option>

<option value="GJ">GJ</option>

<option value="HR">HR</option>

<option value="HP">HP</option>

<option value="JK">JK</option>

<option value="JS">JS</option>

<option value="KA">KA</option>

<option value="KL">KL</option>

<option value="MP">MP</option>

<option value="MH">MH</option>

<option value="MN">MN</option>

<option value="ML">ML</option>

<option value="MZ">MZ</option>

<option value="NL">NL</option>
<option value="OR">OR</option>

<option value="PB">PB</option>

<option value="RJ">RJ</option>

<option value="SK">SK</option>

<option value="UP">UP</option>

<option value="WB">WB</option>

<option value="AN">AN</option>

<option value="CH">CH</option>

<option value="DN">DN</option>

<option value="DD">DD</option>

<option value="LD">LD</option>

<option value="PY">PY</option>

</select> <input type="text" name="vn"></td>

</tr>

<tr>

<th>Phone No</th>

<td><input type="text" name="pn"> </td>

</tr>

<tr>

<th>Email Id</th>

<td><input type="text" name="eid"> </td>

</tr>

<tr>

<th>Address</th>
<td><textarea rows="4" cols="40" name="add"></textarea></td>

</tr>

<tr>

<td></td>

<td><input type="submit" name="su" value="submit"> <input type="reset" name="re"


value="clear"></td>

</tr>

</table></td>

</table>

</form>

<br>

<br>

<br>

</div>

<div id="footer"> </div>

</div>

</div>

</body>

</html>

You might also like