jsp查询mysql数据库中的数据,从mysql数据库获取值以在JSP中显示（JAVA）

I could use some help how to get values from a mysql database, and parse it to a servlet, which opens a jsp file "Showlist.jsp" and have all the values as parameter.

My tabel in my database contains:

ID, Name, Initials, cpr, password, role.

I have created 3 users in my system, and i want to show all users in a jsp file.

Right now i have 3 layers which contain the following classes:

View layer

- html / jsp files

Function layer

- Class function

Data layer

- Class DAOoperator (Contains mysql statements.

- Class DTOoperator (Which is my object with getter and setter methods)

- class DataAccess (contains connection to mysql database)

All this is controlled by a servlet called Controller.

Is there an easy way to do this??

解决方案

In the servlet you access the DAO and call the getUser() method which returns a list of user. Then you set the result to the request.

request.setAttribute("users", userList);

In the jsp you can get it by:

userList = (List)request.getAttribute("users"); %>

a better approach is to use jstl in the jsp instead of plain java code.