blog里有一张表

c…整体就是mysql里存了一张表然后在java程序里用mybatis把数据读出来的一个简单示例。

blog里有一张表

3.0//ENhttp://mybatis.org/dtd/mybatis-3-config.dtd

iddevelopmenttransactionManager

typeJDBC/dataSource

valuecom.mysql.cj.jdbc.Driver/property

nameurl

valuejdbc:mysql://localhost:3306/blog/property

nameusername

value123456//dataSource/environment/environments!--写好的sql映射文件(EmployeeMapper.xml)注册到全局配置文件(mybatis-config.xml)中--mappersmapper

resourceArticleMapper.xml//mappers

/configuration

3.0//ENhttps://mybatis.org/dtd/mybatis-3-mapper.dtd

mapper

namespaceorg.mybatis.example.BlogMapperselect

idselectArticle

resultTypeorg.example.po.Articleselect

from

org.apache.ibatis.io.Resources;

import

org.apache.ibatis.session.SqlSession;

import

org.apache.ibatis.session.SqlSessionFactory;

import

org.apache.ibatis.session.SqlSessionFactoryBuilder;

import

resourcemybatis-config.xml;InputStream

inputStream

Resources.getResourceAsStream(resource);SqlSessionFactory

sqlSessionFactorynew

SqlSessionFactoryBuilder().build(inputStream);SqlSession

sqlSessionsqlSessionFactory.openSession();Article

articlesqlSession.selectOne(selectArticle,1);Gson

gsonnew

Gson();System.out.println(Hello

world!);System.out.println(gson.toJson(article));}

最后把pom.XML也贴一下

xmlnshttp://maven.apache.org/POM/4.0.0xmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://maven.apache.org/POM/4.0.0

http://maven.apache.org/xsd/maven-4.0.0.xsdmodelVersion4.0.0/modelVersiongroupIdorg.example/groupIdartifactIdmybatis-study/artifactIdversion1.0-SNAPSHOT/versionpropertiesmaven.compiler.source14/maven.compiler.sourcemaven.compiler.target14/maven.compiler.targetproject.build.sourceEncodingUTF-8/project.build.sourceEncoding/propertiesdependenciesdependencygroupIdorg.mybatis/groupIdartifactIdmybatis/artifactIdversion3.5.9/version/dependencydependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.27/version/dependencydependencygroupIdcom.google.code.gson/groupIdartifactIdgson/artifactIdversion2.10/version/dependencydependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdversion1.18.30/version/dependency/dependencies/project

mybatis