import java.sql.Statement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; public class MySqlTest { private final static String dbUser = "dbo_java"; private final static String dbPass = "java_test"; private final static String dbHost = "192.168.1.111"; private final static String dbName = "java"; public static void main(String[] args) { Connection conn = null; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); conn = DriverManager.getConnection("jdbc:mysql://" + dbHost + "/" + dbName, dbUser, dbPass); System.out.println("Database connection established"); Statement s = conn.createStatement(); s.executeQuery("SELECT * FROM test_table"); ResultSet rs = s.getResultSet(); while (rs.next()) { int id = rs.getInt("id"); String name = rs.getString("name"); System.out.println("id:" + id); System.out.println("name:" + name); } rs.close(); s.close(); } catch (Exception e) { System.err.println("Cannot connect to database server:" + e.getMessage()); } finally { if (conn != null) { try { conn.close(); } catch (Exception e) { System.err.println("Cannot close connection to database:" + e.getMessage()); } } } } }