var cn = new ActiveXObject("ADODB.Connection");
var rs = new ActiveXObject("ADODB.Recordset");

var strDriver = "{MySQL ODBC 5.3 Unicode Driver}"
var strServer = "localhost"
var strDb = "lightbox"
var strUser = "root"
var strPass =  ""

var connectionString = "Provider=MSDASQL;Driver=" + strDriver;
connectionString += ";Server=" + strServer
connectionString += ";Database=" + strDb
connectionString += ";UID=" + strUser
connectionString += ";PWD=" + strPass
connectionString += ";"

function getFieldName( tableName ) {

	// 接続
	cn.Open( connectionString );
	var query = "select * from " + tableName;

	rs.Open( query, cn );

	var count = rs.Fields.Count;

	var fieldName = [];

	for( var i = 0; i < count; i++ ) {
		fieldName[i] = rs.Fields(i).Name;
	}

	// 閉じる
	rs.Close();
	// 閉じる
	cn.Close();

	return fieldName;

}

// 列数を取得
function getFieldCount( tableName ) {

	// 接続
	cn.Open( connectionString );
	var query = "select * from " + tableName;

	rs.Open( query, cn );

	var count = rs.Fields.Count;

	// 閉じる
	rs.Close();
	// 閉じる
	cn.Close();

	return count;

}

function loadMySQL() {

	
	document.write(connectionString + "<br>");
	
	// 接続
	cn.Open( connectionString );
	
	var query = "select 社員コード,氏名,フリガナ,所属,性別,給与,手当,管理者,DATE_FORMAT(生年月日,'%Y-%m-%d') as 生年月日 from 社員マスタ";
	 
	rs.Open( query, cn );
	
	var text = "";
	
	document.write("<table class='table table-hover'>");
	
	while ( !rs.EOF ) {
	
		document.write("<tr>");
	
		for( var i = 0; i < rs.Fields.Count; i++  ) {
			document.write( "<td>" + rs.Fields( i ).Value + "</td>" );
		}
	
		document.write("</tr>");
	
		rs.MoveNext();
	}
	
	document.write("</table>");
	
	
	// 閉じる
	rs.Close();
	// 閉じる
	cn.Close();

}