/**
*
*/
package de.tutorials;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import java.util.List;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;
/**
* @author Tom
*/
public class SpringJdbcExample {
/**
* @param args
*/
public static void main(String[] args) {
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setServerName("localhost");
dataSource.setPort(3306);
dataSource.setDatabaseName("test");
dataSource.setUser("root");
dataSource.setPassword("tutorials");
RowMapper rowToPersonMapper = new RowMapper() {
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
return new Person(rs.getLong("id"), rs.getString("name"), rs.getDate("dateOfBirth"));
}
};
JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
List<?> persons = jdbcTemplate.query("SELECT id,name,dateOfBirth FROM person where id = ?",
new Object[] { 1 }, rowToPersonMapper);
System.out.println(persons);
persons = jdbcTemplate.query("SELECT id,name,dateOfBirth FROM person where dateOfBirth < ?",
new Object[] { new Date() }, rowToPersonMapper);
System.out.println(persons);
}
static class Person {
Long id;
String name;
Date dateOfBirth;
/**
* @param id
* @param name
* @param dateOfBirth
*/
public Person(Long id, String name, Date dateOfBirth) {
super();
this.id = id;
this.name = name;
this.dateOfBirth = dateOfBirth;
}
/**
* @return the id
*/
public Long getId() {
return id;
}
/**
* @param id the id to set
*/
public void setId(Long id) {
this.id = id;
}
/**
* @return the name
*/
public String getName() {
return name;
}
/**
* @param name the name to set
*/
public void setName(String name) {
this.name = name;
}
/**
* @return the dateOfBirth
*/
public Date getDateOfBirth() {
return dateOfBirth;
}
/**
* @param dateOfBirth the dateOfBirth to set
*/
public void setDateOfBirth(Date dateOfBirth) {
this.dateOfBirth = dateOfBirth;
}
@Override
public String toString() {
return this.id + " " + this.name + " " + this.dateOfBirth;
}
}
}
