第五阶段淘宝项目java+html+mysql(一)

本文涉及的产品
RDS MySQL Serverless 基础系列,0.5-2RCU 50GB
云数据库 RDS MySQL,高可用系列 2核4GB
RDS MySQL Serverless 高可用系列,价值2615元额度,1个月
简介: 第五阶段淘宝项目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);
//    }
}


相关实践学习
每个IT人都想学的“Web应用上云经典架构”实战
本实验从Web应用上云这个最基本的、最普遍的需求出发,帮助IT从业者们通过“阿里云Web应用上云解决方案”,了解一个企业级Web应用上云的常见架构,了解如何构建一个高可用、可扩展的企业级应用架构。
MySQL数据库入门学习
本课程通过最流行的开源数据库MySQL带你了解数据库的世界。 &nbsp; 相关的阿里云产品:云数据库RDS MySQL 版 阿里云关系型数据库RDS(Relational Database Service)是一种稳定可靠、可弹性伸缩的在线数据库服务,提供容灾、备份、恢复、迁移等方面的全套解决方案,彻底解决数据库运维的烦恼。 了解产品详情:&nbsp;https://www.aliyun.com/product/rds/mysql&nbsp;
相关文章
|
5月前
|
负载均衡 算法 关系型数据库
大数据大厂之MySQL数据库课程设计:揭秘MySQL集群架构负载均衡核心算法:从理论到Java代码实战,让你的数据库性能飙升!
本文聚焦 MySQL 集群架构中的负载均衡算法,阐述其重要性。详细介绍轮询、加权轮询、最少连接、加权最少连接、随机、源地址哈希等常用算法,分析各自优缺点及适用场景。并提供 Java 语言代码实现示例,助力直观理解。文章结构清晰,语言通俗易懂,对理解和应用负载均衡算法具有实用价值和参考价值。
大数据大厂之MySQL数据库课程设计:揭秘MySQL集群架构负载均衡核心算法:从理论到Java代码实战,让你的数据库性能飙升!
|
1月前
|
SQL Java 关系型数据库
Java连接MySQL数据库环境设置指南
请注意,在实际部署时应该避免将敏感信息(如用户名和密码)硬编码在源码文件里面;应该使用配置文件或者环境变量等更为安全可靠地方式管理这些信息。此外,在处理大量数据时考虑使用PreparedStatement而不是Statement可以提高性能并防止SQL注入攻击;同时也要注意正确处理异常情况,并且确保所有打开过得资源都被正确关闭释放掉以防止内存泄漏等问题发生。
72 13
|
8月前
|
存储 Java 关系型数据库
java调用mysql存储过程
在 Java 中调用 MySQL 存储过程主要借助 JDBC(Java Database Connectivity)。其核心原理是通过 JDBC 与 MySQL 建立连接,调用存储过程并处理结果。具体步骤包括:加载 JDBC 驱动、建立数据库连接、创建 CallableStatement 对象、设置存储过程参数并执行调用。此过程实现了 Java 程序与 MySQL 数据库的高效交互。
|
3月前
|
人工智能 Java 关系型数据库
Java的时间处理与Mysql的时间查询
本文总结了Java中时间与日历的常用操作,包括时间的转换、格式化、日期加减及比较,并介绍了MySQL中按天、周、月、季度和年进行时间范围查询的方法,适用于日常开发中的时间处理需求。
|
8月前
|
人工智能 JavaScript 关系型数据库
【02】Java+若依+vue.js技术栈实现钱包积分管理系统项目-商业级电玩城积分系统商业项目实战-ui设计图figmaUI设计准备-figma汉化插件-mysql数据库设计-优雅草卓伊凡商业项目实战
【02】Java+若依+vue.js技术栈实现钱包积分管理系统项目-商业级电玩城积分系统商业项目实战-ui设计图figmaUI设计准备-figma汉化插件-mysql数据库设计-优雅草卓伊凡商业项目实战
253 14
【02】Java+若依+vue.js技术栈实现钱包积分管理系统项目-商业级电玩城积分系统商业项目实战-ui设计图figmaUI设计准备-figma汉化插件-mysql数据库设计-优雅草卓伊凡商业项目实战
|
9月前
|
自然语言处理 Java 关系型数据库
Java mysql根据很长的富文本如何自动获取简介
通过使用Jsoup解析富文本并提取纯文本,然后根据需要生成简介,可以有效地处理和展示长文本内容。该方法简单高效,适用于各种应用场景。希望本文对您在Java中处理富文本并生成简介的需求提供实用的指导和帮助。
134 9
|
10月前
|
NoSQL Java 关系型数据库
Liunx部署java项目Tomcat、Redis、Mysql教程
本文详细介绍了如何在 Linux 服务器上安装和配置 Tomcat、MySQL 和 Redis,并部署 Java 项目。通过这些步骤,您可以搭建一个高效稳定的 Java 应用运行环境。希望本文能为您在实际操作中提供有价值的参考。
615 26
|
Java
Java HTTP请求 如何获取并解析返回的HTML内容
在Java开发中,经常会遇到需要获取网页内容的情况。而HTTP请求是实现这一目标的常用方法之一。本文将介绍如何使用Java进行HTTP请求,并解析返回的HTML内容。
660 0
|
数据采集 Java
Java爬虫:Jsoup解析HTML
Java爬虫:Jsoup解析HTML
204 0

推荐镜像

更多