ABSTRACT

In present day scenario, a student goes to a counseling center to get admission in an institution. This is time consuming. Moreover the colleges are not able to select the students of their choice. The main aim of this project is to convert the existing paper filling admission process into electronic filling for all new under graduate student admissions.

We create a web application for prospective students to apply for admission into the list of available colleges and courses of desired university and track the status of their application. We create an administrative web interface for the college admissions officers to review, track, and process new student applications.

class diagram of E-ADMISSIONS Project

The visitors to the E-ADMISSIONS can be both students and colleges. The student can search and fill the admission forms of selected colleges. College administration selects the students based on their academic performance and confirms their admissions. Student can also pay the fees through online after receiving the confirmation.

The fees payment can be done in two ways using credit card or DD number through online. There is also an access control system, which prevents unauthorized public to access all the information, whereas subscribed users can have full access to all available information.

MOTIVATION

The colleges for which this application has been developed were facing huge problems in the management of the admission process. Every year, students in thousands queue up for collecting admission forms and then again for submitting them. This leads to problems in managing the applications, resulting in annoyed parents and students (alike). Also, the admission process is not transparent, leading to scope for widespread malpractices.

In order to rectify these shortcomings, the online admissions system is developed. Here students need not collect physical forms, they are required to fill the admission form and submit it online. This saves a lot of time and effort on the part of the college as well as for the students. Since students interact with colleges, only the deserving candidates can get admission into the college.

PROBLEM DEFINITION:

Generally in order to get admission into an institution, the student should definitely go to the Counseling Center. In this process, colleges will not be able to pick the students of their choice. There is no proper scope of interaction between Colleges and Students. This process is quiet time consuming and hectic mainly for the students who come from long distances.

  • Present system involves more human power. As the students who apply for the colleges are not small in number, much coordination is required in order to organize the counseling process.
  • The students coming from long distances cannot afford to stay for long time near the counseling centers.

HARDWARE SPECIFICATIONS

  • Intel P-IV Processor
  •  512 MB RAM
  • 10 GB Hard Disk 

SOFTWARE SPECIFICATIONS

  • Operating System       :   Windows NT/ XP, Windows 98
  •  Languages                  :   JAVA using Servlets,

JSP with JDBC Drivers, JavaScript, HTML

  • Database                     :   Oracle
  • Web server                  :   Tomcat 5.5

Source Code of INBOX file:

<%@ page import="java.sql.*,java.util.*,Db.*"%>
<%

Connection con=DBConnect.getConnection();

String sname=(String)session.getAttribute("uname");
PreparedStatement pstmt=con.prepareStatement("select cname,status,sdate,code,branch,appid from sinbox where sname=?");
PreparedStatement pstmt1=con.prepareStatement("select appid from sinbox where sname=?");

pstmt.setString(1,sname);
pstmt1.setString(1,sname);
ResultSet rs=pstmt.executeQuery();
ResultSet rs1=pstmt1.executeQuery();
%>
<html>
<title>student inbox</title>
<center>
<font size="5" >
<b><p style="color='#7c7cba';font-family:'Perpetua'"><marquee behavior='alternate'>ONLINE ADMISSIONS SYSTEM</marquee> </p></b></font>
<table width='100%'>
<tr><td width='100%' bgcolor="#a2a2ce"><font size='5px'><center>
Welcome
<%
out.println(sname);
%></center></font></td></tr><tr align='left'><a href='studentlogin.html'>LOGOUT</A></tr></table>

<br><br>
<center>

<table border=1 cellspacing='0' cellpadding='4' bgcolor='lightyellow' style="font-family:'Perpetua';font-size:'19'">
<tr>
<th align='center'>CNAME</th>
<th align='center'>APPLICATION-ID</th>
<th align='center'>BRANCH</th>
<th align='center'>SUBJECT</th>
<th align='center'>DATE</th>
</tr>
<%
while(rs.next()){
%>
<tr><td align='center'><%=rs.getString(1)%></td>
<td align='center'><%=rs.getString(6)%><input type='hidden' name='appid' value='<%=rs.getString(6)%>' readonly ></td>
<td align='center'><%=rs.getString(5)%></td>
<td align='center'><%=rs.getString(2)%></td>
<td align='center'><%=rs.getString(3)%></td>
</tr>
<%
}
%>
</tbody>
</table>

<form action="link.jsp" method="post">

<b>Application id &nbsp; :&nbsp;&nbsp;&nbsp;</b><select name="appid">

<%
while(rs1.next()){
%>
<option><%= rs1.getString(1)%></option>
<%
}
%>
</select><br>
<br>
<input type="submit" value="select" style="font-size:'16';font-family:'Times new roman'">
</form>
</center>
</body>
</html>