jdbc:mysql://iruri.cft5merq7wis.ap-northeast-2.rds.amazonaws.com:3306/iruri?serverTimezone=Asia/Seoul

GitHub - IruriProject/IruriProject

그래프그리기

<script type="text/javascript">
google.charts.load('current', {
	  packages:['corechart']
	}).then(function () {
				
	  $.ajax({
	    url: "/test",
	    data:{"p_num":${dto.p_num}},
	    dataType: "JSON",
	    success: function(result){
	    	if(result[0].count==0&&result[1].count==0){
	    		$("#ageChart").html("<span style='font-size:1.5em;'>해당 공고의 지원자가 없습니다.</span>");
	    	} else
	      		drawChart(result);
	    }
	  });

	  function drawChart(result) {
	    var data = new google.visualization.DataTable();
	    data.addColumn('string', 'gender');
	    data.addColumn('number', 'count');

	    var dataArray = [];

	    $.each(result, function(i, obj) {
	      dataArray.push([obj.gender, parseInt(obj.count)]);
	    });

	    data.addRows(dataArray);

	    var piechart_options = {
	      colors: ['#4E9F3D', '#cce891']
	    };
	    var piechart = new google.visualization.PieChart(document.getElementById('ageChart'));
	    piechart.draw(data, piechart_options);
	  }
	});

</script>

[YEEUN]