jsp创建mysql数据库_JSP_创建mysql数据库&利用JSP进行数据库查询

当前位置:

IT大杂烩

>

Java

> JSP_创建mysql数据库&利用JSP进行数据库查询

JSP_创建mysql数据库&利用JSP进行数据库查询

www.someabcd.com  网友分享于：Jun 6, 2018 11:37:16 PM

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,"小李","

发布此文章仅为传递网友分享，不代表本站观点，若侵权请联系我们删除，本站将不对此承担任何责任。