帮我生产一个mysql表，用于存储二手车经销商的店铺信息，并为这个表生产mybatis代码。

MySQL表：

CREATE TABLE dealer ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(100) NOT NULL, address varchar(200) NOT NULL, phone varchar(20) NOT NULL, email varchar(100) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;

MyBatis代码：

DealerMapper.java:

public interface DealerMapper { void insert(Dealer dealer); void update(Dealer dealer); void deleteById(int id); Dealer findById(int id); List findAll(); }

Dealer.java:

public class Dealer { private int id; private String name; private String address; private String phone; private String email;

// getter and setter methods

}

DealerMapper.xml:

<insert id="insert" parameterType="com.example.Dealer">
    INSERT INTO dealer (name, address, phone, email)
    VALUES (#{name}, #{address}, #{phone}, #{email})
</insert>

<update id="update" parameterType="com.example.Dealer">
    UPDATE dealer SET
    name = #{name},
    address = #{address},
    phone = #{phone},
    email = #{email}
    WHERE id = #{id}
</update>

<delete id="deleteById" parameterType="int">
    DELETE FROM dealer WHERE id = #{id}
</delete>

<select id="findById" parameterType="int" resultMap="dealerMap">
    SELECT * FROM dealer WHERE id = #{id}
</select>

<select id="findAll" resultMap="dealerMap">
    SELECT * FROM dealer
</select>

帮我生产一个mysql表，用于存储二手车经销商的店铺信息，并为这个表生产mybatis代码。