[ASK] JSTL | KASKUS

Beranda

...

Programmer Forum
[ASK] JSTL

Out-Blaze

04-11-2013 23:06

[ASK] JSTL

permisi gan ane mau nanya, udah mentok banget nih nyari google gak ketemu" emoticon-Mewek

ane baru pemula banget ini belajar JSTL dan JSP, nah ane mau ngambil hasil select dari mysql lewat servlet dan ane tampilin di jspnya, ane cari" di google si dia masukkin dalam class dan di JSPnya dia make JSTL buat ngelooping classnya, tapi di ane malah error, ini kodingannya gan

Spoiler for "userList.jsp":

Code:

<%@ page contentType="text/html; charset=utf-8" language="java" import="java.util.*" errorPage="" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>



<html lang="en" >

 <!-- include header file -->

 <%@ include file = "template-page/tempHeader.jsp" %>

 

 <body>

 <%@ include file = "template-page/tempNavLogin.jsp" %>

 

 <div class="container">

 <div class="row">

 <br><br><br><br>

 <h2 style="text-align:center">User List Eterpad</h2>

 <table align="center" class="table table-hover" style="width:80%">

 <thead>

 <tr>

 <th style="text-align:center; width:8%">No</th>

 <th style="text-align:center">Username</th>

 <th style="text-align:center; width:10%">Action</th>

 </tr>

 </thead>

 <tbody>

 <c:forEach items="${users}" var="user">

 <tr>

 <td style="text-align:center"> 1 </td>

 <td style="text-align:left">${user.getUsername()}</td>

 <td style="text-align:center"><a href="DeleteUser?id=${i}" class="btn btn-danger">Delete</a></td>

 </tr>

 </c:forEach>

 </tbody>

 </table>

 </div>

 </div>

 </body>

</html>

Spoiler for UserList.java:

Code:

package controller.user_management;



import java.io.*;

import java.util.*;

import javax.servlet.*;

import javax.servlet.http.*;

import java.sql.*;

import java.text.*;



class User

{

 private String username;

 private int userid;

 private int roleid;

 

 public void setUsername(String user) { username = user; }

 public void setUserid(int id) { userid = id; }

 public void setRoleid(int id) { roleid = id; }

 

 public String getUsername() { return username; }

 public int getUserid() { return userid; }

 public int getRoleid() { return roleid; }

}



public class UserList extends HttpServlet

{

 @Override

 public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException

 {

 doPost(request, response);

 }

 

 @Override

 public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException

 {

 ArrayList<User> users = new ArrayList<User>();

 PrintWriter out = response.getWriter();

 

 String Driver = "com.mysql.jdbc.Driver";

 String db = "jdbc:mysql://localhost/eterped";

 

 try {

 Class.forName(Driver);



 Connection conn = DriverManager.getConnection(db, "root", "");



 Statement stmt = conn.createStatement();

 String sql = "SELECT username, role, a.roleid as roleid, userid FROM users a JOIN roles b ON a.roleid = b.roleid";

 ResultSet rs = stmt.executeQuery(sql);

 

 while (rs.next()) {

 User u = new User();

 u.setUsername(rs.getString("username"));

 u.setUserid(rs.getInt("roleid"));

 u.setRoleid(rs.getInt("userid"));

 String role = rs.getString("role");

 if (!role.equals("admin")) {

 out.println(u.getUsername());

 users.add(u);

 }

 }

 

 stmt.close();

 

 } catch (Exception e) {

 out.println(e);

 }

 

 for (Iterator<String> i = users.iterator(); i.hasNext(); ) {

 String item = i.next();

 out.println(item);

 }

 request.setAttribute("users", users);

 getServletContext().getRequestDispatcher("/userList.jsp").forward(request, response);

 }

}

Spoiler for error:

Code:

type Exception report



message javax.el.MethodNotFoundException: Unable to find method [getUsername] with [0] parameters



description The server encountered an internal error (javax.el.MethodNotFoundException: Unable to find method [getUsername] with [0] parameters) that prevented it from fulfilling this request.



exception



org.apache.jasper.JasperException: javax.el.MethodNotFoundException: Unable to find method [getUsername] with [0] parameters

 org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:549)

 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)

 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)

 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)

 javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

 controller.user_management.UserList.doPost(UserList.java:70)

 controller.user_management.UserList.doGet(UserList.java:30)

 javax.servlet.http.HttpServlet.service(HttpServlet.java:621)

 javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

root cause



javax.el.MethodNotFoundException: Unable to find method [getUsername] with [0] parameters

 javax.el.BeanELResolver.invoke(BeanELResolver.java:444)

 javax.el.CompositeELResolver.invoke(CompositeELResolver.java:161)

 org.apache.el.parser.AstValue.getValue(AstValue.java:159)

 org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:189)

 org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:985)

 org.apache.jsp.userList_jsp._jspx_meth_c_005fforEach_005f0(userList_jsp.java:191)

 org.apache.jsp.userList_jsp._jspService(userList_jsp.java:148)

 org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

 javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)

 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)

 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)

 javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

 controller.user_management.UserList.doPost(UserList.java:70)

 controller.user_management.UserList.doGet(UserList.java:30)

 javax.servlet.http.HttpServlet.service(HttpServlet.java:621)

 javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

mohon bantuannya gan emoticon-Big Grin

, apa ada metode lain buat nampilin query dari servletnya selain cara itu?

869

Kutip

Balasan

Komentar yang asik ya

Mari bergabung, dapatkan informasi dan teman baru!

Programmer Forum

20.3KThread•5.1KAnggota

Urutkan

Terlama

Komentar yang asik ya