public class Test {

	public static void main(String[] args) {
		ApplicationContext context = 
				new ClassPathXmlApplicationContext("applicationContext.xml");
		
		UserService userService = (UserService) context.getBean("userService");
		User user = new User();
		user.setId("11111");
		user.setName("zhangsan22222");
		userService.addUser(user);
	}

}

public class UserService {
	public UserDao userDao;
	public UserDao getUserDao() {
		return userDao;
	}
	public void setUserDao(UserDao userDao) {
		this.userDao = userDao;
	}
	public void addUser(User user){
		userDao.addUser(user);
	}
}

public class UserDaoImp implements UserDao{
	public void addUser(User user){
		System.out.println("添加了一个用户，姓名是"
	        +user.getName()+user.getId());
	}
}

    public static void main( String[] args ){
    	Test test = new Test();
    	UserAction userAction = test.getController();
    	test.testAdd(userAction);
//    	test.testFindNumbers(userAction);
//    	test.testFindNameById(userAction);
//    	test.testFindUser(userAction);
//    	test.testFindAll(userAction);
//    	test.testFindMapUser(userAction);
//    	test.testFindMapAll(userAction);
    }
    public UserAction getController(){
    	ApplicationContext context = 
        		new ClassPathXmlApplicationContext("config/applicationContext.xml");
    	UserAction userAction = (UserAction) context.getBean("userAction");
    	return userAction;
    }
    
    public void testAdd(UserAction userAction){
    	User user  =new User();
    	user.setId(7);
    	user.setName("张三");
    	user.setAge(20);
    	userAction.add(user);
    }
    
    public void testFindNumbers(UserAction userAction){
    	int numbers = userAction.findNumbers();
    	System.out.println("findNumbers方法的查询结果：");
    	System.out.println("共有"+numbers+"个用户！");
    }
    
    public void testFindNameById(UserAction userAction){
    	String name = userAction.findNameById(1);
    	System.out.println("findNameById方法的查询结果：");
    	System.out.println("学号为1的学生的姓名为："+name);
    }
    
    public void testFindUser(UserAction userAction){
    	System.out.println("findUser方法的查询结果：");
    	User user  = userAction.findById(1);
    	System.out.println("id："+user.getId()
    	+",name:"+user.getName()
    	+",age:"+user.getAge());
    }

    public void testFindAll(UserAction userAction){
    	List<User> users  = userAction.findAll();
    	System.out.println("findAll方法的查询结果：");
    	for(User user:users){
	    	System.out.println("id："+user.getId()
	    	+",name:"+user.getName()
	    	+",age:"+user.getAge());
    	}
    }

    public void testFindMapUser(UserAction userAction){
    	System.out.println("findMapUser方法的查询结果：");
    	Map<String,Object> user  = userAction.findMapById(1);
    	System.out.println("id："+user.get("id")
    	+",name:"+user.get("name")
    	+",age:"+user.get("age"));
    }

    public void testFindMapAll(UserAction userAction){
    	System.out.println("findMapAll方法的查询结果：");
    	List<Map<String,Object>> users  = userAction.findAllMap();
    	for(Map<String,Object> user:users){
        	System.out.println("id："+user.get("id")
        	+",name:"+user.get("name")
        	+",age:"+user.get("age"));
    	}
    }
}

public class UserAction {
	private UserService userService;

	public UserService getUserService() {
		return userService;
	}

	public void setUserService(UserService userService) {
		this.userService = userService;
	}

	public void add(User user) {
		userService.add(user);
	}

	public String findNameById(int id) {
		return userService.findNameById(id);
	}

	public int findNumbers() {
		return userService.findNumbers();
	}

	public List<User> findAll() {
		return userService.findAll();
	}

	public User findById(int id) {
		return userService.findById(id);
	}

	public Map<String, Object> findMapById(int id) {
		return userService.findMapById(id);
	}

	public List<Map<String, Object>> findAllMap() {
		return userService.findAllMap();
	}
}

public class UserService {
	private UserDao userDao;

	public UserDao getUserDao() {
		return userDao;
	}

	public void setUserDao(UserDao userDao) {
		this.userDao = userDao;
	}

	public void add(User user) {
		userDao.add(user);
	}

	public String findNameById(int id) {
		return userDao.findNameById(id);
	}

	public int findNumbers() {
		return userDao.findNumbers();
	}

	public List<User> findAll() {
		return userDao.findAll();
	}

	public User findById(int id) {
		return userDao.findById(id);
	}

	public Map<String, Object> findMapById(int id) {
		return userDao.findMapById(id);
	}

	public List<Map<String, Object>> findAllMap() {
		return userDao.findAllMap();
	}
}

public class UserDao {
	private JdbcTemplate jdbcTemplate;
 
	private NamedParameterJdbcTemplate npjt;
	
	public JdbcTemplate getJdbcTemplate() {
		return jdbcTemplate;
	}

	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}
	public NamedParameterJdbcTemplate getNpjt() {
		return npjt;
	}

	public void setNpjt(NamedParameterJdbcTemplate npjt) {
		this.npjt = npjt;
	}
	
	public void add(User user){
		String sql = "insert into CUSTOMERS values(?,?,?)";
		jdbcTemplate.update(sql,
				new Object[]{user.getId(),user.getName(),user.getAge()});
		
		/*NamedParameterJdbcTemplate使用：Map传参*/
		String sql1="insert into CUSTOMERS (id,name,age) values (:id,:name,:age)";
		Map<String,Object> paramMap=new HashMap<String,Object>();
		paramMap.put("id", 1);
		paramMap.put("age", "20");
		paramMap.put("name", "npjt");
		paramMap.put("sex", "女");
		npjt.update(sql1, paramMap);
		
		/*NamedParameterJdbcTemplate使用：实体类（User）传参*/
		SqlParameterSource paramSource=new BeanPropertySqlParameterSource(user);
		npjt.update(sql1, paramSource);
	}

	public String findNameById(int id) {
		String sql = "SELECT NAME FROM CUSTOMERS WHERE id = ?";
		String name = (String) jdbcTemplate.queryForObject(sql, new Object[] { id }, String.class);
		return name;
	}

	public int findNumbers() {
		String sql = "SELECT COUNT(*) FROM CUSTOMERS";
		int total = jdbcTemplate.queryForObject(sql,Integer.class);
		return total;
	}

	public List<User> findAll() {
		String sql = "SELECT * FROM CUSTOMERS";
		//List<Customer> customers = jdbcTemplate.query(sql, new BeanPropertyRowMapper(Customer.class));
		List<User> customers = jdbcTemplate.query(sql, new CustomerRowMapper());
		return customers;
	}

	public User findById(int id) {
		String sql = "SELECT * FROM CUSTOMERS WHERE id = ?";
		User customer = (User) jdbcTemplate.queryForObject(sql,
				new Object[] { id },new CustomerRowMapper());
		return customer;
	}
	
	public Map<String,Object> findMapById(int id){
		String sql = "SELECT * FROM CUSTOMERS WHERE id = ?";
		return jdbcTemplate.queryForMap(sql,new Object[]{id});
	}
	
	public List<Map<String,Object>> findAllMap(){
		String sql = "SELECT * FROM CUSTOMERS";
		return jdbcTemplate.queryForList(sql);
	}
}

public class Account implements Serializable {

    private Integer id;
    private String name;
    private Double money;
	//setter...getter...toString...方法略    
}

public interface AccountDao {

    @Insert("insert into tbl_account(name,money)values(#{name},#{money})")
    void save(Account account);

    @Delete("delete from tbl_account where id = #{id} ")
    void delete(Integer id);

    @Update("update tbl_account set name = #{name} , money = #{money} where id = #{id} ")
    void update(Account account);

    @Select("select * from tbl_account")
    List<Account> findAll();

    @Select("select * from tbl_account where id = #{id} ")
    Account findById(Integer id);
}

public interface AccountService {

    void save(Account account);

    void delete(Integer id);

    void update(Account account);

    List<Account> findAll();

    Account findById(Integer id);

}

@Service
public class AccountServiceImpl implements AccountService {

    @Autowired
    private AccountDao accountDao;

    public void save(Account account) {
        accountDao.save(account);
    }

    public void update(Account account){
        accountDao.update(account);
    }

    public void delete(Integer id) {
        accountDao.delete(id);
    }

    public Account findById(Integer id) {
        return accountDao.findById(id);
    }

    public List<Account> findAll() {
        return accountDao.findAll();
    }
}

public class App {
    public static void main(String[] args) throws IOException {
        // 1. 创建SqlSessionFactoryBuilder对象
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        // 2. 加载SqlMapConfig.xml配置文件
        InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml.bak");
        // 3. 创建SqlSessionFactory对象
        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(inputStream);
        // 4. 获取SqlSession
        SqlSession sqlSession = sqlSessionFactory.openSession();
        // 5. 执行SqlSession对象执行查询，获取结果User
        AccountDao accountDao = sqlSession.getMapper(AccountDao.class);

        Account ac = accountDao.findById(1);
        System.out.println(ac);

        // 6. 释放资源
        sqlSession.close();
    }
}

//配置类注解
@Configuration
//包扫描，主要扫描的是项目中的AccountServiceImpl类
@ComponentScan("com.itheima")
public class SpringConfig {
}

public class JdbcConfig {
    @Value("${jdbc.driver}")
    private String driver;
    @Value("${jdbc.url}")
    private String url;
    @Value("${jdbc.username}")
    private String userName;
    @Value("${jdbc.password}")
    private String password;

    @Bean
    public DataSource dataSource(){
        DruidDataSource ds = new DruidDataSource();
        ds.setDriverClassName(driver);
        ds.setUrl(url);
        ds.setUsername(userName);
        ds.setPassword(password);
        return ds;
    }
}

@Configuration
@ComponentScan("com.itheima")
@PropertySource("classpath:jdbc.properties")
@Import(JdbcConfig.class)
public class SpringConfig {
}

public class MybatisConfig {
    //定义bean，SqlSessionFactoryBean，用于产生SqlSessionFactory对象
    @Bean
    public SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource){
        SqlSessionFactoryBean ssfb = new SqlSessionFactoryBean();
        //设置模型类的别名扫描
        ssfb.setTypeAliasesPackage("com.itheima.domain");
        //设置数据源
        ssfb.setDataSource(dataSource);
        return ssfb;
    }
    //定义bean，返回MapperScannerConfigurer对象
    @Bean
    public MapperScannerConfigurer mapperScannerConfigurer(){
        MapperScannerConfigurer msc = new MapperScannerConfigurer();
        msc.setBasePackage("com.itheima.dao");
        return msc;
    }
}

@Configuration
@ComponentScan("com.itheima")
@PropertySource("classpath:jdbc.properties")
@Import({JdbcConfig.class,MybatisConfig.class})
public class SpringConfig {
}

public class App2 {
    public static void main(String[] args) {
        ApplicationContext ctx = new AnnotationConfigApplicationContext(SpringConfig.class);

        AccountService accountService = ctx.getBean(AccountService.class);

        Account ac = accountService.findById(1);
        System.out.println(ac);
    }
}