Where I am-ish...

Opretter forbindelse til databasen. Rimelig besværligt!

import java.io.*;
import java.sql.*;
import java.util.*;

/**
 * @author qitsuk
 */
public class DBTool {

    private static String url;
    private static String username;
    private static String password;
    private int rows;

    private DBTool() {
    }

    public static Connection getConnection() throws FileNotFoundException, IOException, SQLException {
        Properties props = new Properties();
        FileInputStream in = new FileInputStream("DBP.properties");
        props.load(in);
        url = props.getProperty("jdbc.url");
        username = props.getProperty("jdbc.username");
        password = props.getProperty("jdbc.password");
        Connection conn = DriverManager.getConnection(url, username, password);
        return conn;
    }

Sætter en ny person ind i databasen og udskriver alle personer i Participants "Table-ed".

public class DBTest {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) throws FileNotFoundException, IOException, SQLException {
        Connection conn = DBTool.getConnection();
        Statement state = conn.createStatement();
        String query2 = "INSERT INTO Participants VALUES('05', 'Jørgensen', 'Hanne', '040932-1364', 'Dat Street 8')";
        String query = "SELECT * FROM Participants";
        state.execute(query2);
        ResultSet rs = state.executeQuery(query);
        while (rs.next()) {
            System.out.println("ID:         " + rs.getString("ID"));
            System.out.println("Last Name:  " + rs.getString("Last_Name"));
            System.out.println("First Name: " + rs.getString("First_Name"));
            System.out.println("CPR:        " + rs.getString("CPR"));
            System.out.println("Address:    " + rs.getString("Address"));
            System.out.println("__________________");
        }

    }
}

Udskriver det her:
ID:         1
Last Name:  Andersen
First Name: Viggo
CPR:        040835-3657
Address:    Filth Street 8
__________________
ID:         2
Last Name:  Hansen
First Name: Bent
CPR:        030548-3521
Address:    Coronation Road 12
__________________
ID:         3
Last Name:  Svendsen
First Name: Marianne
CPR:        050862-0258
Address:    Slither Avenue 6
__________________
ID:         4
Last Name:  Jensen
First Name: Margrethe
CPR:        091229-3692
Address:    Hiatus Boulevard
__________________
ID:         5
Last Name:  Jørgensen
First Name: Hanne
CPR:        040932-1364
Address:    Dat Street 8
__________________

So much work for so very little output!! :P