久久r热视频,国产午夜精品一区二区三区视频,亚洲精品自拍偷拍,欧美日韩精品二区

您的位置:首頁技術文章
文章詳情頁

詳解Mybatis中常用的約束文件

瀏覽:2日期:2023-10-22 17:13:26

SqlMapConfig.xml的約束,也就是Mybatis主配置文件的約束

<?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'>

持久層接口映射文件的約束

<?xml version='1.0' encoding='UTF-8'?><!DOCTYPE mapper PUBLIC '-//mybatis.org//DTD Mapper 3.0//EN' 'http://mybatis.org/dtd/mybatis-3-mapper.dtd'>

日志文件的配置log4j.properties

```bash# Set root category priority to INFO and its only appender to CONSOLE.# log4j.rootCategory=INFO, CONSOLE debug info warn error fatallog4j.rootCategory=debug, CONSOLE, LOGFILE # Set the enterprise logger category to FATAL and its only appender to CONSOLE.log4j.logger.org.apache.axis.enterprise=FATAL, CONSOLE # CONSOLE is set to be a ConsoleAppender using a PatternLayout.log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout log4j.appender.CONSOLE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %mn # LOGFILE is set to be a File appender using a PatternLayout.log4j.appender.LOGFILE=org.apache.log4j.FileAppender #生成的日志文件的位置和命名log4j.appender.LOGFILE.File=d:axis.log log4j.appender.LOGFILE.Append=true log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout log4j.appender.LOGFILE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %mn

PS:Mybatis xml約束文件的使用

一:準備.DTD約束文件

核心配置文件約束文件:mybatis-config.dtd

<?xml version='1.0' encoding='UTF-8' ?><!-- Copyright 2009-2012 The MyBatis Team Licensed under the Apache License, Version 2.0 (the 'License'); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an 'AS IS' BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.--><!ELEMENT configuration (properties?, settings?, typeAliases?, typeHandlers?, objectFactory?, objectWrapperFactory?, plugins?, environments?, databaseIdProvider?, mappers?)><!ELEMENT databaseIdProvider (property*)><!ATTLIST databaseIdProvidertype CDATA #REQUIRED><!ELEMENT properties (property*)><!ATTLIST propertiesresource CDATA #IMPLIEDurl CDATA #IMPLIED><!ELEMENT property EMPTY><!ATTLIST propertyname CDATA #REQUIREDvalue CDATA #REQUIRED><!ELEMENT settings (setting+)><!ELEMENT setting EMPTY><!ATTLIST settingname CDATA #REQUIREDvalue CDATA #REQUIRED><!ELEMENT typeAliases (typeAlias*,package*)><!ELEMENT typeAlias EMPTY><!ATTLIST typeAliastype CDATA #REQUIREDalias CDATA #IMPLIED><!ELEMENT typeHandlers (typeHandler*,package*)><!ELEMENT typeHandler EMPTY><!ATTLIST typeHandlerjavaType CDATA #IMPLIEDjdbcType CDATA #IMPLIEDhandler CDATA #REQUIRED><!ELEMENT objectFactory (property*)><!ATTLIST objectFactorytype CDATA #REQUIRED><!ELEMENT objectWrapperFactory (property*)><!ATTLIST objectWrapperFactorytype CDATA #REQUIRED><!ELEMENT plugins (plugin+)><!ELEMENT plugin (property*)><!ATTLIST plugininterceptor CDATA #REQUIRED><!ELEMENT environments (environment+)><!ATTLIST environmentsdefault CDATA #REQUIRED><!ELEMENT environment (transactionManager,dataSource)><!ATTLIST environmentid CDATA #REQUIRED><!ELEMENT transactionManager (property*)><!ATTLIST transactionManagertype CDATA #REQUIRED><!ELEMENT dataSource (property*)><!ATTLIST dataSourcetype CDATA #REQUIRED><!ELEMENT mappers (mapper*,package*)><!ELEMENT mapper EMPTY><!ATTLIST mapperresource CDATA #IMPLIEDurl CDATA #IMPLIEDclass CDATA #IMPLIED><!ELEMENT package EMPTY><!ATTLIST packagename CDATA #REQUIRED>

sql映射文件約束文件:mybatis-mapper.dtd

<?xml version='1.0' encoding='UTF-8' ?><!-- Copyright 2009-2011 The MyBatis Team Licensed under the Apache License, Version 2.0 (the 'License'); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an 'AS IS' BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.--><!ELEMENT mapper (cache-ref | cache | resultMap* | parameterMap* | sql* | insert* | update* | delete* | select* )+><!ATTLIST mapperxmlns:fo CDATA #IMPLIEDnamespace CDATA #IMPLIED><!ELEMENT cache-ref EMPTY><!ATTLIST cache-refnamespace CDATA #REQUIRED><!ELEMENT cache (property*)><!ATTLIST cachetype CDATA #IMPLIEDeviction CDATA #IMPLIEDflushInterval CDATA #IMPLIEDsize CDATA #IMPLIEDreadOnly CDATA #IMPLIED><!ELEMENT parameterMap (parameter+)?><!ATTLIST parameterMapid CDATA #REQUIREDtype CDATA #REQUIRED><!ELEMENT parameter EMPTY><!ATTLIST parameterproperty CDATA #REQUIREDjavaType CDATA #IMPLIEDjdbcType CDATA #IMPLIEDmode (IN | OUT | INOUT) #IMPLIEDresultMap CDATA #IMPLIEDscale CDATA #IMPLIEDtypeHandler CDATA #IMPLIED><!ELEMENT resultMap (constructor?,id*,result*,association*,collection*, discriminator?)><!ATTLIST resultMapid CDATA #REQUIREDtype CDATA #REQUIREDextends CDATA #IMPLIEDautoMapping (true|false) #IMPLIED><!ELEMENT constructor (idArg*,arg*)><!ELEMENT id EMPTY><!ATTLIST idproperty CDATA #IMPLIEDjavaType CDATA #IMPLIEDcolumn CDATA #IMPLIEDjdbcType CDATA #IMPLIEDtypeHandler CDATA #IMPLIED><!ELEMENT result EMPTY><!ATTLIST resultproperty CDATA #IMPLIEDjavaType CDATA #IMPLIEDcolumn CDATA #IMPLIEDjdbcType CDATA #IMPLIEDtypeHandler CDATA #IMPLIED><!ELEMENT idArg EMPTY><!ATTLIST idArgjavaType CDATA #IMPLIEDcolumn CDATA #IMPLIEDjdbcType CDATA #IMPLIEDtypeHandler CDATA #IMPLIEDselect CDATA #IMPLIEDresultMap CDATA #IMPLIED><!ELEMENT arg EMPTY><!ATTLIST argjavaType CDATA #IMPLIEDcolumn CDATA #IMPLIEDjdbcType CDATA #IMPLIEDtypeHandler CDATA #IMPLIEDselect CDATA #IMPLIEDresultMap CDATA #IMPLIED><!ELEMENT collection (constructor?,id*,result*,association*,collection*, discriminator?)><!ATTLIST collectionproperty CDATA #REQUIREDcolumn CDATA #IMPLIEDjavaType CDATA #IMPLIEDofType CDATA #IMPLIEDjdbcType CDATA #IMPLIEDselect CDATA #IMPLIEDresultMap CDATA #IMPLIEDtypeHandler CDATA #IMPLIEDnotNullColumn CDATA #IMPLIEDcolumnPrefix CDATA #IMPLIED><!ELEMENT association (constructor?,id*,result*,association*,collection*, discriminator?)><!ATTLIST associationproperty CDATA #REQUIREDcolumn CDATA #IMPLIEDjavaType CDATA #IMPLIEDjdbcType CDATA #IMPLIEDselect CDATA #IMPLIEDresultMap CDATA #IMPLIEDtypeHandler CDATA #IMPLIEDnotNullColumn CDATA #IMPLIEDcolumnPrefix CDATA #IMPLIED><!ELEMENT discriminator (case+)><!ATTLIST discriminatorcolumn CDATA #IMPLIEDjavaType CDATA #REQUIREDjdbcType CDATA #IMPLIEDtypeHandler CDATA #IMPLIED><!ELEMENT case (constructor?,id*,result*,association*,collection*, discriminator?)><!ATTLIST casevalue CDATA #REQUIREDresultMap CDATA #IMPLIED resultType CDATA #IMPLIED><!ELEMENT property EMPTY><!ATTLIST propertyname CDATA #REQUIREDvalue CDATA #REQUIRED><!ELEMENT typeAlias EMPTY><!ATTLIST typeAliasalias CDATA #REQUIREDtype CDATA #REQUIRED><!ELEMENT select (#PCDATA | include | trim | where | set | foreach | choose | if)*><!ATTLIST selectid CDATA #REQUIREDparameterMap CDATA #IMPLIEDparameterType CDATA #IMPLIEDresultMap CDATA #IMPLIEDresultType CDATA #IMPLIEDresultSetType (FORWARD_ONLY | SCROLL_INSENSITIVE | SCROLL_SENSITIVE) #IMPLIEDstatementType (STATEMENT|PREPARED|CALLABLE) #IMPLIEDfetchSize CDATA #IMPLIEDtimeout CDATA #IMPLIEDflushCache (true|false) #IMPLIEDuseCache (true|false) #IMPLIEDdatabaseId CDATA #IMPLIED><!ELEMENT insert (#PCDATA | selectKey | include | trim | where | set | foreach | choose | if)*><!ATTLIST insertid CDATA #REQUIREDparameterMap CDATA #IMPLIEDparameterType CDATA #IMPLIEDtimeout CDATA #IMPLIEDflushCache (true|false) #IMPLIEDstatementType (STATEMENT|PREPARED|CALLABLE) #IMPLIEDkeyProperty CDATA #IMPLIEDuseGeneratedKeys (true|false) #IMPLIEDkeyColumn CDATA #IMPLIEDdatabaseId CDATA #IMPLIED><!ELEMENT selectKey (#PCDATA | include | trim | where | set | foreach | choose | if)*><!ATTLIST selectKeyresultType CDATA #IMPLIEDstatementType (STATEMENT|PREPARED|CALLABLE) #IMPLIEDkeyProperty CDATA #IMPLIEDorder (BEFORE|AFTER) #IMPLIEDdatabaseId CDATA #IMPLIED><!ELEMENT update (#PCDATA | include | trim | where | set | foreach | choose | if)*><!ATTLIST updateid CDATA #REQUIREDparameterMap CDATA #IMPLIEDparameterType CDATA #IMPLIEDtimeout CDATA #IMPLIEDflushCache (true|false) #IMPLIEDstatementType (STATEMENT|PREPARED|CALLABLE) #IMPLIEDdatabaseId CDATA #IMPLIED><!ELEMENT delete (#PCDATA | include | trim | where | set | foreach | choose | if)*><!ATTLIST deleteid CDATA #REQUIREDparameterMap CDATA #IMPLIEDparameterType CDATA #IMPLIEDtimeout CDATA #IMPLIEDflushCache (true|false) #IMPLIEDstatementType (STATEMENT|PREPARED|CALLABLE) #IMPLIEDdatabaseId CDATA #IMPLIED><!-- Dynamic --><!ELEMENT include EMPTY><!ATTLIST includerefid CDATA #REQUIRED><!ELEMENT sql (#PCDATA | include | trim | where | set | foreach | choose | if)*><!ATTLIST sqlid CDATA #REQUIRED><!ELEMENT trim (#PCDATA | include | trim | where | set | foreach | choose | if)*><!ATTLIST trimprefix CDATA #IMPLIEDprefixOverrides CDATA #IMPLIEDsuffix CDATA #IMPLIEDsuffixOverrides CDATA #IMPLIED><!ELEMENT where (#PCDATA | include | trim | where | set | foreach | choose | if)*><!ELEMENT set (#PCDATA | include | trim | where | set | foreach | choose | if)*><!ELEMENT foreach (#PCDATA | include | trim | where | set | foreach | choose | if)*><!ATTLIST foreachcollection CDATA #REQUIREDitem CDATA #IMPLIEDindex CDATA #IMPLIEDopen CDATA #IMPLIEDclose CDATA #IMPLIEDseparator CDATA #IMPLIED><!ELEMENT choose (when* , otherwise?)><!ELEMENT when (#PCDATA | include | trim | where | set | foreach | choose | if)*><!ATTLIST whentest CDATA #REQUIRED><!ELEMENT otherwise (#PCDATA | include | trim | where | set | foreach | choose | if)*><!ELEMENT if (#PCDATA | include | trim | where | set | foreach | choose | if)*><!ATTLIST iftest CDATA #REQUIRED>

二:在eclipse中使用XML約束文件將約束文件,插入到xml文件中,兩種約束文件的插入位置是相同的

核心配置文件:

<?xml version='1.0' encoding='UTF-8'?><!-- .DTD文件是xml格式文件的約束文件,它約束了該xml文件使用的標簽以及標簽之間的關系 --><!DOCTYPE configurationPUBLIC '-//mybatis.org//DTD Config 3.0//EN''http://mybatis.org/dtd/mybatis-config.dtd'>

sql映射文件:

<?xml version='1.0' encoding='UTF-8'?><!-- 該文件代表的是類和表的映射關系,關于表的sql語句等等寫在這里 --><!DOCTYPE mapperPUBLIC '-//mybatis.org//DTD Mapper 3.0//EN''http://mybatis.org/dtd/mybatis-mapper.dtd'>

三:集成到eclipse開發工具中Window-> Preferences->XML->XML Catalog->Add

然后

key:寫入 xml文件中 PUBLIC中的值

Location:選擇dtd文件的實際物理位置

總結

到此這篇關于Mybatis中常用的約束文件的文章就介紹到這了,更多相關Mybatis約束文件內容請搜索好吧啦網以前的文章或繼續瀏覽下面的相關文章希望大家以后多多支持好吧啦網!

標簽: Mybatis 數據庫
相關文章:
主站蜘蛛池模板: 习水县| 顺义区| 桂东县| 宁安市| 义马市| 古蔺县| 萍乡市| 奉新县| 顺平县| 无为县| 永德县| 资中县| 修水县| 洛南县| 岳阳县| 古交市| 文登市| 抚州市| 田东县| 白银市| 东源县| 赞皇县| 清流县| 广水市| 巴塘县| 临漳县| 阿鲁科尔沁旗| 扎囊县| 绥中县| 开平市| 望城县| 滕州市| 晋江市| 化德县| 榆社县| 子长县| 崇仁县| 曲麻莱县| 泾川县| 五莲县| 财经|