public void addSMS(SmsFromHeadteacher smsFromHeadteacher){

		try{
		// Step 1: Load the JDBC driver.
	      Class.forName("com.mysql.jdbc.Driver");

	   // Step 2: Establish the connection to the database.
	      String url = "jdbc:mysql://localhost:3306/snv_db";
	      Connection conn = DriverManager.getConnection(url,"simonmysql","nomisa");

		String query = "INSERT INTO sms_from_headteacher ("

			+" creator,"
			+" comment,"
			+" sender,"
			+" date_received) VALUES ("
			+"?,?,?,?)";



			 // set all the preparedstatement parameters
		    PreparedStatement st = conn.prepareStatement(query);
		    st.setInt(1, smsFromHeadteacher.getCreator().getUserId());
		    st.setString(2, smsFromHeadteacher.getComment());
		    st.setString(3, smsFromHeadteacher.getSender());

		    //Converting from java.util.Date to java.sql.Date
		    java.util.Date utilDate = new java.util.Date();
		    utilDate = smsFromHeadteacher.getDateReceived();
		    java.sql.Date sqlDate = new java.sql.Date(utilDate.getTime());

		    st.setDate(4, sqlDate);


		    st.executeUpdate();
		    st.close();
		}
		catch(SQLException se){

			se.printStackTrace();

		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}