1.like用于模糊查找 car_type like #{carType}

             select * from carinfo                 car_type like #{carType}             car_color like #{carColor}             

 

2.更新 car_type = #{carType},

       
     
             update carinfo       
             
       
               car_type = #{carType},       
              
       
               car_color = #{carColor},       
              
             where id=#{id}