mybatis连接mysql数据库步骤

<dependencies>
    <!-- MyBatis -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.x.x</version>
    </dependency>

    <!-- MySQL 驱动 -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>x.x.x</version>
    </dependency>
</dependencies>

<configuration>
    <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/mydatabase" />
                <property name="username" value="root" />
                <property name="password" value="mypassword" />
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!-- 添加映射文件 -->
        <mapper resource="com/example/mappers/ExampleMapper.xml" />
    </mappers>
</configuration>

public interface ExampleMapper {
    // 添加方法定义
    void insertExample(Example example);
    Example selectExampleById(int id);
    // 其他方法...
}

<mapper namespace="com.example.mappers.ExampleMapper">
    <insert id="insertExample" parameterType="com.example.models.Example">
        INSERT INTO example (id, name) VALUES (#{id}, #{name})
    </insert>

    <select id="selectExampleById" parameterType="int" resultType="com.example.models.Example">
        SELECT * FROM example WHERE id = #{id}
    </select>

    <!-- 其他 SQL 语句和映射规则... -->
</mapper>

String resource = "path/to/mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

SqlSession sqlSession = sqlSessionFactory.openSession();
ExampleMapper exampleMapper = sqlSession.getMapper(ExampleMapper.class);

Example example = new Example();
example.setId(1);
example.setName("Example Name");
exampleMapper.insertExample(example);

Example selectedExample = exampleMapper.selectExampleById(1);