3 Replies Latest reply: Oct 11, 2011 8:33 AM by 889091 RSS

    How to make the JSTL access my database and some syntax question.


      I've been trying and trying to make my jstl work but still not working.

      Have added the resource references in tomcat.

      jdbc/WebApplication1     javax.sql.DataSource     Container     Shareable     database for WebApplication1

      Not sure what other things I must do in order for my jsp page to display a table using jstl.

      Hope some one can share with me.

      <jsp:useBean id="Tutors" scope="session" class="databaseAccess.TutorsBean"/>
      <jsp:setProperty name ="Tutors" property="*"/>
      <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
      <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
      <%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
      <%@ taglib prefix="x" uri="http://java.sun.com/jsp/jstl/xml" %>

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

      <sql:setDataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://
      localhost:3306/pract1" user="root" password="123"/>

      <sql:query var="tutors" maxRows="5">
      Select *, GROUP_CONCAT(subject.subjectName SEPARATOR \", \") AS Subj from tutors LEFT JOIN subinter ON subinter.tutorsID = tutors.id LEFT JOIN subject ON subinter.subjectID = subject.id GROUP BY tutors.id");


      In MySQL I have created 3 tables by the name of tutors, subject and subinter

      But, netbean IDE gave me an error on <sql:query var="tutors" maxRows="5">

      So, hope someone can advise me where have I gone wrong with the syntax or what?