<ora:sqlQuery id="equiposLog" dataSource="jdbc/mysql2" scope="request">
SELECT nombre FROM usuario
WHERE user = ? and password = ?
<ora:sqlStringValue param="usuario" />
<ora:sqlStringValue param="password" />
As you can see the first program(login.jsp) is asking user and password.
The second program(validate.jsp) tries to find this data in a Database. If positive, the control will go to mainmenu.html otherwise will return to login.jsp.
I am using Tomcat 6 as a container and MySQL as Database.
I am stucked at this point and any help would be very welcome.
Tapas, is very correct. You are writing JSPs as if it were still 2001. In 2015 JSPs should be written using the JSTL (JSP Standard Tag Library) and the EL (Expression Language). Please make sure your study materials are up to data and cover theses topics rather than putting Java code into JSPs.
I also recommend novices to JSP read the following: