表現層:JSP/Servlet 或 Spring MVC
業務層:Service 接口與實現
持久層:JDBC / MyBatis / Hibernate
數據層:MySQL 客戶表 (id, name, contact, address, ...)
public class Customer {
private Integer id;
private String name;
private String phone;
// getter/setter/toString
}
public interface CustomerDAO {
void add(Customer c);
void delete(int id);
void update(Customer c);
Customer findById(int id);
List<Customer> findAll();
}
@Service
public class CustomerServiceImpl implements CustomerService {
@Autowired CustomerDAO dao;
// 事務控制、業務邏輯校驗
}
建議從簡單的 JDBC 版本入手,理解連接池、PreparedStatement 防注入、事務邊界控制,再遷移至框架。