userdao.java

来自「rrprur jhgrhg rojgrrgrhhh」· Java 代码 · 共 53 行

package terry.work;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import javax.sql.DataSource;

import org.springframework.jdbc.core.JdbcTemplate;

public class UserDAO implements IUserDAO
{
	private JdbcTemplate jdbcTemplate;
	//private DataSource dataSource;
	//private String uanme;
	
	public void setDataSource(DataSource dataSource)
	{
		jdbcTemplate=new JdbcTemplate(dataSource);
	}
	
	public void insert(User user)
	{
		String uname=user.getUname();
		int age=user.getAge();
		jdbcTemplate.update("insert into users(uname,age) values('"+ uname +"',"+ age +")");
	}
	public User find(int id)
	{
		List rows=jdbcTemplate.queryForList("select * from users where id="+id);
		Iterator it=rows.iterator();
		if(it.hasNext())
		{
			Map userMap=(Map)it.next();
			int i=(new Integer(userMap.get("id").toString())).intValue();
			String uname=userMap.get("uname").toString();
			int age=(new Integer(userMap.get("age").toString())).intValue();
				
			User user=new User();
			user.setId(i);
			user.setUname(uname);
			user.setAge(age);
			return user;
		}
		
		return null;
	}
}