File name Classdb.java
import java.sql.*;
import javax.sql.*;
public class classdb {
Connection con = null;
public static void connect ()
{
Connection conn = null;
try
{
String userName = "darwin1234";
String password = "donmock123";
String User;
String Userpassword;
String url = "jdbc:mysql://localhost/Clients";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection (url, userName, password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * from UsersInfo ");
while (rs.next()) {
User = rs.getString(1);
Userpassword = rs.getString(2);
System.out.println(User);
System.out.println(Userpassword);
}
System.out.println ("Database connection established");
}
catch (Exception e)
{
System.err.println ("Cannot connect to database server");
}
}
}
This is the Idea on how to connect mysql database in java. :)