mysql jdbc报密码错_JDBC链接Mysql数据库,为什么老是报这种异常,我密码没有写错,用Mysql登陆时候就是这密码...

packageJDBC;importjava.sql.Driver;importjava.sql.Connection;importjava.sql.Statement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.Properties;publi...

package JDBC;

import java.sql.Driver;

import java.sql.Connection;

import java.sql.Statement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Properties;

public class FirstJdbc {

public static void main(String[] args) {

Connection con = null;

Statement st = null;

ResultSet rs = null;

try{

Driver d = new com.mysql.jdbc.Driver();

Properties p = new Properties();

p.setProperty("user:", "root");

p.setProperty("password:", "jp");

con =d.connect("jdbc:mysql://localhost:3306/test",p);

st = con.createStatement();//创建一个Statement对象来将SQL语句发送到数据库。

String sql ="select * from sb;";

rs = st.executeQuery(sql);

while(rs.next()){

System.out.println("id"+rs.getInt("id"));

System.out.println(",name"+rs.getString("name"));

}

}catch(Exception e ){

e.printStackTrace();

}finally{

try{

rs.close();

}catch(Exception e){

}

try {

st.close();

} catch (Exception e) {

}

try {

con.close();

} catch (Exception e) {

}

}

}

}

异常 Access denied for user ''@'localhost' (using password: NO)

展开