[Java知识库]Mybatis快速使用

一、注解开发

//另外还有@Update@Delete@Insert
public interface SakuraArmsMapper {
    @Select("SELECT * FROM card WHERE belong_goddess_id = #{goddessId} ORDER BY card_id")
    List<Card> getAllCardByGoddessId(String goddessId);

    @Select("SELECT * FROM goddess WHERE goddess_name = #{goddessName} LIMIT 1")
    Goddess getGoddessByGoddessName(String goddessName);
}

二、xml配置

<?xml version="1.0" encoding="utf-8"?>
        <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
    <!-- 允许驼峰命名 -->
    <setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>
<environments default="development">
    <environment id="development">
        <transactionManager type="JDBC"/>
        <dataSource type="POOLED">
            <property name="driver" value="com.mysql.jdbc.Driver"/>
            <property name="url"
                      value="jdbc:mysql://localhost:3306/sakura_arms?serverTimezone=UTC&amp;allowMultiQueries=true"/>
            <property name="username" value="root"/>
            <property name="password" value="root"/>
        </dataSource>
    </environment>
</environments>
<mappers>
    <mapper class="mapper.SakuraArmsMapper"/>
</mappers>
</configuration>