Mybatis删除语法操作

	
	
	        delete from video where create_time  ]]> #{createTime} and price = ]]> #{price}
	
	    
	
	
	  /**
	     * 根据时间和价格删除
	     * @param map
	     * @return
	     */
	    int deleteByCreateTimeAndPrice(Map map);
	
	
	
	public class SqlSessionDemo {
	    public static void main(String[] args) throws IOException {
	
	        String resouce = "config/mybatis-config.xml";
	        //读取配置文件
	        InputStream inputStream =  Resources.getResourceAsStream(resouce);
	        //构建Session工厂
	        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
	        //获取Session
	        SqlSession sqlSession = sqlSessionFactory.openSession();
	        VideoMapper videoMapper = sqlSession.getMapper(VideoMapper.class);
	
	        Map map = new HashMap<>();
	        map.put("createTime","2021-01-11 09:33:20");
	
	        map.put("price",9000);
	
	        int rows = videoMapper.deleteByCreateTimeAndPrice(map);
	
	        System.out.println(rows);
	
	
	    }