java操作数据库语法

1 新建数据库

1.1 新建数据库

1 启动mysql数据库

2 新建数据库

1.2 mysql数据库语法

1 选择数据库

use java_demo1

2 移除数据库

drop database java_web1

3 创建表

CREATE TABLE `user` (
    `id` int(11) PRIMARY KEY AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `age` int(11)
);

4 移除表

drop table user;

5 创建表

CREATE TABLE `user` (
    `id` int(11) PRIMARY KEY AUTO_INCREMENT,
    `name` varchar(255),
    `password` varchar(255) NOT NULL,
    `age` int(11),
    `phone` varchar(255) NOT NULL
);

6 添加全部字段

insert into user(password,name,age,phone)values("123456","tom","16","18483233516");
insert into user(password,name,age,phone)values("admin123","make","17","18563233516");
insert into user(password,name,age,phone)values("admin","root","16","18483233529");
insert into user(password,name,age,phone)values("root","root123","16","18483233654");
insert into user(password,name,age,phone)values("123456","admin456","16","18483233123");
insert into user(password,name,age,phone)values("123456","tom","17","18483233789");
insert into user(password,name,age,phone)values("1234567","tom","16","18483233516");

7 查询字段

查询全部字段
select * from user;
查询指定字段内容
select password,name from user;
查询条件成立字段
select password,name from user where id=1;

8 删除值

delete from user where id =1;

9 修改值

update user set name = "李四" where id = 2;

10 增加字段

alter table user add 'address' varchar(255);

11 模糊查询

select * from user where name like '%李%'；

12 删除字段

alter table user drop adress;

13 分页显示

select * from user limit 5;

14 排序 降序 desc 升序 aec

select * from user order by age;

15 分组

select age,count(*) from user group by age;

2 java操作mysql的语法

现在文件下新建lib文件并导入mysql插件

选择lib右击添加为库