今天发现Mybaits的配置文件校验时不停的报错,可却没找到原因,上网找了后,发现错误原因竟然是文件配置的位置关系
如下,会报错:
The content of element type "configuration" must match "(properties?,settings?,typeAliases?,typeHandlers?,objectFactory?,objectWrapperFactory?,plugins?,environments?,mappers?)".
Xml代码
<?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">
<configuration>
<!--默认数据库 -->
<environments default="development">
<!-- 测试数据库 -->
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
<property name="url"
value="jdbc:sqlserver://localhost:1433;DatabaseName=mybatisdb"/>
<property name="username" value="sa" />
<property name="password" value="123456" />
</dataSource>
</environment>
<!-- 正式数据库 -->
<environment id="product">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
<property name="url"
value="<pre name="code" class="html" style="font-size: 14px; font-weight: bold; line-height: 25.2000007629395px;">jdbc:sqlserver://localhost:1433;DatabaseName=mybatisdb
" /><property name="username" value="root" /><property name="password" value="root" /></dataSource></environment></environments>
<span style="white-space:pre"> </span><typeAliases>
<typeAlias type="cn.itcast.mybatis.domain.User" alias="User"/>
</typeAliases>
<mappers><mapper resource="cn/itcast/mybatis/mapping/UserMapper.xml" /></mappers></configuration>
</pre><p></p><pre>
原来应该将typeAliases配置放在最上面就可以了
<?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">
<configuration>
<typeAliases>
<typeAlias type="cn.itcast.mybatis.domain.User" alias="User"/>
</typeAliases>
<!--默认数据库 -->
<environments default="development">
<!-- 测试数据库 -->
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
<property name="url"
value="jdbc:sqlserver://localhost:1433;DatabaseName=mybatisdb"/>
<property name="username" value="sa" />
<property name="password" value="123456" />
</dataSource>
</environment>
<!-- 正式数据库 -->
<environment id="product">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
<property name="url"
value="jdbc:sqlserver://127.0.0.1:1433/mybatisdbproduct?characterEncoding=UTF-8" />
<property name="username" value="root" />
<property name="password" value="root" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="cn/itcast/mybatis/mapping/UserMapper.xml" />
</mappers>
</configuration>