JDBC-查询时中文内容解析问题

问题原因

动画演示

具体代码

package com.coderitl;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Scanner;

/**
 * @Auther: coder-itl
 * @Date: 2021/8/9  10:55
 * @Description: com.coderitl
 * @version: 1.0
 */
public class PreJDBCLogin {
    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.jdbc.Driver"); // ?useUnicode=true&characterEncoding=utf-8&
        Connection connection = DriverManager.getConnection("jdbc:mysql://101.34.1.228:3306/test?autoReconnect=true&useSSL=false", "root", "root");
        if (connection != null) {
            System.out.println("数据库连接成功");
        } else {
            System.out.println("数据库连接失败");
        }
        // prepareStatement
        Scanner scan = new Scanner(System.in);
        System.out.println("请输入用户名: ");
        String inputUsername = scan.next();
        System.out.println("请输入密码: ");
        String inputPassword = scan.next();
        // 使用 ？ 作为占位符
        PreparedStatement preparedStatement = connection.prepareStatement("select username,password from userinfo where username=? and password=?");
        // 下标从 1 开始，中文内容不能正确解析
        // 解决方案: jdbc:mysql://101.34.1.228:3306/test?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false
        preparedStatement.setString(1, inputUsername);
        preparedStatement.setString(2, inputPassword);
        // 执行sql
        ResultSet resultSet = preparedStatement.executeQuery();
        if (resultSet.next()) {
            System.out.println("登录成功");
        } else {
            System.out.println("登录失败");
        }
    }
}

解决方案

• 修改url

 Connection connection = DriverManager.getConnection("jdbc:mysql://101.34.1.228:3306/test?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false", "root", "root");

• 正确输出