MySQL部分:
#判断存在即删除数据库 drop database if exists mydb; #创建数据库 create database mydb; #使用数据库 use mydb; #创建表 create table t_user ( uid int primary key auto_increment, username varchar(20), password varchar(20), phone varchar(11), address varchar(50) ); insert into t_user(username,password,phone,address) values('张三','666','18965423548','南阳'); insert into t_user(username,password,phone,address) values('李四','333','18754263548','许昌'); insert into t_user(username,password,phone,address) values('小美','123','18565234759','信阳'); select * from t_user where username=? and password=? select * from t_user; create table t_goods ( gid int primary key auto_increment, gname varchar(20), price double, mark varchar(100) ); insert into t_goods(gname,price,mark) values('泡面',4.5,'够香够辣就是这个味!'); insert into t_goods(gname,price,mark) values('火腿',8.5,'肉质细腻Q弹!'); insert into t_goods(gname,price,mark) values('雪碧',3.5,'清爽冰凉随心爽!'); select * from t_goods;
运行结果如图所示:
项目部署:
那么我们可以先看各个页面的jsp代码和运行结果。
首页.jsp代码如下:
<%--
Created by IntelliJ IDEA.
User: 16230
Date: 2023/2/20
Time: 14:44
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>第一个Web项目</title>
</head>
<body>
<h2>欢迎来到主页</h2>
<a href="login.jsp">去登录</a>
</body>
</html>
页面效果如图所示:
登录页面.jsp代码如下:
<%--
Created by IntelliJ IDEA.
User: 16230
Date: 2023/2/14
Time: 11:25
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>登录</title>
</head>
<body>
<h2>登录</h2>
<form action="login" method="post">
账号:<input type="text" name="username" value=""> <br>
密码:<input type="password" name="password" value=""> <br>
<input type="submit" value="登录">
<a href="register.jsp">没有账号?请点击注册</a>
</form>
</body>
</html>
点击“去登录”,进入登录页面,效果如图所示:
注册页面.jsp代码如下:
<%--
Created by IntelliJ IDEA.
User: 16230
Date: 2023/2/18
Time: 11:52
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<h2>注册</h2>
<form action="register" method="post">
账号:<input type="text" name="username" value=""> <br>
密码:<input type="password" name="password" value=""> <br>
电话:<input type="text" name="phone" value=""> <br>
地址:<input type="text" name="address" value=""> <br>
<input type="submit" value="注册">
<a href="login.jsp">已有帐号?请登录</a>
</form>
</body>
</html>
点击“没有账号?请点击注册”,跳转到注册页面,效果如图所示:
输入账号、密码、电话、地址后,点击“注册”,可进入登录页面,或点击“已有帐号?请登录”,也可进入登录页面:
输入账号密码后,若如输入正确,可进入主页,反之进入错误页:
错误页.jsp代码如下:
<%--
Created by IntelliJ IDEA.
User: 16230
Date: 2023/2/17
Time: 23:50
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>错误页</title>
</head>
<body>
<h2>${error_msg}</h2>
<a href="login.jsp">返回登录</a>
</body>
</html>
登录成功之后,就可以进入商品信息页,我们先写jsp代码:
<%@ page import="java.util.List" %>
<%@ page import="com.du.bean.Goods" %><%--
Created by IntelliJ IDEA.
User: 16230
Date: 2023/2/17
Time: 23:47
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!--导入JSTL的核心类库-->
<%@ taglib prefix="pfx" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<!--EL表达式:通过 $ { } 从作用域对象中获取数据,如果该数据是对象,则可以通过对象名.属性名获取数值-->
<h2>欢迎来自${user.address}的${user.username}访问项目主页</h2>
<form action="seach" method="post">
<input type="text" name="keyword" value="" />
<input type="submit" value="搜索"/>
</form>
<a href="addGoods.jsp">添加商品</a>
<table>
<thead>
<tr>
<th>商品编号</th>
<th>商品名称</th>
<th>商品价格</th>
<th>商品说明</th>
<th>操作</th>
</tr>
</thead>
<tbody id="list">
<!--items:要遍历的集合对象(写EL表达式) var:集合中对应临时对象-->
<pfx:forEach items="${goodsList}" var="goods">
<tr>
<td>${goods.gid}</td>
<td>${goods.gname}</td>
<td>${goods.price}</td>