mysql jdbc 이용한 예제

 
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
 
public class BusinessCardManagerDao {
    private static String dbUrl = "jdbc:mysql://localhost:3306/businesscard?serverTimezone=UTC";
    private static String dbUser = "employee";
    private static String dbPassward = "connect123!@#";
    
    public List<BusinessCard> searchBusinessCard(String keyword){
        List<BusinessCard> list = new ArrayList<>();
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch (Exception e) {
            e.printStackTrace();
        }
        String sql = "SELECT name, phone, companyName FROM businesscard WHERE name LIKE ?";
        try(Connection conn = DriverManager.getConnection(dbUrl, dbUser, dbPassward);
            PreparedStatement ps = conn.prepareStatement(sql);
                ){
                ps.setString(1,keyword+"%"); //like연산시 주의점 "'"+keyword+"%'" 로 하면 인식을 못한다.
                ResultSet rs = ps.executeQuery();
                while(rs.next()) {
                    String name = rs.getString("name");
                    String phone =rs.getString("phone");
                    String companyName = rs.getString("companyName");
                    BusinessCard businessCard = new BusinessCard(name, phone, companyName);
                    list.add(businessCard);
                }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return list;
    }
 
    public BusinessCard addBusinessCard(BusinessCard businessCard){
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch (Exception e) {
            e.printStackTrace();
        }
        String sql = "insert into businesscard value(?,?,?,?)";
        try(Connection conn = DriverManager.getConnection(dbUrl, dbUser, dbPassward);
            PreparedStatement ps = conn.prepareStatement(sql);
                ) {
            ps.setString(1, businessCard.getName());
            ps.setString(2, businessCard.getPhone());
            ps.setString(3, businessCard.getCompanyName());
            ps.setDate(4,new java.sql.Date(businessCard.getCreateDate().getTime())); 
            //주의점 setDate의 date는 java.sql.Date이다. java.util.Date.getTime()을 하면 해결이 된다.
            ps.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }
}
 

주의점 !

22행 : like 연산시 주의점

51행: setDate시 주의점