Comment Added by : Józek Java

Comment Added at : 2013-05-14 15:01:13

Comment on Tutorial : Using JDBC to connect to MySQL from Java Program By Rajan
Yes. I have been trying to optimize this code for several hours and I found this solution! Check this piece of code:

import java.sql.*;

public class pierwszePolaczenie
{

public static void main(String args[])
{

try
{
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/javatest", "root", "");
Statement stmt = con.createStatement();

ResultSet rs = stmt.executeQuery("Select * FROM osoba");

while (rs.next())
{
System.out.println(String.format("Id: %s, Imie: %s, Nazwisko: %s ",
rs.getString("Id"), rs.getString("Imie"), rs.getString("Nazwisko")));
}

con.close();
}

catch(SQLException e)
{
e.printStackTrace();
}

}

}

View Tutorial