【文件属性】：
文件名称：eclipse +jsp+ servlet+MySQL省市县 三级菜单的查询
文件大小：1MB
文件格式：ZIP
更新时间：2022-06-08 16:26:28
JSP Servlet 省市县 eclipse mysql
采用Eclipse 编写的关于省市县三级菜单采用JSP +servlet+MYSQL ,数据库表的数据文件在src文件夹中
mysql> show tables;
+----------------+
| Tables_in_area |
+----------------+
| area |
| cities |
| provinces |
+----------------+
3 rows in set (0.00 sec)
mysql> desc provinces;
+----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| pid | char(6) | NO | | NULL | |
| province | varchar(100) | NO | | | |
+----------+--------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
mysql> desc cities;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| cid | char(6) | NO | | NULL | |
| city | varchar(40) | NO | | NULL | |
| pid | char(6) | NO | | NULL | |
+-------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
mysql> desc area;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| aid | char(6) | NO | | NULL | |
| area | varchar(40) | NO | | NULL | |
| cid | char(6) | NO | | NULL | |
+-------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
【文件预览】：
testajax
----WebContent()
--------META-INF()
--------WEB-INF()
--------index.html(198B)
--------area()
----.settings()
--------org.eclipse.wst.jsdt.ui.superType.name(6B)
--------org.eclipse.wst.common.project.facet.core.xml(305B)
--------org.eclipse.wst.common.component(476B)
--------org.eclipse.wst.jsdt.ui.superType.container(49B)
--------.jsdtscope(567B)
--------org.eclipse.jdt.core.prefs(364B)
----src()
--------testajax()
----.project(908B)
----.classpath(951B)
----build()
--------classes()