dao包prodao.java
package dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import entity.Pro;
import util.RowMapper;
import util.DBHelp;
public class ProDao {
private DBHelp<Pro> db = new DBHelp<Pro>();
public List<Pro> findAll(){
String sql = "select id,proname,price from t_pro";
return db.executeQueryForList(sql, new ProRowMapper());
}
public boolean save(String name,float price){
String sql = "insert into t_pro (proname ,price) values(?,?)";
return db.executeSQL(sql,name,price);
}
public void delById(int id){
String sql = "delete from t_pro where id =?";
db.executeSQL(sql,id);
}
public Pro findById(int id){
String sql = "select id,proname,price from t_pro where id=?" ;
return db.executeQueryForObject(sql,new ProRowMapper(),id);
}
public boolean update(Pro p){
String sql = "update t_pro set proname = ?,price = ? where id= ?";
return db.executeSQL(sql,p.getProname(),p.getPrice(),p.getId());
}
private class ProRowMapper implements RowMapper<Pro>{
public Pro mapRow(ResultSet rs) throws SQLException {
Pro p = new Pro();
p.setId(rs.getInt("id"));
p.setProname(rs.getString("proname"));
p.setPrice(rs.getFloat("price"));
return p;
}
}
}