customerdaojdbcimpl2.java

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

package dao.jdbc;

import java.util.List;

import org.springframework.jdbc.core.support.JdbcDaoSupport;

import dao.CustomerDAO;
import entity.Customer;

public class CustomerDAOJdbcImpl2 extends JdbcDaoSupport implements CustomerDAO{

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

	public List<Customer> findAll() {
		// TODO Auto-generated method stub
		String sql = "select * from Customer";
		return getJdbcTemplate().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) getJdbcTemplate().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()};
		getJdbcTemplate().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()};
		getJdbcTemplate().update(sql,params);
		
	}
}