Spring JDBC Demo

为什么80%的码农都做不了架构师？>>>   

<!-- 连接数据库参数配置 -->
	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
		<property name="url" value="jdbc:mysql://127.0.0.1:3306/spring"/>
		<property name="username" value="root"/>
		<property name="password" value=""/>
	</bean>
	
	<bean id="userDaoImpl" class="com.alan.dao.impl.UserDaoImpl">
		<property name="dataSource" ref="dataSource"/>
	</bean>

// UserDaoImpl.java
public class UserDaoImpl extends JdbcDaoSupport implements UserDao {

	@Override
	public int save(User user) {
		String sql = "insert into t_user(username, password) values (?, ?)";
		return this.getJdbcTemplate().update(sql,
				new Object[] { user.getUsername(), user.getPassword() });
	}

	@Override
	public int delete(int uid) {
		String sql = "delete from t_user where uid = ?";
		return this.getJdbcTemplate().update(sql, new Object[] { uid });
	}

	@Override
	public int update(User user) {
		String sql = "update t_user set username = ?, password = ? where uid = ?";
		return this.getJdbcTemplate().update(
				sql,
				new Object[] { user.getUsername(), user.getPassword(),
						user.getUid() });
	}

	@SuppressWarnings("unchecked")
	@Override
	public List<Map<String, Object>> findAll() {
		String sql = "select * from t_user";
		return this.getJdbcTemplate().queryForList(sql);
	}

	@Override
	public int count() {
		String sql = "select count(*) from t_user";
		return this.getJdbcTemplate().queryForInt(sql);
	}

	@Override
	public User findById(int uid) {
		String sql = "select * from t_user where uid = ?";
		return (User) this.getJdbcTemplate().queryForObject(sql, 
				new Object[] { uid },
				new RowMapper() {
					@Override
					public Object mapRow(ResultSet rs, int rowNum)
							throws SQLException {
						User user = new User();
						user.setUid(rs.getInt("uid"));
						user.setUsername(rs.getString("username"));
						user.setPassword(rs.getString("password"));
						return user;
					}
				});
	}

	@SuppressWarnings("unchecked")
	@Override
	public List<User> findAll2() {
		String sql = "select * from t_user";
		return this.getJdbcTemplate().query(sql, new RowMapper() {
			@Override
			public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
				User user = new User();
				user.setUid(rs.getInt("uid"));
				user.setUsername(rs.getString("username"));
				user.setPassword(rs.getString("password"));
				return user;
			}
			
		});
	}

}

转载于:https://my.oschina.net/moson/blog/139433