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:

Java New Articles

Error loading feed.

Javas Latest News

Error loading feed.

Java Web Services and XML

Error loading feed.

Ajax Latest News

Error loading feed.

Mac OS Java Features

Error loading feed.

Advance Spotlights

Error loading feed.

Patterns Features

Error loading feed.