Guest User

Untitled

a guest
Nov 27th, 2018
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.19 KB | None | 0 0
  1. public Connection getMySqlConnection()
  2. {
  3. /* Declare and initialize a sql Connection variable. */
  4. Connection ret = null;
  5.  
  6. try
  7. {
  8.  
  9. /* Register for jdbc driver class. */
  10. Class.forName("com.mysql.cj.jdbc.Driver");
  11.  
  12. /* Create connection url. */
  13. String mysqlConnUrl = "jdbc:mysql://ip/ristorante?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC";
  14.  
  15. /* db user name. */
  16. String mysqlUserName = "guest";
  17.  
  18. /* db password. */
  19. String mysqlPassword = "guestpass";
  20.  
  21. /* Get the Connection object. */
  22. ret = DriverManager.getConnection(mysqlConnUrl , mysqlUserName , mysqlPassword );
  23.  
  24.  
  25. /* Get related meta data for this mysql server to verify db connect successfully.. */
  26. DatabaseMetaData dbmd = ret.getMetaData();
  27.  
  28. String dbName = dbmd.getDatabaseProductName();
  29.  
  30. String dbVersion = dbmd.getDatabaseProductVersion();
  31.  
  32. String dbUrl = dbmd.getURL();
  33.  
  34. String userName = dbmd.getUserName();
  35.  
  36. String driverName = dbmd.getDriverName();
  37.  
  38. System.out.println("Database Name is " + dbName);
  39.  
  40. System.out.println("Database Version is " + dbVersion);
  41.  
  42. System.out.println("Database Connection Url is " + dbUrl);
  43.  
  44. System.out.println("Database User Name is " + userName);
  45.  
  46. System.out.println("Database Driver Name is " + driverName);
  47.  
  48. }catch(Exception ex)
  49. {
  50. ex.printStackTrace();
  51. }finally
  52. {
  53. return ret;
  54. }
  55. }
  56.  
  57. W/System.err: java.lang.UnsupportedOperationException
  58. at java.util.regex.Matcher.group(Matcher.java:383)
  59. at com.mysql.cj.conf.ConnectionUrlParser.isConnectionStringSupported(ConnectionUrlParser.java:152)
  60. at com.mysql.cj.conf.ConnectionUrl.acceptsUrl(ConnectionUrl.java:258)
  61. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:195)
  62. at java.sql.DriverManager.getConnection(DriverManager.java:569)
  63. at java.sql.DriverManager.getConnection(DriverManager.java:219)
  64. at com.example.spara.restaurant.activity_home.getMySqlConnection(activity_home.java:163)
  65. at com.example.spara.restaurant.activity_home.onCreate(activity_home.java:80)
Add Comment
Please, Sign In to add comment