新手使用ibatis出错：Element type "SqlMapConfig" must be declared.

[落叶尘枫]

各路英雄好汉，江湖救急：刚接触iBatis(工程导入了mybatis-2.3.5.jar，mySQL 驱动包)

SqlMapConfig.xml 文件内容如下:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE SqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<SqlMapConfig>
<properties resource="SqlMap.properties"/>
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property value="${driver}" name="JDBC.Driver"/>
<property value="${url}" name="JDBC.ConnectionURL"/>
<property value="${username}" name="JDBC.Username"/>
<property value="${password}" name="JDBC.Password"/>
</dataSource>
</transactionManager>
<SqlMap resource="Student.xml"/>
</SqlMapConfig>



student.xml 文件内容如下 :


<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap>

<typeAlias alias="Student" type="myIbatis.Student"/>

<resultMap id="StudentResult" class="Student">
<result property="id" column="id"/>
<result property="name" column="name"/>
<result property="sex" column="sex"/>
<result property="major" column="major"/>
<result property="birthday" column="birthday"/>
</resultMap>

<select id="selectAllStudent" resultClass="Student">
select * from student_table
</select>

</sqlMap>

SqlMap.properties 文件内容如下 :

driver = "com.mysql.jdbc.Driver"
url = "jdbc:mysql://localhost:3306/myIbatisDB"
username="root"
password="fhlu18"


写了一个方法 studentDaoImpl.jva

import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;

import myIbatis.Student;
import com.ibatis.sqlmap.client.SqlMapClient;

public class StudentDaoImpl implements StudentDao {

private static SqlMapClient sqlMapClient = null;
static {
try {
Reader reader = com.ibatis.common.resources.Resources.getResourceAsReader("myIbatis/SqlMapConfig.xml");

sqlMapClient = com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(reader);

reader.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}


public List<Student> queryAllStudent() {
List<Student> studentList = null;
try {
studentList = sqlMapClient.queryForList("selectAllStudent");
} catch (SQLException e) {
e.printStackTrace();
}
return studentList ;
}


public List<Student> queryselectStudentByName(String name) {
// TODO Auto-generated method stub
return null;
}


public static void main(String[] args) {
StudentDao studentDao = new StudentDaoImpl();
studentDao.queryAllStudent();

}

}


运行这个 main 方法时报错：Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type "SqlMapConfig" must be declared.


请各位高手帮忙指教一下，感激万分！感激万分！感激万分

[悠忧虫]

view plaincopy to clipboardprint?
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">


改为

view plaincopy to clipboardprint?
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">


------------------------------------------------------------------------------

我没用过iBatis，不知道该过之后行不行

[落叶尘枫]

补充一下：
上述三个配置文件放在src/myIbatis 目录 下

运行报错：
java.lang.ExceptionInInitializerError
Caused by: java.lang.RuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type "SqlMapConfig" must be declared.
at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:49)
at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:63)
at myIbatis.StudentDaoImpl.<clinit>(StudentDaoImpl.java:18)
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: Element type "SqlMapConfig" must be declared.
at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:53)
at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:46)
... 2 more
Caused by: org.xml.sax.SAXParseException: Element type "SqlMapConfig" must be declared.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:195)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:131)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:384)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:318)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleStartElement(XMLDTDValidator.java:1929)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement(XMLDTDValidator.java:764)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1357)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$ContentDriver.scanRootElementHook(XMLDocumentScannerImpl.java:1289)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:3084)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:912)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:645)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:508)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:807)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107)
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:225)
at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:283)
at com.ibatis.common.xml.NodeletParser.createDocument(NodeletParser.java:157)
at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:50)
... 3 more
Exception in thread "main"

[悠忧虫]

http://blog.csdn.net/zhongweijian/archive/2009/10/10/4651329.aspx

解析xml时出错了

[落叶尘枫]

ibatis出现这个错误需要把头部

view plaincopy to clipboardprint?
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">


改为

view plaincopy to clipboardprint?
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

两者有什么不同吗？？

[lizhongyi188]

<select id="selectAllStudent" resultClass="Student"> 这里将resultClass改为resultMap即可 记得给分哈

[Inhibitory]

推荐你看一下iBatis最简单的入门吧：http://www.cppblog.com/biao/archive/2010/10/24/131051.html

每一步写得都很清楚

[落叶尘枫]

[Quote=引用 5 楼 lizhongyi188 的回复:]
<select id="selectAllStudent" resultClass="Student"> 这里将resultClass改为resultMap即可 记得给分哈
[/Quote]

这个修改后还是不行，不过也要谢谢你！

[go_327_wind]

引用 5 楼 lizhongyi188 的回复:

<select id="selectAllStudent" resultClass="Student"> 这里将resultClass改为resultMap即可 记得给分哈

resultClass也可以的吧