Guest User

Untitled

a guest
Nov 23rd, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.53 KB | None | 0 0
  1. import java.sql.*;
  2.  
  3. public class JDBC {
  4. static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
  5. static final String DATABASE_URL = "jdbc:mysql://localhost/Shortener";
  6. static final String USER_NAME = "Albuquerque";
  7. static final String USER_PASSWORD = "rootpasswordgiven";
  8.  
  9. public static String dataFromDB(String data) {
  10. System.out.println("Registering JDBC driver and connection...");
  11. try {
  12. Class.forName(JDBC_DRIVER);
  13. } catch(ClassNotFoundException e) {
  14. e.printStackTrace();
  15. }
  16. System.out.println("Registering Statement...");
  17. ResultSet resultSet = null;
  18. try (Connection connection = DriverManager.getConnection(DATABASE_URL, USER_NAME, USER_PASSWORD);
  19. Statement statement = connection.createStatement();
  20. ) {
  21. if (isID(data)) {
  22. String sqlQueryID = String.format("SELECT strings FROM ShortenerStrings WHERE id = %s", data);
  23. resultSet = statement.executeQuery(sqlQueryID);
  24. return resultSet.getInt("id") + "";
  25. } else {
  26. String sqlQuerySTRING = String.format("SELECT id FROM ShortenerStrings WHERE strings = %s", data);
  27. resultSet = statement.executeQuery(sqlQuerySTRING);
  28. return resultSet.getString("Strings") + "";
  29. }
  30. } catch(SQLException e) {
  31. e.printStackTrace();
  32. }
  33.  
  34. return null;
  35. }
  36.  
  37. private static boolean isID(String data) {
  38. for(int i = 0; i < data.length(); ++i) {
  39. if (!Character.isDigit(data.charAt(i)))
  40. return false;
  41. }
  42. return true;
  43. }
  44. }
  45.  
  46. Registering JDBC driver and connection...
  47. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  48. at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
  49. at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
  50. at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
  51. at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
  52. at java.lang.Class.forName0(Native Method)
  53. at java.lang.Class.forName(Class.java:264)
  54. at webserver.JDBC.dataFromDB(JDBC.java:14)
  55. at source_code.Solution.main(Solution.java:30)
  56. Registering Statement...
  57. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/Shortener
  58. at java.sql.DriverManager.getConnection(DriverManager.java:689)
  59. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  60. at webserver.JDBC.dataFromDB(JDBC.java:20)
  61. at source_code.Solution.main(Solution.java:30)
  62. null
Add Comment
Please, Sign In to add comment