JSP实现下拉框的内容显示的是数据库中的数据

来源：互联网发布：linux rm最酷的命令编辑：程序博客网时间：2024/06/15 12:36

<%@ 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>

阅读全文

1 0