Database Setup

1. Database Setup

2. SQL Query 결과

3. Product table data 추가

4. 다운로드...

5. Run SQL button

6. 결과

7. New File: JDBC resource

8. !

10. !

11. 암호

12. glassfish-resources.xml

13. glassfish-resources.xml

14. Deploy !

15. Add Reference to web.xml

16. Add Reference to glassfish-web.xml

17. Create jsp to test data source

18. Palette Window: [ctrl + shift] + 8

20. JSTL Java Server Pages Standard Tag Library JSTL directives:

23. Context Parameters • web deployment descriptor (web.xml)안에 name-value 정의합니다:

25. 확인 In index.jsp:

26. JSP Expression Language • JSP EL • initParam은 EL 정의됀 객체 입니다 • EL 경계 기호:${....}

27. 결과

28. Db Query in index.jsp

29. 변수 categories

30. 변수 categories categories 변수는 javax.servlet.jsp.jstl.sql.Resultinterface를 구현합니다

31. JSTL forEach

33. javax.servlet.jsp.jstl.sql.Result ${categories.rows} is the same as categories.getRows();

34. JAVA EL isLimitedByMaxRows() isLimitedByMaxRows() ${limitedByMaxRows} limitedByMaxRows LimitedByMaxRows() limitedByMaxRows() LimitedByMaxRows() limitedByMaxRows()

37. category.jsp

39. category.jsp • Retrieve data using JSTL sql library • Display data using JSTL core library and Expression Language (EL)

40. Db Query

42. pageContext은? • implicit Object • pageContext.requestHttpServletRequest객체 입니다 • pageContext.request.queryString:request.getQueryString() 메소드를 호출합니다

43. Request Path Elements http://www.bob.com/NiceDoggy/category?id=1 context path request.getContextPath() servlet path request.getServletPath() pathInfo request.getPathInfo()

44. Request Path Elements http://www.bob.com/NiceDoggy/category?3 request.getContextPath() /NiceDoggy request.getServletPath() /category request.getPathInfo() ?3 request.getQueryString() 3

45. Request Path Elements http://www.bob.com/NiceDoggy/category?3 request.getContextPath() ${pageContext.request.contextPath} request.getServletPath() ${pageContext.request.servletPath} request.getPathInfo() ${pageContext.request.pathInfo} request.getQueryString() ${pageContext.request.queryString}

47. 2ndDb Query API:

49. 3rdDb Query