AI 助理
文档备案控制台
开发者社区 开发与运维 文章 正文

第五阶段淘宝项目java+html+mysql（一）

2023-02-15 269
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
本文涉及的产品
RDS AI 助手，专业版
RDS MySQL DuckDB 分析主实例，集群系列 4核8GB
RDS DuckDB + QuickBI 企业套餐，8核32GB + QuickBI 专业版
简介： 第五阶段淘宝项目java+html+mysql

文章目录


代码展示

Dao层实现

UserDaoImpl

IUserDao

ShoppingDaoImpl

Dao层接口

Service层接口

IShoppingService

Service层实现

UserServiceImpl

ShoppingServiceImpl

实体层

User

Shoping

Controller层

ChangeServlet

ClearServlet

CommodityServlet

DeletServlet

InsertUserServlet

LogoutServlet

QueryServlet

RegisterServlet

UpdatenumServlet

前端html

change.jsp

commod.jsp

delete.jsp

enter.jsp

index.jsp

login.jsp

logout.jsp

panduan.jsp

panduan1.jsp

panduan2.jsp

panduan3.jsp

panduan4.jsp

shopping.jsp

css


代码展示


Dao层实现


UserDaoImpl


package org.lyl.taobao.dao.impl;
import org.lyl.taobao.api.entity.Shoping;
import org.lyl.taobao.api.entity.User;
import org.lyl.taobao.dao.IUserDao;
import java.sql.*;
public class UserDaoImpl implements IUserDao {
    @Override
    public boolean insertUser(User user) throws SQLException {
        boolean x = true;
        Connection conn = null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/runoob","root","asd.123");
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
        String sql = "insert into user values(null,?,?,?)";
        String sql1 = "select * from user";
        java.sql.Statement st = conn.createStatement();
        ResultSet rs = st.executeQuery(sql1);
        while (rs.next()) {
            String name = rs.getString("uername");
            if (name.equals(user.getUserName())) {
                x = false;
            }
        }
        if (x==true) {
            PreparedStatement pst = null;
            pst = conn.prepareStatement(sql);
            pst.setString(1, user.getUserName());
            pst.setString(2, user.getUserPassword());
            pst.setString(3, user.getPhone());
            int len = pst.executeUpdate();
            if (len>0){
                return true;
            }
        }
        return false;
    }
    @Override
    public boolean change(User user) throws ClassNotFoundException {
        Class.forName("com.mysql.cj.jdbc.Driver");
        try {
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/runoob", "root", "asd.123");
            String sql = "select * from user";
            Statement st = conn.createStatement();
            ResultSet rs = st.executeQuery(sql);
            while (rs.next()){
                String name = rs.getString("uername");
                String phone = rs.getString("phone");
                if (name.equals(user.getUserName())&&phone.equals(user.getPhone())){
                    String sql1 = "UPDATE user SET PASSWORD=? WHERE uername=?";
                    PreparedStatement ps = conn.prepareStatement(sql1);
                    ps.setString(1,user.getUserPassword());
                    ps.setString(2,user.getUserName());
                    ps.execute();
                    return true;
                }
            }
        } catch (Exception e ) {
            e.printStackTrace();
            return false;
        }
        return false;
    }
    public static int uid;
    @Override
    public boolean register(User user) {
        try {
            Shoping shoping = new Shoping();
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/runoob","root","asd.123");
            String sql = "select * from user";
            java.sql.Statement st = conn.createStatement();
            ResultSet rs = st.executeQuery(sql);
            while (rs.next()){
                String paw = rs.getString("password");
                String name = rs.getString("uername");
                int id = rs.getInt("id");
                if (paw.equals(user.getUserPassword())&&name.equals(user.getUserName())){
                   uid = id;
                    return true;
                }
            }
            rs.close();
            st.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return false;
    }
    @Override
    public boolean delete(User user) {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/runoob","root","asd.123");
            String sql = "delete from user where uername=?";
            String sql1 = "select * from user";
            String sql2 = "delete from shopping where uid=?";
            java.sql.Statement st = conn.createStatement();
            ResultSet rs = st.executeQuery(sql1);
            PreparedStatement pr = conn.prepareStatement(sql);
            PreparedStatement pr1 = conn.prepareStatement(sql2);
            while (rs.next()){
                String name = rs.getString("uername");
                String password = rs.getString("password");
                if (name.equals(user.getUserName())&&password.equals(user.getUserPassword())) {
                    pr.setString(1,name);
                    pr1.setInt(1,uid);
                    pr.execute();
                    pr1.execute();
                    return true;
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        }
        return false;
    }
}

IUserDao


package org.lyl.taobao.dao;
import org.lyl.taobao.api.entity.User;
import java.sql.SQLException;
public interface IUserDao {
    boolean insertUser(User user) throws SQLException;
    boolean change(User user) throws ClassNotFoundException;
    boolean register(User user);
    boolean delete(User user);
}

ShoppingDaoImpl


package org.lyl.taobao.dao.impl;
import org.lyl.taobao.api.entity.Shoping;
import org.lyl.taobao.dao.IShoppingDao;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class ShoppingDaoImpl implements IShoppingDao {
    @Override
    public boolean commodity(Shoping shoping) {
        boolean z = false;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/runoob","root","asd.123");
            String sql = "insert into shopping values(null,?,?,?,?,?)";
            String sql1 = "select * from shopping";
            String sql2 = "update shopping set num = ? where name = ?";
            PreparedStatement pst = conn.prepareStatement(sql);
            Statement st = conn.createStatement();
            ResultSet rs = st.executeQuery(sql1);
            while (rs.next()) {
                String name = rs.getString("name");
                int uid = rs.getInt("uid");
                int num = rs.getInt("num");
                if (name.equals(shoping.getName())&&uid==UserDaoImpl.uid){
                    num ++;
                    PreparedStatement ps = conn.prepareStatement(sql2);
                    ps.setInt(1,num);
                    ps.setString(2,shoping.getName());
                    ps.execute();
                    z = true;
                    return true;
                }
            }
            if (z!=true){
                pst.setString(1,shoping.getName());
                pst.setString(2,shoping.getInformation());
                pst.setInt(3,shoping.getPrice());
                pst.setInt(4,shoping.getNum());
                pst.setInt(5,UserDaoImpl.uid);
            }
            int len = pst.executeUpdate();
            if (len>0){
                return true;
            }
            pst.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        }
        return false;
    }
    public static int x = 0;
    @Override
    public List<Shoping> query() {
//        ArrayList<String> list = new ArrayList<>();
        List<Shoping> list = new ArrayList<>();
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/runoob","root","asd.123");
            String sql = "select * from shopping";
            java.sql.Statement st = conn.createStatement();
            ResultSet rs = st.executeQuery(sql);
            while (rs.next()){
                int uid = rs.getInt("uid");
                if (uid==UserDaoImpl.uid){
                    int id = rs.getInt("id");
                    String name = rs.getString("name");
                    String information = rs.getString("information");
                    int price = rs.getInt("price");
                    int num = rs.getInt("num");
//                    String info = "商品名：" + name+"  |  " + "商品信息：" + information +"  |  "+ "价格：" + price +"  |  "+"数量："+num;
//                    list.add(info);
                    Shoping shoping = new Shoping(id,name,information,price,num);
                    list.add(shoping);
                    x += price*num;
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return list;
    }
//    @Override
//    public List queryid() {
//        ArrayList<Integer> list = new ArrayList<>();
//        try {
//            Class.forName("com.mysql.cj.jdbc.Driver");
//            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/runoob","root","asd.123");
//            String sql = "select * from shopping";
//            java.sql.Statement st = conn.createStatement();
//            ResultSet rs = st.executeQuery(sql);
//            while (rs.next()){
//                int uid = rs.getInt("uid");
//                if (uid==UserDaoImpl.uid){
//                    int id = rs.getInt("id");
//                    list.add(id);
//                }
//            }
//        } catch (Exception e) {
//            e.printStackTrace();
//        }
//        return list;
//    }
    @Override
    public boolean delet(Shoping shoping) {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/runoob","root","asd.123");
            String sql = "delete from shopping where id=?";
            String sql1 = "select * from shopping";
            java.sql.Statement st = conn.createStatement();
            ResultSet rs = st.executeQuery(sql1);
            PreparedStatement pr = conn.prepareStatement(sql);
            while (rs.next()){
                int id = rs.getInt("id");
                int uid = rs.getInt("uid");
                if (shoping.getId()==id&&uid==UserDaoImpl.uid) {
                    pr.setInt(1,id);
                    pr.execute();
                    return true;
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        }
        return false;
    }
    @Override
    public boolean clear(Shoping shoping) {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/runoob","root","asd.123");
            String sql = "delete from shopping where uid =?";
            String sql1 = "select * from shopping";
            PreparedStatement pr = conn.prepareStatement(sql);
            java.sql.Statement st = conn.createStatement();
            ResultSet rs = st.executeQuery(sql1);
            while (rs.next()){
                int uid = rs.getInt("uid");
                if (UserDaoImpl.uid==uid) {
                    pr.setInt(1,uid);
                    pr.execute();
                    return true;
                }
            }
            pr.execute();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return true;
    }
    @Override
    public boolean update(Shoping shoping) {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/runoob","root","asd.123");
            String sql1 = "select * from shopping";
            String sql2 = "update shopping set num = ? where id = ?";
            Statement st = conn.createStatement();
            ResultSet rs = st.executeQuery(sql1);
            while (rs.next()){
                int id = rs.getInt("id");
                int uid = rs.getInt("uid");
                int num = rs.getInt("num");
                if (id==shoping.getId()&&uid==UserDaoImpl.uid){
                    num--;
                    if (num==0){
                        return false;
                    }else {
                        PreparedStatement ps = conn.prepareStatement(sql2);
                        ps.setInt(1, num);
                        ps.setInt(2, id);
                        ps.execute();
                    }
                }
            }
            rs.close();
            st.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return true;
    }
}

Dao层接口


package org.lyl.taobao.dao;
import org.lyl.taobao.api.entity.Shoping;
import java.util.List;
public interface IShoppingDao {
    boolean commodity(Shoping shoping);
    List<Shoping> query();
//    List queryid();
    boolean delet(Shoping shoping);
    boolean clear(Shoping shoping);
    boolean update(Shoping shoping);
}

Service层接口


package org.lyl.taobao.api;
import org.lyl.taobao.api.entity.User;
import java.sql.SQLException;
public interface IUserService {
    boolean insertUser(User user) throws SQLException;
    boolean change(User user) throws ClassNotFoundException;
    boolean register(User user);
    boolean delete (User user);
}

IShoppingService


package org.lyl.taobao.api;
import org.lyl.taobao.api.entity.Shoping;
import java.util.List;
public interface IShoppingService {
    boolean commodity(Shoping shoping);
    List<Shoping> query();
    boolean delet(Shoping shoping);
    boolean clear(Shoping shoping);
    boolean update(Shoping shoping);
}


Service层实现


UserServiceImpl


package org.lyl.taobao.service;
import org.lyl.taobao.api.IUserService;
import org.lyl.taobao.api.entity.User;
import org.lyl.taobao.dao.IUserDao;
import org.lyl.taobao.dao.impl.UserDaoImpl;
import java.sql.SQLException;
public class UserServiceImpl implements IUserService {
    @Override
    public boolean insertUser(User user) throws SQLException {
        IUserDao iUserDao = new UserDaoImpl();
        return iUserDao.insertUser(user);
    }
    @Override
    public boolean change(User user) throws ClassNotFoundException {
        IUserDao iUserDao = new UserDaoImpl();
        return iUserDao.change(user);
    }
    @Override
    public boolean register(User user) {
        IUserDao iUserDao = new UserDaoImpl();
        return iUserDao.register(user);
    }
    @Override
    public boolean delete(User user) {
        IUserDao iUserDao = new UserDaoImpl();
        return iUserDao.delete(user);
    }
}

ShoppingServiceImpl


package org.lyl.taobao.service;
import org.lyl.taobao.api.IShoppingService;
import org.lyl.taobao.api.entity.Shoping;
import org.lyl.taobao.dao.IShoppingDao;
import org.lyl.taobao.dao.impl.ShoppingDaoImpl;
import java.util.List;
public class ShoppingServiceImpl implements IShoppingService {
    @Override
    public boolean commodity(Shoping shoping) {
        IShoppingDao iShoppingDao = new ShoppingDaoImpl();
       return iShoppingDao.commodity(shoping);
    }
    @Override
    public List<Shoping> query() {
        IShoppingDao iShoppingDao = new ShoppingDaoImpl();
        return iShoppingDao.query();
    }
    @Override
    public boolean delet(Shoping shoping) {
        IShoppingDao iShoppingDao = new ShoppingDaoImpl();
        return iShoppingDao.delet(shoping);
    }
    @Override
    public boolean clear(Shoping shoping) {
        IShoppingDao iShoppingDao = new ShoppingDaoImpl();
        return iShoppingDao.clear(shoping);
    }
    @Override
    public boolean update(Shoping shoping) {
        IShoppingDao iShoppingDao = new ShoppingDaoImpl();
        return iShoppingDao.update(shoping);
    }
}


实体层


User


package org.lyl.taobao.api.entity;
public class User {
    private String userName;
    private String userPassword;
    private String phone;
    /**
     * 用户注册和修改密码
     * @param userName
     * @param userPassword
     * @param phone
     */
    public User(String userName, String userPassword, String phone) {
        this.userName = userName;
        this.userPassword = userPassword;
        this.phone = phone;
    }
    /**
     * 用户登录
     * @param userName
     * @param userPassword
     */
    public User(String userName, String userPassword) {
        this.userName = userName;
        this.userPassword = userPassword;
    }
    public String getUserName() {
        return userName;
    }
    public String getPhone() {
        return phone;
    }
    public String getUserPassword() {
        return userPassword;
    }
    @Override
    public String toString() {
        return "User{" +
                "userName='" + userName + '\'' +
                ", userPassword='" + userPassword + '\'' +
                ", phone=" + phone +
                '}';
    }
}

Shoping


package org.lyl.taobao.api.entity;
public class Shoping {
    private  int id;
    private String name;
    private String information;
    private int price;
    private int num;
    private int uid;
    public Shoping() {
    }
    public Shoping(String name, String information, int price, int num) {
        this.name = name;
        this.information = information;
        this.price = price;
        this.num = num;
    }
    public Shoping(String name, String information, int price) {
        this.name = name;
        this.information = information;
        this.price = price;
    }
    public Shoping(int id) {
        this.id = id;
    }
    public Shoping(int id, String name, String information, int price, int num) {
        this.id = id;
        this.name = name;
        this.information = information;
        this.price = price;
        this.num = num;
    }
    public int getId() {
        return id;
    }
    public String getName() {
        return name;
    }
    public String getInformation() {
        return information;
    }
    public int getPrice() {
        return price;
    }
    public int getNum() {
        return num;
    }
    public int getUid() {
        return uid;
    }
    public void setUid(int uid) {
        this.uid = uid;
    }
    @Override
    public String toString() {
        return "Shooping{" +
                "name='" + name + '\'' +
                ", information='" + information + '\'' +
                ", price=" + price +
                ", num=" + num +
                '}';
    }
}

Controller层


ChangeServlet


package org.lyl.taobao.controller;
import lombok.SneakyThrows;
import org.lyl.taobao.api.IUserService;
import org.lyl.taobao.api.entity.User;
import org.lyl.taobao.service.UserServiceImpl;
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("/change")
public class ChangeServlet extends HttpServlet {
    static boolean x ;
    @SneakyThrows
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;utf-8");
        String name = req.getParameter("uname");
        String paw = req.getParameter("upaw");
        String num = req.getParameter("phone");
         if (name==""||paw==""||num==""){
             req.setAttribute("msg","输入的值不能为空！！！");
             req.getRequestDispatcher("change.jsp").forward(req,resp);
         }else {
             User user1 = new User(name,paw,num);
             IUserService iUserService = new UserServiceImpl();
             x = iUserService.change(user1);
             resp.sendRedirect("panduan1.jsp");
         }
    }
    public static boolean x() {
        return x;
    }
}

ClearServlet


package org.lyl.taobao.controller;
import org.lyl.taobao.api.IShoppingService;
import org.lyl.taobao.api.entity.Shoping;
import org.lyl.taobao.service.ShoppingServiceImpl;
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("/clear")
public class ClearServlet extends HttpServlet {
    public static boolean x;
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;utf-8");
        Shoping shoping = new Shoping();
        IShoppingService iShoppingService = new ShoppingServiceImpl();
         x = iShoppingService.clear(shoping);
        if (x){
            resp.sendRedirect("shopping.jsp");
        }
    }
}

CommodityServlet


package org.lyl.taobao.controller;
import org.lyl.taobao.api.IShoppingService;
import org.lyl.taobao.api.entity.Shoping;
import org.lyl.taobao.service.ShoppingServiceImpl;
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("/com")
public class CommodityServlet extends HttpServlet {
    static boolean x;
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        resp.setContentType("text/html;utf-8");
        String name = req.getParameter("names");
        String information = req.getParameter("informations");
        int price = Integer.parseInt(req.getParameter("prices"));
        int num = Integer.parseInt(req.getParameter("num"));
        Shoping shoping1 = new Shoping(name,information,price,num);
        IShoppingService iShoppingService = new ShoppingServiceImpl();
         x = iShoppingService.commodity(shoping1);
         resp.sendRedirect("panduan3.jsp");
    }
    public static boolean x(){
        return x;
    }
}

DeletServlet


package org.lyl.taobao.controller;
import org.lyl.taobao.api.IShoppingService;
import org.lyl.taobao.api.entity.Shoping;
import org.lyl.taobao.service.ShoppingServiceImpl;
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("/del")
public class DeletServlet extends HttpServlet {
    static boolean x;
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        resp.setContentType("text/html;utf-8");
        int id = Integer.parseInt(req.getParameter("id"));
        Shoping shoping = new Shoping(id);
        IShoppingService iShoppingService = new ShoppingServiceImpl();
         x =iShoppingService.delet(shoping);
         resp.sendRedirect("panduan2.jsp");
    }
    public static boolean x(){
        return x;
    }
}

InsertUserServlet


package org.lyl.taobao.controller;
import org.lyl.taobao.api.IUserService;
import org.lyl.taobao.api.entity.User;
import org.lyl.taobao.service.UserServiceImpl;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
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;
@WebServlet("/insertUser")
public class InsertUserServlet extends HttpServlet {
    static boolean x;
    @lombok.SneakyThrows
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;utf-8");
        String name = req.getParameter("names");
        String paw = req.getParameter("paw");
        String num = req.getParameter("num");
        if (name==""||paw==""||num==""){
            req.setAttribute("msg","输入的值不能为空！！！");
            req.getRequestDispatcher("login.jsp").forward(req,resp);
        }else {
            User user = new User(name,paw,num);
            IUserService iUserService = new UserServiceImpl();
            x = iUserService.insertUser(user);
            resp.sendRedirect("panduan4.jsp");
        }
    }
    public static boolean x() {
        return x;
    }
}

LogoutServlet


package org.lyl.taobao.controller;
import org.lyl.taobao.api.IUserService;
import org.lyl.taobao.api.entity.User;
import org.lyl.taobao.service.UserServiceImpl;
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("/lout")
public class LogoutServlet extends HttpServlet {
    public static boolean x;
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        resp.setContentType("text/html;utf-8");
        String password = req.getParameter("password");
        User user = new User(RegisterServlet.name1,password);
        IUserService iUserService = new UserServiceImpl();
         x = iUserService.delete(user);
        if (x){
            resp.sendRedirect("index.jsp");
        }else {
            req.setAttribute("msg","密码错误，注销失败！！！");
            req.getRequestDispatcher("logout.jsp").forward(req,resp);
        }
    }
}

QueryServlet


package org.lyl.taobao.controller;
import org.lyl.taobao.api.IShoppingService;
import org.lyl.taobao.api.entity.Shoping;
import org.lyl.taobao.service.ShoppingServiceImpl;
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("/que")
public class QueryServlet extends HttpServlet {
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        resp.setContentType("text/html;utf-8");
        HttpSession session = req.getSession();
        IShoppingService iShoppingService = new ShoppingServiceImpl();
        List<Shoping> shopings = iShoppingService.query();
        session.setAttribute("shop",shopings);
        resp.sendRedirect("shopping.jsp");
    }
//    public static List list(){
//        Shoping shoping = new Shoping();
//        IShoppingService iShoppingService = new ShoppingServiceImpl();
//        return iShoppingService.query(shoping);
//    }
}


文章标签：
云数据库 RDS MySQL 版
前端开发
关键词：
Java项目
Java MYSQL
项目HTML
云数据库 RDS MySQL 版项目
云数据库 RDS MySQL 版java
相关实践学习
每个IT人都想学的“Web应用上云经典架构”实战
本实验从Web应用上云这个最基本的、最普遍的需求出发，帮助IT从业者们通过“阿里云Web应用上云解决方案”，了解一个企业级Web应用上云的常见架构，了解如何构建一个高可用、可扩展的企业级应用架构。
MySQL数据库入门学习
本课程通过最流行的开源数据库MySQL带你了解数据库的世界。 &nbsp; 相关的阿里云产品：云数据库RDS MySQL 版 阿里云关系型数据库RDS（Relational Database Service）是一种稳定可靠、可弹性伸缩的在线数据库服务，提供容灾、备份、恢复、迁移等方面的全套解决方案，彻底解决数据库运维的烦恼。 了解产品详情:&nbsp;https://www.aliyun.com/product/rds/mysql&nbsp;
允诺@晴天
目录
相关文章
啦啦啦191
|
8月前
|
安全 Java API
Java Web 在线商城项目最新技术实操指南帮助开发者高效完成商城项目开发
本项目基于Spring Boot 3.2与Vue 3构建现代化在线商城，涵盖技术选型、核心功能实现、安全控制与容器化部署，助开发者掌握最新Java Web全栈开发实践。
啦啦啦191
780 1
啦啦啦191
|
9月前
|
前端开发 Java API
2025 年 Java 全栈从环境搭建到项目上线实操全流程指南：Java 全栈最新实操指南（2025 版）
本指南涵盖2025年Java全栈开发核心技术，从JDK 21环境搭建、Spring Boot 3.3实战、React前端集成到Docker容器化部署，结合最新特性与实操流程，助力构建高效企业级应用。
啦啦啦191
2935 1
南瓜佬
|
8月前
|
IDE 安全 Java
Lombok 在企业级 Java 项目中的隐性成本：便利背后的取舍之道
Lombok虽能简化Java代码，但其“魔法”特性易破坏封装、影响可维护性，隐藏调试难题，且与JPA等框架存在兼容风险。企业级项目应优先考虑IDE生成、Java Records或MapStruct等更透明、稳健的替代方案，平衡开发效率与系统长期稳定性。
南瓜佬
531 115
啦啦啦191
|
9月前
|
JavaScript Java 微服务
现代化 Java Web 在线商城项目技术方案与实战开发流程及核心功能实现详解
本项目基于Spring Boot 3与Vue 3构建现代化在线商城系统，采用微服务架构，整合Spring Cloud、Redis、MySQL等技术，涵盖用户认证、商品管理、购物车功能，并支持Docker容器化部署与Kubernetes编排。提供完整CI/CD流程，助力高效开发与扩展。
啦啦啦191
1053 64
蓝易云
|
8月前
|
SQL Java 关系型数据库
Java连接MySQL数据库环境设置指南
请注意，在实际部署时应该避免将敏感信息（如用户名和密码）硬编码在源码文件里面；应该使用配置文件或者环境变量等更为安全可靠地方式管理这些信息。此外，在处理大量数据时考虑使用PreparedStatement而不是Statement可以提高性能并防止SQL注入攻击；同时也要注意正确处理异常情况，并且确保所有打开过得资源都被正确关闭释放掉以防止内存泄漏等问题发生。
蓝易云
398 13
游客4v3gpgavlizks
|
8月前
|
存储 小程序 Java
热门小程序源码合集：微信抖音小程序源码支持PHP/Java/uni-app完整项目实践指南
小程序已成为企业获客与开发者创业的重要载体。本文详解PHP、Java、uni-app三大技术栈在电商、工具、服务类小程序中的源码应用，提供从开发到部署的全流程指南，并分享选型避坑与商业化落地策略，助力开发者高效构建稳定可扩展项目。
游客4v3gpgavlizks
1960 0
啦啦啦191
|
10月前
|
安全 JavaScript Java
java Web 项目完整案例实操指南包含从搭建到部署的详细步骤及热门长尾关键词解析的实操指南
本项目为一个完整的JavaWeb应用案例，采用Spring Boot 3、Vue 3、MySQL、Redis等最新技术栈，涵盖前后端分离架构设计、RESTful API开发、JWT安全认证、Docker容器化部署等内容，适合掌握企业级Web项目全流程开发与部署。
啦啦啦191
913 0
扬仔8888
|
关系型数据库 MySQL Perl
用sed语法将pt-query-digest分析的mysql慢查询转换成html页面，简单转换但是看着方便多了
扬仔8888
2697 0
游客ib7xsk7hcucuo
|
11月前
|
存储 前端开发 JavaScript
仿真银行app下载安装， 银行卡虚拟余额制作app，用html+css+js实现逼真娱乐工具
这是一个简单的银行账户模拟器项目，用于学习前端开发基础。用户可进行存款、取款操作，所有数据存储于浏览器内存中
游客ib7xsk7hcucuo
3062 4
卓伊凡
|
人工智能 程序员 UED
【01】完成新年倒计时页面-蛇年新年快乐倒计时领取礼物放烟花html代码优雅草科技央千澈写采用html5+div+CSS+JavaScript-优雅草卓伊凡-做一条关于新年的代码分享给你们-为了C站的分拼一下子
【01】完成新年倒计时页面-蛇年新年快乐倒计时领取礼物放烟花html代码优雅草科技央千澈写采用html5+div+CSS+JavaScript-优雅草卓伊凡-做一条关于新年的代码分享给你们-为了C站的分拼一下子
卓伊凡
868 21
【01】完成新年倒计时页面-蛇年新年快乐倒计时领取礼物放烟花html代码优雅草科技央千澈写采用html5+div+CSS+JavaScript-优雅草卓伊凡-做一条关于新年的代码分享给你们-为了C站的分拼一下子

热门文章

最新文章

  • 1
    阿里云DTS踩坑经验分享系列｜如何使用DTS进行MySQL->ClickHouse同步
  • 2
    MySQL · 引擎特性 · InnoDB redo log漫游
  • 3
    MySQL高级篇——MVCC多版本并发控制
  • 4
    IDEA使用C3P0连接Mysql数据库
  • 5
    MySQL总结-3
  • 6
    MySQL 存储过程探秘
  • 7
    PHP调用MYSQL存储过程实例
  • 8
    你有这么高效的MySQL版本号排序，记住我给出的原理
  • 9
    【Mysql实战】问题分析利器之binlog
  • 10
    MySQL Like模糊查询速度太慢如何进行优化
  • 1
    Java 设计模式之策略模式：灵活切换算法的艺术
    2053
  • 2
    Java 设计模式之观察者模式：构建松耦合的事件响应系统
    585
  • 3
    Java 设计模式之状态模式：让对象的行为随状态优雅变化
    984
  • 4
    java零基础学习者入门课程
    653
  • 5
    Java 设计模式之责任链模式：优雅处理请求的艺术
    817
  • 6
    【Azure Storage Account】Java Code访问Storage Account File Share的上传和下载代码示例
    522
  • 7
    百宝箱开放平台 ✖️ Java SDK
    1653
  • 8
    《深入理解Spring》：现代Java开发的核心框架
    1013
  • 9
    用Java语言实现一个自定义的ArrayList类
    344
  • 10
    从混沌到秩序：Java共享内存模型如何通过显式约束驯服并发？
    236

    • 相关课程

    更多
  • MySQL企业常见架构与调优经验分享
  • 阿里云云原生数据仓库AnalyticDB MySQL版 使用教程
  • MySQL实战进阶
  • 阿里云数据库产品家族及特性
  • 数据库及SQL/MySQL基础
  • 云数据库MySQL快速入门

    • 相关电子书

    更多
  • 《零基础HTML入门教程》
  • 天猫 HTML5 互动技术实践
  • 天猫HTML5互动技术实践

    • 推荐镜像

    更多
  • mysql
    • 下一篇
    阿里云正式发布 Agentic 代码安全：AI驱动的双Agent协同引擎