jsp连接数据库

1.添加jar
将jar文件添加到工程下的lib文件夹

2.

3.
4.利用MySQL制作表格

SET FOREIGN_KEY_CHECKS=0;
create database hello DEFAULT CHARSET=utf8;
use hello;
-- ----------------------------
-- Table structure for admin_info
-- ----------------------------
DROP TABLE IF EXISTS `admin_info`;
CREATE TABLE `admin_info` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `pwd` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_info
-- ----------------------------
INSERT INTO `admin_info`(name,pwd) VALUES ('admin', '123456');