Question

操作mysql的查询语句有中文时查不到结果

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

public class ConnectMySQL {
public static void main(String[] args) {
String url = "jdbc:mysql://127.0.0.1:3306/ztc";
String user = "admin";
String password = "123";
String sql ="select * from student where stu_name like binary '%刘%'";

Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;

try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(
url,user,password);
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next()) {
String[] result = new String[3];
result[0] =(String)rs.getString(1);
result[1] = (String)rs.getString(2);
// result[2] = (String)rs.getString(3);
System.out.print(result[0]+" ");
System.out.println(result[1]);
}
}catch (Exception e) {
e.printStackTrace();
}
finally {

try {
if(rs!=null) {
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(pstmt!=null) {
pstmt.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(conn!=null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}

Answer 1

在连接字符串中加charset项，如：
connectionString = @"server=localhost;user id=root;password=123456;database=mydb;charset=utf8;";

Answer 2

这也许是表当中不存在该字段