Guest User

Untitled

a guest
Aug 19th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.02 KB | None | 0 0
  1. public class Book {
  2. private int idbook;
  3. private String name;
  4. private int type_idtype;
  5.  
  6.  
  7.  
  8. public int getIdbook() {
  9. return idbook;
  10. }
  11.  
  12. public void setIdbook(int idbook) {
  13. this.idbook = idbook;
  14. }
  15.  
  16. public String getName() {
  17. return name;
  18. }
  19.  
  20. public void setName(String name) {
  21. this.name = name;
  22. }
  23. public int getType_idtype() {
  24. return type_idtype;
  25. }
  26.  
  27. public void setType_idtype(int type_idtype) {
  28. this.type_idtype = type_idtype;
  29. }
  30. }
  31.  
  32. public class Type {
  33. private int idtype;
  34. private String typename;
  35.  
  36. public int getIdtype() {
  37. return idtype;
  38. }
  39.  
  40. public void setIdtype(int idtype) {
  41. this.idtype = idtype;
  42. }
  43.  
  44. public String getTypename() {
  45. return typename;
  46. }
  47.  
  48. public void setTypename(String typename) {
  49. this.typename = typename;
  50. }
  51.  
  52. }
  53.  
  54. Statement stmt;
  55. stmt = conn.createStatement();
  56.  
  57. String sql = "SELECT book.name, type.typename from book Join type
  58. on type.idtype=book.type_idtype";
  59.  
  60.  
  61.  
  62. ResultSet rs = stmt.executeQuery(sql);
  63. Book b;
  64. Type t;
  65. List<Book> list = new ArrayList<Book>();
  66.  
  67.  
  68. while(rs.next())
  69. {
  70. int count = rs.getRow();
  71. b= new Book();
  72. t=new Type();
  73. b.setName(rs.getString("name"));
  74. t.setTypename(rs.getString("typename"));
  75. list.add(b);
  76.  
  77. }
  78.  
  79. request.getSession().setAttribute("list", list);
  80.  
  81. response.sendRedirect("booksjsp.jsp");
  82. stmt.close();
  83. conn.close();
  84.  
  85. <% List list = (List)session.getAttribute("list"); %>
  86.  
  87. <table border="1">
  88.  
  89. <tr>
  90.  
  91. <th>Name</th>
  92. <th>Name</th>
  93.  
  94.  
  95. </tr>
  96. <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
  97. <c:forEach items="${list}" var="element">
  98. <tr>
  99. <td>${element.name}</td>
  100. <td>${element.typename}</td>
  101. </tr>
  102. </c:forEach>
  103.  
  104. </table>
Add Comment
Please, Sign In to add comment