select下拉框的使用
下拉框获取固定的值
<select name="projectKind" lay-verify="required">
<option value="">请选择项目类型</option>
<option value="创新型">创新型</option>
<option value="公益型">公益型</option>
<option value="公益型">创意型</option>
</select>
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/60e20ae63735bc1d2c12252cba7a208f.png)
下拉框获取数据库的值
<select name="positionSid" lay-verify="required" id="id">
<option value="" selected="selected">请选择学生学号</option>
<%
String driverName="com.mysql.cj.jdbc.Driver";
String userName="root";
String psw="010802";
String dbName="koko";
String url="jdbc:mysql://localhost:3306/koko?serverTimezone=UTC&characterEncoding=UTF-8&useUnicode=true&useSSL=false";
Class.forName(driverName);
Connection conn=DriverManager.getConnection(url,userName,psw);
String strSql="select * from student";
Statement stat=conn.createStatement();
ResultSet rs=stat.executeQuery(strSql);
while(rs.next())
{
String s = rs.getString("sid");
%>
<option value="<%= s%>"><%= s%></option>
<%
}
%>
</select>