吴江专业的网站建设,潍坊建设部门管理网站,甬城通可以在线充值吗,建站多少钱一个准备源代码包
下载源代码 3.4.6 版本 https://github.com/mybatis/mybatis-3/releases?page2 通过 idea 导入然后回自动下载所有依赖#xff0c;根据 3.4.6 版本的 pom.xml 找到依赖的 mybatis-parent 版本 parentgroupIdorg.mybatis/groupIdar…准备源代码包
下载源代码 3.4.6 版本 https://github.com/mybatis/mybatis-3/releases?page2 通过 idea 导入然后回自动下载所有依赖根据 3.4.6 版本的 pom.xml 找到依赖的 mybatis-parent 版本 parentgroupIdorg.mybatis/groupIdartifactIdmybatis-parent/artifactIdversion29/versionrelativePath //parent同样需要从 github 下载 https://github.com/mybatis/parent/releases/tag/mybatis-parent-29
准备测试环境
代码结构 创建 Maven 项目并添加依赖 pom.xml
?xml version1.0 encodingUTF-8?
project 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/groupIdartifactIdmybatisjsnm/artifactIdversion1.0-SNAPSHOT/versionpropertiesjunit.version4.12/junit.versionmybatis.version3.4.6/mybatis.versionmysql.version8.0.16/mysql.versiondruid.version1.0.9/druid.version/propertiesdependencies!-- log4j --dependencygroupIdlog4j/groupIdartifactIdlog4j/artifactIdversion1.2.17/version/dependency!-- Mybatis --dependencygroupIdorg.mybatis/groupIdartifactIdmybatis/artifactIdversion${mybatis.version}/version/dependency!-- MySql --dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion${mysql.version}/version/dependency!-- 连接池 --dependencygroupIdcom.alibaba/groupIdartifactIddruid/artifactIdversion${druid.version}/version/dependency!-- Junit --dependencygroupIdjunit/groupIdartifactIdjunit/artifactIdversion${junit.version}/versionscopetest/scope/dependency!-- install 后源码缺包--dependencygroupIdorg.javassist/groupIdartifactIdjavassist/artifactIdversion3.26.0-GA/version/dependency!-- install 后源码缺包--dependencygroupIdognl/groupIdartifactIdognl/artifactIdversion3.0.6/version/dependency/dependenciesbuildfinalNamemybatis/finalNamepluginsplugingroupIdorg.apache.maven.plugins/groupIdartifactIdmaven-compiler-plugin/artifactIdconfigurationsource1.8/sourcetarget1.8/targetencodingUTF-8/encoding/configuration/plugin/plugins/build
/project创建 mapper 接口 CountryMapper
public interface CountryMapper {public ListCountry selectAll();
}创建实体类 Country
public class Country {private Long id;private String countryname;private String countrycode;... // get/set 方法
}相应字段自行在数据库里面创建
create table country (id int (11),countryname varchar (765),countrycode varchar (765)
); 创建 CountryMapper.xml
?xml version1.0 encodingUTF-8?
!DOCTYPE mapper PUBLIC -//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtdmapper namespaceorg.example.mybatisjsnm.mapper.CountryMapperselect idselectAll resultTypeCountryselect id,countryname,countrycode from country/select
/mapper配置 log4j.properties
# Global logging configuration
log4j.rootLoggerERROR,stdout
# Mybatis logging configuration...
log4j.logger.com.simple.mapperTRACE
# Console output...
log4j.appender.stdoutorg.apache.log4j.ConsoleAppender
log4j.appender.stdout.layoutorg.apache.log4j.PatternLayout
log4j.appender.layout.ConversionPattern%5p [%t] - %m%n配置 mybatis-config.xml
?xml version1.0 encodingUTF-8 ?
!DOCTYPE configurationPUBLIC -//mybatis.org//DTD Config 3.0//ENhttp://mybatis.org/dtd/mybatis-3-config.dtd
configuration!--开启日志输出--settingssetting namelogImpl valueSTDOUT_LOGGING //settings!--配置类别名配置后在Mapper配置文件通常我们将编写SQL语句的配置文件成为Mapper配置文件中需要使用pojo包中的类时使用简单类名即可--typeAliasespackage nameorg.example.mybatisjsnm.pojo//typeAliasesenvironments defaultdevelopmentenvironment iddevelopmenttransactionManager typeJDBCproperty name value//transactionManagerdataSource typePOOLEDproperty namedriver valuecom.mysql.cj.jdbc.Driver/property nameusername valueroot/property namepassword valueroot/property nameurl valuejdbc:mysql://localhost:3306/mybatis//dataSource/environment/environmentsmapperspackage nameorg.example.mybatisjsnm.mapper//mappers/configuration创建运行主类 MyBatisTest
public class MyBatisTest {Testpublic void testMyBatisBuild() throws IOException {InputStream input Resources.getResourceAsStream(mybatis-config.xml);SqlSessionFactory sessionFactory new SqlSessionFactoryBuilder().build(input);SqlSession sqlSession sessionFactory.openSession();CountryMapper mapper sqlSession.getMapper(CountryMapper.class);ListCountry countries mapper.selectAll();}
}运行程序
集合成源代码
代码结构 首先将 mybatis-3-mybatis-3.4.6、parent-mybatis-parent-29 导入到刚刚测试的相同 project 中导入方式 File - Project Structure - Modules - 号然后分别在 mybatis-3-mybatis-3.4.6、parent-mybatis-parent-29 执行下面命令
mvn clean install -Dmaven.test.skiptrue如果 mybatis-3-mybatis-3.4.6 显示 maven-pdf-plugin 相关的失败的话把这个插件注释掉
!-- plugin--
!-- groupIdorg.apache.maven.plugins/groupId--
!-- artifactIdmaven-pdf-plugin/artifactId--
!-- /plugin--然后再尝试 debug、运行代码看看是否能跳转到你相应代码上
