Spring… i na wiosnę, i na lato – Część 1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
SEVERE: Exception sending context destroyed event to listener instance of class org.springframework.web.context.ContextLoaderListener
java.lang.ExceptionInInitializerError
	at org.springframework.web.context.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:144)
	at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4819)
	at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5466)
	at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:232)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:160)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1585)
	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalStateException: org.slf4j.LoggerFactory could not be successfully initialized. See also http://www.slf4j.org/codes.html#unsuccessfulInit
	at org.slf4j.LoggerFactory.getILoggerFactory(LoggerFactory.java:282)
	at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:248)
	at org.apache.commons.logging.impl.SLF4JLogFactory.getInstance(SLF4JLogFactory.java:155)
	at org.apache.commons.logging.impl.SLF4JLogFactory.getInstance(SLF4JLogFactory.java:131)
	at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:272)
	at org.springframework.web.context.ContextCleanupListener.<clinit>(ContextCleanupListener.java:43)
	... 16 more

1
2
3
4
5
6
7
8
9
@Controller
public class CustomerController {

	@RequestMapping(value = "/customer", method = RequestMethod.GET)
	public String home(Locale locale, Model model) {

		return "customer_list";
	}
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
@Service
public class CustomerService {

	private final Customer customer = new Customer("Jan", "Kowalski", "example.com");

	public Customer getCustomerById(Long id) {
		return customer;
	}

	public List<Customer> getAllCustomers() {
		return Arrays.asList(customer);
	}

	public Customer createCustomer(String firstName, String lastName, String email) {
		return customer;
	}
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
public class Customer implements Serializable {

	/**
	 *
	 */
	private static final long serialVersionUID = -7801982418517678583L;

	private Long id;

	private String firstName;

	private String lastName;

	private String email;

	public Customer() {
	}

	public Customer(String firstName, String lastName, String email) {
		this.firstName = firstName;
		this.lastName = lastName;
		this.email = email;
	}

	public Long getId() {
		return id;
	}

	public void setId(Long id) {
		this.id = id;
	}

	public String getFirstName() {
		return firstName;
	}

	public void setFirstName(String firstName) {
		this.firstName = firstName;
	}

	public String getLastName() {
		return lastName;
	}

	public void setLastName(String lastName) {
		this.lastName = lastName;
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	@Override
	public int hashCode() {
		final int prime = 31;
		int result = 1;
		result = prime * result + ((id == null) ? 0 : id.hashCode());
		result = prime * result
				+ ((firstName == null) ? 0 : firstName.hashCode());
		result = prime * result
				+ ((lastName == null) ? 0 : lastName.hashCode());
		result = prime * result + ((email == null) ? 0 : email.hashCode());
		return result;
	}

	@Override
	public boolean equals(Object obj) {
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		Customer other = (Customer) obj;
		if (email == null) {
			if (other.email != null)
				return false;
		} else if (!email.equals(other.email))
			return false;
		if (firstName == null) {
			if (other.firstName != null)
				return false;
		} else if (!firstName.equals(other.firstName))
			return false;
		if (id == null) {
			if (other.id != null)
				return false;
		} else if (!id.equals(other.id))
			return false;
		if (lastName == null) {
			if (other.lastName != null)
				return false;
		} else if (!lastName.equals(other.lastName))
			return false;
		return true;
	}

	@Override
	public String toString() {
		return ToStringBuilder.reflectionToString(this);
	}
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
@Controller
public class CustomerController {

	@Autowired
	private CustomerService customerService;

	@RequestMapping(value = "/customer", method = RequestMethod.GET)
	public String home(Locale locale, Model model) {

		List<Customer> customers = customerService.getAllCustomers();

		model.addAttribute("customers", customers);

		return "customer_list";
	}
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
@Repository
@Transactional(readOnly = true)
public class CustomerRepository {

	private JdbcTemplate jdbcTemplate;

	@Autowired
	public void setDataSource(DataSource dataSource) {
		this.jdbcTemplate = new JdbcTemplate(dataSource);
	}

	public Customer getCustomerById(Long id) {
		return jdbcTemplate.queryForObject("SELECT id, first_name, last_name, email FROM customer WHERE id = ?", new Object[]{id}, new CustomerMapper());
	}

	public Customer getCustomerByEmail(String email) {
		return jdbcTemplate.queryForObject("SELECT id, first_name, last_name, email FROM customer WHERE email = ?", new Object[]{email}, new CustomerMapper());
	}

	public List<Customer> getAllCustomers() {
		return jdbcTemplate.query("SELECT id, first_name, last_name, email FROM customer", new CustomerMapper());
	}

	@Transactional(readOnly=false)
	public Customer storeCustomer(Customer customer) {

		if (customer.getId() == null) {
			Long newId = jdbcTemplate.queryForObject("SELECT GEN_ID( CUSTOMER_GEN_SEQ, 1) FROM RDB$DATABASE", Long.class);

			customer.setId(newId);

			jdbcTemplate.update("insert into customer (id, first_name, last_name, email) values (?, ?, ?, ?)", customer.getId(), customer.getFirstName(), customer.getLastName(), customer.getEmail());
		} else {
			jdbcTemplate.update("update customer set first_name = ?, last_name = ?, email = ? where id = ?", customer.getFirstName(), customer.getLastName(), customer.getEmail(), customer.getId());
		}

		return getCustomerById(customer.getId());
	}

	private static final class CustomerMapper implements RowMapper<Customer> {

	    public Customer mapRow(ResultSet rs, int rowNum) throws SQLException {
	    	Customer customer = new Customer();
	    	customer.setId(rs.getLong("id"));
	        customer.setFirstName(rs.getString("first_name"));
	        customer.setLastName(rs.getString("last_name"));
	        customer.setEmail(rs.getString("email"));
	        return customer;
	    }
	}
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
@Service
public class CustomerService {

	@Autowired
	private CustomerRepository customerRepository;

	public Customer getCustomerById(Long id) {
		return customerRepository.getCustomerById(id);
	}

	public List<Customer> getAllCustomers() {
		return customerRepository.getAllCustomers();
	}

	public Customer createCustomer(String firstName, String lastName, String email) {
		Customer customer = new Customer(firstName, lastName, email);

		return customerRepository.storeCustomer(customer);
	}
}