问答详情
源自:3-1 Mybatis 的下载并搭建核心架构

问一下 PersistenceException怎么解决

http://img2.mukewang.com/5e3791b70001fc1803970082.jpg

http://img2.mukewang.com/5e3791b700013d8602550191.jpg

http://img1.mukewang.com/5e3791b70001f48007440261.jpg

http://img2.mukewang.com/5e3791b700016ef907170414.jpg

http://img4.mukewang.com/5e3791b70001705308050264.jpg

这是我的xml文件

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

<!--


       Copyright 2009-2016 the original author or authors.


       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.


-->

<!DOCTYPE configuration

    PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

    "http://mybatis.org/dtd/mybatis-3-config.dtd">


<configuration>

<!--

  <settings>

    <setting name="useGeneratedKeys" value="false"/>

    <setting name="useColumnLabel" value="true"/>

  </settings>


  <typeAliases>

    <typeAlias alias="UserAlias" type="org.apache.ibatis.submitted.complex_property.User"/>

  </typeAliases>-->


  <environments default="development">

    <environment id="development">

      <transactionManager type="JDBC">

        <property name="" value=""/>

      </transactionManager>

      <dataSource type="UNPOOLED">

        <property name="driver" value="com.mysql.jdbc.Driver"/>

        <property name="url" value="jdbc:mysql://127.0.0.1:3306/micro_message?serverTimezone=UTC "/>

        <property name="username" value="root"/>

        <property name="password" value="500730"/>

      </dataSource>

    </environment>

  </environments>


<!--

  <mappers>

    <mapper resource="MicroMessage/src/sqlxml/Message.xml"/>

  </mappers>

  -->


</configuration>


提问者:演绎法5919 2020-02-03 11:22

个回答

  • 慕雪1586862
    2020-02-03 13:53:02

    public class MessageDao {
     public List<Message> queryMessageList(String command,String description) {
      DBAccess dbAccess = new DBAccess();
      List<Message> messages = new ArrayList<Message>();
      SqlSession sqlSession = null;
      try {
       sqlSession = dbAccess.getSqlSession();
       //通过sqlSession执行SQL语句
       messages = sqlSession.selectList("Message.queryMessageList");
      } catch (IOException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
      } finally {
       if (sqlSession!=null) {
        sqlSession.close();
       }
      }
      return messages;
     }

    还有Configuration.xml文件中
    <mappers>
        <mapper resource="com/cailiang/config/Message.xml"/>
    </mappers>
    路径从src后面算起