Exception in thread "main" java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
        at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2205)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2236)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2035)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        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:425)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at MyQuery.main(MyQuery.java:14)







import java.sql.Connection;
        import java.sql.DriverManager;
        import java.sql.ResultSet;
        import java.sql.SQLException;
        import java.sql.Statement;




        public class MyQuery {

            public static void main(String[] args) throws SQLException {
                // TODO Auto-generated method stub
                Connection cn= DriverManager.getConnection("jdbc:mysql://localhost/?user=root&password=rootpassword");

              Statement s= null;
                  ResultSet rs= null;
                  s= cn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
                                        java.sql.ResultSet.CONCUR_READ_ONLY);
                  s.setFetchSize(Integer.MIN_VALUE);
                  s.execute("SELECT res_id FROM reservations WHERE filled= 0");
                  rs= s.getResultSet();
                  while (rs.next())
                  {
                    Reservation v= UnfilledReservation(rs.getInt(1));
                    LockReservation(v);
                    FillReservation(rs.getInt(1));
                    UnlockReservation(v);
                  }
                  rs.close();

            }

            private static void UnlockReservation(Reservation v) {
                // TODO Auto-generated method stub

            }

            private static void FillReservation(int int1) {
                // TODO Auto-generated method stub

            }

            private static Reservation UnfilledReservation(int int1) {
                // TODO Auto-generated method stub
                return null;
            }

            private static void LockReservation(Reservation v) {
                // TODO Auto-generated method stub

            }

        }