Agenda.java

package application;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Map;

public class Agenda {
	private ArrayList<String> mod;
	private String  creator, name, code;
	Map<String, String> map;

	public Agenda(String[] mod, String dates, String creator, String name,
			String c) {
		this.mod = new ArrayList<String>(Arrays.asList(mod));
		this.creator = creator;
		this.name = name;
		code = c;
		map = NotableDates.stringToMap(dates);
		this.mod.removeAll(Arrays.asList("", null));
	}
	public Agenda(ArrayList<String> mod, String dates, String creator, String name,
			String c) {
		this.mod = mod;
		this.creator = creator;
		this.name = name;
		code = c;
		this.mod.removeAll(Arrays.asList("", null));

		map = NotableDates.stringToMap(dates);
	}

	public void put(String s, String s1){
		map.put(s, s1);
	}
	public void addMod(String s) {
		mod.add(s);
	}
	@Override
	public String toString(){
		return this.name;
	}

	public void removeMod(String s) {
		mod.remove(s);
	}

	public ArrayList<String> getMods() {
		return mod;
	}

	public String getCreator() {
		return creator;
	}

	public String getName() {
		return name;
	}

	public String getActivationCode() {
		return code;
	}

	public void changeCreator(String s) {
		creator = s;
	}

	public void changeName(String s) {
		name = s;
	}


	public Map<String, String> getMap(){
		return map;
	}
	private String modString() {

		return mod.toString();
	}
	private static ArrayList<String> toListFromString(String s){
		String value = s;
		if(value.startsWith("[,")){
			value.replaceFirst(", ", "");
		}
		if (value.isEmpty()) {
			return new ArrayList<String>(0);
		}
		if (value.length() == 1) {
			return new ArrayList<String>(Arrays.asList(new String[] { s }));
		}
		value = value.substring(1, value.length() - 1).replaceAll(" ", "");
		String[] split = value.split(",");

		return new ArrayList<String>(Arrays.asList(split));
	}
	public static Agenda getAgenda(String co) {
		String s = "select * from Agenda where Code ='" + co + "'";
		Connection conn = null;

		try {
			Class.forName("com.mysql.jdbc.Driver");

			conn = DriverManager.getConnection(Global.URL + Global.DATABASE,
					Global.USERNAME, Global.PASSWORD);
			PreparedStatement ps = conn.prepareStatement(s);
			ResultSet x = ps.executeQuery();
			if (x.next()) {
				return new Agenda(toListFromString(x.getString(4)),
						x.getString(5), x.getString(3), x.getString(1), co);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		System.out.println("Returning null at getAgenda(String)");
		return null;
	}

	public boolean exists() {
		return getAgenda(code) != null;
	}

	public void update() {
		String sql = "UPDATE Agenda SET Name='" + getName() + "', Creators='"
				+ getCreator() + "', Mods='" + modString() + "', Dates='"
				+ NotableDates.mapToString(map) + "' WHERE Code='"
				+ getActivationCode() + "'";
		Connection conn = null;
		Statement stmt = null;

		try {
			Class.forName("com.mysql.jdbc.Driver");

			conn = DriverManager.getConnection(Global.URL + Global.DATABASE,
					Global.USERNAME, Global.PASSWORD);
			if(!exists()){
				return;
			}
			System.out.println(sql);
			stmt = conn.createStatement();
			stmt.executeUpdate(sql);

		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public void create() {
		String sqls = "INSERT INTO Agenda(Name, Code, Creators, Mods, Dates) VALUES('"
				+ name
				+ "', '"
				+ code
				+ "', '"
				+ creator
				+ "', '"
				+ modString() + "', '" + NotableDates.mapToString(map) + "');";
		String s = "select * from Agenda where Code = '" + code + "'";
		Connection conn = null;
		Statement stmt = null;

		try {
			Class.forName("com.mysql.jdbc.Driver");

			conn = DriverManager.getConnection(Global.URL + Global.DATABASE,
					Global.USERNAME, Global.PASSWORD);
			PreparedStatement ps = conn.prepareStatement(s);
			ResultSet x = ps.executeQuery();
			if (x.next()) {
				System.out.println("Activation Code exists");
				return;
			}
			System.out.println(sqls);
			stmt = conn.createStatement();
			stmt.executeUpdate(sqls);

		} catch (Exception e) {
			e.printStackTrace();
		}

	}
}