Java - Connect to mysql

        static String driver = "com.mysql.jdbc.Driver";
        static String ConnectionString = "jdbc:mysql://localhost:3306/test";
	static String username = "test";
	static String password = "test";
	
	public final Connection getConnection()
	{
		try {
			Class.forName(driver);
			Connection conn = DriverManager.getConnection(ConnectionString, username, password);
			return conn;
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
	}

package io.hause.db;

import java.sql.*;
import java.util.ArrayList;

import io.hause.models.AustauschprogrammlisteModel;
import io.hause.utils.*;


public class Austauschprogrammliste 
{
	// CURD
	DBConnector dbc;
	Connection conn;
	
	public Austauschprogrammliste()
	{
		dbc = new DBConnector();
		conn = dbc.getConnection();
	}
	
	// select
	public ArrayList<AustauschprogrammlisteModel> select(String condition)
	{
		ArrayList<AustauschprogrammlisteModel> alapls = new ArrayList<AustauschprogrammlisteModel>();
		try
		{
			if(condition.trim().equals(""))
			{
				condition = "1=1";
			}
			
			String queryStr = "SELECT * FROM Austauschprogrammliste WHERE " + condition;
			
			PreparedStatement ps = conn.prepareStatement(queryStr);
			
			ResultSet rs = ps.executeQuery();

			while(rs.next())
			{
				AustauschprogrammlisteModel apl = new AustauschprogrammlisteModel();
				apl.setId(rs.getInt("id"));
				apl.setAustauschprogrammlisteName("programName");
				alapls.add(apl);
			}
			
			return alapls;
		}
		catch (Exception ex)
		{
			return null;
		}
	}
	
	// insert
	public boolean insert(AustauschprogrammlisteModel m)
	{
		String insertStr = "INSERT INTO Austauschprogrammliste(programName) VALUES(?)";
		
		PreparedStatement ps;
		try {
			ps = conn.prepareStatement(insertStr);
			ps.setString(1, m.getAustauschprogrammlisteName());
			ps.executeUpdate();
			return true;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			//e.printStackTrace();
			return false;
		}
	}
	
	// update 
	public boolean update(AustauschprogrammlisteModel m)
	{
		String insertStr = "UPDATE Austauschprogrammliste SET programName=? WHERE id=?";
		
		PreparedStatement ps;
		try {
			ps = conn.prepareStatement(insertStr);
			ps.setString(1, m.getAustauschprogrammlisteName());
			ps.setInt(2, m.getId());
			ps.executeUpdate();
			return true;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			//e.printStackTrace();
			return false;
		}
	}
	
	//delete by id
	public boolean delete(int id)
	{
		String insertStr = "DELETE FROM Austauschprogrammliste WHERE id=?";
		
		PreparedStatement ps;
		try {
			ps = conn.prepareStatement(insertStr);
			ps.setInt(1, id);
			ps.executeUpdate();
			return true;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			//e.printStackTrace();
			return false;
		}
	}
	
	// test
	/*
	public static void main(String args[])
	{
		Austauschprogrammliste aplist = new Austauschprogrammliste();
		
		//ArrayList<AustauschprogrammlisteModel> apls = aplist.select("");
		
		//System.out.println("count:" + apls.size());
		
		AustauschprogrammlisteModel m = new AustauschprogrammlisteModel();
		//m.setId(3);
		m.setAustauschprogrammlisteName("Landesprogramm South Australia");
		
		if(aplist.insert(m))
		{
			System.out.println("Yes");
		}
		else
		{
			System.out.println("No");
		}
	}
	*/
}