jsp+servlet+mysql开发web

html文件转译为jsp文件在开头加上：

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

1.数据库相关
显示数据库列表show databases;
创建数据库create database db_name;
删除数据库drop database db_name;
使用数据库use db_name;
2.数据表相关
显示数据表列表show tables;
查看数据表结构desc tb_name;
创建数据表`

create table tb_students(stu_num char(11) primary key auto_increment,  //设置主键，且自动增长
                         stu_name varchar(20) not null,
                         stu_sex char(2) not null,
                         stu_age int,
                         stu_tel char(11) not null unique);`               //不能为空，且唯一
                         constraint FK1 foreign key(stu_name)references tb_users(name);//设置外键

删除数据表drop table tb_name;
增：将数据添加到数据表

insert into tb_students(stu_num,stu_name,stu_sex,stu_age,stu_tel)values('10010100103','Lucy','MM',20,'13232323322');

查：显示数据表中特定的数据显示指定列

select stu_num,stu_name from tb_students;select * from tb_students where stu_sex='MM';

改：修改数据

update tb_students set stu_name=?,tu_sex=?,stu_age=?,stu_tel=? where stu_num=?;

.删：删除数据

delete from tb_students where stu_num=?;