Скачать или смотреть Part 3.5: Java EE Web App Tutorial - Connecting DB to the WebApp with Environment Variables

The Environment variables in the tutorial works on Mac OSX, but unfortunately Windows based OS are different. It turned out that ampersand "&" breaks the string. So instead, on Windows machines, use three variable (where I have used my own MySql instance as example connection string - please substitute with your own):

-DJDBC_CONNECTION_STRING=jdbc:mysql://aavafvjib4gqt7.cq0gnplmhraq.eu-central-1.rds.amazonaws.com:3306/webapptutorial
-DJDBC_USER=root
-DJDBC_PASSWORD=webapp2017

In Java add:


DB_Url = System.getProperty("JDBC_CONNECTION_STRING");
String DB_User = System.getProperty("JDBC_USER");
String DB_Password = System.getProperty("JDBC_PASSWORD");
String DB_Connection_String = DB_Url + "?user=" + DB_User + "&password=" + DB_Password;

conn = DriverManager.getConnection(DB_Connection_String);

This works on both OSX and Windows.