Advertisement
Guest User

Untitled

a guest
Mar 5th, 2016
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.61 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.ResultSet;
  4. import java.sql.SQLException;
  5. import java.sql.Statement;
  6. import java.util.HashMap;
  7.  
  8. public class Conn {
  9. public static String url = "jdbc:mysql://127.9.77.2:3306/mysql";
  10. public static String user = "adminSKr7Tbz";
  11. public static String password = "h1xha****";
  12.  
  13. public static void main(String[] args) throws ClassNotFoundException, SQLException {
  14. // TODO Auto-generated method stub
  15. Class.forName("com.mysql.jdbc.Driver");
  16. Connection conn = DriverManager.getConnection(url,user,password);
  17. System.out.println("Connecting to database...");
  18. Statement stmt = conn.createStatement();
  19. ResultSet rs = stmt.executeQuery("select * from country LIMIT 10;");
  20. while (rs.next()) {
  21. HashMap map = new HashMap();
  22. String name = rs.getString("Name");
  23. Integer col = Integer.parseInt(rs.getString("Area"));
  24. map.put("name",name);
  25. map.put("value",col);
  26. System.out.println(map);
  27.  
  28. }
  29. }
  30. }
  31.  
  32. Exception in thread "main" java.sql.SQLException: Access denied for user 'adminSKr7Tbz'@'localhost' (using password: YES)
  33. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
  34. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
  35. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
  36. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
  37. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894)
  38. at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3808)
  39. at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1256)
  40. at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2032)
  41. at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
  42. at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
  43. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  44. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  45. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  46. at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  47. at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
  48. at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
  49. at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)
  50. at java.sql.DriverManager.getConnection(DriverManager.java:571)
  51. at java.sql.DriverManager.getConnection(DriverManager.java:215)
  52. at visualize.Conn.main(Conn.java:18)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement