Java connectivity with MySQL

Here is how database connectivity with MYSQL can be performed.

Use Datasource.

Context context = new InitialContext();
DataSource dataSource = (DataSource) context.lookup("java:comp/env/jdbc/myDB");

or configure from your database

MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setUser("scott");
dataSource.setPassword("tiger");
dataSource.setServerName("myDBHost.example.org");

Here is the connection code:

Connection conn = dataSource.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT ID FROM USERS");

rs.close();
stmt.close();
conn.close();

hope this will help you to connect to ...