JDBC中文模糊查询时在后要加characterEncoding=utf-8,不然是出不出来的
package dao;
import java.sql.Connection;import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DB {
static{
try{Class.forName("com.mysql.jdbc.Driver");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection con=null;
String url="jdbc:mysql://127.0.0.1:3306/test? characterEncoding=utf-8";
String userName="root";
String pwd="123456";
try{
con=DriverManager.getConnection(url, userName, pwd);
}catch(SQLException e){
e.printStackTrace();
}
return con;
}
public ResultSet getKeyWord(String key){
String sql="select Name from helpkey where Name like '%"+key+"%'";
System.out.println(sql);
Connection con=getConnection();
ResultSet rs=null;
Statement stm=null;
try{
stm=con.createStatement();
rs=stm.executeQuery(sql);
//System.out.println(rs.getString("name"));
}catch(SQLException e){
e.printStackTrace();
}
return rs;
}
}