Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- public class JDBC {
- static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
- static final String DATABASE_URL = "jdbc:mysql://localhost/Shortener";
- static final String USER_NAME = "Albuquerque";
- static final String USER_PASSWORD = "rootpasswordgiven";
- public static String dataFromDB(String data) {
- System.out.println("Registering JDBC driver and connection...");
- try {
- Class.forName(JDBC_DRIVER);
- } catch(ClassNotFoundException e) {
- e.printStackTrace();
- }
- System.out.println("Registering Statement...");
- ResultSet resultSet = null;
- try (Connection connection = DriverManager.getConnection(DATABASE_URL, USER_NAME, USER_PASSWORD);
- Statement statement = connection.createStatement();
- ) {
- if (isID(data)) {
- String sqlQueryID = String.format("SELECT strings FROM ShortenerStrings WHERE id = %s", data);
- resultSet = statement.executeQuery(sqlQueryID);
- return resultSet.getInt("id") + "";
- } else {
- String sqlQuerySTRING = String.format("SELECT id FROM ShortenerStrings WHERE strings = %s", data);
- resultSet = statement.executeQuery(sqlQuerySTRING);
- return resultSet.getString("Strings") + "";
- }
- } catch(SQLException e) {
- e.printStackTrace();
- }
- return null;
- }
- private static boolean isID(String data) {
- for(int i = 0; i < data.length(); ++i) {
- if (!Character.isDigit(data.charAt(i)))
- return false;
- }
- return true;
- }
- }
- Registering JDBC driver and connection...
- java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
- at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
- at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
- at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
- at java.lang.Class.forName0(Native Method)
- at java.lang.Class.forName(Class.java:264)
- at webserver.JDBC.dataFromDB(JDBC.java:14)
- at source_code.Solution.main(Solution.java:30)
- Registering Statement...
- java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/Shortener
- at java.sql.DriverManager.getConnection(DriverManager.java:689)
- at java.sql.DriverManager.getConnection(DriverManager.java:247)
- at webserver.JDBC.dataFromDB(JDBC.java:20)
- at source_code.Solution.main(Solution.java:30)
- null
Add Comment
Please, Sign In to add comment