02-Main.java

package syain;
 
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
 
import org.eclipse.jface.action.MenuManager;
import org.eclipse.jface.action.StatusLineManager;
import org.eclipse.jface.action.ToolBarManager;
import org.eclipse.jface.window.ApplicationWindow;
import org.eclipse.swt.SWT;
import org.eclipse.swt.events.SelectionAdapter;
import org.eclipse.swt.events.SelectionEvent;
import org.eclipse.swt.graphics.Point;
import org.eclipse.swt.widgets.Button;
import org.eclipse.swt.widgets.Composite;
import org.eclipse.swt.widgets.Control;
import org.eclipse.swt.widgets.Display;
import org.eclipse.swt.widgets.Shell;
import org.eclipse.swt.widgets.Text;
 
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
 
public class Main extends ApplicationWindow {
    private Text text;
     
    private Connection conn = null;
    private Statement stmt = null;
    private ResultSet rs = null;    
    private String connectionString = "jdbc:mysql://localhost/lightbox?user=root&password=";
    private Text fld_sname;
 
    /**
     * Create the application window.
     */
    public Main() {
        super(null);
        createActions();
        addToolBar(SWT.FLAT | SWT.WRAP);
        addMenuBar();
        addStatusLine();
    }
 
    /**
     * Create contents of the application window.
     * @param parent
     */
    @Override
    protected Control createContents(Composite parent) {
        Composite container = new Composite(parent, SWT.NONE);
         
        text = new Text(container, SWT.BORDER);
        text.setBounds(10, 10, 73, 21);
         
        Button btnNewButton = new Button(container, SWT.NONE);
        btnNewButton.addSelectionListener(new SelectionAdapter() {
            @Override
            public void widgetSelected(SelectionEvent e) {
                 
                String scode = text.getText();
                System.out.println(scode);
 
                 
                try {
                    // 接続文字列で接続
                    conn = (Connection) DriverManager.getConnection(connectionString);
                     
                    String query_base = "select * from 社員マスタ where 社員コード = '%s'";
                    String query = String.format(query_base, scode);
                    System.out.println(query);
                     
                    stmt = (Statement) conn.createStatement();
                    rs = stmt.executeQuery(query);
                     
                    String sname;
                    if( rs.next() ) {
                         
                        sname = rs.getString("氏名");
                        System.out.println(sname);
                         
                        fld_sname.setText(sname);
                         
                    }
 
                     
                    rs.close();
                    stmt.close();
                    // 接続を閉じる
                    conn.close();
                     
                } catch (SQLException ex) {
                    // TODO 自動生成された catch ブロック
                    ex.printStackTrace();
                }
                 
            }
        });
        btnNewButton.setBounds(89, 8, 75, 25);
        btnNewButton.setText("New Button");
         
        fld_sname = new Text(container, SWT.BORDER);
        fld_sname.setBounds(10, 49, 324, 21);
 
        return container;
    }
 
    /**
     * Create the actions.
     */
    private void createActions() {
        // Create the actions
    }
 
    /**
     * Create the menu manager.
     * @return the menu manager
     */
    @Override
    protected MenuManager createMenuManager() {
        MenuManager menuManager = new MenuManager("menu");
        return menuManager;
    }
 
    /**
     * Create the toolbar manager.
     * @return the toolbar manager
     */
    @Override
    protected ToolBarManager createToolBarManager(int style) {
        ToolBarManager toolBarManager = new ToolBarManager(style);
        return toolBarManager;
    }
 
    /**
     * Create the status line manager.
     * @return the status line manager
     */
    @Override
    protected StatusLineManager createStatusLineManager() {
        StatusLineManager statusLineManager = new StatusLineManager();
        return statusLineManager;
    }
 
    /**
     * Launch the application.
     * @param args
     */
    public static void main(String args[]) {
        try {
            Main window = new Main();
            window.setBlockOnOpen(true);
            window.open();
            Display.getCurrent().dispose();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
 
    /**
     * Configure the shell.
     * @param newShell
     */
    @Override
    protected void configureShell(Shell newShell) {
        super.configureShell(newShell);
        newShell.setText("New Application");
    }
 
    /**
     * Return the initial size of the window.
     */
    @Override
    protected Point getInitialSize() {
        return new Point(450, 300);
    }
}