先建数据库,四张表:会员、员工、产品、订单,弄好主外键关系,然后搭建工程项目,数据库连接成功后,包应该有:
musicSys.bean 放实体类:Vip、Employee、Product、Order
musicSys.dao 对会员、员工、产品、订单的增删改查操作,命名可以是VipDao、EmployeeDao...他们都应该是接口,类似:
public interface OrderDao{
public void addOrder(String sql);
public void deleteOrder(String sql);
...
}
musicSys.dao.impl 实现dao中的接口
public class OrderDaoImpl implements OrderDao{
public void addOrder(String sql){
//1、获取数据库连接
//2、增加订单
}
public void deleteOrder(String sql){
//1、获取数据库连接
//2、删除订单
}
...
}
musicSys.service 也是接口、业务类
public interface OrderService{
public boolean addOrder(Order order);
public boolean deleteOrder(int orderId);
}
musicSys.service.impl 实现业务类
public class OrderServiceImpl implements OrderService{
private OrderDao orderDao = new OrderDaoImpl();
public boolean addOrder(Order order){
int orderId = order.getOrderId();
.....
String sql = "insert into Order(......)values(orderId.....)";
orderDao.addOrder(sql);
}
public boolean deleteOrder(int orderId){
String sql = "delete from Order where orderId ="+orderId ;
orderDao.delete(sql);
}
}
musicSys.servlet 控制层,放servlet
,其余类的操作类似这样的结构,大概就是这样吧
musicSys.bean 放实体类:Vip、Employee、Product、Order
musicSys.dao 对会员、员工、产品、订单的增删改查操作,命名可以是VipDao、EmployeeDao...他们都应该是接口,类似:
public interface OrderDao{
public void addOrder(String sql);
public void deleteOrder(String sql);
...
}
musicSys.dao.impl 实现dao中的接口
public class OrderDaoImpl implements OrderDao{
public void addOrder(String sql){
//1、获取数据库连接
//2、增加订单
}
public void deleteOrder(String sql){
//1、获取数据库连接
//2、删除订单
}
...
}
musicSys.service 也是接口、业务类
public interface OrderService{
public boolean addOrder(Order order);
public boolean deleteOrder(int orderId);
}
musicSys.service.impl 实现业务类
public class OrderServiceImpl implements OrderService{
private OrderDao orderDao = new OrderDaoImpl();
public boolean addOrder(Order order){
int orderId = order.getOrderId();
.....
String sql = "insert into Order(......)values(orderId.....)";
orderDao.addOrder(sql);
}
public boolean deleteOrder(int orderId){
String sql = "delete from Order where orderId ="+orderId ;
orderDao.delete(sql);
}
}
musicSys.servlet 控制层,放servlet
,其余类的操作类似这样的结构,大概就是这样吧
那你那时候都干啥啊,俺们期末考试作业啊,其实我们JSP才学完SERvlet,其他的都还没学,我就想提前了解了解,以后再看说不定就容易了