《JavaWeb编程技术》课后习题答案(13)
时间:2025-07-11
时间:2025-07-11
(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());