Tuesday, September 11, 2012

Connect to MySQL with JDBC driver

import java.sql.*;

public class MySqlConnect{
  public static void main(String[] args) {
       try {
                Class.forName("com.mysql.jdbc.Driver");
                Connection con = DriverManager.getConnection("jdbc:mysql://localhost/Polaroid?user=root&password=");
                Statement st = con.createStatement();
                ResultSet rs = st.executeQuery("select * from cases");

                while(rs.next()) {
                    System.out.println( rs.getString("id"));
                }
                st.close();
                rs.close();
                con.close();
        } catch (Exception ex) {
                ex.printStackTrace();
        }


  }
}

No comments:

Advance Java Blogging

Java New Articles

Javas Latest News

Java Web Services and XML

Ajax Latest News

Mac OS Java Features

Advance Spotlights

Patterns Features