Introduction:

           The project “Online counseling system a Java Project” has been designed by keeping in mind the objective of enhancing the counseling process. This software will be a very easy for the students. This system is operational as an online system. This system can be used to report, register as wee as search information about various colleges and universities where students can apply.Online-Counseling-System-a-Java-Project

            The project report on Online counseling system gives a complete analysis if the system developed. This system greatly reduces the paperwork that is generated by the manual counseling process. The project follows a modular approach. The modules are institute record module, student record module and counseling module. Each module serves its own specific purpose.                        

Online Counseling Java Project Description:

        The project covers the entire counseling process online. In the institute record module, any institute can enter the counseling process by providing all the details about their institute. A search option is provided for users to know about their institute. A delete option is also present on the site which enables it to withdraw its name from the counseling list. The display option reveals the details of the institute.

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;</span>

public class Login extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res) throws IOException,ServletException
{
PrintWriter out = null;
try
{
out=res.getWriter();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:SUS","PLMS","PLMS");
// Connection con=DriverManager.getConnection("jdbc:odbc:SUS1","PLMS","PLMS");
Statement st=con.createStatement();
String S = req.getParameter("name");
String P = req.getParameter("pwd");
out.println(S);

ResultSet rs=st.executeQuery("select pers_no,password from pers_pass where pers_no="+S);
out.println("&lt;html&gt; &lt;body&gt;");
out.println("&lt;form&gt;");

while(rs.next())
{
if(P.equals(rs.getString(2)))
{
// res.sendRedirect("c:/javawebserver2.0/public_html/MainMenu.html");
res.sendRedirect("/MainMenu.html");
}
else
{
//res.sendRedirect("c:/javawebserver2.0/public_html/loginfail.html");
res.sendRedirect("/loginfail.html");
}

}
out.println("&lt;/form&gt;&lt;/head&gt;&lt;/html&gt;");
}
catch(Exception e)
{ out.println(e);}
}
}

          The 2nd module i.e. the student module has two parts. One is the search option which will aid in searching record of any student who has been allotted a seat during counseling. A delete option is present to delete the student from its record after the counseling process. The counseling module is a very important module and it has further sub categories within it. Students are allocated seats on the basis of these categories.    

Conclusion:

        The system discussed in the above project considerably speeds up the counseling process and it is done so in an efficient and easy manner. This system is also applicable for other universities or institutes and data entered in these systems are in user friendly forms. 

download Project Report of CSE Online counseling system a Java Project.