该博客详细介绍了如何利用Ajax、JSP和Servlet在Java Web环境中创建一个多级下拉菜单的联动效果。首先创建了school数据库及其对应的class和student表，接着定义了DB类进行数据库操作。然后，创建了StudentVO和ClassVO类，以及对应的StudentManager和ClassManager类，用于获取和管理数据。在JSP页面中，通过遍历Manager类获取的数据来展示下拉菜单。最后，编写了一个Servlet来处理下拉框的选择变化，动态更新学生列表，实现了无刷新联动效果。
create database school;
use school;
create table class(
id
int primary key AUTO_INCREMENT,
name varchar(10)
);
create table
student(
id int primary key AUTO_INCREMENT,
name varchar(10),
cid int
references class(id)
);
insert into class values(null,
'0501');
insert into class values(null, '0502');
insert into class
values(null, '0503');
insert into class values(null, '0504');
insert
into student values(null, '11', 1);
insert into student values(null, '21',
2);
insert into student values(null, '22', 2);
insert into student
values(null, '31', 3);
insert into student values(null, '32', 3);
insert
into student values(null, '33', 3);
insert into student values(null, '41',
4);
insert into student values(null, '42', 4);
insert into student
values(null, '43', 4);
insert into student values(null, '44', 4);
简单打包数据库操作类DB：
package DropDownList;
import java.sql.*;
public class DB {
private static Connection conn;
public static Connection getConn() {
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/school", "root", "root");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void close(Connection conn) {
try {
conn.close();
} catch (SQLException e) {
e.
最低0.47元/天 解锁文章
2313
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
