以访问数据库的方式用jsp动态生成下拉列表
图片效果:
建好数据库,建表并插入数据:
CREATE TABLE optionlist( id INT, employee VARCHAR(20) ); INSERT INTO optionlist(id,employee) VALUES (1,"java模块的前世今生"), (2,"java从入坟到出土"), (3,"我要java的半生缘"), (4,"如果不是真的喜欢谁学java"), (5,"C++我的兄弟"), (6,"java从贫困到欠债");
建立User类,即传说中的Model层:
public class User{
private int id;
private String employee;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getEmployee() {
return employee;
}
public void setEmployee(String employee) {
this.employee = employee;
}
public User(int id, String employee) {
super();
this.id = id;
this.employee = employee;
}
}
在同一包下建立Control层,即DAO(data access object:数据访问层)
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
public