Java进阶-连接池&事务(九）.zip

create table product( pid int primary key, pname varchar(20), price double ); INSERT INTO product(pid,pname,price) VALUES(1,'联想',5000); INSERT INTO product(pid,pname,price) VALUES(2,'海尔',3000); INSERT INTO product(pid,pname,price) VALUES(3,'雷神',5000); INSERT INTO product(pid,pname,price) VALUES(4,'JACK JONES',800); INSERT INTO product(pid,pname,price) VALUES(5,'真维斯',200); INSERT INTO product(pid,pname,price) VALUES(6,'花花公子',440); INSERT INTO product(pid,pname,price) VALUES(7,'劲霸',2000); INSERT INTO product(pid,pname,price) VALUES(8,'香奈儿',800); INSERT INTO product(pid,pname,price) VALUES(9,'相宜本草',200); INSERT INTO product(pid,pname,price) VALUES(10,'面霸',5); INSERT INTO product(pid,pname,price) VALUES(11,'好想你枣',56); INSERT INTO product(pid,pname,price) VALUES(12,'香飘飘奶茶',1);