public int checkTestByName(String test_name) {
		String checkTestQuery = "SELECT * FROM TEST_TYPE WHERE UPPER(test_name) = UPPER('"
				+ test_name + "')";
		int type_id = 0;
		try {
			rs = stmt.executeQuery(checkTestQuery);
			if (rs.next()) {
				type_id = rs.getInt("type_id");
			}
		} catch (SQLException e) {
			System.out.println("Cannot execute select test type statement.");
		}
		return type_id;
	}