JDBC建立连接的时候为什么设置编码这块会出错啊啊啊啊啊
package com.Xerxes.JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Demo01_JDBC {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/web01?useUnicode=true&characterEncoding=UTF8&useSSL=false";
//指定编码,防止乱码。后面跟上问号
String user = "root";
String password = "123456";
Connection con = DriverManager.getConnection(url, user, password); //驱动管理器
Statement state = con.createStatement();
ResultSet rs = state.executeQuery("select * from user");
while(rs.next())
{
System.out.println(rs.getInt(1)+rs.getString(2)+rs.getString(3));
}
//关闭:结果集需要关闭。statement需要关闭。Connection也需要关闭。
if(rs != null)
rs.close();
if(state != null)
state.close();
if(con != null)
con.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}