java - Spring MVC display data from database -
i trying display data database, getting error
loginsuccess.java
package java4s; import java.util.list; import javax.servlet.http.httpsession; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.annotation.scope; import org.springframework.stereotype.controller; import org.springframework.ui.modelmap; import org.springframework.web.bind.annotation.modelattribute; import org.springframework.web.bind.annotation.requestmapping; import org.springframework.web.bind.annotation.requestmethod; import org.springframework.web.servlet.modelandview; import java4s.employeeservice; @controller @scope("session") public class loginsuccesscontroller { @autowired employeeservice emp_service; @requestmapping(value = "/login", method=requestmethod.post) public modelandview loginvalidateform(modelmap model, @modelattribute("loginform") employee employee, httpsession session) { if(emp_service.validatelogin(employee.getusername(), employee.getpassword())) { list<employee> user_info = emp_service.getuserinfo(employee.getusername()); session.setattribute("session_username", employee.getusername()); //add value session variable model.addattribute("result", "login success"); model.addattribute("user_info", user_info); } else model.addattribute("result", "login failure"); return new modelandview("loginsuccess",model); } } loginsuccess.jsp
<?xml version="1.0" encoding="iso-8859-1" ?> <%@page contenttype="text/html" pageencoding="utf-8"%> <%@taglib uri="http://www.springframework.org/tags/form" prefix="form" %> <%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>login result</title> </head> <body> ${result} <c:if test="${session_username != null }">hello ${session_username}! <div align="center" style="top:100px;"> <h1>my information</h1> <table> <tr> <td>username :</td> <td>${$user_info.username}</td> </tr> <tr> <td>firstname :</td> <td>${$user_info.firstname}</td> </tr> </table> </div> </c:if> </body> </html> employeeserviceimpl.java
package java4s; import java.sql.resultset; import java.sql.sqlexception; import java.util.arraylist; import java.util.list; import java4s.employee; import org.springframework.jdbc.core.jdbctemplate; import org.springframework.jdbc.core.rowmapper; import javax.sql.datasource; import org.springframework.beans.factory.annotation.autowired; public class employeeserviceimpl implements employeeservice { @autowired datasource datasource; @override public list<employee> getuserinfo(string username) { // todo auto-generated method stub string sql_query = "select * employeeinfo username = '" + username + "'"; list<employee> user_info = new arraylist<employee>(); jdbctemplate jdbctemplate = new jdbctemplate(datasource); user_info = jdbctemplate.query(sql_query, new rowmapper<employee>(){ @override public employee maprow(resultset rs, int rownum) throws sqlexception { employee employee = new employee(); employee.setusername(rs.getstring("username")); employee.setfirstname(rs.getstring("firstname")); return employee; } }); return user_info; } } error
org.apache.jasper.jasperexception: exception occurred processing jsp page /jsp/loginsuccess.jsp @ line 18 15: <table> 16: <tr> 17: <td>username :</td> 18: <td>${user_info.username}</td> 19: </tr> 20: <tr> 21: <td>firstname :</td> stacktrace: org.apache.jasper.servlet.jspservletwrapper.handlejspexception(jspservletwrapper.java:568) 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:728) org.springframework.web.servlet.view.internalresourceview.rendermergedoutputmodel(internalresourceview.java:238) org.springframework.web.servlet.view.abstractview.render(abstractview.java:264) org.springframework.web.servlet.dispatcherservlet.render(dispatcherservlet.java:1208) org.springframework.web.servlet.dispatcherservlet.processdispatchresult(dispatcherservlet.java:992) org.springframework.web.servlet.dispatcherservlet.dodispatch(dispatcherservlet.java:939) org.springframework.web.servlet.dispatcherservlet.doservice(dispatcherservlet.java:856) org.springframework.web.servlet.frameworkservlet.processrequest(frameworkservlet.java:920) org.springframework.web.servlet.frameworkservlet.dopost(frameworkservlet.java:827) javax.servlet.http.httpservlet.service(httpservlet.java:647) org.springframework.web.servlet.frameworkservlet.service(frameworkservlet.java:801) javax.servlet.http.httpservlet.service(httpservlet.java:728) root cause java.lang.numberformatexception: input string: "username" java.lang.numberformatexception.forinputstring(numberformatexception.java:65) java.lang.integer.parseint(integer.java:492) java.lang.integer.parseint(integer.java:527) javax.el.listelresolver.coerce(listelresolver.java:173) javax.el.listelresolver.getvalue(listelresolver.java:52) org.apache.jasper.el.jasperelresolver.getvalue(jasperelresolver.java:104) org.apache.el.parser.astvalue.getvalue(astvalue.java:183) org.apache.el.valueexpressionimpl.getvalue(valueexpressionimpl.java:185) org.apache.jasper.runtime.pagecontextimpl.proprietaryevaluate(pagecontextimpl.java:1026) org.apache.jsp.jsp.loginsuccess_jsp._jspx_meth_c_005fif_005f0(loginsuccess_jsp.java:125) org.apache.jsp.jsp.loginsuccess_jsp._jspservice(loginsuccess_jsp.java:85) org.apache.jasper.runtime.httpjspbase.service(httpjspbase.java:70) javax.servlet.http.httpservlet.service(httpservlet.java:728) 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:728) org.springframework.web.servlet.view.internalresourceview.rendermergedoutputmodel(internalresourceview.java:238) org.springframework.web.servlet.view.abstractview.render(abstractview.java:264) org.springframework.web.servlet.dispatcherservlet.render(dispatcherservlet.java:1208) org.springframework.web.servlet.dispatcherservlet.processdispatchresult(dispatcherservlet.java:992) org.springframework.web.servlet.dispatcherservlet.dodispatch(dispatcherservlet.java:939) org.springframework.web.servlet.dispatcherservlet.doservice(dispatcherservlet.java:856) org.springframework.web.servlet.frameworkservlet.processrequest(frameworkservlet.java:920) org.springframework.web.servlet.frameworkservlet.dopost(frameworkservlet.java:827) javax.servlet.http.httpservlet.service(httpservlet.java:647) org.springframework.web.servlet.frameworkservlet.service(frameworkservlet.java:801) javax.servlet.http.httpservlet.service(httpservlet.java:728)
try in jsp.
<c:foreach items="${user_info}" var="user_info"> <c:out value="${user_info.username}" /> </c:foreach>
Comments
Post a Comment