问一下 PersistenceException怎么解决

来源:3-1 Mybatis 的下载并搭建核心架构

演绎法5919

2020-02-03 11:22

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>


写回答 关注

1回答

  • 慕雪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后面算起


通过自动回复机器人学Mybatis---基础版

微信公众号自动回复功能学习Mybatis,基础教程加案例实战方式学习

107412 学习 · 786 问题

查看课程

相似问题