innoQuartz 실행을 위한 필요 설치 항목(실습 준비)

InnoQuearz.Setup

 

1. JVM 8이상 : InnoQuartz-Server/InnoQuartz-Designer 실행시 JDK 8이상의 버젼이 필요

    JDK 8 다운로드 Link - https://www.oracle.com/kr/java/technologies/javase/javase-jdk8-downloads.html    

  위의 사이트에서 로그인 후, JDK를 다운로드 받는다.

  (OpenJDK로 다운로드는 https://jdk.java.net/java-se-ri/8-MR3에서 다운로드 가능)

 

 

2. MariaDB (테스트용) 설치 

    Download Link - https://mariadb.org/download/

MariaDB Download

• 사용자 정보 : 계정(root / innoquartz), schema(edu_quartz)
• Check -> Enable access from remote machines for 'root' user 
• Check -> Use UTF8 as default server's character set

 

MariaDB Install wizard

 

• 테이블 생성시 입력 언어는 utf8_general_ci로 생성

3. Sample Table 생성

DROP DATABASE IF EXISTS EDU_QUARTZ;

CREATE DATABASE EDU_QUARTZ CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE EDU_QUARTZ.`MEMBER` (
	`SEQ` INT NOT NULL AUTO_INCREMENT,
	`FIRST_NAME` VARCHAR(50) NULL DEFAULT NULL,
	`LAST_NAME` VARCHAR(50) NULL DEFAULT NULL,		
	`GENDER` VARCHAR(50) NOT NULL DEFAULT '',
	`AGE` INT NOT NULL,
	`CITY` VARCHAR(50) NOT NULL DEFAULT '',
	`JOIN_TYPE` VARCHAR(50) NOT NULL DEFAULT 'ONLINE',
	`CREATE_DT` TIMESTAMP NOT NULL,
	`MODIFY_DT` TIMESTAMP NOT NULL,
	PRIMARY KEY (`SEQ`)
)
COLLATE='utf8mb4_general_ci'
;

CREATE TABLE EDU_QUARTZ.`MEMBER_MALE` (
	`SEQ` INT NOT NULL AUTO_INCREMENT,
	`FIRST_NAME` VARCHAR(50) NULL DEFAULT NULL,
	`LAST_NAME` VARCHAR(50) NULL DEFAULT NULL,		
	`GENDER` VARCHAR(50) NOT NULL DEFAULT '',
	`AGE` INT NOT NULL,
	`CITY` VARCHAR(50) NOT NULL DEFAULT '',
	`JOIN_TYPE` VARCHAR(50) NOT NULL DEFAULT 'ONLINE',
	`CREATE_DT` TIMESTAMP NOT NULL,
	`MODIFY_DT` TIMESTAMP NOT NULL,
	PRIMARY KEY (`SEQ`)
)
COLLATE='utf8mb4_general_ci'
;

CREATE TABLE EDU_QUARTZ.`MEMBER_FEMALE` (
	`SEQ` INT NOT NULL ,
	`FIRST_NAME` VARCHAR(50) NULL DEFAULT NULL,
	`LAST_NAME` VARCHAR(50) NULL DEFAULT NULL,		
	`GENDER` VARCHAR(50) NOT NULL DEFAULT '',
	`AGE` INT NOT NULL,
	`CITY` VARCHAR(50) NOT NULL DEFAULT '',
	`JOIN_TYPE` VARCHAR(50) NOT NULL DEFAULT 'ONLINE',
	`CREATE_DT` TIMESTAMP NOT NULL,
	`MODIFY_DT` TIMESTAMP NOT NULL,
	PRIMARY KEY (`SEQ`)
)
COLLATE='utf8mb4_general_ci'
;

CREATE TABLE EDU_QUARTZ.`MEMBER_VIP` (
	`SEQ` INT NOT NULL ,
	`FIRST_NAME` VARCHAR(50) NULL DEFAULT NULL,
	`LAST_NAME` VARCHAR(50) NULL DEFAULT NULL,		
	`GRADE` VARCHAR(10) ,
	`GENDER` VARCHAR(1) NOT NULL DEFAULT '',
	`AGE` INT NOT NULL,
	`CITY` VARCHAR(50) NOT NULL DEFAULT '',
	`JOIN_TYPE` VARCHAR(50) NOT NULL DEFAULT 'ONLINE',	
	`CREATE_DT` TIMESTAMP NOT NULL,
	`MODIFY_DT` TIMESTAMP NOT NULL,
	PRIMARY KEY (`SEQ`)
)
COLLATE='utf8mb4_general_ci'

 

 

4. InnoQuartz 교육 동영상

   1) InnoQuartz Setup - youtu.be/3frqTfqLzHY

InnoQuartz.Setup

 

   2) InnoQuartz-Designer(Basic) - youtu.be/TZxkFTeLPo8

InnoQuartz-Designer(Basic)

 

   3) InnoQuartz-Designer(Advanced) - youtu.be/wAgK4rl-0I4

nnoQuartz-Designer(Advanced)

 

   4) InnoQuartz-Server - youtu.be/y5twBCaosQ4

InnoQuartz-Server

 

   5) SharedRepository(Git) : youtu.be/USOECabFN5o

InnoQuartz-Designer.SharedRepository(Git)