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

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:postgresql://localhost/lightbox?user=postgres&password=パスワード";
			con = DriverManager.getConnection(connectString);			
			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