JdbcTemplate的常用的方法

package com.et.jdbcTemplate;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import org.junit.Test;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

public class TemplateDemo {
	static JdbcTemplate jdbc;
	static{
		DriverManagerDataSource dataSource = new DriverManagerDataSource();
		dataSource.setUrl("jdbc:mysql://localhost:3306/spring");
		dataSource.setUsername("root");
		dataSource.setPassword("123");
		dataSource.setDriverClassName("com.mysql.jdbc.Driver");
		jdbc = new JdbcTemplate(dataSource);
	}
	/**
	 * 添加
	 */
	@Test
	public void addUser() {
		String sql = "insert into user values(?,?)";
		int num = jdbc.update(sql, "小苍","123");
		System.out.println(num);
	}
	/**
	 * 删除
	 */
	@Test
	public void deleteUser() {
		String sql = "delete from user where username=?";
		int num = jdbc.update(sql, "小苍");
		System.out.println(num);
	}
	/**
	 * 修改
	 */
	@Test
	public void updateUser() {
		String sql = "update user set password=? where username=?";
		int num = jdbc.update(sql, "666","小张");
		System.out.println(num);
	}
	public void findAll(){
		String sql = "select * from user where username=?";
		List list = jdbc.query(sql,new MyRowMapper(),"小华");
		System.out.println(list);

	}
	public void findUser(){
		String sql = "select * from user where username=?";
		User user = jdbc.queryForObject(sql, new MyRowMapper());
		System.out.println(user);
	}
	public void count(){
		String sql = "select count(*) from user";
		int num = jdbc.queryForObject(sql, Integer.class);
		System.out.println(num);
	}
}
class MyRowMapper implements RowMapper<User>{

	public User mapRow(ResultSet rs, int rowNum) throws SQLException {
		String username = rs.getString("username");
		String password = rs.getString("password");
		User user = new User();
		user.setPassword(password);
		user.setUsername(username);
		return user;
	}
}