jsp获取mysql表,使用jsp从数据库中获取数据

how to fetch the states from the the states table in mssql server db by using jsp as a drop down box

解决方案

To start, create a javabean representing a state with code and name (basically the same data as you have in the DB table). Then create a DAO class which does the database interaction task. Then create a Servlet class which retrieves the list from the DAO, puts it in the request scope and forwards the request to the JSP. Finally create a JSP file which displays the list using JSTL's c:forEach.

Basic example of the state bean:

public class State {

private String code;

private String name;

// Add (generate) public getters and setters.

}

Basic example of the DAO class:

public List list() {

List states = new ArrayList();

// Do your JDBC thing here.

return states;

}

Basic example of the Servlet class:

protected void doGet(HttpServletRequest request, HttpServletResponse response) {

List states = stateDAO.list();

request.setAttribute("states", states);

request.getRequestDispatcher("/WEB-INF/page.jsp").forward(request, response);

}

Basic example of JSP file:

${state.name}

Map the servlet on the url-pattern to your taste in web.xml and invoke this servlet by your browser.

To get more insights and ideas around the DAO pattern, you may find this article useful as well.