<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="javabean.book"%>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="javabean.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<%
List<String> list=new ArrayList<String>();
Connection con=null;
ResultSet rs=null;
Statement stmt=null;
con=DBUtil.getDb();
String sql="select book_publish from book_info";
stmt=con.createStatement();
try{
rs=stmt.executeQuery(sql) ;
while(rs.next()){
list.add(rs.getString("book_publish"));
}
}catch(SQLException ex){
System.out.println(ex.getMessage());
}
%>
<select>
<%for(int i=0;i<list.size();i++){%>
<option><%=list.get(i)%></option>
<%}%>
</select>
</body>
</html>
JSP实现下拉框的内容显示的是数据库中的数据
最新推荐文章于 2023-02-23 13:45:21 发布