Java源码社

基于javaweb的JSP+Servlet简单商品管理系统(java+servlet+jsp+mysql+tomcat)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

392024482407

412024482407

422024482407

432024482407

442024482407

基于javaweb的JSP+Servlet简单商品管理系统(java+servlet+jsp+mysql+tomcat)

登录：
admin 123456

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
                price=new String(str.getBytes("ISO-8859-1"),"utf-8");

            }
        }



    }
}


// System.out.println(zhuxuetype);
if (formItems != null && formItems.size() > 0) {
    // 迭代表单数据
    for (FileItem item : formItems) {
        // 处理不在表单中的字段
        if (!item.isFormField()) {
            String fileName = new File(item.getName()).getName();
            String uuid = UUID.randomUUID().toString().replaceAll("-", "");
            String filePath = uploadPath + File.separator + uuid+".png";


            if(fileName.endsWith("png")||fileName.endsWith("jpg")){

                File storeFile = new File(filePath);
                // 在控制台输出文件的上传路径
                System.out.println(filePath);//路劲
                // 保存文件到硬盘
                item.write(storeFile);

                //

                String ac;

                QueryRunner qr = new QueryRunner(JdbcUtil.getDataSource());
                Mysqld.setCon(JdbcUtil.open());
                String sql="insert into s_shop (`name`,contenct,price,path) VALUES(?,?,?,?)";
                String tt=uuid+".png";


                String data[]= {
                       names,contenct,price,tt
                };
                int num=Mysqld.upDate(sql,data);
                if(num==1) {
                    request.setAttribute("message",
                            "添加成功");
                }else {
                    request.setAttribute("message",
                            "切勿重复添加");
                }

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
public class RegisterServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    }

    /**
     * 实现注册账号的功能
     * @param request
     * @param response
     * @throws ServletException
     * @throws IOException
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");//防止中文乱码


        //获取账号和密码
        String name =request.getParameter("username");
        String password = request.getParameter("password");
        System.out.println("账号："+name);

        UserBean userBean=new UserBean(name,password);

        UserDao userDao=new UserDao();
        int sta=userDao.addUser(userBean);
        request.getSession().setAttribute("staId", "0");
        if(sta==0){
            request.getSession().setAttribute("sta", "注册失败，改账号已经存在");
            response.sendRedirect("register.jsp");
        }else{
            request.getSession().setAttribute("staId", "1");
            request.getSession().setAttribute("sta", "注册成功，请登录...");
            response.sendRedirect("register.jsp");

        }


    }
}



1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
// 迭代表单数据
for (FileItem item : formItems) {
    // 处理不在表单中的字段
    if (!item.isFormField()) {
        String fileName = new File(item.getName()).getName();
        String uuid = UUID.randomUUID().toString().replaceAll("-", "");
        String filePath = uploadPath + File.separator + uuid+".png";


        if(fileName.endsWith("png")||fileName.endsWith("jpg")){

            File storeFile = new File(filePath);
            // 在控制台输出文件的上传路径
            System.out.println(filePath);//路劲
            // 保存文件到硬盘
            item.write(storeFile);

            //

            String ac;

            QueryRunner qr = new QueryRunner(JdbcUtil.getDataSource());
            Mysqld.setCon(JdbcUtil.open());
            String sql="insert into s_shop (`name`,contenct,price,path) VALUES(?,?,?,?)";
            String tt=uuid+".png";


            String data[]= {
                   names,contenct,price,tt
            };
            int num=Mysqld.upDate(sql,data);
            if(num==1) {
                request.setAttribute("message",
                        "添加成功");
            }else {
                request.setAttribute("message",
                        "切勿重复添加");
            }

        }else {
            //不是pdf
            request.setAttribute("message",
                    "请上传png,jpg格式图片");
            getServletContext().getRequestDispatcher("/addShop.jsp").forward(
                    request, response);
            return ;
        }


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
upload.setHeaderEncoding("UTF-8");

// 构造临时路径来存储上传的文件
// 这个路径相对当前应用的目录
String uploadPath = getServletContext().getRealPath("/") + "images";
System.out.println(uploadPath);



// 如果目录不存在则创建
File uploadDir = new File(uploadPath);
if (!uploadDir.exists()) {
    uploadDir.mkdir();
}
String names = null,contenct = null,price = null,id=null;
try {
    // 解析请求的内容提取文件数据
    @SuppressWarnings("unchecked")
    // 中文处理
    List<FileItem> formItems = upload.parseRequest(request);


    //  contenct   uploadFile  A  B  C
    if (formItems != null && formItems.size() > 0) {
        // 迭代表单数据
        for (FileItem item : formItems) {
            // 处理不在表单中的字段
            if (item.isFormField()) {
                String name = item.getFieldName();
                System.out.println(item);

                if(name.equals("name")) {
                    String str = item.getString();

                    names=new String(str.getBytes("ISO-8859-1"),"utf-8");
                    System.out.println("这个是结果"+names);

                }
                if(name.equals("id")) {
                    String str = item.getString();

                    id=new String(str.getBytes("ISO-8859-1"),"utf-8");


                }
                if(name.equals("contenct")) {
                    String str = item.getString();
                    contenct=new String(str.getBytes("ISO-8859-1"),"utf-8");


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48

@WebServlet(name = "PageCountServlet", value = "/PageCountServlet")
public class PageCountServlet 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 {

        String id=request.getParameter("id");
        String res= (String) request.getSession().getAttribute("res");
        if(id.equals("pr")){
            //上一页

            if(res.equals("1")){//第一页则删除
                request.getSession().removeAttribute("res");
            }else{
                int st=Integer.parseInt(res)-1;
                String end=String.valueOf(st);
                request.getSession().setAttribute("res",end);

            }
            response.sendRedirect("manage.jsp");
        }
       else  if(id.equals("ne")){
            //下一页
            int a=new UserDao().getCount();
            a=a/8+1;
            int end = Integer.parseInt(res);
            if(end==a){
                //不需要操作
            }
            if(end<a){
                //不需要操作
                request.getSession().setAttribute("res",String.valueOf(end+1));
            }
            if(end>a){

            }

            response.sendRedirect("manage.jsp");
        }

        else{
            request.getSession().setAttribute("res",id);
            response.sendRedirect("manage.jsp");

项目链接：
https://javayms.github.io?id=382024482407201ma
https://javayms.pages.dev?id=382024482407201ma