一个小菜鸟的成长之路:
废话不多说,直接上干货
首先是java环境:jdk1.10 jdbc驱动:mysql-connector-java-5.1.46.jar
其次是开发软件IntelliJ IDEA2018
三个数据表:
admin:
CREATE TABLE `admin` (
`id` int(11) NOT NULL,
`name` varchar(30) NOT NULL,
`password` varchar(30) NOT NULL,
`gender` char(10) DEFAULT NULL,
PRIMARY KEY (`id`)
)
customer:
CREATE TABLE `customer` (
`customer_id` char(20) NOT NULL,
`customer_password` varchar(30) NOT NULL,
`customer_name` varchar(30) NOT NULL,
`customer_money` float(10,2) DEFAULT NULL,
`customer_identity` char(10) DEFAULT NULL,
PRIMARY KEY (`customer_id`)
)
goods:
CREATE TABLE `goods` (
`