• Using databases from Java programs
   
  • Create Java program, which executes clause "SELECT * FROM MEMBER" and prints results by using System.out.
     
  • Accessing database drivers:
     Class.forName("org.gjt.mm.mysql.Driver").newInstance();
    
  • Opening connection:
    Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1/database","root",null);

• SQL sentence is made in class Statement:
  Statement stmt = con.createStatement();

 SELECT -clauses:
ResultSet rs = stmt.executeQuery("...");

• Clauses for INSERT, UPDATE and DELETE:
  stmt.executeUpdate("...");
   
• Back