Calma Work-Life Balance Test

<%@ page contentType="text/html; charset=iso-8859-1"%> <%@ page language="java"%> <%@ page errorPage=""%> <%@ page import="java.sql.*"%> <%@ page import="java.io.*"%> <%@ page import="java.util.*"%> <%@ page import="java.lang.*"%> <%@ page session="false"%> Calma Work-Life Balance Test

Downloads

Work-Life Balance Test

We all want to have a balance in our lives. Work is important (it pays the bills and gives us a sense of identity) but our home life is equally important. The Work-Life Balance Test seeks to draw attention to the many aspects of our lives - our relationships, money issues, family, social support, community issues, home life and work impact.

Take the test and see how 'balanced' you are! And we have some helpful advice if you need it - in your Results page.

Key
N	= No
n/a	= Not applicable
Y	= Yes

<% Connection con = null; Class.forName("com.mysql.jdbc.Driver").newInstance(); //Class.forName("org.gjt.mm.mysql.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://localhost/alexaad1_calmaDB?user=alexaad1_webuser&password=webuser1234"); //con = DriverManager.getConnection("jdbc:mysql://localhost/calmaDB","gavin","whisky"); %>

<% String tableName = "work_life_questions"; String query = null; //the query Statement statement = null; ResultSet resultSet = null; String code, order, question, no_value, na_value, yes_value; try { statement = con.createStatement(); query = "SELECT * "+"FROM "+ tableName +" "; statement.execute(query); resultSet = statement.getResultSet(); while (resultSet.next()) { code = resultSet.getString(1); order = resultSet.getString(2); question = resultSet.getString(3); no_value = resultSet.getString(4); na_value = resultSet.getString(5); yes_value = resultSet.getString(6); // Print row, with hidden fields, for each question out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); } out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println("

		N	n/a	Y
"); out.println(order); out.println("	"); // Hidden fields for question letter code and order out.println(""); out.println(""); out.println(question); out.println("	"); out.println(""); out.println("	"); out.println(""); out.println("	"); out.println(""); out.println("
		N	n/a	Y

"); out.println(""); out.println("

"); } catch (Exception e) { e.printStackTrace(); out.println("Query failed"); } finally { try { if(con!=null) con.close(); } catch(SQLException sqle) { sqle.printStackTrace(); out.println("con.close() failed"); } } %>

Site design & construction by