· web view1. introduction. 1.1 . an. o. verview. the project entitled “student bulletin board...

STUDENT BULLETIN BOARD MANGEMENT SYSTEM

1. INTRODUCTION

1.1 An Overview

The project entitled “Student Bulletin Board Management System” aims at

developing a Student Bulletin Board for students and teachers for sharing

notes,news,questions, placement information, etc .The project has been developed

with JSP as the Front End and Microsoft Access 2003 as the Back End .The project is

prepaired to implement in Windows Xp platform. The project helps to maintain all

transaction between teachers and students.

1.2 Objective Of The Project

The main objective of the project is to manage the time consumption and work

burden will be reduced immensely . As a result of the detailed study carried out ,

various objectives are formulated . There should be an entry screen and report at

every stage of the application. Facility for the maintenance of all the tables facility to

accept validate and process data . Facility to generate all essential reports. Help

should provided at each and every steps .Thus making user friendly. Validation

checks must be performed at each and every level .Database should be designed with

minimum redundancy.

www.engineeringminiprojects.com1


CHAPTER 2

SYSTEM ANALYSIS

System analysis is a logical process; the objective of this phase is not actually to

solve the problem but to determine what must be done to solve the problem. The basic

objective of the analysis stage is to develop the logical model of the system using tools such

as the data flow diagram and elementary data description of the elementary algorithm. The

logical model is Subject to review by both the management and the user who agree that the

model does in fact reflect what should be done to solve the problem.

System analysis is not a precise science. It is in fact more of an art, aided by

scientific approach to find definition and recording data, gathering traditional structures is

only one part of the system analysis, the next step is to examine the data, assess the situation

and looking at the alternatives.

2.2.1 Advantages of proposed system

Flexible and tolerable for future modification.

Operational performance improvement.

Secure and reliable database technology ensures systems are always available.

Above all it is user friendly and simple.

2.3 Feasibility Study

The main objective of the feasibility study is to treat the technical, operational,

logical and economic feasibility of developing the computerized system. All systems are

feasible, given unlimited resources and infinite time. It is both necessary and prudent to

evaluate the feasibility of the project at System study phase itself. The feasibility study to be

conduced for this project involves.

1. Technical Feasibility

2. Operational Feasibility

3. Economic Feasibility

2.3.1 Technical Feasibility



Technical feasibility includes Risk Resources availability and technologies. The

management provides latest hardware and software facilities for the successful completion of

the projects. With these latest hardware and software support the system will perform

extremely well. The system is available through Internet.

2.3.2 Operational Feasibility

In the existing manual system it is very difficult to maintain and update huge

amount of information. The development of the system was started because of the

requirement put forward by the management. This system, will handles the request in a better

way and make the process easier thus, it is sure that the system developed is operationally

feasible.

2.3.3 Economic Feasibility

In the economic feasibility the development cost of the system is evaluated

weighing it against the ultimate benefit derived from the new system. It is found that the

benefit, from the new system would be more than the cost and time involved in its

development.



CHAPTER 3

ENVIRONMENT

3.1 System Specification

3.1.1 Software Specification

Operating System : 32-bit Operating System

Web Server : Apache Tomcat

Web Browser : Internet Explorer

Front-End Tool : php ,html and mysql

Client side Script : JavaScript

Server side Script : Java Server Pages

Back-End Tool : MS Access 2003

3.1.2 Hardware Specification

Processor : x386/32-bit

RAM : 128 MB or Higher

Hard Disk : 40 GB or higher



3.2 Software Technology Review

3.2.1 Overview of JSP:

JSP is a technology developed by Microsoft to take text scripts in an HTML context

and run them on the Web server to create dynamic and interactive pages. While JSP is

different from HTML, it is usually written as scripts within an HTML document. HTML is a

static document that the Web server displays upon request by the browser. But if the HTML

has JSP scripts embedded within it, the server will run those scripts and then display the

results within the page on the browser.

1 . JSP stands for Java Server Pages

2. JSP is a program that runs inside Apache tomcat

3.2.1.1 Advantages of JSP

1 Vs. Active Server Pages (ASP) - ASP is a similar technology from Microsoft. The

advantages of JSP are twofold. First, the dynamic part is written in Java, not Visual

Basic or other MS-specific language, so it is more powerful and easier to use.

Second, it is portable to other operating systems and Microsoft Web servers.

2 Vs. Pure Servlets - It is more convenient to write (and to modify) regular HTML than

to have a zillion print statements that generate the HTML.

3 Vs. Server-Side - Includes (SSI).SSI is a widely support technology for including

externally defined pieces into a static web page.

4 Vs. JavaScript - JavaScript can generate HTML dynamically on the client. This is the

useful capability, but only handles situations where the dynamic information is based

on the client’s environment. With the exception of cookies, HTTP and form

submission data is not available to JavaScript. And, since it runs on the client,

JavaScript can’t access server-side resources like databases, catalogs, pricing

information, and the like.

5 Vs. Static HTML - Regular HTML, of course, cannot contain dynamic information.

JSP is so easy and convenient that it is quite feasible to augment HTML pages that

only benefit marginally by the insertion of small amounts of dynamic data.



Previously, the cost of using dynamic data would preclude its use in all but the most

valuable instances.

3.2.1.2 JSP Scripting Elements:

JSP scripting elements let we insert Java code into the Servlet that will be generated

from the current JSP page. There are the three forms:

1. Expression of the form <%= expression %> that are evaluated and inserted into

the output.

2. Script lets of the form <% code %> that are inserted into the Servlets services

method, and

3. Declarations of the form < % ! code % > that are inserted into the body of the

Servlets class, outside of any existing methods.

Each of these is described in more detail below.

3.2.1.3 JSP Scriptlets :

JSP script lets let we insert arbitrary code into the servlets method that will be built to

generate the page. Script lets have the following form

<% Java Code %>

Script lets have access to the same automatically defined variables as expressions. So,

for example, if the output is to appear in the resultant page, a variable is used. The characters

“%>” inside a scriptlet, enter “%\>” instead. Finally, note that the XML equivalent of <%

code %> is

<jsp:script let>

Code

</jsp:scriptlet>

3.2.1.4 JSP Declarations

<%! Java Code %> Since declarations do not generate any Output, they are normally used

in conjunction with JSP expressions or script lets .Finally, note that XML equivalent of <%!

Code %> is

<jsp:declaration>



code

</jsp:declaration>

3.2.1.5 JSP Directives:

A JSP directive affects the overall structure of the servlet class. It usually has the

following form:

<%@ directive attribute=”value” %>

However, we can also combine multiple attribute settings for a single directive, as

follows:

<%@ directive attribute1=”value1”

attribute2=”value2”

………..

attribute=”value” %>

3.2.1.6 JSP Environment

Java Server Pages (JSP) allows to take advantage of server-side scripting.

Furthermore, JSP provides an array of objects and components, which manage the interaction

between the browser and the web server. Scripting languages such as VBScript and

JavaScript are used to manipulate these objects.

JSP is not actually a language in itself. Meaning there is no JSP code per se, but

VBScript or JavaScript or whichever scripting language we decide we want to use.

JavaScript is the most widely used language for JSP.

.3.2.1.7 J2EE

The Software Development Kit (SDK) comes mainly in 3 forms:

Java2 Standard Edition (J2SE)

Java2 Mobile Edition (J2ME)

Java2 Enterprise Edition (J2EE)

Java Platform, Enterprise Edition or Java EE is a widely used platform for server

programming in the Java programming language. The Java EE Platform differs from the



Standard Edition (SE) of Java in that it adds additional libraries which provide functionality

to deploy fault-tolerant, distributed, multi-tier, Java software, based largely on modular

components running on an application server.

The J2EE platform uses a distributed multitiered application model for enterprise

applications. Application logic is divided into components according to function, and the

various application components that make up a J2EE application are installed on different

machines depending on the tier in the multitiered J2EE environment to which the application

component belongs.

3.2.2 HTML (Hyper Text Markup Language)

Hypertext Markup Language (HTML), the languages of the World Wide Web

(WWW), allows users to produces Web pages that include text, graphics and pointer to other

Web pages (Hyperlinks).

HTML is not a programming language but it is an application of ISO Standard 8879,

SGML (Standard Generalized Markup Language), but specialized to hypertext and adapted

to the Web. The idea behind Hypertext is that instead of reading text in rigid linear structure,

we can easily jump from one point to another point. We can navigate through the information

based on our interest and preference. A markup language is simply a series of elements, each

delimited with special characters that define how text or other items enclosed within the

elements should be displayed. Hyperlinks are underlined or emphasized works that load to

other documents or some portions of the same document.

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.

3.2.3 JavaScript:



JavaScript is a script-based programming language that was developed by Netscape

Communication Corporation. JavaScript was originally called Live Script and renamed as

JavaScript to indicate its relationship with Java. JavaScript supports the development of both

client and server components of Web-based applications. On the client side, it can be used to

write programs that are executed by a Web browser within the context of a Web page. On the

server side, it can be used to write Web server programs that can process information

submitted by a Web browser and then updates the browser’s display accordingly.

Even though JavaScript supports both client and server Web programming, we prefer

JavaScript at Client side programming since most of the browsers supports it. JavaScript is

almost as easy to learn as HTML, and JavaScript statements can be included in HTML

documents by enclosing the statements between a pair of scripting tags

<SCRIPTS>.. </SCRIPT>.

<SCRIPT LANGUAGE = “JavaScript”>

JavaScript statements

</SCRIPT>

3.2.4 Microsoft Access

Microsoft Access is a powerful program with dozens of features to help with our

information management. Microsoft constantly expands the capabilities of Access for both

new database users and program it includes an amazing array of tools. Access is relational

database. It is a flexible program that works for both simple and complex database project.

It’s also relational database which means lets us define relationship between different type

information. So we can use them together . For this project the version used is Microsoft

Access 2003.

Data in ACCESS is organized in the form tables. With in a table record are arranged

according to a common reference value known as the primary key field . The value in the key

field is different for every record and thus help in uniquely identifying the records . Since a

value one table can replicates across other tables. This relation is implemented through the

concept of foreign key . A foreign key in a table , which links that table database in ACCESS

, has a default extension of MDB. ACCESS also maintains to store the order of records .

Index object thus provides efficient access to data. Similarly, in a table indexes control the



way data is accessed . How ever it does not duplicate the data itself , nor does it changes the

sequence in which data stored in table

FEATURES OF MS -ACCESS

Access is multi featured DBMS that can be used by both beginners and those who

have previous DBMS experience. This section describes some of the key features of Access .

Access is a window based application and therefore has an interface similar to Windows.NT.

Access maintains a single disk file or a database and its entire associate object . However,

Access can create links to data tables in any other DBMS like FoxPro.

The Elements of Access Database

The heart of a database is the information it holds. But there are important elements,

usually referred to as object in Access Database. The kinds of objects in an Access Database

are Tables, Form, Reports, and Queries etc. Tables hold information. Any data we enter into

the Database store in a table. Queries let us ask questions about our data or makes changes to

data. Forms are for viewing and editing information. Pages are HTML files that let us view

access data. Reports are summarizing and data. Macros perform one or more database

actions automatically. The project “Student Bulletin Board Management System” uses the

extreme capabilities of Tables in Access program. The database of this project is very simple

and normalized.

CHAPTER 4



SYSTEM DESIGN

System design involves translating information requirements and conceptual design

into technical specification and general flow of processing. After the project idea is specified,

related information is gathered and a way to evolve the system is developed. The process

starts with a study of the outputs required of the system, the inputs given, the data that is to

be stored, how to store the data, the data structured for storage.

4.1 Input Design

Input design is the method by which valid data are accepted from the user. This part of the

designing requires very careful attention. If the data going into the system is incorrect then

the processing and output will magnify these errors. Inaccurate input data are the most

common cause of errors in data processing.Input design consists of the following processes:-

Designing graphical user entry screen are easy to use.Designing procedures and functions to

valid the data as per business rules.Designing functions needed to store data into a usable

form for processing.Designing the common integrated functions that can be used by all other

users when needed.

4.1.1 Input Objectives

Controlling Amount of Input: Wherever user input is required, giving possible input values

as default in that area reduces the amount of user keystrokes. Thus the user can pass on to

next data without much typing. This makes the data entry much fast and error free. When the

user has the format of input to be given,it will be very easy for the user to give input in the

same format.

Avoiding Delay: A processing delay resulting from data entry operations is called a

bottleneck. Such bottlenecks are made obsolete in this project by breaking up the amount of

data to be entered in each form into different smaller and simpler forms.

Avoiding Errors in Data: The rate at which errors occur depends on the quantity of the data.

As told in the above objective these errors are reduced by making the number of data to be

entered in each form is reduced.

Avoiding Extra Steps: To fulfill any operation the user have no need to do complex steps,

instead any operation can be done with simple easy to use steps.



4.2 Output design

Output design is one of the most important feature of the information system. When the

output is not of good quality, the users will be averse to use the newly designed system and

may not use the system. There are many types of outputs, all of which can be either highly

useful or can be critical to the users, depending on the manner and degree to which they are

used.

Outputs from computer system are required primarily to communicate the results of

processing to users. They are also used to provide a permanent hard copy of the results for

later consultation.

4.2.1 Output Objectives

The output from an information system should accomplish one or more of the following

objectives:

Convey information about past activities, current status, or projections of the future.

Signal important events, opportunities, problems or warnings

Trigger an action

Confirm an action

The output design of this project is made with objectives in mind.

4.3 Data Flow Diagram

Data Flow Diagram (DFD) representing a system at any level of detail with a graphic

network of symbols showing data flows, data stores, data processes, and data sources. The

purpose of DFD is to provide a semantic bridge between users and system developers. The

diagram is the basis of structured system analysis.

A level 0 DFD, also called a fundamental system model or a context model represents the

entire software elements as a single bubble with input and output indicated by incoming and

outgoing arrows respectively. Additional process and information flow parts are represented

in the next level i.e., Level 1 DFD. Each of the processes represented at Level 1 are sub

functions of overall system depicted in the context model. Any processes, which are complex

in Level 1, will be further represented into sub functions in the next level, i.e., in level 2.

Data flow diagrams illustrate how data is processed by a system in terms of inputs, and

outputs. Represent major components or functions with Circles.Actions for input by a user or



a system go in Rectangular Boxes.Databases are represented by Parallel lines enclosing a

phrase corner.

4.3.1 DataFlow Diagram – The Rules

1. External Entities

External entities are objects outside the system, with which the system communicates.

External entities are sources and destinations of the system’s inputs and outputs.

2. Processes

When naming processes, avoid glossing over them, without really

understanding their role. Indications that this has been done are the use of vague terms in the

descriptive title area like ‘process’ or ‘update’. The most important thing is that the

description must be meaningful to whoever will be using the diagram.

3. Data Flows

Double-headed arrows can be used (to show two-way flows) on all but bottom

level diagrams. Furthermore, in common with most of the other symbols used, a data flow at

a particular level of a diagram may be decomposed to multiple data flows at lower levels.

4. Data Store

Data store represent stores of data within the systems and are represented by

open rectangle.Data Flows represent the movements of data between other components and

are shown by arrows.

Rectangular box defined a source of destination of the system

A circle stands for processes that converts data into information



Data Flow

An open rectangle is a data store

4.4 Analysis Tools

System analysis is the process of collecting and interpreting facts, understanding problems

and using the information to suggest improvements on the system. This will help to

understand the existing system and determine how computers make its operation more

effective.

4.4.1. Use Case Diagram

In software engineering, a use case diagram in the Unified Modeling Language (UML) is a

type of behavioral diagram defined by and created from a Use-case analysis. Its purpose is to

present a graphical overview of the functionality provided by a system in terms of actors,

their goals, and any dependencies between those use cases.

The main purpose of a use case diagram is to show what system functions are performed for

which actor. Roles of the actors in the system can be depicted. The use case diagram shows

the position or context of the use case among other use cases. As an organizing mechanism, a

set of consistent, coherent use cases promotes a useful picture of system behavior, a common

understanding between the customer/owner/user and the development team.


Administrator

Login

Student RegistrationApproval

Faculty Registration

News Approval

View NewsApproval

Notes Approval

View Notes

View Faculties

View Students


www.engineeringminiprojects.com

Fig 4.4.1.1 Use Case Diagram for Administrator

15

Login

Faculty

Add News

Add Notes

View News

View Notes



Fig 4.4.1.2 Use Case Diagram for Faculties

16

Login

Student

Add News

Add Notes

View News

View Notes

Change Password

Fig 4.4.1.3 Use Case Diagram for Students



Admin/Faculty/Student

Student Bulletin Board Management SystemAdmin/Faculty/Student

Login name

Password

Response

Fig 4.3.1 Context Level (Level 0)


DATAFLOW DIAGRAMS


student

Add questions And

answers

View notes

Add news

login

Newstab3

Notes1

View news

notesdetails

notesdteailsnewsdetails

username

newsdetails

password

select

newsid

select

notesid

Fig 4.3.2 Level 1 DFD for Student



Fig 4.3.3 Level 1 DFD for Faculty

faculty

Add questions And

answers

View notes

Add news

login

Newstab3

Level 1.2

Notes1

View news

notesdetails

notesdteailsnewsdetails

newsdetails

username

password

select

newsid

notesid

seletct



1.0Student Registration

Login

6.0 News Approval

4454.05.0

Notes Approval

regi

Newstab3

Notes1

faculty details

Student

details

News details

notes details

faculty 1

4.0View Faculties

2.0View Students

Student

details

faculty details

3.0FacultyRegistration

username

password

Student info

seletct

Faculty info

seletct

Accept/reject

Accept/reject



Fig 4.3.4 Level 1 DFD for Administrator

Administrator

21

Admin

2.1Accept/reject

Faculty14.1Update/delete

facultydetails

5.1Accept/reject

6.1Accept/reject

regi

Notes1

Newstab33

notesdetails

newsdetails

studentdetails

Update/delete

Accept/reject

Accept/reject

Accept/reject

Fig 4.3.5 Level 2 DFD for Administrator


.



4.5Database Design

The database design is a logical development in the methods used by the computers

to access and manipulate data stored in the various parts of the computer systems. Database

is defined as an integrated collection of data. The overall objective in the development of

database technology has been to treat data as an organizational resource and as an integrated

whole. The main objectives of databases are data integrity and data independence.

A database is a collection of interrelated data stored with minimum redundancy to

serve many users quickly and effectively. The database serves as the repository of data, so a

well-designed database can lead to a better program structure and reduce procedural

complexity. In a database environment, common data are available and used by several

users.

Database Management System(DBMS) allow the data to be protected and

organized separately from other resources like hardware, software, and programs. DBMS is a

software package, which contains components that are not found other data management

packages. The significant of DBMS is the separation of data as seen by the programs and

data as stored on the direct access storage devices. That is the difference between the logical

and physical data.

The main objectives covered in database design are:

Controlled redundancy

Data independence

Accuracy and integrity

Privacy and security

Performance

The database tables used in this project are given below



Table 4.5.1 admin

Description: It stores Admin information

FieldName Type Size Description Constraints

Name Text 15 Administrator

Name

Primary Key

Pas Text 10 Password Not Null

Table 4.5.2faculty1

Description: It stores faculty information


Facultyname Text 15 Name of faculty NotNull

Facultyid Text 15 faculty Id Primary Key

Subject Text 15 Subject of the

faculty

NotNull

Password Text 10 Password Not null

]

Table 4.5.3note1



Description: It stores Notes information


Question Text 25 Questions NotNull

Answer Text 25 Answers NotNull

Subject Text 15 Subject of the

Qustions

NotNull

Name1 Text 15 Name NotNull

Id1 Number 15 Notes id Primary key

Status Yes/No Status flag Not null

Table 4.5.4regi

Description: It stores Student information




Name Text 15 Name of student NotNull

Username Text 15 Username of the

student

Primary key

Password Text 10 Password of the

student

Not Null

Adnumber Number 5 Admission

number of the

student

Not Null

Emailed Text 50 Emailid

Status Yes/No Status flg Not null

Table 4.5.5newstab3

Description: It stores News information




News Text 25 News NotNull

Name Text 15 Name of the

student or faculty

NotNull

Head Text 15 News heading NotNull

Id Number 5 News id Primary key

Status Yes/No Status flag Not null

CHAPTER 6

CONCLUSION

The project was successfully completed within the time span allotted. Every effort

has been made to present the system in more user – friendly manner. All the activities



provide a feeling like an easy walk over to the user who is interfacing with the system. A

trial run of the system has been made and is giving good results.

The software has been developed in JSP. All the modules are tested separately and

put together to form the main system the system has been developed in an attractive dialogs

fashion. So user with minimum knowledge about the computers can operate the system

easily. By using this software the user and administrator are able to communicate in a faster

and better way and will be more secure so that the system is developed in an efficient manner

from unauthorized access.

APPENDIX-A- SCREEN SHOTS



Figure A.1.Login screen



FigureA.2.student registration



Figure A.3.Student homepage



FigureA.4.News registration



Figure A. 5.News details view form



Figure A.6.Changing password



Figure A.7.Administrator home page



Figure A.8. Faculty Registration



Figure A.9. Registration Approval Form



Figure A.10. Faculty Updation Form



Figure A.11. Faculty Home

APPENDIX B – Sample Code



/Source code of login page

<%@page import="java.sql.*" %><%@page import="java.io.*" %><%@page import="java.util.*" %><%try{String uname,pword,typ,s="student",f="faculty",ad="administrator";

String name = request.getParameter( "username" );String pword1=request.getParameter("password");

uname=request.getParameter("username");pword=request.getParameter("password");typ=request.getParameter("type");String sta="accept";Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connection con=DriverManager.getConnection("jdbc:odbc:hh"," "," ");Statement st=con.createStatement();

if(typ.equals("student")){ResultSet rs=st.executeQuery("SELECT Username,Password,status FROM regi WHERE Username='" + uname +"' AND Password='" + pword +"' AND status= '"+sta+"' " );

while(rs.next()){session.setAttribute( "theName", name );session.setAttribute("pw",pword1);response.sendRedirect("studhome1.jsp");}response.sendRedirect("welcome1.jsp");}else if(typ.equals("faculty")){

ResultSet rs=st.executeQuery("SELECT Facultyid,Password FROM faculty1 WHERE Facultyid='" + uname +"' AND Password='" + pword +"'" );

while(rs.next()){session.setAttribute( "theName", name );response.sendRedirect("fachome.jsp");



}response.sendRedirect("welcome1.jsp");}else if(typ.equals("administrator")){

ResultSet rs=st.executeQuery("SELECT Adminname,Password FROM admin WHERE Adminname='" + uname +"' AND Password='" + pword +"'" );

while(rs.next()){session.setAttribute( "theName", name );session.setAttribute("pw",pword1);response.sendRedirect("adminhome.jsp");}response.sendRedirect("welcome1.jsp");}else{response.sendRedirect("welcome1.jsp");}

st.close();con.close();

}

catch(Exception e){out.println(""+e);}

%>Source code for add new student

<%@page import="java.sql.*" %><%try{

String username=null;username=request.getParameter("username");String sta="accept",sta1="reject";

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");



Connection con=DriverManager.getConnection("jdbc:odbc:hh"," "," ");

Statement st=con.createStatement();String qStr="update regi set status='accept' where username='"+username+"'";

st.executeUpdate(qStr);st.close();con.close();response.sendRedirect("acceptreg.jsp");}


%>Source code for insert news

<%try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");


Statement st=con.createStatement();ResultSet rs = null;

rs = st.executeQuery("SELECT news,status,name"+ " FROM newstab3 where status='register'");

// Loop through the result set printing each line

out.println("<table border=1>");

while (rs.next()) {String ne = rs.getString(1);String stat = rs.getString(2);String na= rs.getString(3);%><tr>



<td><%=ne%><td><%=stat%><td><%=na%><td><a href='accept2.jsp?news=<%=ne%>'>Accept</a><td><a href='reject2.jsp?news=<%=ne%>'>Reject</a></tr>

<%

}}catch(Exception e){out.println(""+e);}

%><%@page import="java.sql.*" %><%try{

String news1=null;news1=request.getParameter("news");String sta="accept",sta1="reject";



Statement st=con.createStatement();String qStr="update newstab3 set status='accept' where news='"+news1+"'";

st.executeUpdate(qStr);st.close();con.close();response.sendRedirect("acceptnews.jsp");}




%><%@page import="java.sql.*" %><%try{

String username=null;username=request.getParameter("news");String sta="accept",sta1="reject";



Statement st=con.createStatement();String qStr="update newstab3 set status='reject' where news='"+username+"'";

st.executeUpdate(qStr);st.close();con.close();response.sendRedirect("acceptnews.jsp");}


%>

Source code for view news

<%try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");



rs = st.executeQuery("SELECT news,status,name,head"+ " FROM newstab3 where status='accept' ");//where status='accept'




out.println("<table border=1>");%><td><h2>Headding</h2><td><h2>News</h2><td><h2>Name</h2><%

while (rs.next()) {String ne = rs.getString(1);String stat = rs.getString(2);String na = rs.getString(3);String he = rs.getString(4);%><tr><td><%=he%><td><%=ne%><td><%=na%>

</tr>

<%


%>

Source code for view notes<%try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");



rs = st.executeQuery(



"SELECT question,answer,name1"+ " FROM note1 where status='accept' ");//where status='accept'


out.println("<table border=4>");%><tr>

<td><h2>Question</h2><td><h2>Answer</h2><td><h2>Name</h2>

</tr><%

while (rs.next()) {String ne = rs.getString(1);String stat = rs.getString(2);String na = rs.getString(3);%>

<tr>

<td><%=ne%><td><%=stat %><td><%=na%>

</tr>

<%


%>

Source code for change password

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



<%try{

String np;np=request.getParameter("new");String re=request.getParameter("rep");String s=request.getParameter("old");String una=""+session.getAttribute("theName");String p=""+session.getAttribute("pw");Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");


Statement st=con.createStatement();// out.println(fn1);

ResultSet rs=null;rs=st.executeQuery("select Password from admin");while(rs.next())p=rs.getString(1);

if(np.equals(re)){if(p.equals(s)){String qStr="update admin set Password='"+np+"' where Adminname='"+ una +"'";st.executeUpdate(qStr);}elseresponse.sendRedirect("change4.jsp");

}elseresponse.sendRedirect("change4.jsp");st.close();con.close();response.sendRedirect("adminhome.jsp");}


%>

REFERENCE



1. Elias M Awad ,System Analysis and Design ,TataMcgrawHill,Second Edition ,Year 2000.

2. Roger S Pressman, Software Egineering ,TataMcgrawHill, Fifth Edition ,Year 2004.

3. Phil Hanna -JSP 2.0 The Complete Reference TataMcgrawHill Edition

4. Herbert Schildt -JAVA2 The Complete Reference - Fifth Edition


· web view1. introduction. 1.1 . an. o. verview. the project entitled “student bulletin board...

Documents