MySQL JDBC Fetch Data Using Statement Interface

You can follow the steps shown below to create a table in you database server. In our case, the database name is library and the table name is books. The SQL query to create this table is shown below.

First, insert some data in the books table. Then, You may try the following code snippet.

package com.t4b.jdbc.mysql.test; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class TestMain { static { try { Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch (Exception ex) { ex.printStackTrace(); } } public static void main(String[] args) { String publisher = "Oxford"; Connection con = null; Statement stmt = null; ResultSet rs = null; try { con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/library", "root", "iltwat"); stmt = con.createStatement(); rs = stmt.executeQuery("select * from books where publisher='" + publisher + "'"); while (rs.next()) { System.out.println( rs.getString("name") + " : " + rs.getString("author") + " : " + rs.getString("publisher")); } } catch (SQLException e) { e.printStackTrace(); } finally { if (rs != null) { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } if (con != null) { try { con.close(); } catch (SQLException e) { e.printStackTrace(); } } if (stmt != null) { try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } } } }

Happy Exploring!