Advertisement
Guest User

Untitled

a guest
Apr 7th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.95 KB | None | 0 0
  1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  2. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
  3. <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
  4. <html>
  5. <head>
  6. <title>Hello, SQL!</title>
  7. </head>
  8. <body>
  9. <sql:setDataSource var="dataSource" driver="com.mysql.jdbc.Driver"
  10. url="jdbc:postgresql://localhost/some_database"
  11. user="username" password="password"/>
  12.  
  13. <sql:query dataSource="${dataSource}" var="resultSet">
  14. select id, name from some_table;
  15. </sql:query>
  16.  
  17. <select>
  18. <c:forEach var="row" items="${resultSet.rows}">
  19. <option value="${row.id}">${row.name}</option>
  20. </c:forEach>
  21. </select>
  22. </body>
  23. </html>
  24.  
  25. package com.example;
  26.  
  27. public class OptionsBean implements Serializable {
  28. private static final String SQL_QUERY = "select name from some_table;";
  29. private List<String> options;
  30.  
  31. public OptionsBean() {
  32. options = new ArrayList<>();
  33. try (Connection conn = DriverManager.getConnection("jdbc:postgresql://localhost/some_database","username","password")) {
  34. Statement stmt = conn.createStatement();
  35. ResultSet rs = stmt.executeQuery(SQL_QUERY);
  36. while (rs.next()) {
  37. options.add(rs.getString("name"));
  38. }
  39. }
  40. } catch (SQLException e) {
  41. e.printStackTrace();
  42. }
  43. }
  44.  
  45. public String getOptions(){
  46. return options;
  47. }
  48. }
  49.  
  50. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  51. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
  52. <html>
  53. <head>
  54. <title>Hello, SQL!</title>
  55. </head>
  56. <body>
  57. <jsp:useBean id="optionsBean" class="com.example.OptionsBean" />
  58.  
  59. <select>
  60. <c:forEach var="option" items="${optionsBean.options}">
  61. <option>${option}</option>
  62. </c:forEach>
  63. </select>
  64. </body>
  65. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement