Multiple markers at this line error in eclipse

How to solve "Multiple markers at this line" error  in eclipse

Steps 

1) Right click on your Project->Properties->JavaScript->Include Path->Source

type in box     **/jquery*.js
             

What is a Stored Procedure?

What is a Stored Procedure?

                A stored procedure  is a named in PL/SQL block which performs one or more specific task. This is similar to a procedure in other programming languages.           

          We can pass parameters to procedures in three ways.
          1) IN-parameters
          2) OUT-parameters
          3) IN OUT-parameters

A procedure may or may not return any value.

 ***************************************************

Simple Syntax to create a procedure is:

  DELIMITER $$

DROP PROCEDURE IF EXISTS `lib`.`ProNew` $$
CREATE PROCEDURE `lib`.`ProNew` ()
BEGIN

END $$

DELIMITER ;

 **********************************************

Standard Syntax to create a procedure is: 

CREATE [OR REPLACE] PROCEDURE proc_name [list of parameters] 

IS    

   Declaration section 

BEGIN    

   Execution section 

EXCEPTION    

  Exception section 

END; 

******************************************** 

Real Structure of  Procedure Given Below

First create table Class_Master

DROP TABLE IF EXISTS `lib123`.`class_master`;
CREATE TABLE  `lib123`.`class_master` (
  `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `ShortName` varchar(10) NOT NULL,
  `Course` varchar(30) CHARACTER SET utf8 NOT NULL,
  `Year` varchar(10) DEFAULT NULL,
  `DIVN` varchar(10) DEFAULT NULL,
  `Subject` varchar(20) CHARACTER SET utf8 NOT NULL,
  `IsDeleted` bit(1) NOT NULL DEFAULT b'0',
  `AddedBy` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000',
  `AddedDateTime` datetime DEFAULT NULL,
  `UpdatedBy` int(10) unsigned zerofill NOT NULL DEFAULT '0000000000',
  `UpdatedDateTime` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Then Create Procedure

DELIMITER $$

DROP PROCEDURE IF EXISTS `Sp_Class_Master_SAVE` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Sp_Class_Master_SAVE`(
  out Param_return tinyint,
  inout Param_Id smallint(5),
  in Param_ShortName varchar(10) ,
  in Param_Course varchar(30) ,
  in Param_Year varchar(10) ,
  in Param_DIVN varchar(10) ,
  in Param_Subject varchar(20),
  in Param_IsDeleted bit,
  in Param_AddedBy int(10),
  in Param_AddedDateTime datetime,
  in Param_UpdatedBy int(10),
  in Param_UpdatedDateTime datetime
)
BEGIN
if exists(select Id from class_master where Id!=Param_Id and
ShortName like Param_ShortName) then
     set Param_Return=0;
    else
      if(Param_Id>0) then
      update class_master
      set  Id=Param_Id
,ShortName=Param_ShortName,Course=Param_Course,

Year=Param_Year,DIVN=Param_DIVN,Subject=Param_Subject,

IsDeleted=Param_IsDeleted,AddedBy=Param_AddedBy,

AddedDateTime=Param_AddedDateTime,

UpdateBy=Param_UpdatedBy,UpdateDateTime=Param_UpdatedDateTime
           where Id=Param_Id;
           set Param_Return=2;
    else
     Insert into class_master(Id,ShortName,Course,Year,DIVN,Subject,IsDeleted,AddedBy,

AddedDateTime,UpdatedBy,UpdatedDateTime) VALUES
(Param_Id,Param_ShortName,Param_Course,Param_Year,Param_DIVN,

Param_Subject,Param_IsDeleted,
  Param_AddedBy,Param_AddedDateTime,Param_UpdatedBy,Param_UpdatedDateTime);
      SET Param_Return = 1;
      SET Param_Id = LAST_INSERT_ID();
    END IF;
  END IF;
END $$

DELIMITER ;

What is Prototype in Software Life Cycle?

  What is Prototype in Software Life Cycle?

                The Prototyping Model is a systems development method (SDM) in which a prototype (an early approximation of a final system or product) is built, tested, and then reworked as necessary until an acceptable prototype is finally achieved from which the complete system or product can now be developed. This  model works best in scenarios where not all of the project requirements are known in detail ahead of time. It is an iterative , trial-and-error process that takes place between the developers and the users.


There are several steps in the Prototyping Model: 

1. The new system requirements are defined in as much detail as possible. This usually involves interviewing a number of users representing all the departments or aspects of the existing system.
2. A preliminary design is created for the new system.
3. A first prototype of the new system is constructed from the preliminary design. This is usually a scaled-down system, and represents an approximation of the characteristics of the final product.
4. The users thoroughly evaluate the first prototype, noting its strengths and weaknesses, what needs to be added, and what should to be removed. The developer collects and analyzes the remarks from the users.
5. The first prototype is modified, based on the comments supplied by the users, and a second prototype of the new system is constructed.
6. The second prototype is evaluated in the same manner as was the first prototype.
7. The preceding steps are iterated as many times as necessary, until the users are satisfied that the prototype represents the final product desired.
8. The final system is constructed, based on the final prototype.
9. The final system is thoroughly evaluated and tested. Routine maintenance is carried out on a continuing basis to prevent large-scale failures and to minimize downtime.