Day58 실습프로젝트(JDBC 캡슐화)

Sql 세션 만들기

mybatis 구조 살펴보기

insert문 만들기

  public int insert(String sql, Object... values) throws Exception{
    try(PreparedStatement stmt = con.prepareStatement(sql)){
      
      int inparameterIndex = 1;
      for(Object value : values) {
        stmt.setString(inparameterIndex++,value.toString());
      }
    return stmt.executeUpdate();
    }
  }
  
  public int update(String sql, Object... values) throws Exception{
    return insert(sql,values);
  }
  
  public int delete(String sql, Object... values) throws Exception{
    return insert(sql,values);
  }

update문 만들기

  public int update(String sql, Object... values) throws Exception{
    return insert(sql,values);
  }

delete문 만들기

  public int delete(String sql, Object... values) throws Exception{
    return insert(sql,values);
  }

selectList 만들기