java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
这错误到底怎么改啊?本人还是菜鸟,希望大家能说得详细一点,谢谢啦!!
package com.jingxin.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class JDBCText {
public static void main(String[] args) {
String sql="SELET * FROM tbl_user";
Connection conn=null;
Statement st=null;
ResultSet rs=null;
try {
Class.forName("com.mysql.jdbc.Driver");//注册JDBC驱动程序,forname用来初始化参数指定的类,并创建一个指定的实例对象。
String url = "jdbc:mysql://127.0.0.1:3306/testdb?"
+ "user=root&password=123456&useUnicode=true&characterEncoding=UTF8";
conn = DriverManager.getConnection(url);
st=conn.createStatement();
rs=st.executeQuery(sql);//发送sql语句
/*对ResultSet对象进行遍历*/
while(rs.next()){
System.out.println(rs.getInt("id")+" ");//用来获取数据库中字段类型为整型的字段值。
System.out.println(rs.getString("name")+" ");
System.out.println(rs.getString("password")+" ");
System.out.println(rs.getString("email")+" ");
System.out.println();
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
rs.close();
} catch (Exception e2) {
// TODO: handle exception
}
try {
st.close();
} catch (Exception e2) {
// TODO: handle exception
}
try {
conn.close();
} catch (Exception e2) {
// TODO: handle exception
}
}
}
}