- 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