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

时间:2025-07-10

(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());

《JavaWeb编程技术》课后习题答案(13).doc 将本文的Word文档下载到电脑

精彩图片

热门精选

大家正在看

× 游客快捷下载通道(下载后可以自由复制和排版)

限时特价:7 元/份 原价:20元

支付方式:

开通VIP包月会员 特价:29元/月

注:下载文档有可能“只有目录或者内容不全”等情况,请下载之前注意辨别,如果您已付费且无法下载或内容有问题,请联系我们协助你处理。
微信:fanwen365 QQ:370150219