二手车经销商店铺信息 MySQL 表和 MyBatis 代码示例

本文提供了一个用于存储二手车经销商店铺信息的 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<Dealer> 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

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE mapper PUBLIC '-//mybatis.org//DTD Mapper 3.0//EN'
    'http://mybatis.org/dtd/mybatis-3-mapper.dtd'>
<mapper namespace='com.example.DealerMapper'>
    <resultMap id='dealerMap' type='com.example.Dealer'>
        <id column='id' property='id'/>
        <result column='name' property='name'/>
        <result column='address' property='address'/>
        <result column='phone' property='phone'/>
        <result column='email' property='email'/>
    </resultMap>

    <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>
</mapper>

总结

以上代码示例展示了如何使用 MySQL 和 MyBatis 创建和操作二手车经销商店铺信息表。您可以根据实际需求调整表结构和 MyBatis 代码。