customerdaojdbcimpl.java

来自「加拿大达内科技有限公司配需java程序员的上课时的代码」· Java 代码 · 共 53 行

package dao.jdbc;

import java.util.List;

import org.springframework.jdbc.core.JdbcTemplate;

import dao.CustomerDAO;
import entity.Customer;

public class CustomerDAOJdbcImpl implements CustomerDAO{
	private JdbcTemplate jt;
	
	public void setJt(JdbcTemplate jt) {
		this.jt = jt;
	}

	public void delete(String name) {
		// TODO Auto-generated method stub
		String sql = "delete from Customer where name=?";
		Object[] params = new Object[]{name};
		jt.update(sql,params);
	}

	public List<Customer> findAll() {
		// TODO Auto-generated method stub
		String sql = "select * from Customer";
		return jt.query(sql, new CustomerRowMapper());
	}

	public Customer findByName(String name) {
		// TODO Auto-generated method stub
		String sql = "select * from Customer where name=?";
		Object[] params = new Object[]{name};
		return (Customer) jt.queryForObject(sql, params,new CustomerRowMapper());
	}

	public void save(Customer c) {
		// TODO Auto-generated method stub
		String sql="insert into Customer(name,age) values(?,?)";
		Object[] params = new Object[]{c.getName(),c.getAge()};
		jt.update(sql,params);
	}

	public void update(Customer c) {
		// TODO Auto-generated method stub
		String sql = "update Customer set name=?,age=? where id=?";
		Object[] params = new Object[]{c.getName(),c.getAge(),c.getId()};
		jt.update(sql,params);
		
	}
	
}