MySQL部分
#創(chuàng)建數(shù)據(jù)庫
create database mydb;
#創(chuàng)建表
create table t_user
(
uid int primary key auto_increment,
username varchar(20),
password varchar(20),
phone varchar(11),
address varchar(50)
);
#插入數(shù)據(jù)
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','信陽');
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,'肉質(zhì)細膩Q彈！');
insert into t_goods(gname,price,mark) values('雪碧',3.5,'清爽冰涼隨心爽！');Java部分
在idea中創(chuàng)建有關(guān)類
?web中寫jsp頁面，index.jsp是首頁布局
<html>
<head>
<title>這是JavaWeb項目</title>
</head>
<body>
<h2>開始學(xué)習(xí)JavaWeb吧！</h2>
<a href="login.jsp">登錄</a>
<a href="zhuce.jsp">注冊</a>
</body>
</html>運行效果如下：
?登錄頁面
<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="zhuce.jsp">沒有賬號？請注冊</a>
</form>
</body>
</html>運行效果如下：
?注冊頁面?
<html>
<head>
<title>注冊</title>
</head>
<body>
<form action="zhuce" method="post">
賬號:<input type="text" name="username" value=""><br>
密碼:<input type="password" name="password" value=""><br>
電話:<input type="text" name="phone"><br>
地址:<input type="text" name="address">
<input type="submit" value="注冊">
<a href="login.jsp">已有帳號？請登錄</a>
</form>
</body>
</html>運行效果如下：
?登陸正確時跳轉(zhuǎn)到zhuye.jsp主頁頁面（使用Java腳本獲取集合中對象的元素，放html標簽中）
<%@ page import="java.util.List" %>
<%@ page import="com.shi.bean.Goods" %><%--
Created by IntelliJ IDEA.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>登錄</title>
</head>
<body>
<h2>登陸成功！</h2>
<h3>歡迎來到項目主頁</h3>
<table>
<thead>
<tr>
<th>商品編號</th>
<th>商品名稱</th>
<th>商品價格</th>
<th>商品說明</th>
</tr>
</thead>
<tbody id="list">
<%
//獲取session
HttpSession session1 = request.getSession();
//從session中取出數(shù)據(jù)
List<Goods> goodsList = (List<Goods>) session1.getAttribute("goodsList");
//遍歷集合元素
for (Goods goods : goodsList) {
%>
<!--使用Java腳本獲取集合中對象的元素，放html標簽中-->
<tr>
<td><%=goods.getGid()%>
</td>
<td><%=goods.getGname()%>
</td>
<td><%=goods.getPrice()%>
</td>
<td><%=goods.getMark()%>
</td>
</tr>
<%
}
%>
</tbody>
</table>
</body>
</html>
運行效果如下：
?在登陸頁面，密碼或用戶名輸入錯誤時跳轉(zhuǎn)到error.jsp再返回login.jsp登陸頁面
<html>
<head>
<title>錯誤頁</title>
</head>
<body>
<h2>出錯啦！</h2>
<a href="login.jsp">返回登陸</a>
</body>
</html>效果如圖所示：
??用戶實體類代碼如下：
package com.shi.bean;
public class User {
private int uid;
private String username;
private String password;
private String phone;
private String address;
public int getUid() {
return uid;
}
public String getUsername() {
return username;
}
public String getPassword() {
return password;
}
public String getPhone() {
return phone;
}
public String getAddress() {
return address;
}
public void setUid(int uid) {
this.uid = uid;
}
public void setUsername(String username) {
this.username = username;
}
public void setPassword(String password) {
this.password = password;
}
public void setPhone(String phone) {
this.phone = phone;
}
public void setAddress(String address) {
this.address = address;
}
@Override
public String toString() {
return "User{" +
"uid=" + uid +
", username='" + username + '\'' +
", password='" + password + '\'' +
", phone='" + phone + '\'' +
", address='" + address + '\'' +
'}';
}
}
package com.shi.bean;
public class Goods {
private int gid;
private String gname;
private Double price;
private String mark;
public int getGid() {
return gid;
}
public void setGid(int gid) {
this.gid = gid;
}
public String getGname() {
return gname;
}
public void setGname(String gname) {
this.gname = gname;
}
public Double getPrice() {
return price;
}
public void setPrice(Double price) {
this.price = price;
}
public String getMark() {
return mark;
}
public void setMark(String mark) {
this.mark = mark;
}
@Override
public String toString() {
return "Goods{" +
"gid=" + gid +
", gname='" + gname + '\'' +
", price=" + price +
", mark='" + mark + '\'' +
'}';
}
}
?功能邏輯類UserDao
package com.shi.dao;
import com.shi.bean.User;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class UserDao {
private static String jdbcDriver = "com.mysql.jdbc.Driver";
private static String jdbcUrl = "jdbc:mysql://localhost:3306/mydb";
private static String jdbcUser = "root";
private static String jdbcPwd = "root";
private Connection con = null; //數(shù)據(jù)庫連接對象
private PreparedStatement pstm = null; //預(yù)處理對象
private ResultSet rs = null; //結(jié)果集對象
private int row = 0; //增刪改受影響的行數(shù)
public User login(String username, String password) {
User login = null;
try {
Class.forName(jdbcDriver);
con = DriverManager.getConnection(jdbcUrl, jdbcUser, jdbcPwd);
String sql = "select * from t_user where username=? and password=?";
pstm = con.prepareStatement(sql);
pstm.setObject(1, username);
pstm.setObject(2, password);
rs = pstm.executeQuery();
if (rs.next()) {
//從結(jié)果集中取出數(shù)據(jù)，封裝到User對象中
login = new User();
login.setUid(rs.getInt("uid"));
login.setUsername(rs.getString("username"));
login.setPassword(rs.getString("password"));
login.setPhone(rs.getString("phone"));
login.setAddress(rs.getString("Address"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
if (pstm != null) {
rs.close();
}
if (con != null) {
rs.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
return login;
}
public int add(User user) {
try {
Class.forName(jdbcDriver);
con = DriverManager.getConnection(jdbcUrl, jdbcUser, jdbcPwd);
String sql = "insert into t_user(username,password,phone,address) values(?,?,?,?)";
pstm = con.prepareStatement(sql);
pstm.setObject(1, user.getUsername());
pstm.setObject(2, user.getPassword());
pstm.setObject(3, user.getPhone());
pstm.setObject(4, user.getAddress());
row = pstm.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
if (pstm != null) {
rs.close();
}
if (con != null) {
rs.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
return row;
}
}
?功能邏輯類GoodsDao
package com.shi.dao;
import com.shi.bean.Goods;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
public class GoodsDao {
//連接數(shù)據(jù)庫的四大參數(shù)
private static String jdbcDriver = "com.mysql.jdbc.Driver";
private static String jdbcUrl = "jdbc:mysql://localhost:3306/mydb";
private static String jdbcUser = "root";
private static String jdbcPwd = "root";
private Connection con = null; //數(shù)據(jù)庫連接對象
private PreparedStatement pstm = null; //預(yù)處理對象
private ResultSet rs = null; //結(jié)果集對象
public List<Goods> selectAll() {
List<Goods> goodsList = new ArrayList<>();
try {
Class.forName(jdbcDriver);
con = DriverManager.getConnection(jdbcUrl, jdbcUser, jdbcPwd);
String sql = "select*from t_goods";
pstm = con.prepareStatement(sql);
rs = pstm.executeQuery();
while (rs.next()) {
Goods goods = new Goods();
//從結(jié)果集中獲取數(shù)據(jù)，封裝到Goods對象中
goods.setGid(rs.getInt("gid"));
goods.setGname(rs.getString("gname"));
goods.setPrice(rs.getDouble("price"));
goods.setMark(rs.getString("mark"));
//把當前行對應(yīng)的對象存儲到集合中
goodsList.add(goods);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
if (pstm != null) {
rs.close();
}
if (con != null) {
rs.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
return goodsList;
}
}
Login邏輯代碼
package com.shi.dao;
import com.shi.bean.Goods;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
/**
* @author 史佳寧 2023/2/20 16:36
* @version 1.0
*/
public class GoodsDao {
//連接數(shù)據(jù)庫的四大參數(shù)
private static String jdbcDriver = "com.mysql.jdbc.Driver";
private static String jdbcUrl = "jdbc:mysql://localhost:3306/mydb";
private static String jdbcUser = "root";
private static String jdbcPwd = "root";
private Connection con = null; //數(shù)據(jù)庫連接對象
private PreparedStatement pstm = null; //預(yù)處理對象
private ResultSet rs = null; //結(jié)果集對象
public List<Goods> selectAll() {
List<Goods> goodsList = new ArrayList<>();
try {
Class.forName(jdbcDriver);
con = DriverManager.getConnection(jdbcUrl, jdbcUser, jdbcPwd);
String sql = "select*from t_goods";
pstm = con.prepareStatement(sql);
rs = pstm.executeQuery();
while (rs.next()) {
Goods goods = new Goods();
//從結(jié)果集中獲取數(shù)據(jù)，封裝到Goods對象中
goods.setGid(rs.getInt("gid"));
goods.setGname(rs.getString("gname"));
goods.setPrice(rs.getDouble("price"));
goods.setMark(rs.getString("mark"));
//把當前行對應(yīng)的對象存儲到集合中
goodsList.add(goods);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
if (pstm != null) {
rs.close();
}
if (con != null) {
rs.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
return goodsList;
}
}
Zhuce邏輯代碼
package com.shi.servlet;
import com.shi.bean.User;
import com.shi.dao.UserDao;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
//設(shè)置當前類用來處理/register的請求
@WebServlet("/zhuce")
public class Zhuce extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//1.設(shè)置編碼
req.setCharacterEncoding("utf-8");
resp.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=UTF-8");
//2.獲取請求參數(shù)
String username=req.getParameter("username");
String password=req.getParameter("password");
String phone=req.getParameter("phone");
String address=req.getParameter("address");
//封裝：把上面所有的變量裝載到User對象中
User user=new User();
user.setUsername(username);
user.setPassword(password);
user.setPhone(phone);
user.setAddress(address);
//3:執(zhí)行業(yè)務(wù)處理---jdbc的操作
UserDao userDao=new UserDao();
int row = userDao.add(user);
if(row>0){
resp.sendRedirect("login.jsp");//指定跳轉(zhuǎn)的頁面
}else {
resp.sendRedirect("error.jsp");
}
}
}
SelectAllGoods邏輯代碼
package com.shi.servlet;
import com.shi.bean.Goods;
import com.shi.dao.GoodsDao;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.util.List;
@WebServlet("/selectAllGoods")
public class SelectAllGoods extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//查詢所有商品信息
GoodsDao goodsDao=new GoodsDao();
List<Goods> goodsList=goodsDao.selectAll();
System.out.println(goodsList);
//把數(shù)據(jù)傳遞到前端頁面
//通過request獲取session對象，該對象可以向前端傳輸數(shù)據(jù)內(nèi)容
HttpSession session = req.getSession();
//向session中存入商品信息集合
session.setAttribute("goodsList",goodsList);
//登陸成功，跳轉(zhuǎn)到主頁
resp.sendRedirect("zhuye.jsp");//跳轉(zhuǎn)到指定頁面
}
}
登錄成功后跳轉(zhuǎn)到主頁并展示數(shù)據(jù)庫的商品信息效果如下：
重新查看展示數(shù)據(jù)，請求轉(zhuǎn)發(fā)給SelectAllGoods?
package com.shi.servlet;
import com.shi.bean.Goods;
import com.shi.dao.GoodsDao;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.util.List;
@WebServlet("/selectAllGoods")
public class SelectAllGoods extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//查詢所有商品信息
GoodsDao goodsDao=new GoodsDao();
List<Goods> goodsList=goodsDao.selectAll();
System.out.println(goodsList);
//把數(shù)據(jù)傳遞到前端頁面
//通過request獲取session對象，該對象可以向前端傳輸數(shù)據(jù)內(nèi)容
HttpSession session = req.getSession();
//向session中存入商品信息集合
session.setAttribute("goodsList",goodsList);
//登陸成功，跳轉(zhuǎn)到主頁
resp.sendRedirect("zhuye.jsp");//跳轉(zhuǎn)到指定頁面
}
}
主頁代碼?
<%@ page import="java.util.List" %>
<%@ page import="com.shi.bean.Goods" %><%--
Created by IntelliJ IDEA.
User: ss
Date: 2023/2/20
Time: 14:46
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!--導(dǎo)入JSTL的核心類庫-->
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>主頁</title>
</head>
<body>
<h2>歡迎來自${user.address}的${user.username}訪問項目主頁</h2>
<a href="addGoods.jsp">添加商品</a>
<table>
<thead>
<tr>
<th>商品編號</th>
<th>商品名稱</th>
<th>商品價格</th>
<th>商品說明</th>
</tr>
</thead>
<tbody id="list">
<!--items:要遍歷的集合對象（寫EL表達式）-->
<c:forEach items="${goodsList}" var="goods">
<tr>
<td>${goods.gid}</td>
<td>${goods.gname}</td>
<td>${goods.price}</td>
<td>${goods.mark}</td>
<td>
<a href="findById?gid=${goods.gid}">修改</a>
<a href="dell?gid=${goods.gid}">刪除</a>
</td>
</tr>
</c:forEach>
</tbody>
</table>
</body>
</html>
返回到登錄頁面登錄商品頁面
?商品添加
添加時跳轉(zhuǎn)的頁面，代碼如下
<%--
Created by IntelliJ IDEA.
User: ss
Date: 2023/2/24
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>
</head>
<body>
<h2>商品信息錄入</h2>
<form action="addGoods" method="post">
商品名稱：<input type="text"name="gname" value="" placeholder="商品名稱"><br/>
商品價格：<input type="number" step="0.01" name="price" value="" placeholder="商品價格"><br/>
商品說明：<input type="textr" name="mark" value="" placeholder="商品說明"><br/>
<input type="submit" value="添加">
</form>
</body>
</html>
效果如圖
?功能代碼
package com.shi.servlet;
import com.shi.bean.Goods;
import com.shi.dao.GoodsDao;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/addGoods")
public class AddGoods extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("UTF-8");
resp.setCharacterEncoding("UTF-8");
Goods goods=new Goods();
goods.setGname(req.getParameter("gname"));
goods.setPrice(Double.parseDouble(req.getParameter("price"))); //獲取字符串數(shù)字轉(zhuǎn)化為double數(shù)據(jù)
goods.setMark(req.getParameter("mark"));
GoodsDao goodsDao=new GoodsDao();
int row=goodsDao.add(goods);
if (row>0){
req.getRequestDispatcher("selectAllGoods").forward(req,resp);
}else {
req.setAttribute("error_msg","添加商品信息失??！");
req.getRequestDispatcher("error.jsp").forward(req,resp);
}
}
}
?商品修改
頁面代碼如下
<%--
Created by IntelliJ IDEA.
User: \ss
Date: 2023/2/25
Time: 15:14
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="updateGoods" method="post">
商品編號：<input type="text"name="gid" value="${goods.gid}" placeholder="商品編號" readonly="readonly"><br/>
商品名稱：<input type="text"name="gname" value="${goods.gname}" placeholder="商品名稱"><br/>
商品價格：<input type="number" step="0.01" name="price" value="${goods.price}" placeholder="商品價格"><br/>
商品說明：<input type="textr" name="mark" value="${goods.mark}" placeholder="商品說明"><br/>
<input type="submit" value="修改">
</form>
</body>
</html>
?獲取當前點擊修改商品信息的id，向頁面?zhèn)鬏攊d
package com.shi.servlet;
import com.shi.bean.Goods;
import com.shi.dao.GoodsDao;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
@WebServlet("/findById")
public class FindGoodsById extends HttpServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
int gid=Integer.parseInt(request.getParameter("gid"));
//根據(jù)gid查詢商品信息
GoodsDao goodsDao=new GoodsDao();
Goods goods = goodsDao.selectById(gid);
if (goods!=null){
//把數(shù)據(jù)存儲到request域?qū)ο笾?，然后請求轉(zhuǎn)發(fā)到頁面
request.setAttribute("goods",goods);
request.getRequestDispatcher("showGoods.jsp").forward(request,response);
}else {
//登陸失敗，跳轉(zhuǎn)到錯誤頁面
request.setAttribute("error_msg","修改頁面出現(xiàn)異常！");
request.getRequestDispatcher("error.jsp").forward(request,response);
}
}
}
實現(xiàn)代碼如下
package com.shi.servlet;
import com.shi.bean.Goods;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/updateGoods")
public class UpdateGoods extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setCharacterEncoding("utf-8");
//獲取表單去哦那個球的數(shù)據(jù)，封裝到goods對象中
Goods goods=new Goods();
goods.setGid(Integer.parseInt(req.getParameter("gid")));
goods.setGname(req.getParameter("gname"));
goods.setPrice(Double.parseDouble(req.getParameter("price")));
goods.setMark(req.getParameter("mark"));
System.out.println(goods);
}
}
?邏輯代碼
public int add(Goods goods) {
try {
Class.forName(jdbcDriver);
con = DriverManager.getConnection(jdbcUrl, jdbcUser, jdbcPwd);
String sql = "insert into t_goods(gname,price,mark) values(?,?,?)";
pstm = con.prepareStatement(sql);
pstm.setObject(1, goods.getGname());
pstm.setObject(2, goods.getPrice());
pstm.setObject(3, goods.getMark());
row = pstm.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
try {
if (rs != null) {
rs.close();
}
if (pstm != null) {
rs.close();
}
if (con != null) {
rs.close();
}
} catch (Exception e) {
e.printStackTrace();
}
return row;
}商品刪除
也是獲取當前商品id，根據(jù)id進行修改操作
GoodsDao邏輯代碼文章來源：http://www.zghlxwxcb.cn/news/detail-502556.html
public int deleteById(int gid) {
try {
Class.forName(jdbcDriver);
con = DriverManager.getConnection(jdbcUrl, jdbcUser, jdbcPwd);
String sql = "delete from t_goods where gid=?";
pstm = con.prepareStatement(sql);
pstm.setObject(1, gid);
row=pstm.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
} catch (Exception e) {
e.printStackTrace();
}
}
return row;
}select實現(xiàn)功能代碼文章來源地址http://www.zghlxwxcb.cn/news/detail-502556.html
package com.shi.servlet;
import com.shi.dao.GoodsDao;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/dell")
public class DellGoods extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
int gid=Integer.parseInt(req.getParameter("gid"));
//根據(jù)id執(zhí)行數(shù)據(jù)庫的刪除
GoodsDao goodsDao=new GoodsDao();
int row=goodsDao.deleteById(gid);
if (row>0){
req.getRequestDispatcher("selectAllGoods").forward(req,resp);
}else {
//請求轉(zhuǎn)發(fā)，查詢所有商品信息（刷新）
req.setAttribute("error_msg","刪除出現(xiàn)了問題！");
req.getRequestDispatcher("error.jsp").forward(req,resp);
}
}
}
到了這里，關(guān)于JavaWeb項目----實現(xiàn)用戶登錄、注冊、對商品信息進行的添加、刪除、修改功能的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
