Setting up MySQL Database and Tables

CREATE TABLE `tutorials` (

INSERT INTO `tutorials` VALUES (2, 'JSP Tutorial', 'Java Server Pages or JSP for short is Sun''s solution for developing dynamic web sites. JSP provide excellent server side scripting support for creating database driven web applications.', 'http://www.roseindia.net/jsp/jsp.shtml');

INSERT INTO `tutorials` VALUES (3, 'Struts Tutorials - Jakarta Struts Tutorial', 'This complete reference of Jakarta Struts shows you how to develop Struts applications using ant and deploy on the JBoss Application Server. Ant script is provided with the example code. Many advance topics like Tiles, Struts Validation Framework, Ja', 'http://www.roseindia.net/struts/index.shtml');

INSERT INTO `tutorials` VALUES (4, 'The Complete Spring Tutorial', 'Spring is grate framework for development of Enterprise grade applications. Spring is a light-weight framework for the development of enterprise-ready applications. Spring can be used to configure declarative transaction management, remote access to', 'http://www.roseindia.net/spring/index.shtml');

INSERT INTO `tutorials` VALUES (5, 'Java Server Faces (JSF) Tutorial', 'JavaServer Faces or JSF is grate technology for the development of user interfaces for web applications. The Java Server Faces specification is defined by JSR 127 of the Java Community Process.', 'http://www.roseindia.net/jsf/');

INSERT INTO `tutorials` VALUES (6, 'Jboss 3.0 Tutorial', ' This lesson shows you how to build you web application and install on the Jboss 3.0 application server. After the completion of this lesson you will be able to compile, assemble and deploy your J2EE application on Jboss 3.0 application server.', 'http://www.roseindia.net/jboss/index.shtml');