《JavaWeb编程技术》课后习题答案(13)

(ArrayList<CustomerBean>)request.getAttribute("custs");

for(CustomerBean cb : custs){

out.println(cb.getCustName() + " "+ cb.getEmail() + " "

+ cb.getPhone() + "</br>");

}

%>

</body></html>

10. 首先在SampleDAO类中定义下面两个字符串常量：

private static final String DELETE_SQL =

"DELETE FROM customer WHERE custName = ?";

private static final String UPDATE_SQL =

"UPDATE customer SET email=? , phone=? WHERE custName=?";

下面是删除客户和修改客户的方法：

// 按姓名删除客户记录

public boolean deleteCustomer(String custName){

Connection conn = null;

PreparedStatement pstmt = null;

ResultSet rst = null;

CustomerBean customer =null;

try{

conn = dataSource.getConnection();

pstmt = conn.prepareStatement(DELETE_SQL);

pstmt.setString(1,custName);

int n = pstmt.executeUpdate();

if(n ==1){

return true;

}else{

return false;

}

}catch(SQLException se){

return false;

}finally{

try{

pstmt.close();

conn.close();

}catch(SQLException se){}

}

}

// 修改客户记录

public boolean updateCustomer(CustomerBean customer){

Connection conn = null;

PreparedStatement pstmt = null;

try{

conn = dataSource.getConnection();

pstmt = conn.prepareStatement(UPDATE_SQL);

pstmt.setString(1,customer.getEmail());

pstmt.setString(2,customer.getPhone());