maven管理工程，引入MyBatis、MySQL遇到的问题

来源：互联网发布：金和软件股票编辑：程序博客网时间：2024/05/18 21:47

今天学习了一下使用maven管理项目来引入MyBatis和MySQL

测试代码段：

package com.kexue.model.dao;

import java.io.IOException;
import java.io.InputStream;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class TestMyBatis {
   public static void main(String[] args) {
       String resource = "com/kexue/model/dao/mybatis-config.xml";
       InputStream inputStream;
       try {
           inputStream = Resources.getResourceAsStream(resource);
           SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
           SqlSession session = sqlSessionFactory.openSession();
//           session.insert("org.mybatis.example.BlogMapper.insertBlog");
           String name = session.selectOne("BlogMapper.selectBlog", 1);
           System.out.println(name);
           System.out.println("SUCCESS!");
       } catch (IOException e) {
           // TODO Auto-generated catch block
           System.out.println("Failure");
           e.printStackTrace();
       }
   }

}

MyBatis的版本如下：

<dependency>
       <groupId>org.mybatis</groupId>
       <artifactId>mybatis</artifactId>
       <version>3.4.0</version>
</dependency>

刚开始MySQL的版本如下：

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>6.0.2</version>
</dependency>

报错：java.lang.UnsupportedClassVersionError: org/apache/lucene/store/Directory : Unsupported major.minor version 52.0

原因：JDK的版本不同导致的问题，将项目的JDK版本调整为1.8之后，这个错误解决

新报错：

Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

...... WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

### Cause: java.sql.SQLException:
The server time zone value '�й��׼ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

原因：MySQL的版本过高导致，将MySQL的版本调整为如下：

<dependency>
       <groupId>mysql</groupId>
       <artifactId>mysql-connector-java</artifactId>
       <version>5.0.4</version>
</dependency>

结果运行成功，且没有警告。

0 0