BCSL-057 ASSIGNMENT SOLUTION (2018-19)

If you have any queries please leave a message here
Your Message
×


Answer -

Home.html

<html>
<head>
<title>Home Page</title>
<link rel="stylesheet" type="text/css" href="mystyle.css">
</head>
<body>
<table width="100%" bgcolor="#E0FFFF">
<tr height="150">
<td><center><h1>HOME</h1></center></td>
<td align="right" width="400">
<p style="font-size:16pt; font-family:Cambria; font-weight: bold;">Indira Gandhi National Open University</p>
<img src="logo.png" height="60" width="150">
</td>
</tr>
</table>
<table width="100%">
<tr>
<td width="250">
<div class="vertical-menu">
<a href="Home.html" class="active">Home</a>
<a href="Re-Registration.html">Re-Registration</a>
<a href="Status-Check.html">Status-Check</a>
<a href="Help.html">Help ?</a>
</div>
</td>
<td>
<div style="overflow: auto; height: 500; margin-left:10px;">

<u><h2>Re-registration</h2></u>
<br /><p class="headercss">Rules and Process</p>
<p class="textcss"><b>Note:</b> Re-registration means registering for next year/semester of a Program. So it is applicable only to students enrolled in undergraduate/postgraduate programmes of two-three years duration. You can re-register for the next year/semester of your Programme irrespective of whether you have submitted the assignments or appeared in the term-end examination of the previous semester. Please go through the related rules carefully.</p>
<p class="textcss">This application is best viewed using current versions of Firefox, Chrome at a screen resolution of 1024 x 768 or higher. This application will not work in Internet explorer Ver 11 and above.</p>
<br /><p class="headercss">Instruction to Fill Application Form Online</p>
<ol class="textcss">
<li><p>If you are a first time applicant then you are check the User Manual carefully.</p>
<li><p>Before proceeding for filling the form online the applicant must have the following:-
<ul style="list-style-type: lower-roman;">
<li>Enrolment Number
<li>Registered email ID and mobile number, if not then get it registered by contacting the concerned regional center or by visiting.
</ul></p>
</ol><br />

</div>
</td>
</tr>
</table>
<table width="100%" bgcolor="#E0FFFF">
<tr height="50">
<td><center><p class="footer">&#9400 Indira Gandhi National Open University Re-registration Web Link</p></center></td>
</tr>
</table>
</body>
</html>

Re-Registration.html

<html>
<head>
<title>Re-Registration Page</title>
<link rel="stylesheet" type="text/css" href="mystyle.css">
<script type="text/javascript">
function Number(event)
{
var key = event.which || event.keyCode;
return ((key >= 48 && key <= 57) || key == 8);
}
function PageField()
{
document.getElementById("blankLabel").style.display = "none";
}
function BlankField()
{
var enrolment, password;
var notblank=true;
enrolment = document.getElementById("enrolment").value;
password = document.getElementById("pwd").value;
if(enrolment.length > 0 && password.length >= 6)
document.getElementById("blankLabel").style.display = "none";
if(enrolment.length == 0)
{
document.getElementById("blankLabel").innerHTML = "Enrolment Number field is blank";
document.getElementById("blankLabel").style.display = "block";
notblank=false;
}
else
if(password.length < 6)
{
document.getElementById("blankLabel").innerHTML = "Length of entered password is less than 6 characters";
document.getElementById("blankLabel").style.display = "block";
notblank=false;
}
return notblank;
} </script>
</head>
<body onload="PageField()">
<table width="100%" bgcolor="#E0FFFF">
<tr height="150">
<td><center><h1>RE-REGISTRATION</h1></center></td>
<td align="right" width="400">
<p style="font-size:16pt; font-family:Cambria; font-weight: bold;">Indira Gandhi National Open University</p>
<img src="logo.png" height="60" width="150">
</td>
</tr>
<table width="100%">
<tr>
<td width="250">
<div class="vertical-menu">
<a href="Home.html">Home</a>
<a href="Re-Registration.html" class="active">Re-Registration</a>
<a href="Status-Check.html">Status-Check</a>
<a href="Help.html">Help ?</a>
</div>
</td>
<td>
<center><form name="Registration" method="post" onsubmit="return BlankField()" action="Payment.jsp">
<table cellpadding="10" class="textcss">
<tr><td>Enrolment Number</td>
<td><input type="text" id="enrolment" name="enrolment" size="25" maxlength="9" onkeypress="return Number(event);"></td></tr>
<tr><td>Password</td>
<td><input type="password" id="pwd" name="pwd" size="25" maxlength="32"></td></tr>
</table>
<p class="textcss"><b><font color="red"><label id="blankLabel"></label></font></b></p>
<p><input type="submit" style='width:100' value="SUBMIT"></p>
</form></center>
</td>
</tr>
</table>
<table width="100%" bgcolor="#E0FFFF">
<tr height="50">
<td><center><p class="footer">&#9400 Indira Gandhi National Open University Re-registration Web Link</p></center></td>
</tr>
</table>
</body>
</html>

Status-Check.html

<html>
<head>
<title>Status-Check Page</title>
<link rel="stylesheet" type="text/css" href="mystyle.css">
<script type="text/javascript">
function Number(event)
{
var key = event.which || event.keyCode;
return ((key >= 48 && key <= 57) || key == 8);
}
function PageField()
{
document.getElementById("blankLabel").style.display = "none";
}
function BlankField()
{
var enrolment;
var notblank=true;
enrolment = document.getElementById("enrolment").value;
if(enrolment.length > 0)
document.getElementById("blankLabel").style.display = "none";
if(enrolment.length == 0)
{
document.getElementById("blankLabel").innerHTML = "Enrolment Number field is blank";
document.getElementById("blankLabel").style.display = "block";
notblank=false;
}
return notblank;
}
</script>
</head>
<body onload="PageField()">
<table width="100%" bgcolor="#E0FFFF">
<tr height="150">
<td><center><h1>STATUS CHECK</h1></center></td>
<td align="right" width="400">
<p style="font-size:16pt; font-family:Cambria; font-weight: bold;">Indira Gandhi National Open University</p>
<img src="logo.png" height="60" width="150">
</td>
</tr>
</table>
<table width="100%">
<tr>
<td width="250">
<div class="vertical-menu">
<a href="Home.html">Home</a>
<a href="Re-Registration.html">Re-Registration</a>
<a href="Status-Check.html" class="active">Status-Check</a>
<a href="Help.html">Help ?</a>
</div>
</td>
<td>
<center><form name="Display" method="post" onsubmit="return BlankField()" action="DisplayStudentDetails.jsp">
<p><span class="textcss" style="margin-right:10px;">Enrolment Number</span>
<input type="text" id="enrolment" name="enrolment" size="25" maxlength="9" onkeypress="return Number(event);"></p>
<p class="textcss"><b><font color="red"><label id="blankLabel"></label></font></b></p>
<p><input type="submit" style='width:100' value="DISPLAY"></p>
</form></center>
</td>
</tr>
</table>
<table width="100%" bgcolor="#E0FFFF">
<tr height="50">
<td><center><p class="footer">&#9400 Indira Gandhi National Open University Re-registration Web Link</p></center></td>
</tr>
</table>
</body>
</html>

Help.html

<html>
<head>
<title>Help Page</title>
<link rel="stylesheet" type="text/css" href="mystyle.css">
</head>
<body>
<table width="100%" bgcolor="#E0FFFF">
<tr height="150">
<td><center><h1>HELP</h1></center></td>
<td align="right" width="400">
<p style="font-size:16pt; font-family:Cambria; font-weight: bold;">Indira Gandhi National Open University</p>
<img src="logo.png" height="60" width="150">
</td>
</tr>
</table>
<table width="100%">
<tr>
<td width="250">
<div class="vertical-menu">
<a href="Home.html">Home</a>
<a href="Re-Registration.html">Re-Registration</a>
<a href="Status-Check.html">Status-Check</a>
<a href="Help.html" class="active">Help ?</a>
</div>
</td>
<td>
<center><table width="90%" border="1" cellpadding="10" class="textcss">

<tr><th>Home</th><th>Re-registration</th><th>Status Check</th><tr>
<tr><td width="33%" valign="top">The Home page display the process and rules of re-registration.</td>
<td width="33%" valign="top">The Re-registration page display a form for logging into fee-payment form page.</td>
<td width="34%">The Status-Check page contains a form to accept the enrolment number of a student to display his/her enrolment number, name and last semester enrolled information.</td></tr>

</table></center>
</td>
</tr>
</table>
<table width="100%" bgcolor="#E0FFFF">
<tr height="50">
<td><center><p class="footer">&#9400 Indira Gandhi National Open University Re-registration Web Link</p></center></td>
</tr>
</table>
</body>
</html>

Payment.jsp

<%@page import="java.sql.*"%>
<%
int enrolmentNo=Integer.parseInt(request.getParameter("enrolment"));
String loginPassword=request.getParameter("pwd");
String url="jdbc:mysql://localhost:3306/University";
String user="Admin";
String password="Admin1234";
String SQL="SELECT * FROM student WHERE enrolment="+enrolmentNo+" AND password='"+loginPassword+"'";
boolean login=false;
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection(url,user,password);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(SQL);
if(rs.next())
{
out.println(rs.getString("enrolment"));
login=true;
}
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
%>
<html>
<head>
<title>Payment Page</title>
<link rel="stylesheet" type="text/css" href="mystyle.css">
<style>input[type="date"] { height: 40px; font-size:14pt; font-family:Cambria; }</style>
</head>
<body>
<table width="100%" bgcolor="#E0FFFF">
<tr height="150">
<td><center><h1>RE-REGISTRATION</h1></center></td>
<td align="right" width="400">
<p style="font-size:16pt; font-family:Cambria; font-weight: bold;">Indira Gandhi National Open University</p>
<img src="logo.png" height="60" width="150">
</td>
</tr>
</table>
<table width="100%">
<tr>
<td width="250">
<div class="vertical-menu">
<a href="Home.html">Home</a>
<a href="Re-Registration.html" class="active">Re-Registration</a>
<a href="Status-Check.html">Status-Check</a>
<a href="Help.html">Help ?</a>
</div>
</td>
<td>
<% if(login) { %>
<center><h2>Fee Payment</h2>
<form name="Payment" method="post" action="#">
<br /><p class="headercss">Enrolment Number : <% out.print(enrolmentNo); %></p>
<table cellpadding="10" class="textcss">
<tr><td>Draft Number</td>
<td><input type="text" id="draftno" name="draftno" size="14" maxlength="6"></td></tr>
<tr><td>Draft Date</td>
<td><input type="date" id="draftdate" name="draftdate"></td></tr>
<tr><td>Draft Amount</td>
<td><input type="text" id="amount" name="amount" size="14" maxlength="10"></td></tr>
</table>
<br /><input type="submit" style='width:100' value="Submit">
</form></center>
<%
} else {
out.print("<center><h2><font color='red'>Invalid Enrolment Number/Password</font></h2></center>");
}
%>
</td>
</tr></table>
<table width="100%" bgcolor="#E0FFFF">
<tr height="50">
<td><center><p class="footer">&#9400 Indira Gandhi National Open University Re-registration Web Link</p></center></td>
</tr>
</table>
</body>
</html>

DisplayStudentDetails.jsp

<%@page import="java.sql.*"%>
<html>
<head>
<title>Display Student Details</title>
<link rel="stylesheet" type="text/css" href="mystyle.css">
</head>
<body>
<table width="100%" bgcolor="#E0FFFF">
<tr height="150">
<td><center><h1>STATUS CHECK</h1></center></td>
<td align="right" width="400">
<p style="font-size:16pt; font-family:Cambria; font-weight: bold;">Indira Gandhi National Open University</p>
<img src="logo.png" height="60" width="150">
</td>
</tr>
</table>
<table width="100%">
<tr>
<td width="250">
<div class="vertical-menu">
<a href="Home.html">Home</a>
<a href="Re-Registration.html">Re-Registration</a>
<a href="Status-Check.html" class="active">Status-Check</a>
<a href="Help.html">Help ?</a>
</div>
</td>
<td>
<%
int enrolmentNo=Integer.parseInt(request.getParameter("enrolment"));
String url="jdbc:mysql://localhost:3306/University";
String user="Admin";
String password="Admin1234";
String SQL="SELECT * FROM student WHERE enrolment="+enrolmentNo;
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection(url,user,password);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(SQL);
if(rs.next())
{
%>
<center><h2>Student Details</h2>
<table border="1" cellpadding="10" class="textcss">
<tr>
<th>Enrolment Number</th>
<th>Student Name</th>
<th>Current Semester</th>
</tr>
<tr>
<td><center><% out.println(rs.getString("enrolment")); %></center></td>
<td><% out.println(rs.getString("sname")); %></td>
<td><center><% out.println(rs.getString("semester")); %></center></td>
</tr>
</table></center>
<%
} else {
out.print("<center><h2><font color='red'>Invalid Enrolment Number</font></h2></center>");
}
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
%>
</td>
</tr></table>
<table width="100%" bgcolor="#E0FFFF">
<tr height="50">
<td><center><p class="footer">&#9400 Indira Gandhi National Open University Re-registration Web Link</p></center></td>
</tr>
</table>
</body>
</html>

mystyle.css

h1 { font-family:Cambria; }
h2 { font-family:Cambria; color:#8B0000; }
.textcss { font-size:14pt; font-family:Cambria; }
.headercss { font-size:16pt; font-family:Cambria; font-weight: bold; color: #00008B; }
.footer {font-size:16pt; font-family:Cambria; font-weight: bold; }
.vertical-menu { height: 500; width: 250px; font-size:16pt; font-family:Cambria; font-weight: bold; background-color: #FFFFE0; }
.vertical-menu a { background-color: #FFFFE0; color: black; display: block; padding: 12px; text-decoration: none; }
.vertical-menu a:hover { background-color: #D4D4D4; }
.vertical-menu a.active { background-color: #90EE90; }
input[type="text"] { height: 40px; font-size:14pt; font-family:Cambria; }
input[type="password"] { height: 40px; font-size:14pt; font-family:Cambria; }
input[type="submit"] { height: 40px; font-size:14pt; font-family:Cambria; font-weight: bold; width:350;}
table, th, td { border-collapse: collapse; }



ABOUT US

QuestionSolves.com is an educational website that helps worldwide students in solving computer education related queries.

Also, different software like Visual Studio, SQL Server, Oracle etc. are available to download in different versions.

Moreover, QuestionSolves.com provides solutions to your questions and assignments also.


MORE TOPIC


Windows Command

UNIX Command

IGNOU Assignment Solution

IGNOU Question Paper Solution


WHAT WE DO


Website Devlopment

Training

Home Learning

Provide BCA, MCA Projects

Provide Assignment & Question Paper Solution


CONTACT US


Follow Us