mybatis连接mysql数据库

<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="password"/>
      </dataSource>
    </environment>
  </environments>
  ...
</configuration>

<mapper namespace="com.example.dao.UserMapper">
  <select id="getUserById" resultType="com.example.model.User">
    SELECT * FROM user WHERE id = #{id}
  </select>
  ...
</mapper>

// 加载配置文件
InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

// 创建SqlSession
SqlSession sqlSession = sqlSessionFactory.openSession();

try {
    // 执行SQL语句
    User user = sqlSession.selectOne("com.example.dao.UserMapper.getUserById", 1);
    System.out.println(user);
} finally {
    // 关闭SqlSession
    sqlSession.close();
}