Maria DB 연결_이름만 키워드로 검색 (입력 1칸),(콘솔창)

코드

 

package swing0613;

import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;

public class Win extends JFrame {
    JLabel la = new JLabel("검색");
    JButton bt = new JButton("클릭");
    JTextField jt = new JTextField("");
    Connection con = null;

    Win() throws ClassNotFoundException, SQLException {
        String url = "jdbc:mariadb://localhost:3307/jspdb";
        String user = "root";
        String pass = "maria";
        Class.forName("org.mariadb.jdbc.Driver");
        System.out.println("드라이버 로딩!");

        con = DriverManager.getConnection(url, user, pass);
        System.out.println("접속 성공!");

        Container c = this.getContentPane();
        c.setLayout(null);
        this.setSize(300, 300);
        this.setLocation(500, 500);
        this.setTitle("첫 윈도우");

        la.setSize(50, 20);
        la.setLocation(30, 30);
        c.add(la);

        jt.setSize(100, 30);
        jt.setLocation(30, 50);
        c.add(jt);

        bt.setSize(60, 30);
        bt.setLocation(130, 50);
        c.add(bt);

        bt.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                String keyword = jt.getText();
                String sql = "select * from person where name like '%" + keyword + "%'";
                try {
                    Statement stmt = con.createStatement();
                    ResultSet rs = stmt.executeQuery(sql);
                    while (rs.next()) {
                        int id = rs.getInt("id");
                        String name = rs.getString("name");
                        String addr = rs.getString("addr");
                        String phone = rs.getString("phone");
                        System.out.printf("%d, %s, %s, %s\n", id, name, addr, phone);
                    }
//                    jt.setText(sql);
//                    System.out.println(jt.getText());
                } catch (SQLException ex) {
                    ex.printStackTrace();
                }
            }
        });

        this.setVisible(true);
    }

    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        new Win();
    }
}

 

실행 결과