java - How do I pre-fill text fields in a form with info from a database in a .jsp? -
java - How do I pre-fill text fields in a form with info from a database in a .jsp? -
i'm trying create form updates entry in mysql database. table users table contains various fields related user. need page work update form takes username passed via previous page , pre-fills text fields existing data. it's model 1 application uses presentation, transport, , info layer. transport layer user.java , info layer (that interacts database) userdb.java.
here's code, functional except pre-filling.
update: i've edited reflect changes answers below, want note "userdb.getusers()" returns arraylist.
<%@ page language="java" contenttype="text/html; charset=iso-8859-1" pageencoding="iso-8859-1" import="java.util.arraylist,beans.*,data.*"%> <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd"> <% //get parameters request string username = request.getparameter("username"); arraylist userlist = userdb.getusers(username); user user = userlist.get(0); %> <html> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> <link rel="stylesheet" href="styles/style.css" type="text/css" /> <title>user admin</title> </head> <body> <div id="main"> <h1>update user</h1> <h3>user info</h3> <hr> <div id="content"> <form action="updateuser.jsp" method="get"> <p>user name<br> <input type="text" name="username" size="20" value="<%=username%>"/> </p> <p>password<br> <input type="text" name="password" size="20" value="<%=user.getpassword()%>"/> </p> <p>first name<br> <input type="text" name="firstname" size="20" value="<%=user.getfirstname()%>"/> </p> <p>last name<br> <input type="text" name="lastname" size="20" value="<%=user.getlastname()%>"/> </p> <p>email address<br> <input type="text" name="email" size="20" value="<%=user.getemail()%>"/> </p> <p> <input type="submit" value="commit update"> </p> </form> </div> </div> </body> </html>
i know i'm doing wrong "user" object, i'm overlooking it.
you passing username string
<% //get parameters request string username = request.getparameter("username"); user = userdb.getusers("username"); //it should (with out quotes user = userdb.getusers(username); %>
java jsp jsp-tags
Comments
Post a Comment