int LongSize = Long.SIZE;
System.out.println("longSize:"+LongSize);

@Data
public class TitleVO {
     private long    boardSeq;
     private String  title;
     private String  writer;
     private Date    date;
     private String  dateString;
     private long    count;
     private String  userId;              // userId가 아니라  Name아닌가?
     private long    userSeq;
     private boolean boardDel;
     private PostReplyVO postReplyVO; // 게시물 화면에서 그릴 때  순서 필요
     public PostReplyVO getPostReplyVO() {
           return postReplyVO;
     }
}

@Data
@NoArgsConstructor
@AllArgsConstructor
public class PostReplyVO {
     private long    boardSeq;
     private long    parentSeq;
     private int          boardOrder;
     private long    boardDepth;
}

<resultMap id="postReply" type="TitleVO">
   <id property="boardSeq" column="boardSeq" />
   <id property="title" column="title" />
   <id property="writer" column="writer" />
   <id property="date" column="date" />
   <id property="count" column="count" />
        <association property="postReplyVO"  javaType="PostReplyVO" >
             <result property="boardSeq"  column="boardSeq" />
             <result property="parentSeq"  column="parentSeq" />
             <result property="boardOrder"  column="boardOrder" />
             <result property="boardDepth"  column="boardDepth" />
        </association>
</resultMap>

<select id="getTitleVOList" parameterType="SelectVO" resultMap="postReply">
    SELECT board_seq as boardSeq
           , title
           , writer
           , date
           , count
           , user_id as userId
           , user_seq as userSeq
           , board_del as boardDel
           , parent_seq as parentSeq
           , board_order as boardOrder
           , board_depth as boardDepth  
    FROM    board
    
    <include refid="searchBoard"></include>
    ORDER BY parent_seq DESC, board_order ASC
    LIMIT #{start}, #{length}    
</select>

<dependency>
	<groupId>org.mybatis</groupId>
	<artifactId>mybatis</artifactId>
	<version>3.4.2</version>
</dependency>

<!-- mybatis-spring -->
<dependency>
	<groupId>org.mybatis</groupId>
	<artifactId>mybatis-spring</artifactId>
	<version>1.3.1</version>
</dependency>

<dependency>
	<groupId>org.mariadb.jdbc</groupId>
	<artifactId>mariadb-java-client</artifactId>
	<version>2.3.0</version>
</dependency>

import static org.junit.Assert.fail;

import java.sql.Connection;
import java.sql.DriverManager;
import org.junit.Test;
import lombok.extern.log4j.Log4j;

@Log4j
public class mysqlDBTest {

	@Test
	public void testConnection() throws ClassNotFoundException {	
		 Class.forName("org.mariadb.jdbc.Driver");
	    try (Connection con = DriverManager.getConnection("jdbc:mariadb://127.0.0.1:3310/test", "test", "1234"))
		{
			System.out.println(con);
		} catch (Exception e) {
			fail(e.getMessage());
		}
	}
}

- 아래는 접속을 확인하기 위해서 유닛테스트를 하기 위해 Connection 직접 호출
- RootConfig.java

@Bean
public DataSource dataSource(){
	DriverManagerDataSource dataSource = new DriverManagerDataSource();
	dataSource.setDriverClassName("org.mariadb.jdbc.Driver");
	dataSource.setUrl("jdbc:mariadb://localhost:3310/test");
	dataSource.setUsername("test");
	dataSource.setPassword("1234");
	
	return dataSource;
}

  @Bean
  public SqlSessionFactory sqlSessionFactory() throws Exception {
    SqlSessionFactoryBean sqlSessionFactory = new SqlSessionFactoryBean();
    sqlSessionFactory.setDataSource(dataSource());
    return (SqlSessionFactory) sqlSessionFactory.getObject();
  }

- test.java

  @Setter(onMethod_ = { @Autowired })
  private SqlSessionFactory sqlSessionFactory;

  @Test
  public void testMyBatis() {

    try (SqlSession session = sqlSessionFactory.openSession();
       Connection con = session.getConnection();) {
      log.info(con);
      

    } catch (Exception e) {
    	log.info("실패"+e.getMessage());
      fail(e.getMessage());
    }

  } } ~~~

<dependency>
	<groupId>com.zaxxer</groupId>
	<artifactId>HikariCP</artifactId>
	<version>2.7.4</version>
</dependency>

@Bean
public DataSource dataSource(){
	  HikariConfig hikariConfig = new HikariConfig();
	  hikariConfig.setDriverClassName("org.mariadb.jdbc.Driver");
	  hikariConfig.setJdbcUrl("jdbc:mariadb://localhost:3310/test");
	  hikariConfig.setUsername("test");
	  hikariConfig.setPassword("1234");
	
	  HikariDataSource dataSource = new HikariDataSource(hikariConfig);
	return dataSource;
}

columns : [
				{"data":"boardSeq", render:function(data, type, full, meta){
					return '<div class="board-list-boardSeq">'+data+'</div>';
				
				}},
				{"data":"title", render:function(data, type, full, meta){
            		return '<div class="board-list-title">'+data+'</div>';
            	}},
				{"data":"writer"},
				{"data":"dateString"},
				{"data":"count"}
            ],

result.put("iTotalRecords", totalCount);
result.put("iTotalDisplayRecords", totalCount);

  d.searchValue = selectValue;    					// x
  d.searchType =  $('.list-select-form').val();		// o

$('#searchBoardButton').click(function(){
	$('.list-select-form').val( $('.list-select-form').val());
	$('.board-list-serach-form').val($('.board-list-serach-form').val());
	$('#board1-table').DataTable().ajax.reload();
});

table = $('#board1-table').DataTable({
	pagingType:"simple_numbers_no_ellipses",        // 페이징에서 생략부호 빼기
	serverSide: true,                                             // ajax로 서버 데이터 처리
	pageLength: pageLen,                                          // 게시물 뒤로가기 시 기존 가지고 있던 페이지 크기를 넣어주므로 변수에 값 저장 
	searching: true,
	ordering: false,
	select: true,
	ajax : {
		 "type":"POST",
		 "url":'/board/list',
		 "data":function(d, event){                                   // 서버에 전달할 데이터
			   d.searchValue = $('.board-list-serach-form').val();    // 검색 버튼을 누르면 .board-list-search-form 의 값을 가져옴.
			   d.searchType =  $('.list-select-form').val();
			   var info =  $('#board-list-select-vo').val();
			   if(info != undefined){
					d.start =  ($('#board-list-select-vo .page').val()-1) * 10;
					d.length =  $('#board-list-select-vo .length').val();
					d.searchType =  $('#board-list-select-vo .searchType').val();
					d.searchValue =  $('#board-list-select-vo .searchValue').val();
			   }
			   return d;                    
		 }
		 
	},    
	columns : [                                                       // 서버에서 받은 값을 넣어주기 전 커스텀마이징 할 수 있다.
		 {"data":"boardSeq", render:function(data,  type, full, meta){
			   return '<div  class="board-list-boardSeq">'+data+'</div>';
		 
		 }},
		 {"data":"title", render:function(data,  type, full, meta){
		 return '<div  class="board-list-title">'+data+'</div>';
	}},
		 {"data":"writer"},
		 {"data":"dateString"},
		 {"data":"count"}
],
"initComplete":function(oSettings){                            		// 데이터 테이블 초기화
	var info = $('#board-list-select-vo').val();
	if(info != undefined){
		 var pageNum = $('#board-list-select-vo  .page').val();
			   pageNum *= 1;
			   this.fnPageChange( pageNum-1 );
			   $('#board-list-select-vo').remove();
	}
}
,"fnDrawCallback": function(){                                      // 서버에서 데이터 전달 후 처리
	var api = this.api();
	var json = api.ajax.json().selectVO;
	gLength = json.length;
	gPage = table.page.info().page + 1;
	gStart = json.start;
	gSearchType = json.searchType;
	gSearchValue = json.searchValue;
	
	$('#board1-table').on("click",  ".board-list-title", function(){
		  var parent = $(this).parent();
		 if(undefined == parent){
			   return;
		 }
		 
		 var parent = $(parent).parent();
		 if(undefined == parent){
			   return;
		 }
			   
		 var boardSeq =   $(parent).children('td').children('.board-list-boardSeq').html();
		 if(undefined == $('#boardSearchForm')){
			   return;
		 }
			   
		 var data = {
			   "boardSeq" : boardSeq
		 };
									
		 var url = getHrefBoardList('#actionForm',   '/board/'+boardSeq);
		 ajaxRequest("/board/"+boardSeq,  JSON.stringify(data),  "POST", url);
	});             
}
});

$('#searchBoardButton').click(function(){            				// 검색 버튼 누르기

$('.list-select-form').val( $('.list-select-form').val());			// 값을 전달 할 때 값을 직접참조($('.list-select-form').val();)로 전달하지 않으면 전달값이 갱신이 안됨
$('.board-list-serach-form').val($('.board-list-serach-form').val());
$('#board1-table').DataTable().ajax.reload();						// reload 를 받드시해야한다
	
});