Thread: problems with lib imports and statements

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.simple.SimpleJdbcInsert;
import org.springframework.transaction.annotation.Transactional;
 
import javax.sql.DataSource;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
 
public class CustomerManagerImpl implements CustomerManager {
 
    private JdbcTemplate jdbc;
 
 
    public CustomerManagerImpl(DataSource dataSource) {
        this.jdbc = new JdbcTemplate(dataSource);
    }
 
    @Override
    public void deleteCustomer(long id) {
        jdbc.update("DELETE FROM customers WHERE id=?", id);
    }
 
    @Override
    public void updateCustomer(Customer c) {
        jdbc.update("UPDATE customers set fullname=?,address=?,phone=?,email=? where id=?",
                c.getFullname(), c.getAddress(), c.getPhone(), c.getEmail(), c.getId());
    }
 
    private RowMapper<Customer> customerMapper = new RowMapper<Customer>() {
        @Override
        public Customer mapRow(ResultSet rs, int rowNum) throws SQLException {
            return new Customer(rs.getLong("id"),rs.getString("fullname"),rs.getString("address"),rs.getString("phone"),rs.getString("email"));
        }
    };
 
    @Transactional
    @Override
    public List<Customer> getAllCustomers() {
        return jdbc.query("SELECT * FROM customers", customerMapper);
    }
 
    @Override
    public Customer getCustomerById(long id) {
        return jdbc.queryForObject("SELECT * FROM customers WHERE id=?", customerMapper, id);
    }
 
    @Override
    public void createCustomer(Customer c) {
        SimpleJdbcInsert insertCustomer = new SimpleJdbcInsert(jdbc).withTableName("customers").usingGeneratedKeyColumns("id");
        Map<String, Object> parameters = new HashMap<>(2);
        parameters.put("fullname", c.getFullname());
        parameters.put("address", c.getAddress());
        parameters.put("phone", c.getPhone());
        parameters.put("email", c.getEmail());
        Number id = insertCustomer.executeAndReturnKey(parameters);
        c.setId(id.longValue());
    }
 
}

Here you can see the errors:

errP1.jpgerrP2.jpg

Oki

PHP Code:

java: package org.springframework.jdbc.core.simple does not exist
java: type org.springframework.jdbc.core.RowMapper does not take parameters
java: no suitable method found for update(java.lang.String,long)
    method org.springframework.jdbc.core.JdbcTemplate.update(java.lang.String,java.lang.Object[]) is not applicable
      (actual argument long cannot be converted to java.lang.Object[] by method invocation conversion)
    method org.springframework.jdbc.core.JdbcTemplate.update(java.lang.String,java.lang.Object[],int[]) is not applicable
      (actual and formal argument lists differ in length)
    method org.springframework.jdbc.core.JdbcTemplate.update(java.lang.String,org.springframework.jdbc.core.PreparedStatementSetter) is not applicable
      (actual argument long cannot be converted to org.springframework.jdbc.core.PreparedStatementSetter by method invocation conversion)
    method org.springframework.jdbc.core.JdbcTemplate.update(org.springframework.jdbc.core.PreparedStatementCreator,org.springframework.jdbc.support.KeyHolder) is not applicable
      (actual argument java.lang.String cannot be converted to org.springframework.jdbc.core.PreparedStatementCreator by method invocation conversion)
    method org.springframework.jdbc.core.JdbcTemplate.update(org.springframework.jdbc.core.PreparedStatementCreator) is not applicable
      (actual and formal argument lists differ in length)
    method org.springframework.jdbc.core.JdbcTemplate.update(org.springframework.jdbc.core.PreparedStatementCreator,org.springframework.jdbc.core.PreparedStatementSetter) is not applicable
      (actual argument java.lang.String cannot be converted to org.springframework.jdbc.core.PreparedStatementCreator by method invocation conversion)
    method org.springframework.jdbc.core.JdbcTemplate.update(java.lang.String) is not applicable
      (actual and formal argument lists differ in length)
java: no suitable method found for update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long)
    method org.springframework.jdbc.core.JdbcTemplate.update(java.lang.String,java.lang.Object[]) is not applicable
      (actual and formal argument lists differ in length)
    method org.springframework.jdbc.core.JdbcTemplate.update(java.lang.String,java.lang.Object[],int[]) is not applicable
      (actual and formal argument lists differ in length)
    method org.springframework.jdbc.core.JdbcTemplate.update(java.lang.String,org.springframework.jdbc.core.PreparedStatementSetter) is not applicable
      (actual and formal argument lists differ in length)
    method org.springframework.jdbc.core.JdbcTemplate.update(org.springframework.jdbc.core.PreparedStatementCreator,org.springframework.jdbc.support.KeyHolder) is not applicable
      (actual and formal argument lists differ in length)
    method org.springframework.jdbc.core.JdbcTemplate.update(org.springframework.jdbc.core.PreparedStatementCreator) is not applicable
      (actual and formal argument lists differ in length)
    method org.springframework.jdbc.core.JdbcTemplate.update(org.springframework.jdbc.core.PreparedStatementCreator,org.springframework.jdbc.core.PreparedStatementSetter) is not applicable
      (actual and formal argument lists differ in length)
    method org.springframework.jdbc.core.JdbcTemplate.update(java.lang.String) is not applicable
      (actual and formal argument lists differ in length)
java: type org.springframework.jdbc.core.RowMapper does not take parameters
java: cannot find symbol
  symbol:   class SimpleJdbcInsert
  location: class cz.muni.fi.pv168.books.CustomerManagerImpl
java: cannot find symbol
  symbol:   class SimpleJdbcInsert
  location: class cz.muni.fi.pv168.books.CustomerManagerImpl
java: package org.springframework.jdbc.core.simple does not exist
java: type org.springframework.jdbc.core.RowMapper does not take parameters
java: cannot find symbol
  symbol:   class SimpleJdbcInsert
  location: class cz.muni.fi.pv168.books.LeaseManagerImpl
java: cannot find symbol
  symbol:   class SimpleJdbcInsert
  location: class cz.muni.fi.pv168.books.LeaseManagerImpl
java: C:\Users\Justy\Desktop\Servlet\books-jdbc\src\main\java\cz\muni\fi\pv168\books\LeaseManagerImpl.java uses unchecked or unsafe operations.
java: Recompile with -Xlint:unchecked for details. 


i already add it :/ I added : org.springframework.jdbc-sources-3.0.5.Release, and spring-jdbc-3.0.2Release-sources and jdbc.jar

Why none of this is working?

Yes it is. I found the jar her: Download org.springframework.jdbc-sources-3.0.5.RELEASE.jar : org.springframework.jdbcoJar File Download

and it's there. But I have no idea why the compiler doesn't sees it

Strange thing is that i'm having issues only with this one jar. Other jars which I added are working well. I checked how to add it here: classpath - how to add a jar to my lib/ directory in intelliJ and have the classes available for my web.xml? - Stack Overflow

But it's the same thing as I already did