@DIV
import java.awt.Font;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;

import javax.swing.JOptionPane;
import javax.swing.UIManager;

public class Main {

	public static void main(String[] args) {

		// メッセージボックスのフォント変更
		Font myFont = new Font("メイリオ",Font.PLAIN,20);
		UIManager.put("OptionPane.messageFont", myFont);
		UIManager.put("OptionPane.buttonFont", myFont);

		// DB 用
		Connection con = null;
		Statement stmt = null;
		ResultSet rset = null;

		try {
			String connectString = "jdbc:odbc:Provider=MSDASQL;Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};Dbq=c:\\tmp\\社員マスタ.xlsx;";
			Properties prop = new Properties();
			prop.put("charSet", "MS932");

			con = DriverManager.getConnection(connectString,prop);
			stmt = con.createStatement();
			String scode = "0001";
			String query = "select  * from [社員マスタ] where [社員コード] = '" + scode + "'";
			rset = stmt.executeQuery ( query );
			if ( rset.next() ) {
				String name = rset.getString( "氏名" );
				JOptionPane.showMessageDialog(null, name);
			}
			else {
				JOptionPane.showMessageDialog(null, "入力した社員コードは存在しません");
			}

			rset.close();
			stmt.close();
			con.close();

		} catch (Exception e1) {
			e1.printStackTrace();
		}
	}

}
@END