最终环境配置:
IDEA2021+JDK8+mysql connector java5+Mysql5+mybatis3.5:从数据库取出数据。
+(servlet+jsp+el表达式jstl):servlet+jsp接收HTTP请求和响应将取出的数据形成页面代码并传递到浏览器,el可以避免书写<%%>加快书写,jstl提供的c:if c:foreach进一步加快书写。
tomcat7插件+html5+css3+chorme:
CheckCodeUtil工具类:生成注册页面验证码图片,验证码采用session保存在服务器,访问注册servlet先进行验证码比对。
cookie:登录成功后将用户名和密码返回浏览器存留,下次访问登录页面时候自动填充账号密码。
注意:jsp中可以用${}直接获取session中的值!
=========================================================================
URL:
首页:http://localhost:8090/demoLogin/
登录页面:http://localhost:8090/demoLogin/
商品列表页面:http://localhost:8090/demoLogin/brandListServlet
注册页面:http://localhost:8090/demoLogin/register.jsp
======================================================================
项目结构:
数据库SQL,数据库名db1
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
`id` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`money` double(11,0) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of account
-- ----------------------------
INSERT INTO `account` VALUES ('1', '历程', '3000', '成都');
INSERT INTO `account` VALUES ('2', '皇帝', '3000', '北京');
-- ----------------------------
-- Table structure for tb_brand
-- ----------------------------
DROP TABLE IF EXISTS `tb_brand`;
CREATE TABLE `tb_brand` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`brand_name` varchar(20) DEFAULT NULL,
`company_name` varchar(20) DEFAULT NULL,
`ordered` int(11) DEFAULT NULL,
`description` varchar(100) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tb_brand
-- ----------------------------
INSERT INTO `tb_brand` VALUES ('4', '凡人修仙传0', '公司0', '222', '描述0', '1');
INSERT INTO `tb_brand` VALUES ('5', '凡人修仙传1', '公司1', '222', '描述1', '1');
INSERT INTO `tb_brand` VALUES ('6', '凡人修仙传2', '公司2', '222', '描述2', '1');
INSERT INTO `tb_brand` VALUES ('7', '凡人修仙传3', '公司3', '222', '描述3', '1');
INSERT INTO `tb_brand` VALUES ('8', '凡人修仙传4', '公司4', '222', '描述4', '1');
INSERT INTO `tb_brand` VALUES ('9', '凡人修仙传5', '公司5', '222', '描述5', '1');
INSERT INTO `tb_brand` VALUES ('10', '凡人修仙传6', '公司6', '222', '描述6', '1');
INSERT INTO `tb_brand` VALUES ('11', '凡人修仙传7', '公司7', '222', '描述7', '1');
INSERT INTO `tb_brand` VALUES ('12', '凡人修仙传8', '公司8', '222', '描述8', '1');
INSERT INTO `tb_brand` VALUES ('13', '凡人修仙传9', '公司9', '222', '描述9', '1');
INSERT INTO `tb_brand` VALUES ('21', '55', '55', '66', '777', '0');
INSERT INTO `tb_brand` VALUES ('22', '666', '888', '778', '888', '1');
-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES ('ldj', '123');
INSERT INTO `tb_user` VALUES ('qwer', '123456');
INSERT INTO `tb_user` VALUES ('qwer11111', '123456');
INSERT INTO `tb_user` VALUES ('qwer666', '123');
INSERT INTO `tb_user` VALUES ('qwer222222', '123456');
INSERT INTO `tb_user` VALUES ('qwer2222226666', '33333333333333');
INSERT INTO `tb_user` VALUES ('123456789', '123456789');
INSERT INTO `tb_user` VALUES ('rott', '12356');
INSERT INTO `tb_user` VALUES ('ro1111', '12356');
INSERT INTO `tb_user` VALUES ('5555', '788888888');
INSERT INTO `tb_user` VALUES ('8888', '8888888');
INSERT INTO `tb_user` VALUES ('33', '');
INSERT INTO `tb_user` VALUES ('999999', '9999999');
INSERT INTO `tb_user` VALUES ('123', '12356');
INSERT INTO `tb_user` VALUES ('yyy', '123');
INSERT INTO `tb_user` VALUES ('root', '123');
INSERT INTO `tb_user` VALUES ('qqq', '123');
INSERT INTO `tb_user` VALUES ('www', '111');
INSERT INTO `tb_user` VALUES ('mmm', 'mmm');
代码和图片见gitee仓库: