看看哪里报错了
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 | package cn.itcast.jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class Dbunit { private static final String URl = "jdbc:mysql://localhost:3306/admin" ; private static final String USRE= "admin" ; private static final String PASSWORD= "admin" ; public static void main(String[] args) throws Exception { Class.forName( "com.mysql.jdbc.Driver" ); Connection conn = DriverManager.getConnection(URl, USRE, PASSWORD); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery( "select * from students" ); while (rs.next()){ System.out.println(rs.getInt( "ID" ) + rs.getString( "name" )); } } } Exception in thread "main" java.sql.SQLException: Access denied for user 'admin' @ 'localhost' (using password: NO) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java: 957 ) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java: 3878 ) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java: 3814 ) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java: 871 ) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java: 1694 ) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java: 1215 ) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java: 2255 ) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java: 2286 ) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java: 2085 ) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java: 795 ) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java: 44 ) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java: 404 ) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java: 400 ) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java: 327 ) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at cn.itcast.jdbc.Dbunit.main(Dbunit.java: 19 ) |