JDBC | MySQL Connection
This tutorial will show you How to connect with MySQL Database?
Step 1: Download MySQL Workbench (Community). Also Download MySQL Connector jar. It's inside zip extract somewhere on your machine.
Step 2: Now install the MySQL workbench. Note: Let the username password be root(you can set custom values)
Step 3: Create a Database like (Test) and a table inside of it (users). Add some user records like name and email id. Assuming you guys know MySQL
Step 4: Open Eclipse and create a new java project. Create a class with the main method.
Add MySQL connector jar file to project. Right-click on project folder > BuildPath > Configure Build Path > Add External Jar > Locate to the connector jar file.
Step 5: Copy-paste the code below in java file
Connection conncetion = null;
try {
Class.forName(“com.mysql.jdbc.Driver”);
conncetion = DriverManager.getConnection(“jdbc:mysql://localhost:3306/restdb”, “root”, “root”);
//“jdbc:mysql://localhost:3306/Test” -> is url(if its a remote db then mention ip addr), “root”> is user, “root”-> password
Statement stmt = conncetion.createStatement();
System.out.println(“Created Connection”);
ResultSet rs = stmt.executeQuery(“select * from users”);
while (rs.next())
System.out.println(rs.getString(1)+” — “+rs.getString(2));
conncetion.close();
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
}finally {
try {
conncetion.close();
} catch (Exception e2) {
e2.printStackTrace();
}
}
}
}
Note: Above is just an example for retrieval of records. You can follow this documentation
Hope this was helpful. Thanks!
