1.28

JDBC 链接数据库

1. 首先，建立一个简单的数据库 people ，创建一张测试表 student

CREATE TABLE `student` (
		`id` int(4) PRIMARY KEY,
		`name` VARCHAR(20),
		`age` int(8),
		`password` VARCHAR(20),
		`email` VARCHAR(40),
		`tel` VARCHAR(20)
);

INSERT INTO `student`(`id`, `name`, `age`, `password`, `email`, `tel`) VALUES
(1, '孙二', 18, '123456', 'se@qq.com', '8339564'),
(2, '张三', 24, '465456564', 'zs@qq.com', '8334654'),
(3, '李四', 35, 'sdfds45', 'ls@qq.com', '8356485'),
(4, '王五', 12, '453544', 'ww@qq.com', '8953456'),
(5, '赵六', 10, '4534533', 'zl@qq.com', '8775412');

创建好之后 student 表如下所示