1. 链接数据库, 并创建新表
mysql>create database people;
mysql>use people;
mysql>create table peoples
->(
->id int NOT NULL AUTO_INCREMENT,
->age int,
->name varchar(30),
->provice varchar(255),
->PRIMARY KEY (id)
->);
2. 向数据表中插入数据
mysql>insert into peoples value (null,20,"张一","河南");
mysql>insert into peoples value (null,21,"张二","上海");
mysql>insert into peoples value (null,22,"张三","山东");
mysql>insert into peoples value (null,23,"李四","山西");
mysql>insert into peoples value (null,24,"王五","陕西");
mysql>insert into peoples value (null,25,"李四","河南");
mysql>insert into peoples value (null,26,"张三","北京");
mysql>insert into peoples value (null,22,"张二","上海");
mysql>insert into peoples value (null,23,"小张","湖北");
mysql>insert into peoples value (null,25,"小李","湖南");
mysql>insert into peoples value (null,24,"小王","上海");
mysql>insert into peoples value (null,25,"张三","北京");
mysql>insert into peoples value (null,24,"李四","山东");
mysql>insert into peoples value (null,23,"张三","河南");
mysql>insert into peoples value (null,26,"小李","山西");
mysql>insert into peoples value (null,23,"张三","河南");
3. 确认数据已经写放到数据表中
mysql>select * from peoples;
数据库部分已经创建完毕;
如果觉得《使用jsp循环查询mysql_[JSP] 创建mysql数据库利用JSP进行数据库查询(1)》对你有帮助,请点赞、收藏,并留下你的观点哦!