jdbc连接数据库报错Connection连接错误

 错误代码示例：

@Test
    public void test1() throws ClassNotFoundException, SQLException {
        //1:注册驱动
        Class.forName("com.mysql.jdbc.Driver");
        //2:获取链接
        String url = "jdbc:mysql://localhost:3308/spj";
        String user = "root";
        String password = "数据库密码";
        Connection conn = null;
        Statement sta = null;
        try {
            conn = DriverManager.getConnection(url, user, password);
            //3:定义sql语句
            String sql = "update j set city='ss' where jno=1";
            //4:获取执行sql语句的对象
            sta = conn.createStatement();
            //5:执行sql
            int count = sta.executeUpdate(sql); //返回受影响的行数
            //6:处理结果
            System.out.println(count);
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
           if(sta!=null)

            //7:释放资源
            sta.close();
           if(conn!=null)
            conn.close();

        }


    }

 

此时仅仅需要再 获取url连接时加上"?useUnicode=true&characterEncoding=utf-8&useSSL=false"即可；

@Test
    public void test1() throws ClassNotFoundException, SQLException {
        //1:注册驱动
        Class.forName("com.mysql.jdbc.Driver");
        //2:获取链接
  String url = "jdbc:mysql://localhost:3306/spj?useUnicode=true&characterEncoding=utf-8&useSSL=false";
        String user = "root";
        String password = "数据库密码";
        Connection conn = null;
        Statement sta = null;
        try {
            conn = DriverManager.getConnection(url, user, password);
            //3:定义sql语句
            String sql = "update j set city='ss' where jno=1";
            //4:获取执行sql语句的对象
            sta = conn.createStatement();
            //5:执行sql
            int count = sta.executeUpdate(sql); //返回受影响的行数
            //6:处理结果
            System.out.println(count);
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
           if(sta!=null)

            //7:释放资源
            sta.close();
           if(conn!=null)
            conn.close();

        }


    }