springJDBC的应用

xmlns:xsi&＃61;"http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation&＃61;"http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">class&＃61;"org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">



/WEB-INF/jdbc.properties


class&＃61;"org.logicalcobwebs.proxool.ProxoolDataSource"
abstract&＃61;"true">









jdbc:mysql://$${jdbc.main.server}?useUnicode&＃61;true&characterEncoding&＃61;gbk&user&＃61;$${jdbc.main.user}&password&＃61;$${jdbc.main.password}&zeroDateTimeBehavior&＃61;convertToNull






class&＃61;"org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate">
class&＃61;"com.example.JdbcCorporateEventDao">

public class Actor {private Long id;private String firstName;private String lastName;private int age;//专业private String specialty;public String getFirstName() {return this.firstName;}public String getLastName() {return this.lastName;}public Long getId() {return this.id;}// setters omitted...

}

public interface CorporateEventDao{public int countOfActors(Actor exampleActor);public long addActor(Actor exampleActor);public boolean updateActor(long userId);public Actor findActorById(long userId);public List getAllUser();}

public class CorporateEventDaoImpl implements CorporateEventDao {private NamedParameterJdbcTemplate jdbcTemplate;public void setAppJdbc(NamedParameterJdbcTemplate jdbcTemplate) {
this.jdbcTemplate &＃61; jdbcTemplate;
}
private ParameterizedBeanPropertyRowMapper rowMapper&＃61;ParameterizedBeanPropertyRowMapper.newInstance(Actor.class);&＃64;Override
public int countOfActors(Actor exampleActor) {String sql &＃61; "select count(*) from t_actor where first_name &＃61;fastName and last_name&＃61;:lastName";
SqlParameterSource namedParameters &＃61; new BeanPropertySqlParameterSource(exampleActor);return this.jdbcTemplate.queryForInt(sql, namedParameters);
}&＃64;Override
public long addActor(Actor exampleActor) {
// TODO Auto-generated method stub
String sql &＃61; "insert into t_actor(first_name,last_name,age,specialty) values(?,?,?,?)";
SqlParameterSource namedParameters &＃61; new BeanPropertySqlParameterSource(exampleActor);
return this.jdbcTemplate.update(sql, namedParameters);
}&＃64;Override
public boolean updateActor(long userId) {
// TODO Auto-generated method stub
String sql &＃61; "update t_actor set id&＃61;?";
return this.jdbcTemplate.getJdbcOperations().update(sql,userId)>0;
}&＃64;Override
public Actor findActorById(long userId) {
// TODO Auto-generated method stub
String sql &＃61; "select first_name,last_name,age,specialty from t_actor where userId&＃61;?";return this.jdbcTemplate.getJdbcOperations().queryForObject(sql, new Object[]{userId}, rowMapper);
}&＃64;Override
public List getAllUser() {
// TODO Auto-generated method stub
String sql &＃61; "select first_name,last_name,age,specialty from t_actor";
return this.jdbcTemplate.getJdbcOperations().queryForList(sql, null, rowMapper);
}public Actor findActor(String specialty, int age) {String sql &＃61; "select id, first_name, last_name from T_ACTOR" &＃43;" where specialty &＃61; ? and age &＃61; ?";// notice the wrapping up of the argumenta in an arrayreturn (Actor) jdbcTemplate.getJdbcOperations().queryForObject(sql, new Object[] {specialty, age}, rowMapper);
}}