Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;
- public class DBConnection {
- // Info connessioni DB
- private static final String dbName = "MotoDB";
- private static final String url = "jdbc:mysql://motodb.c1s5lipxxzvy.eu-west-1.rds.amazonaws.com:3306";
- private static final String username = "Administrator";
- private static final String password = "cocomero";
- private Connection connection;
- private MysqlDataSource dataSource;
- public Connection getConnection() {
- dataSource = new MysqlDataSource();
- dataSource.setUser(username);
- dataSource.setPassword(password);
- dataSource.setServerName(url);
- dataSource.setDatabaseName(dbName);
- ResultSet rs;
- try {
- connection = dataSource.getConnection();
- /*Statement stmt = conn.createStatement();
- rs = stmt.executeQuery("SELECT * FROM CAMPIONATO");
- while (rs.next()) {
- System.out.println(rs.getString("anno"));
- }
- rs.close();
- stmt.close();
- */
- connection.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return connection;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement