import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class BasicJDBCDemo
{
  Connection conn;
  Connection connn;

  public static void main(String[] args)
  {
    new BasicJDBCDemo();
  }

  public BasicJDBCDemo()
  {
  try
    {
    /* Class.forName("org.postgresql.Driver").newInstance();
      String url = "jdbc:postgresql://localhost:5432/postgres";
	  conn = DriverManager.getConnection(url, "postgres", "postgres");*/
	  //connn=DriverManager.getConnection(url, "rso2", "rso2");
	  Class.forName("com.mysql.jdbc.Driver").newInstance();
      String url = "jdbc:mysql://localhost:3306/test";
      conn = DriverManager.getConnection(url, "mysql", "mysql");
      doTests();
      conn.close();
    }
   catch (ClassNotFoundException ex) {System.err.println(ex.getMessage());}
    catch (IllegalAccessException ex) {System.err.println(ex.getMessage());}
    catch (InstantiationException ex) {System.err.println(ex.getMessage());}
    catch (SQLException ex)           {System.err.println(ex.getMessage());}
  }

  private void doTests()
  {
    doSelectTest();

    //doInsertTest();  doSelectTest();
    //doUpdateTest();  doSelectTest();
    //doDeleteTest();   doSelectTest();
  }

  private void doSelectTest()
  {
    System.out.println("[OUTPUT FROM SELECT]");
   String query = "SELECT * FROM names";
   // String query = "DESCRIBE names";
    try
    {

      Statement st = conn.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
      ResultSet rs = st.executeQuery(query);

      while (rs.next())
      {

    	  int a = rs.getInt("id");
    	  String nm = rs.getString("name");
    	  String sn = rs.getString("sur");
    	  System.out.println(a + " " + nm+ " " +sn);

    	  /* if (a==20)
    	  {
    		  String query2 = "INSERT INTO names VALUES(18,'17','17')";
    		  Statement stt = connn.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
    		  ResultSet rss = stt.executeQuery(query2);
    		  System.out.println(rss.getInt("id")+" "+rss.getString("name")+" "+rss.getString("sur"));
    	  }*/

      }
    }
    catch (SQLException ex)
    {
      System.err.println(ex.getMessage());
    }
  }

  private void doInsertTest()
  {
    System.out.print("\n[Performing INSERT] ... ");
    try
    {
      Statement st = conn.createStatement();
      st.executeUpdate("INSERT INTO names (ID)" + "VALUES (1)");
    }
    catch (SQLException ex)
    {
      System.err.println(ex.getMessage());
    }
  }

  private void doUpdateTest()
  {
    System.out.print("\n[Performing UPDATE] ... ");
    try
    {
      Statement st = conn.createStatement();
      st.executeUpdate("UPDATE names SET NAME='y'");
    }
    catch (SQLException ex)
    {
      System.err.println(ex.getMessage());
    }
  }

  private void doDeleteTest()
  {
    System.out.print("\n[Performing DELETE] ... ");
    try
    {
      Statement st = conn.createStatement();
      st.executeUpdate("DELETE FROM names");
    }
    catch (SQLException ex)
    {
      System.err.println(ex.getMessage());
    }
  }
}