更换mysql-connector-java-6.0.5jar包后程序出现的两个异常及解决方法

最新推荐文章于 2021-07-21 10:03:49 发布

weixin_30417487

最新推荐文章于 2021-07-21 10:03:49 发布

阅读量153

点赞数

文章标签：数据库 java

原文链接：http://www.cnblogs.com/demoncirno/p/6013905.html

版权

更换mysql-connector-java-6.0.5jar包后程序出现的两个异常及解决方法

异常一：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.

异常二：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.

下面是我的程序代码：

配置文件：

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/db_daily_management
username=root
password=123456

数据库连接工具类：

package utils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class JdbcUtils {
    
    private static Properties config = new Properties();
    static{
        try {
            config.load(JdbcUtils.class.getClassLoader().getResourceAsStream("db.properties"));
            Class.forName(config.getProperty("driver"));
        } catch (Exception e) {
            throw new ExceptionInInitializerError(e);
        }
    }

    public static Connection getConnection() throws SQLException{
        return DriverManager.getConnection(config.getProperty("url"), config.getProperty("username"), config.getProperty("password"));
    }
    
    
    public static void release(Connection conn,java.sql.PreparedStatement stmt,ResultSet rs){
        
        if(rs!=null){
            try{
                rs.close();   //throw new 
            }catch (Exception e) {
                e.printStackTrace();
            }
            rs = null;
        }
        if(stmt!=null){
            try{
                stmt.close();
            }catch (Exception e) {
                e.printStackTrace();
            }
            stmt = null;
        }
        if(conn!=null){
            try{
                conn.close();
            }catch (Exception e) {
                e.printStackTrace();
            }
        }
        
        
    }
}

测试类：

package test;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.junit.Test;

import utils.JdbcUtils;

public class JdbcTest {
    @Test
    public void testJdbc(){
        Connection conn = null;
        PreparedStatement pst = null;
        ResultSet rs = null;
        String sql = "select count(*) from tb_employee";
        try {
            conn = JdbcUtils.getConnection();
            pst = conn.prepareStatement(sql);
            rs = pst.executeQuery();
            if(rs.next()){
                System.out.println(rs.getInt(1));
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            JdbcUtils.release(conn, pst, rs);
        }
    }
}