65865jytgnhg

@Service
public class ProductBiz {

//    @Autowired
    private ProductMapper productMapper;//CRUD
    public void selectProduct()
    {
        System.out.println("selectProduct");
        List<Product> lst=productMapper.deleteById();
        System.out.println(lst);



    }

package com.cqust.controller;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.cqust.model.Product;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletRequest;

@Controller
public class ProductControler {
 // [q4.1]
// Please complete the answer of Question 4th

    @RequestMapping("/sayHello")
    public String savHello() {
        System.out.println("sayHello...........");
        return "listProduct";
    }

    @PostMapping("/fruitRegist")
    public String Regist(HttpServletRequest req, Model model)
    {
        String productNameName = req.getParameter("product_name");
        System.out.println(productNameName);
        if (productNameName.equals("SiMaYi"))
        {
            model.addAttribute("msg", productNameName.toUpperCase());
            return "listProduct";
        }
        else
        {
            model.addAttribute("msg", "Fruit Name or PWD Error!!!!!!");
            return "login";
        }
    }

// [/q4.1]

    // [q5.1]
//Please complete the answer of Question 5th
    @PostMapping("/userRegist03")
    public String userRegist03(Product product, Model model)
    {
        String productNameName = product.getName();

        System.out.println(productNameName);
        if (productNameName.equals("pg"))
        {
            model.addAttribute("msg", productNameName.toUpperCase());
            return "listProduct";
        }
        else
        {
            model.addAttribute("msg", "Product Name or PWD Error!!!!!!");
            return "login";
        }
    }

    @PostMapping("/deleteProducts")
    public String deleteProducts(int[] ids){
        for (int i=0;i<ids.length;i++){
            System.out.println(ids[i]);
        }
        return "listProduct";
    }


//    下面是测试代码。
   @GetMapping("/login")
    public String test()
    {
        System.out.println("test login");
        return "login";
    }
}

package com.cqust.dao;


import java.util.List;

public interface ProductMapper {
    //[q2.1]
    //Please complete the answer of Question 2nd
    public int deleteById(int pId);

    //[/q2.1]
}

package com.cqust.test;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.BeforeClass;
import org.junit.Test;

import java.io.InputStream;

public class JTest {
//[q2.3]
//   Please complete the answer of Question 2nd
private static SqlSession session=null;
    @BeforeClass
    public static void initSession() throws Exception
    {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        session=sqlSessionFactory.openSession();
        System.out.println("initSession() Runing.........");
    }
    @Test
    public void testProductDeleteById()
    {
        session.delete("com.cqust.dao.ProductMapper.deleteById",1);
        session.commit();


    }

//[/q2.3]
}