<%--
Created by IntelliJ IDEA.
User: user1
Date: 2022/8/9
Time: 21:59
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<%--
create table ac_book(
bookId varchar(50),
bookName varchar(180),
publisher varchar(100),
price float,
constraint pk_book primary key(bookId)
);
insert into ac_book values ('b001','Java从入门到精通','清华大学出版社',77.00);
insert into ac_book values ('b002','Java Web技术整合应用与项目实战','清华大学出版社',89.00);
insert into ac_book values ('b003','基于MVC的设计与开发','电子工业出版社',39.00);
insert into ac_book values ('b004','J2EE应用与开发','电子工业出版社',49.00);
insert into ac_book values ('b005','精通EJB','电子工业出版社',48.00);
select * from ac_book;
--%>
</body>
</html>