Rurony's Training Gym

Spring OXM모듈의 JAXB를 활용한 Tree 구현 예제.

1. spring-oxm 라이브러리 추가 (maven dependency 사용)
jar download url : http://mvnrepository.com/artifact/org.springframework/spring-oxm/3.0.5.RELEASE

2. Spring Bean 설정

XML 응답을 위한 MarshallingView 등록하고 XML 출력을 위한 바운드 객체를 property로 주입.

<bean id="xmlViewer" class="org.springframework.web.servlet.view.xml.MarshallingView">

<constructor-arg>

<bean class="org.springframework.oxm.jaxb.Jaxb2Marshaller">

<property name="classesToBeBound">

<list>

<value>com.rurony.format.common.tree.TreeNode</value>

</list>

</property>

</bean>

</constructor-arg>

</bean>

3. XML 출력을 위한 바운드 객체

XML 출력을 위해 JAXB annotation을 설정하고 Tree 구현을 위해 객체 내에 하위 객체를 포함하도록 구현.

@XmlRootElement(name="Tree")

@XmlAccessorType(XmlAccessType.FIELD)

public class TreeNode {

@XmlAttribute

private String option;

@XmlAttribute

private String status;

@XmlAttribute

private String name;

@XmlAttribute

private int depth;

@XmlAttribute

private int seq;

@XmlAttribute

private String type;

@XmlAttribute

private String parentId;

@XmlAttribute

private String id;

@XmlElement(name="Node")

protected List<TreeNode> nodes = new ArrayList<TreeNode>();

 

public TreeNode() {

}

public TreeNode(String id, String parentId, String type, int seq, String name, String status, String option) {

this.id = id;

this.parentId = parentId;

this.type = type;

this.seq = seq;

this.depth = 0;

this.name = name;

this.status = status;

this.option = option;

}

public void add(TreeNode node) {

if (id.equals(node.parentId)) {

node.depth = depth + 1;

nodes.add(node);

return;

}

Iterator<TreeNode> iter = nodes.iterator();

while (iter.hasNext()) {

iter.next().add(node);

}

}  

[... Setter/Getter ...]

public List<TreeNode> getNodes() {

return nodes;

}

public void setNodes(List<TreeNode> nodes) {

this.nodes = nodes;

}

}

4. MakeTreeNode Class

XML 바운드 객체을 사용하여 Tree XML을 구현하는 객체.

public class MakeTreeNode {

TreeNode treeNode;

public MakeTreeNode(String id, String parentId, String type, int seq, String name, String status, String option) {

treeNode = new TreeNode(id, parentId, type, seq, name, status, option);

}

public MakeTreeNode() {

treeNode = new TreeNode("0", "-1", "1", 1, "ROOT", "1", "");

}

public void add(TreeNode node) {

treeNode.add(node);

}

public void addAll(List<TreeNode> nodes) {

Iterator<TreeNode> iter = nodes.iterator();

while (iter.hasNext()) {

add(iter.next());

}

}

public TreeNode getTreeXmlNode() {

return treeNode;

}

} 

5. Test Tree Util

Domo Tree 추가

public static TreeNode getTestTreeXml() {

List<TreeNode> treeList = new ArrayList<TreeNode>();

treeList.add(new TreeNode("1", "0", "type", 1, "Node 1", "status", "option"));

treeList.add(new TreeNode("2", "1", "type", 1, "Node 1-1", "status", "option"));

treeList.add(new TreeNode("3", "1", "type", 2, "Node 1-2", "status", "option"));

treeList.add(new TreeNode("4", "0", "type", 2, "Node 2", "status", "option"));

treeList.add(new TreeNode("5", "4", "type", 1, "Node 2-1", "status", "option"));

treeList.add(new TreeNode("6", "4", "type", 2, "Node 2-2", "status", "option"));

treeList.add(new TreeNode("7", "5", "type", 1, "Node 2-1-1", "status", "option"));

treeList.add(new TreeNode("8", "5", "type", 2, "Node 2-1-2", "status", "option"));

treeList.add(new TreeNode("9", "0", "type", 3, "Node 3", "status", "option"));

treeList.add(new TreeNode("10", "9", "type", 1, "Node 3-1", "status", "option"));

MakeTreeNode tree = new MakeTreeNode("0", "-1", "1", 1, "Tree Root", "status", "option");

tree.addAll(treeList);

return tree.getTreeXmlNode();

}

6. Controller

@ResponseBody annotation을 사용하여 Url Mapping.

@RequestMapping("/testTreeXML")

public @ResponseBody TreeNode treeXML() {

return MakeTreeUtil.getTestTreeXml();

}

7. Domo Page

WARN : org.dbunit.dataset.AbstractTableMetaData - Potential problem found: The configured data type factory 'class org.dbunit.dataset.datatype.DefaultDataTypeFactory' might cause problems with the current database 'MySQL' (e.g. some datatypes may not be supported properly). In rare cases you might see this message because the list of supported database products is incomplete (list=[derby]). If so please request a java-class update via the forums.If you are using your own IDataTypeFactory extending DefaultDataTypeFactory, ensure that you override getValidDbProducts() to specify the supported database products.

private final static String driverClass = "com.mysql.jdbc.Driver";

private final static String connectionUrl = "jdbc:mysql://localhost/testdb";

private final static String username = "testdb";

private final static String password = "testdb";

private final static String schema = "testdb";

//private IDatabaseTester databaseTester;

public static Connection getConnection() throws InstantiationException, IllegalAccessException, ClassNotFoundException {

Connection conn = null;

try {

Class.forName(driverClass);

conn = DriverManager.getConnection(connectionUrl, username, password);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return conn;

}

@Before

public void setUp() throws Exception {

//databaseTester = new JdbcDatabaseTester(driverClass, connectionUrl, username, password);

//IDatabaseConnection connection = new DatabaseConnection(getConnection());

IDatabaseConnection connection = new MySqlConnection(getConnection(), schema);

try {

IDataSet dataSet = new FlatXmlDataSetBuilder().build(new File("resetDB.xml"));

//DatabaseOperation.CLEAN_INSERT.execute(databaseTester.getConnection(), dataSet);

DatabaseOperation.CLEAN_INSERT.execute(connection, dataSet);

} catch (Exception e) {

// TODO: handle exception

//databaseTester.getConnection().close();

connection.close();

}

}

public class StatServiceImpl implements StatService, ApplicationContextAware {

[...]

public void insertStat(String date) {

                //해당날짜의 log select.

StatBean stat = logDao.getLogStatByDate(date);

if (logger.isInfoEnabled()) {

logger.info(date + " Date Stat : " + stat.toString());

}

int checkStat = statDao.checkStat(date);

if (checkStat > 0) {

statDao.updateStat(stat);    //통계 update

if (logger.isInfoEnabled()) {

logger.info(date + " Date Stat Update");

}

} else {

statDao.insertStat(stat);    //통계 insert

if (logger.isInfoEnabled()) {

logger.info(date + " Date Stat Insert");

}

}

String accessLogDir = "/accessLog/";

String address = constantVo.getUrlContext() + "/admin/store/accessStat/dayStat?offsetDate=" + date;

String localFileName = context.getServletContext().getRealPath(constantVo.getDataUrl() + accessLogDir + date + ".html");

                //해당날짜의 접속통계 페이지를 HTML로 download

int downOk = downloadURL(address, localFileName);

if (downOk == 1) {

if (logger.isInfoEnabled()) {

logger.info(date + " Date Page Download");

}

logDao.deleteLog(date);    //해당날짜의 log delete

if (logger.isInfoEnabled()) {

logger.info(date + " Date Log Delete");

}

}

}

[...]

}

public class StatInsert extends QuartzJobBean {

private StatService statService; //could not autowired

public void setStatService(StatService statService) {

this.statService = statService;

}

protected void executeInternal(JobExecutionContext arg0) throws JobExecutionException {

[...]

statService.insertStat(date);

}

}

<!-- Service Bean -->
<bean id="statService" class="com.rurony.format.access.service.StatServiceImpl" />

<!-- Spring Quartz Scheduler Bean Setting -->

<!-- Simple Quartz Scheduler -->

<!--
<bean id="simpleQuartzJob" class="org.springframework.scheduling.quartz.JobDetailBean">

<property name="jobClass" value="com.rurony.format.schedule.StatInsert"/>

<property name="jobDataAsMap">

<map>

<entry key="statService">

<ref local="statService"/>

</entry>

</map>

</property>

</bean>

<bean id="simpleTrigger" class="org.springframework.scheduling.quartz.SimpleTriggerBean">

<property name="jobDetail" ref="simpleQuartzJob"/>

<property name="startDelay" value="6000"/>

<property name="repeatInterval" value="6000"/>

</bean>
-->

<!-- Cron Quartz Scheduler -->

<!-- Scheduler Bean -->

<bean id="cronQuartzJob" class="org.springframework.scheduling.quartz.JobDetailBean">

<property name="jobClass" value="com.rurony.format.schedule.StatInsert" />

<property name="jobDataAsMap">

<map>

<entry key="statService">

<ref local="statService"/>

</entry>

</map>

</property>

</bean>

<!-- Scheduler Trigger cronExpression setting -->

<bean id="cronTrigger" class="org.springframework.scheduling.quartz.CronTriggerBean">

<property name="jobDetail" ref="cronQuartzJob"/>

<!-- <property name="cronExpression" value="1 * * * * ?"/> -->

<!-- <property name="cronExpression" value="0 30 9 * * ?"/> -->

<property name="cronExpression" value="0 5 0 * * ?"/> <!-- 매일 0시 5분 0초 에 실행 -->

</bean>

<!-- Scheduler Trigger  -->

<bean class="org.springframework.scheduling.quartz.SchedulerFactoryBean">

<property name="triggers">

<list>

<!-- <ref bean="simpleTrigger"/> -->

<ref bean="cronTrigger"/>

</list>

</property>

<property name="quartzProperties">

<props>

<prop key="org.quartz.threadPool.class">org.quartz.simpl.SimpleThreadPool</prop>

    <prop key="org.quartz.threadPool.threadCount">5</prop>

    <prop key="org.quartz.threadPool.threadPriority">4</prop>

    <prop key="org.quartz.jobStore.class">org.quartz.simpl.RAMJobStore</prop>

    <prop key="org.quartz.jobStore.misfireThreshold">60000</prop>

</props>

</property>

</bean>

public class LogServiceImpl implements LogService {

@Autowired

private LogDao logDao;

public void insertLog(LogBean log) {

logDao.insertLog(log);

}

[...]

}

<!-- Service Bean -->
<bean id="logService" class="com.rurony.format.access.service.LogServiceImpl" />
 <!-- Filter Bean -->

<bean id="accessLogFilter" class="com.rurony.format.filter.AccessLogFilter" />

<filter>

<filter-name>accessLogFilter</filter-name>

<filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class>

</filter>

  

<filter-mapping>

<filter-name>accessLogFilter</filter-name>

<url-pattern>/*</url-pattern>

</filter-mapping>

C:\Program Files\Microsoft SQL Server\MSSQL\Data [db_name_Log.ldf]
db_name_Log.ldf 용량 ==> 26GB

-- [db_name] 트랜잭션 로그정보 초기화

-- backup log db_name with truncate_only

-- [db_name] 트랜잭션 로그파일의 물리적인 크기를 줄임

-- dbcc shrinkdatabase (db_name)

 

db_name_Log.ldf 용량 ==> 1MB

--//dbcc shrinkfile (파일이름)

2. Nexus Repository를 사용하기 위한 설정
1) setting.xml

~~
<mirrors>

    <mirror>
        <id>nexus</id>
        <mirrorOf>*</mirrorOf>
        <url>http://localhost:7000/nexus/content/groups/public</url>

    </mirror>

</mirrors>

~~

<profiles>

    <profile>

        <id>nexus</id>    

        <repositories>
            <repository>

            <id>central</id>

            <url>http://central</url>

            <releases><enabled>true</enabled></releases>

            <snapshots><enabled>true</enabled></snapshots>

        </repository>

        </repositories>

        <pluginRepositories>

            <pluginRepository>

                <id>central</id>

                <url>http://central</url>

                <releases><enabled>true</enabled></releases>

                <snapshots><enabled>true</enabled></snapshots>

        </pluginRepository>

        </pluginRepositories>

    </profile>

</profiles>

<activeProfiles>

    <activeProfile>nexus</activeProfile>

</activeProfiles>

~~

1) Repositories 메뉴 --> Add --> Proxy Repository

 
2) Repository ID, Repository Name, Remote Storage Location  입력 후 Save 버튼 클릭으로 완료

 
3) Public Repositories에 등록한 Proxy Repository 추가 

 
4. 3rd party Repository 추가
1) Repositories 메뉴 --> 3rd party repository 선택 --> Artifact Upload 탭 선택 후 업로드
2) POM 파일이 있다면 GAV Definition의 From POM 선택 후 해당  POM 파일 선택 :
    - groupId, artifactId, version은 POM 파일의 내용으로 자동 결정
3) POM 파일이 없다면 GAV Definition의 GAV Parameters 선택 후 해당  Artifact 파일 선택 :
    - groupId, artifactId, version 직접 입력

4) Select Artifact(s) to Upload... 버튼 선택후 해당 파일 선택
5) Add Artifact 버튼을 클릭하여 추가

6) Upload Artifact(s) 버튼을 클릭하여 완료 
7) 등록된 Artifact의 dependency 정보를 사용하여 사용할 프로젝트에서 dependency를 추가 하여 사용.

 
5. 개발 라이브러리 배포
1) Users 메뉴 --> deployment 사용자 우클릭 후 PASSWORD 변경

2) setting.xml

~~

<servers>

    <!-- Nexus deploy user setting -->

    <server>

        <id>nexus-deployment</id>

        <username>deployment</username>

     <password>********</password>

    </server>

</servers>
~~

3) pom.xml : snapshot 또는 release 버전에 맞게 해당 Repository에 Deploy : deploy 페이즈 실행 시 배포

<distributionManagement>

<repository>

<id>nexus-deployment</id>

<name>Nexus Repository</name>

<url>http://localhost:7000/nexus/content/repositories/snapshots/</url>

</repository>

</distributionManagement>