DAOMVC设计模式.docVIP

第一讲 MVC设计模式和DAO设计模式 一、介绍MVC设计模式和DAO设计模式 二、应用设计模式举例——一以添加客户和查询学生列表为例来说明上述内容 详细步骤说明： 1、建立web工程，创建com.ym.dao包，创建接口interface CustomerDao，此处考虑需要对数据进行什么处理，设计相应的方法。 public interface CustomerDao { //public void save(int id,String name,String email); public void save(Customer c); public List listCustomer(); } 2、创建com.ym.dao.impl包，创建类class CustomerDaoImpl implements CustomerDao，实现相应的方法。在写SQL语句的时候创建SQLConstants接口（创建在com.amaker.util包中），将SQL语句的常量定义在里面。创建ConnectionUtil类，封装getConnection()方法来得到一个Connection对象。 import java.sql.Connection; …… public class CustomerDaoImpl implements CustomerDao,SQLConstants{ public List listCustomer() { ConnectionUtil cu = new ConnectionUtil(); Connection conn = cu.getConnection(); //conn.setAutoCommit(false); //Statement stmt ;静态 //PreparedStatement pstmt;动态 //PreparedStatement pstmt = null; List list = new ArrayList(); try { Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(QUERY_CUSTOMER_SQL); while(rs.next()){ int id = rs.getInt(1); String name = rs.getString(2); String email = rs.getString(email); Customer c = new Customer(); c.setId(id); c.setEmail(email); c.setName(name); list.add(c); } return list; } catch (SQLException e) { e.printStackTrace(); }finally{ try { conn.close(); } catch (SQLException e) { conn = null; e.printStackTrace(); } } return null; } public void save(Customer c) { ConnectionUtil cu = new ConnectionUtil(); Connection conn = cu.getConnection(); //conn.setAutoCommit(false); //Statement stmt ;静态 //PreparedStatement pstmt;动态 PreparedStatement pstmt = null; try { pstmt = conn.prepareStatement(ADD_CUSTOMER_SQL); pstmt.setString(1, c.getName()); pstmt.setString(2, c.getEmail()); pstmt.executeUpdate(); //mit(); } catch (SQLException e) { e.printStackTrace(); }finally{ try { conn.close(); } catch (SQLException e) { conn = null; e.p