jdbcTemplate关于crud

package com.spring.jdbcTemplate;

import java.sql.ResultSet;
import java.sql.SQLException;

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

import com.spring.User.User;

public class jdbcTemplateQuery {
	/**
	 * 查询表有多少条记录
	 */
	@Test
	public void testCount(){
		DriverManagerDataSource dataSource = new DriverManagerDataSource();
		//设置数据库信息
		dataSource.setDriverClassName("com.mysql.jdbc.Driver");
		dataSource.setUrl("jdbc:mysql://localhost:3306/lihai?useUnicode=true&characterEncoding=utf-8&useSSL=false");
		dataSource.setUsername("root");
		dataSource.setPassword("111111");
		
		JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
		
		String sql = "select count(*) from jdbc_user";
		int count = jdbcTemplate.queryForObject(sql, Integer.class);//第二个参数：返回类型的class
		System.out.println(count);
		
	}
	
	/**
	 * 查询表返回对象
	 */
	@Test
	public void testObject(){
		DriverManagerDataSource dataSource = new DriverManagerDataSource();
		//设置数据库信息
		dataSource.setDriverClassName("com.mysql.jdbc.Driver");
		dataSource.setUrl("jdbc:mysql://localhost:3306/lihai?useUnicode=true&characterEncoding=utf-8&useSSL=false");
		dataSource.setUsername("root");
		dataSource.setPassword("111111");
		
		JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
		
		String sql = "select * from jdbc_user where username=?";
		//int count = jdbcTemplate.queryForObject(sql, rowMapper, args)
		//方法第二个参数：需要自己写类实现接口，自己做数据封装
		User user = jdbcTemplate.queryForObject(sql, new MyRowMapper(), "kylon");
		System.out.println(user);
		
	}
	
	
	/**
	 * 查询表返回list
	 */
	@Test
	public void testList(){
		DriverManagerDataSource dataSource = new DriverManagerDataSource();
		//设置数据库信息
		dataSource.setDriverClassName("com.mysql.jdbc.Driver");
		dataSource.setUrl("jdbc:mysql://localhost:3306/lihai?useUnicode=true&characterEncoding=utf-8&useSSL=false");
		dataSource.setUsername("root");
		dataSource.setPassword("111111");
		
		JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
		
		String sql = "select * from jdbc_user";
		//int count = jdbcTemplate.queryForObject(sql, rowMapper, args)
		//方法第二个参数：需要自己写类实现接口，自己做数据封装
		List<User> list = jdbcTemplate.query(sql, new MyRowMapper());
		System.out.println(list);
		
	}
	
}

class MyRowMapper implements RowMapper<User>{

	public User mapRow(ResultSet rs, int num) throws SQLException {
		//从结果集得到数据
		String username = rs.getString("username");
		String password = rs.getString("password");
		//把得到的数据封装到对象
		User user = new User();
		user.setPassword(password);
		user.setUsername(username);
		return user;
	}
	
}