Student Portal 3b6u3n

  • ed by: Paul Joseph
  • 0
  • 0
  • November 2021
  • PDF

This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 2z6p3t

Overview 5o1f4z

& View Student Portal as PDF for free.

More details 6z3438

  • Words: 8,995
  • Pages: 89


Contains all other HTML tags

<META>...

Provides

meta-information

about

a

document <SCRIPT>…

Contains client-side or server-side script

…


Creates a table

…

Indicates table data in a table

…

Designates a table row

…

Creates a heading in a table

ADVANTAGES 

A HTML document is small and hence easy to send over the net. It is small because it does not include formatted information.



HTML is platform independent.



HTML tags are not case-sensitive.

Java Database Connectivity What Is JDBC? JDBC is a Java API for executing SQL statements. (As a point of interest, JDBC is a trademarked name and is not an acronym; nevertheless, JDBC is often thought of as standing for Java Database Connectivity. It consists of a set of classes and interfaces written in the Java programming language. JDBC provides a standard API for tool/database developers and makes it possible to write database applications using a pure Java API.

Using JDBC, it is easy to send SQL statements to virtually any relational database. One can write a single program using the JDBC API, and the program will be able to send SQL statements to the appropriate database. The combinations of Java and JDBC lets a programmer write it once and run it anywhere.

What Does JDBC Do? Simply put, JDBC makes it possible to do three things: 

Establish a connection with a database



Send SQL statements



Process the results.

JDBC versus ODBC and other APIs At this point, Microsoft's ODBC (Open Database Connectivity) API is that probably the most widely used programming interface for accessing relational databases. It offers the ability to connect to almost all databases on almost all platforms. So why not just use ODBC from Java? The answer is that you can use ODBC from Java, but this is best done with the help of JDBC in the form of the JDBC-ODBC Bridge, which we will c o v e r s h o r t l y. T h e q u e s t i o n n o w b e c o m e s " W h y d o y o u n e e d JDBC?" There are several answers to this question: 1. ODBC is not appropriate for direct use from Java because it uses a C interface. Calls from Java to native C code have a number of drawbacks

in

the

security,

implementation,

robustness,

and

automatic portability of applications. 2. A literal translation of the ODBC C API into a Java API would not be desirable. For example, Java has no pointers, and ODBC makes copious use of them, including the notoriously error-prone generic pointer "void *". You can think of JDBC as ODBC translated into an object-oriented interface that is natural for Java programmers.

3. ODBC is hard to learn. It mixes simple and advanced features together, and it has complex options even for simple queries. JDBC, on the other hand, was designed to keep simple things simple while allowing more advanced capabilities where required. 4. A Java API like JDBC is needed in order to enable a "pure Java" solution. When ODBC is used, the ODBC driver manager and drivers must be manually installed on every client machine. When the JDBC driver is written completely in Java, however, JDBC code is automatically installable, portable, and secure on all Java platforms from network computers to mainframes.

JDBC-ODBC Bridge If possible, use a Pure Java JDBC driver instead of the Bridge and an ODBC driver. This completely eliminates the client configuration required by ODBC. It also eliminates the potential that the Java VM could be corrupted by an error in the native code brought in by the Bridge (that is, the Bridge native library, the ODBC driver manager library, the ODBC driver library, and the database client library).

What Is the JDBC- ODBC

Bridge?

The JDBC-ODBC Bridge is a JDBC driver, which implements JDBC operations by translating them into ODBC operations. To ODBC it appears as a normal application program. The Bridge implements JDBC for any database for which an ODBC driver is available. The Bridge is implemented as the Sun.jdbc.odbc Java package and contains a native library used to access ODBC. The Bridge is a t development of Innersole and Java Soft.

Java Server Pages (Jsp) Java server Pages is a simple, yet powerful technology for creating and maintaining dynamic-content web pages. Based on the Java programming language, Java Server Pages offers proven portability, open standards, and

a mature re-usable component model .The Java Server Pages architecture enables the separation of content generation from content presentation. This separation not eases maintenance headaches; it also allows web team to focus on their areas of expertise. Now, web page designer can concentrate on layout, and web application designers on programming, with minimal concern about impacting each other’s work.

Features of JSP Portability: Java Server Pages files can be run on any web server or web-enabled application server that provides for them. Dubbed the JSP engine, this involves recognition, translation, and management of the Java Server Page lifecycle and its interaction components.

Components: It was mentioned earlier that the Java Server Pages architecture can include reusable Java components. The architecture also allows for the embedding of a scripting language directly into the Java Server Pages file. The components current ed include Java Beans, and Servlets.

Processing: A Java Server Pages file is essentially an HTML document with JSP scripting or tags. The Java Server Pages file has a JSP extension to the server as a Java Server Pages file. Before the page is served, the Java Server Pages syntax is parsed and processed into a Servlet on the server side. The Servlet that is generated outputs real content in straight HTML for responding to the client.

Access Models: A Java Server Pages file may be accessed in at least two different ways. A client’s request comes directly into a Java Server Page. In this scenario, suppose the page accesses reusable Java Bean components that perform particular well-defined computations like accessing a database. The result of the Beans computations, called result sets is stored within the Bean as

properties. The page uses such Beans to generate dynamic content and present it back to the client. In both of the above cases, the page could also contain any valid Java code. Java Server Pages architecture encourages separation of content from presentation.

Steps in the execution of a JSP Application: 1. The client sends a request to the web server for a JSP file by giving the name of the JSP file within the form tag of a HTML page. 2. This request is transferred to the JavaWebServer. At the server side JavaWebServer receives the request and if it is a request for a jsp file server gives this request to the JSP engine. 3. JSP engine is program which can understands the tags of the jsp and then it converts those tags into a Servlet program and it is stored at the server side. This Servlet is loaded in the memory and then it is executed and the result is given back to the JavaWebServer and then it is transferred back to the result is given back to the JavaWebServer and then it is transferred back to the client.

Purpose The generated application is the first version upon the system. The overall system is planned to be in the formal of distributed architecture with homogeneous database platform. The major objective of the overall system is to keep the following components intact. System consistencySystem integrity Overall security of data Data reliability and Accuracy friendly name both at istration and levels Considering the fact of generality and clarity To cross check that the system overcomes the hurdles of the version specific standards

Project Plan 

Maintain and manage the fee payments details of the students

for

their

academic

purposes

and

examinations. 

Maintain and manage the faculty based material and the previous question papers along with the answers.



Maintain

and

manage

the

faculty

assignments

and

marks details.

MS-ACCESS

What is a Database?

A database is a computer term for a collection of related information about certain topic or business application, such as an employee database or a product database. Databases help you organize related information in a logical manner for easy access. Computer databases can store data in different formats, from simple lines of text (such as names and addresses) to complex data structures that include pictures, sounds or video images. Databases arrange information in such a way that any specific piece of information can be accessed if a reference point is known.

Additional Information

1.Difference between data and database A) A data is a collection of related information put together. B) A database is a computer term for a collection of related information about a certain topic or business application. Database help in organizing related information in logical manner for easy access and retrieval. Database consists of data within its objects. 2. The primary key is used to uniquely identify the records in a table. 3. The set of records returned by a query is known as dynaset. How to create a database:

Microsoft Access provides three methods to create a database: You can create a database by using the Database wizard. The wizard lets you choose from one of the built-in templates, and customize it to some extent. Then it creates a set of tables, queries, forms, and reports, and also a switchboard for the database. The tables do not have any data in them. Use this method if one of the built-in templates closely match your requirements.

Creating a database by using a Database Wizard You can use a Database Wizard to create in one operation the required tables, forms, and reports for the type of database you choose — this is the easiest way to start creating your database. The wizard offers limited options to customize the database.

1.Click New on the toolbar. 2.In the New File task pane, under Templates, click On my computer. 3.On the Databases tab, click the icon for the kind of database you want to create, and then click OK.

4.In the File New Database dialog box, specify a name and location for the database, and then click Create. 5.Follow the instructions in the Database Wizard.

Create a database by using a template:

This is the quickest way to create a database. This method works best if you can find and use a template that very closely matches your requirements. 1.Click New on the toolbar. 2.In the New File task pane, under Templates, either search for a specific template or click Templates on Office Online to browse for a suitable template. 3.Locate the Access template you want, and click . If you want to start creating a database based on your design, create a blank database, then add the tables, forms, reports, and other objects individually — this is the most flexible method, but it requires you to define each database element separately.

Create an empty database without using a

Database Wizard:

1.Click New on the toolbar. 2.In the New File task pane, under New, click Blank Database. 3.In the File New Database dialog box, specify a name and location for the database, and then click Create.

What is a table? Relational databases are constituted by one or more tables than contain the information in an organized form. Databases usually contain more than one table and each one will have a fixed number of fields. The tables are made up by two structures:  Field: It corresponds to the name of the column. It must be unique and besides to have a data type associate  Record: It corresponds to each row that composes the table. There the data and the registries are composed

Relationships in a Database:  One-To-Many Relationships

A one-to-many relationship is the most common type of relationship. In this type of relationship, a row in table A can have many matching rows in table B, but a row in table B can have only one matching row in table A. For example, the Publishers and Titles tables have a one-to-many relationship: each publisher produces many titles, but each title comes from only one publisher. A one-to-many relationship is created if only one of the related columns is a primary key or has a unique constraint. In Access, the primary key side of a one-to-many relationship is denoted by a key symbol. The foreign key side of a relationship is denoted by an infinity symbol.  Many-To-Many Relationships

n a many-to-many relationship, a row in table A can have many matching rows in table B, and vice versa. You create such a relationship by defining a third table, called a junction table, whose primary key consists of the foreign keys from both table A and table B. For example, the Authors table and the Titles table have a many-to-many relationship that is defined by a one-to-many relationship from each of these tables to the TitleAuthors table. The primary key of the TitleAuthors table is the combination of the au_id column (the authors table’s primary key) and the title_id column (the Titles table’s primary key).

 One-To-One Relationships

In a one-to-one relationship, a row in table A can have no more than one matching row in table B, and vice versa. A one-to-one relationship is created if both of the related columns are primary keys or have unique constraints. This type of relationship is not common because most information related in this way would be all in one table. You might use a one-to-one relationship to:  Divide a table with many columns  Isolate part of a table for security reasons.  Store data that is short-lived and could be easily deleted by simply deleting the table.  Store information that applies only to a subset of the main table. In Access, the primary key side of a one-to-one relationship is denoted by a key symbol. The foreign key side is also denoted by a key symbol.

MODULE DESCRIPTION

The total number of databases that were identified to build system

is

14.

The

major

parts

of

the

databases

are

categorized as istration components and students and faculty’s useful

components.

is

managing

The

the

istration

actual

master

components

data

that

may

are be

necessary to maintain the consistency of the system. These databases

are

purely

used

for

the

internal

organizational

needs and necessities. The

students

and

faculty’s

components

are

designed

to

handle to transactional states that arise upon the system whereas students or faculty can make a visit onto the portal for

the

sake

of

the

information

related

to

semesters,

examinations fees, Library Books and Corporate details. The

students and faculty’s components are scheduled to accept parametrical information from the uses as per the system n e c e s s i t y. The

istration

consistent actuaries

in and

collation.

that which

These

transactional

s is

interface

practically

needs

interfaces

states

lute

part

proper to

date

of

on

visitors

date

the

organizational

authentication

the in

concentrate

for

with

deletion

all

and

date the date

updation only with the Date search capabilities. The students or faculties interface helps the ordinary website visitors in transactions the required services that are provided upon the site. The faculties can manage their own

information

in

a

customized

manner

as

per

their

flexibilities.

Number Of Modules Students Module: This module manages all that information related to the students, who got enrolled into the system. The students association towards the particular course and the examination schedules along with the fee payments and results are integrated into this. In this Module we give he flexibility to the in viewing his personal information, applying for the certificates required at the academic level, t o t h e a d m i n i s t r a t o r. T h e y c a n a l s o v i e w f o r a n y n o t i f i c a t i o n s from the corporate, details of the marks obtained in various subjects. Student is also given privilege of accessing their

information

and

changes

the

s

for

the

security reasons. Faculties

Module:

This

module

manages

the

information

that is specific to the faculties. The module also integrates

itself

to

the

courses

subjects

on

manages

itself

details

and

which to

he

to

which

he

is

being

deputed.

maintain

association

of

is

responsible

integration their

The

with

marks

and

module the

entry

the also

faculties’ into

the

concerned subjects depending upon the course, subjects and semester he/she involved. College

Information

Module:

This

module

manages

the

information of all the courses that are practically ed within the College as per their academic councils decision. This

module

also

infrastructure,

involves

faculties

in

maintaining

information,

the

Library

details

details

of and

associated data. This module internally maintains the fees details of courses conducted in the organization, detailed information

of

faculties,

library

catalogue,

issue

of

the

books, available books in the library etc. Corporate Information Management Module: The Module maintains the details of the corporate companies that are interested to provide placements to their College students through campus placements. The portal maintains the list of all the corporate sectors that are available and also provides the facilities for ing them selves onto the database of this site for their future endeavors. The Students and the faculties as well as the management can have a fair glance of information regarding all the corporate sectors and guide their students regarding the essentials and necessities of job placements.

Module: This module deals with istrative strategies of the organization, which involve checking out the student’s registrations, their ission details, and

authenticating them to access the information from the system. This module also involves the maintenance of details of the students submitting requests for the various certificates and permitting them accordingly to have. This module is mainly designed to provide the validation check at the istration level for every event generated at the front-end level.

TESTING

Testing Testing is the process of detecting errors. Testing performs a very critical role for quality assurance and for ensuring the reliability of software. The results of testing are used later on during maintenance also.

Psychology of Testing The aim of testing is often to demonstrate that a program works by showing that it has no errors. The basic purpose of testing phase is to detect the errors that may be present in the program. Hence one should not start testing with the intent of showing that a program works, but the intent should be to show that a program doesn’t work. Testing is the process of executing a program with the intent of finding errors.

Testing Objectives The main objective of testing is to uncover a host of errors, systematically and with minimum effort and time. Stating formally, we can say,

 Testing is a process of executing a program with the intent of finding an error.

 A

successful

test

is

one

that

uncovers

an

as

yet

undiscovered error.  A good test case is one that has a high probability of finding error, if it exists.  The tests are inadequate to detect possibly present errors.  The software more or less confirms to the quality and reliable standards.

Levels of Testing In order to uncover the errors present in different phases we have the concept of levels of testing. The basic levels of testing are as shown below… Client Needs

Requirements

Design

Acceptance Testing

System Testing

Integration Testing

Unit Testing Code

System Testing

The philosophy behind testing is to find errors. Test cases are devised with this in mind. A strategy employed for system testing is code testing.

Code Testing: This strategy examines the logic of the program. To follow this method we developed some test data that resulted in executing every instruction in the program and module i.e. every path is tested. Systems are not designed as entire nor are they tested as single systems. To ensure that the coding is perfect two types of testing is performed or for that matter is performed or that matter is performed or for that matter is performed on all systems.

Types Of Testing  Unit Testing  Link Testing

Unit Testing Unit testing focuses verification effort on the smallest unit of software i.e.

the

module.

Using

the

detailed

design

and

the

process

specifications testing is done to uncover errors within the boundary of the module. All modules must be successful in the unit test before the start of the integration testing begins. In this project each service can be thought of a module. There are so many modules like , HW, Master, Normal , and PManager. Giving different sets of inputs has tested each module. When developing the module as well as finishing the development so that each module works without any error. The inputs are validated when accepting from the . In this application developer tests the programs up as system. Software units in a system are the modules and routines that are assembled and integrated to form a specific function. Unit testing is first done on modules, independent of one another to locate errors. This enables to detect errors. Through this errors resulting from interaction between modules initially avoided.

Link Testing Link testing does not test software but rather the integration of each module in system. The primary concern is the compatibility of each module. The Programmer tests where modules are designed with different parameters, length, type etc.

Integration Testing After the unit testing we have to perform integration testing. The goal here is to see if modules can be integrated proprerly, the emphasis being on testing interfaces between modules. This testing activity can be considered as testing the design and hence the emphasis on testing module interactions. In this project integrating all the modules forms the main system. When integrating all the modules I have checked whether the integration effects working of any of the services by giving different combinations of inputs with which the two services run perfectly before Integration.

White Box Testing This is a unit testing method where a unit will be taken at a time and tested thoroughly at a statement level to find the maximum possible errors. I tested step wise every piece of code, taking care that every statement in the code is executed at least once. The white box testing is also called Glass Box Testing. I have generated a list of test cases, sample data. which is used to check all

possible combinations of execution paths through the code at every

module level.

Black Box Testing This testing method considers a module as a single unit and checks the unit at interface and communication with other modules rather getting into details at statement level. Here the module will be treated as a block box that will take some input and generate output. Output for a given set of input combinations are forwarded to other modules.

DATA FLOW DIAGRAMS

DATA FLOW DIAGRAMS Symbols in DFD: Data Flow

:

Process

:

Data Store

:

Terminator

:

DFD For New Faculty Entry

Department Master

Java Source

Designation Master

Validate Faculty ID

Java Source

Java Sourc e

Check For Department

Data

Check For

Data 1.3

1.2 Designation

Insert

Faculty Master

DFD For New Subject Under Course Entry

Subject Master

Course Master

Course_Sub

Master Validate CourseID

Insert New

SubjectID

Data

CourseID

Check For

2.1

Data

Check For

2.3

2.2 Subject

Course

SubjectID

Data

Insert

Course_Sub

Master

DFD For new Examination Entry

Course Master

Examination Master Validate

Insert New Exam ID

Data 3.1

Semester Master

Exam ID

Check For Course

Data

Check For

Data 3.3

3.2 Semester

Insert

Examination Master

DFD For New Exam Time Table Entry

Examination Master

Exam Time Table Validate ExamID

Insert New ExamID SubjectID

Data 4.1

Subject Master

SubjectID

Check For

Data

Check For

Data 4.3

4.2 Subject

Exam

Insert

Exam Time Table DFD For New Fee Payment Details

Fee Payment Master

Payment Master Details Validate PaymentID PaymentTypeID Insert New

Data

Check For

Data

PaymentID PaymentTypeID

5.1

Fee Payment

5.2

Check For

Fee Payment Type Master

Data 5.3

Fee Payment TypeID Insert

Exam Time Table

DFD For New Faculty Course Entry

Faculty Master

Faculty Course Master Validate FacultyID CourseID Insert New FacultyID CourseID

Data 6.1

Check For

Faculty

Data

Check For

6.2 Course

CourseMaster

Verif y Data 6.3

Insert

Faculty Course Master DFD For New Faculty Subject Entry

Faculty Master

Faculty Course Master Validate FacultyID CourseID Insert New

Data

FacultyID

6.1

SubjectID

Check For

Faculty

Data

Check For

6.2 Subject

Insert

Faculty Subject Master

Subject Master

Verif y Data 6.3

DFD For New Student Registration

Course Master

Student Master

Request for

Generate StudentID()

Validate Course ID()

Student Registration

7.1

7.2

Semester Master

V al i d a t e Semest er ID 7.3

Commi t

Updatio n Of Data Student Master DFD For Student Examination Registration

Student Master

Examination Master

Request for

Generate Exam ID()

Exam Registration

8.1

Subject Master

V al i d a t e Subject ID

Validate Student ID() 8.2

8.3

Commi t

Updatio n Of Data Examinantion Master

DFD for Notes Submission By Faculty

Subject Master

Faculty Master

Faculty Notes Master

Request for

Generate Notes ID()

Validate Faculty ID()

Notes Submission

9.1

9.2

V al i d a t e Subject ID 9.3

Commi t

Updatio n Of Data Faculty Notes Master DFD For Fee Payment Fee Payment Master Details

Faculty Notes Master

Request for Notes Submission

Student Master

Generate Fee Payment ID()

Validate student ID()

10.1

10.2

Generate Fee Payment ID() 10.3

Validate Fee ID()

Commi t

Updatio n Of Data Faculty Notes Master

10.2

Fee Master

DATA DICTIONARY

LIST OF TABLES TABLE NAME

:

NAME

TYPE

CONSTRAINT

USID PWD

TEXT 20 TEXT 10

PRIMARY KEY

TABLE NAME

:

_CORPORATE

NAME

TYPE

CONSTRAINT

CORPORATE_ID NOTIFICATION_ID NOTI_DATE NOTI_LDATE NOTIFICATION

TEXT 20 TEXT 20 DATE DATE TEXT 20

PRIMARY KEY

TABLE NAME

: BRANCH_MASTER

NAME

TYPE

CONSTRAINT

BRANCH_ID BRANCH_NAME BRANCH_DESC COURSE_ID

TEXT TEXT TEXT TEXT

PRIMARY KEY FOREIGN KEY

TABLE NAME

:

CATALOG

NAME

TYPE

CONSTRAINT

BOOK_ID BOOK_NAME BOOK_AUTHOR BOOK_EDITION

TEXT 10 TEXT 20 TEXT 20 TEXT 10

PRIMARY KEY

TABLE NAME

:

CORPORATE_

NAME

TYPE

CONSTRAINT

CID C PW_OLD PW_NEW

TEXT TEXT TEXT TEXT

FOREIGN KEY

TABLE NAME

:

CORPORATE_MASTER

NAME

TYPE

CORPORATE_ID CORPORATE_NAME CORPORATE_DESC CORPORATE_WEBSITE

TABLE NAME

TEXT 20 TEXT 20 TEXT 10 TEXT 20

CONSTRAINT PRIMARY KEY

:COURSE_MASTER

NAME

TYPE

CONSTRAINT

COURSE_ID

TEXT 10

PRIMARY KEY

COURSE_NAME

TEXT 20

COURSE_SHORT_NAME TEXT 5 COURSE_DESCRIPTION TEXT 20 COURSE_FEE

TEXT 10

TABLE NAME: COURSE_SUBJECT_MASTER NAME COURSE_ID SUBJECT_ID SEMESTER_ID

TYPE TEXT TEXT TEXT

CONSTRAINT FOREIGN KEY FOREIGN KEY FOREIGN KEY

TABLE NAME:DEPARTMENT_MASTER NAME DEPARTMENT_ID DEPARTMENT_NAME DEPARTMENT_DESCRIPTION

TYPE TEXT 8 TEXT 10 TEXT 20

CONSTRAINT PRIMARY KEY

TABLE NAME:DESIGNATION_MASTER NAME DESIGNATION_ID DESIGNATION_NAME DESIGNATION_DESCRITION

TYPE TEXT 10 TEXT 15 TEXT 20

CONSTRAINT PRIMARY KEY

TABLE NAME:FACULTY_ NAME FACULTY_ID

TYPE TEXT

CONSTRAINT FOREIGN KEY

_NAME PW_OLD PW_NEW PW_CHANGED_DATE

TEXT TEXT TEXT DATE

TABLE NAME:SEMISTER_MASTER NAME SEMISTER_ID SEMISTER_TYPE SEM_START_DATE SEM_END_DATE

TYPE TEXT 10 TEXT 10 DATE DATE

CONSTRAINT PRIMARY KEY

TABLE NAME:STUDENT_CERTIFICATES NAME STUDENT_ID CERTIFICATES APPLY_DATE APPLY_STATUS

TYPE TEXT TEXT DATE TEXT

CONSTRAINT FOREIGN KEY

TABLE NAME:FACULTY_MASTER NAME

TYPE

CONSTRAINT

FACULTY_ID FIRSTNAME LASTNAME GENDER ROLE REM_QUESTION REM_ANSWER DOB HOUSENO STREET CITY STATE COUNTRY PINCODE PHONENO DEPARTMENT_ID DESIGNATION_ID DATE EMAIL

TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT DATE TEXT TEXT TEXT TEXT TEXT NUMBER NUMBER TEXT TEXT DATE TEXT

PRIMARY KEY

FOREIGN KEY FOREIGN KEY

TABLE NAME:JOB_DETAILS NAME JOB_ID JOB_NAME JOB_QUALIFICATION

TYPE TEXT TEXT TEXT

CONSTRAINT PRIMARY KEY

NO_OF_VACANCIES LAST_DATE COMPANY_ID

NUMBER DATE TEXT

FOREIGN KEY

TABLE NAME:NOTIFICATION_MASTER NAME NOTIFICATION_ID NOTI_DATE NOTI_LDATE NOTIFICATION INDENDED_FOR STATUS

TYPE TEXT DATE DATE TEXT TEXT TEXT

CONSTRAINT PRIMARY KEY

TABLE NAME:STUDENT_ NAME STUDENT_ID _NAME PW_OLD PW_NEW PW_CHANGED_DATE

TYPE TEXT TEXT TEXT TEXT DATE

CONSTRAINT FOREIGN KEY

TABLE NAME:STUDENT_MARKS NAME STUDENTID STUDENTNAME SUB1 SUB2

TYPE TEXT TEXT NUMBER NUMBER

CONSTRAINT FOREIGN KEY

SUB3 SUB4 SUB5

NUMBER NUMBER NUMBER

TABLE NAME:STUDENT_MASTER NAME STUDENT_ID FIRSTNAME LASTNAME GENDER ROLE REM_QUESTION REM_ANSWER DOB HOUSENO STREET CITY STATE COUNTRY PINCODE PHONENO COURSE_ID DATE_OF_ISSION EMAIL

TYPE TEXT TEXT TEXT TEXT TEXT TEXT TEXT TEXT DATE TEXT TEXT TEXT TEXT TEXT NUMBER NUMBER TEXT DATE TEXT

CONSTRAINT PRIMARY KEY

FOREIGN KEY

TABLE NAME:STU_NOTIFICATION_MASTER NAME TYPE NOTIFICATION_ID TEXT NOTI_DATE DATE

CONSTRAINT PRIMARY KEY

NOTI_LDATE NOTIFICATION INDENDED_FOR STATUS

DATE TEXT TEXT TEXT

TABLE NAME:SUBJECT_MASTER NAME SUBJECT_ID SUBJECT_NAME SUBJECT_LONG_NAME SUBJECT_DESCRIPTION

TYPE TEXT 10 TEXT 10 TEXT 20 TEXT 20

CONSTRAINT PRIMARY KEY

CODING

1.CourseMasterServlet.java /*StudentServlet.java*/ import conpack.Conn;

import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.util.*;

public class CourseMasterServlet extends HttpServlet { public void service(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException { PrintWriter out=res.getWriter(); try { String cid=req.getParameter("CNO"); String cname=req.getParameter("CNAME"); String cshort=req.getParameter("CSHORTNAME"); String cdesc=req.getParameter("CDESC"); String cfee=req.getParameter("CFEE"); String action=req.getParameter("action");

res.setContentType("text/html");

if (action.equals("Insert")) { java.sql.Connection con=Conn.getCon(); java.sql.Statement st=con.createStatement(); String sss="insert into course_master values('"+cid+"','"+cname+"','"+cshort+"','"+cdesc+"',"+cfee+")"; System.out.println(sss); int c=st.executeUpdate(sss); System.out.println("IIIIIIIIIIIIIIIII"+c); if (c==1) { RequestDispatcher rd=req.getRequestDispatcher("CourseInsertSuc.html"); rd.include(req,res); }//if else { RequestDispatcher rd=req.getRequestDispatcher("CourseMasterEntry.jsp"); rd.include(req,res); out.println("

* Invalid Operaion
* Try Once Again

");

return; } } else { RequestDispatcher rd=req.getRequestDispatcher("CourseMasterEntry.jsp"); rd.include(req,res); out.println("

* Invalid Operation
* Try Once Again

"); return; }

} catch (Exception e) {e.printStackTrace(); RequestDispatcher rd=req.getRequestDispatcher("CourseMasterEntry.jsp"); rd.include(req,res); out.println("

* Invalid Operation
* Try Once Again

"); return;

} } }

2. SubjectMasterServlet.java /*StudentServlet.java*/

import conpack.Conn; import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.util.*;

public class SubjectMasterServlet extends HttpServlet { public void service(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException {PrintWriter out=res.getWriter(); try { String sid=req.getParameter("sid"); String sname=req.getParameter("sname");

String slname=req.getParameter("slname"); String sdes=req.getParameter("sdes"); String action=req.getParameter("action"); res.setContentType("text/html"); out.println(sid+"
"); out.println(sname+"
"); out.println(slname+"
"); out.println(action+"
"); if (action.equals("Insert")) { java.sql.Connection con=Conn.getCon(); java.sql.Statement st=con.createStatement(); String sss="insert into subject_master values('"+sid+"','"+sname+"','"+slname+"','"+sdes+"')" ; System.out.println(sss); int c=st.executeUpdate(sss); System.out.println("IIIIIIIIIIIIIIIII"+c); //con.close();st.close(); if (c==1) {

RequestDispatcher rd=req.getRequestDispatcher("SubjectInsertSuc.html"); rd.include(req,res); }//if else { RequestDispatcher rd=req.getRequestDispatcher("SubjectMasterEntry .jsp"); rd.include(req,res); out.println("

* Invalid Operaion
* Try Once Again

"); return; } } else { RequestDispatcher rd=req.getRequestDispatcher("/SubjectMasterEntr y.jsp"); rd.include(req,res); out.println("

* Invalid Operation
* Try Once Again

"); return;

}

} catch (Exception e) {e.printStackTrace(); RequestDispatcher rd=req.getRequestDispatcher("/SubjectMasterEntr y.jsp"); rd.include(req,res); out.println("

* Invalid Operation
* Try Once Again

"); return;

} } }

FORMS AND REPORTS

1.Homepage

2. Page

3.Student Page

4.Student Registration Page

5.Students Certificates Form

6.Students Search Form

7.Faculty Registration Form

8.Faculty Search Form

9. Job Infor mat i on For m

10. Det ai l s Of Job

11.Course

12.Course Deatils

13.Semester Entry Form

14.Semester Entry Report

15.Subject Details

16.Subject Entry Form

17.Subject Details Report

18. Form

19.

20.About College

21.Infrastructure

22.Courses

23.Faculty

24.Library

25.Corporate

26.Corport Report

27.Job Details

28.Company Profile

29.Student Details

30.Student

31.Student Information

32.Certificates Application

33.MarkList

34.Job Information

35.Faculty Form

36.Faculty Profile

37.Student Details

FUTURE SCOPE

FUTURE UPGRADES: This system can be upgraded in the future. The Future system will be connected to online and perform all the transactions directly from the Main System database which facilitates the full control to the authorities over the sub systems. All the Transactions performed everywhere can be easily known from the main System. Manual The entire application has been designed using Ms-access as back end and using the graphical features of HTML and dynamism through the JSP provides the front end interface. 

The customer can Interact with the website just by providing the URL that is specified.



The system displays the list of all items that are practically working and ready for sale, which he can click and select for shopping.



Once the total number of items has been chosen, he pushes them onto the card.



If the customer is ed, the shopping card is accepted; else a message is prompted which specifies the customer to get ed.



If the customer can get ed by clicking on the logon button and provide the required information as specified.



Each time the ed customer come on to the site he can makes use of the name and the that is allocated to him.



The who is managing the actual information should also be ed for the first time, and they are also allocated with the name and .



The has full-length privileges related to the activities that govern the data maintenance.



The also has the privilege to manage and maintain the authentication standards for all customers.



Using core java and components like JSP and EJB needs proper deployment as per general specifications developed the front end as it

SUMMARY CONCLUSION:

This Student Portal is developed using Java.

So it can operate

effectively and efficiently on any platform with out any modifications. It facilitates fast, secure, reliable and efficient Management to the end s. Using this application the higher authorities have the full control on all parts of the undergoing systems. This System provides the full security and is free from malpractice in the Student Portal.

BIBLIOGRAPHY

 J ava C o mpl ete Refer en ce: HE RBE RT SC HIE LD  Wor k i n g w ith MS - Office: RON MON S FI ELD  J ava S erv l et Pr ogrammi n g: JASON HUN TE R  So ftwar e En gi n eer in g: ROG E R S.PRE SSMAN

Related Documents c2h70

Student Portal 3b6u3n
December 2019 55
Student Portal 3b6u3n
November 2021 0
Wsdc - Student Portal 3ku1v
August 2021 0
Smude Student Portal Manual 186k6
November 2019 64
Smc Student Portal 3j5l18
December 2019 81
Srs Of Student Portal 5n543d
April 2022 0

More Documents from "Paul Joseph" 6i4n5r

Patent Us3951134 - Apparatus And Method For Remotely Monitoring And Altering Brain Waves - Google Patents.pdf 2n5ed
December 2019 18
Prediabetes - Wikipedia, The Free Encyclopedia.pdf 6n5o5f
May 2022 0
Student Portal 3b6u3n
November 2021 0
Nikola Tesla - The Complete Patents Of Nikola Tesla - The Man Who Invented The 20th Century.pdf 39373g
November 2019 44
How To Critically Appraise An Article.pdf m1j2i
September 2022 0
In The Shelter Of Thy Wings 336nu
October 2019 89

Copyright © 2025 IDOUB.