手机信息管理系统

dao层接口

public interface MDao {
    int insert (Moblie moblie);
   List <Moblie> selectById(Integer id);

    List<Moblie> selectAll();
    int delete (Integer id);
    int update(Moblie moblie);
}

dao层实现类

public class MDaoImpl implements MDao{
    DBHelper db=new DBHelper();
    @Override
    public int insert(Moblie moblie) {
        String sql="insert into  moblie values(?,?,?,?,?,?)";
        Object []objects={moblie.getId(),moblie.getBrand(),moblie.getModel(),moblie.getPrice(),moblie.getCount(),moblie.getVersion()};
        return db.update(sql,objects);

    }

    @Override
    public List<Moblie> selectById(Integer id) {
        String sql="select * from moblie where id=?";
        List<Moblie> list=db.query(sql,Moblie.class,id);
        return list;
    }

    @Override
    public List<Moblie> selectAll() {
        String sql="select * from moblie";
        return db.query(sql,Moblie.class);
    }

    @Override
    public int delete(Integer id) {
        String sql="delete from moblie where id=?";
        return db.update(sql,id);
    }

    @Override
    public int update(Moblie moblie) {
        String sql = "UPDATE moblie SET price = ? WHERE id = ?";
        return db.update(sql, moblie.getPrice(), moblie.getId());
    }
}

业务层接口

public interface MSevice {
    boolean add(Integer id,String brand,String model,Double price,Integer count ,String version);
    List<Moblie> findById(Integer id);
    List<Moblie>findAll();
    boolean remove(Integer id);
    boolean updateprice(Double price,Integer id);
}

业务层实现类

  public boolean add(Integer id, String brand, String model, Double price, Integer count, String version) {
        Moblie mb=new Moblie();
        mb.setId(id);
        mb.setBrand(brand);
        mb.setCount(count);
        mb.setPrice(price);
        mb.setVersion(version);
        mb.setModel(model);
        return md.insert(mb)==1?true:false;
    }

    @Override
    public List<Moblie> findById(Integer id) {
        return md.selectById(id);
    }

    @Override
    public List<Moblie> findAll() {
        return md.selectAll();
    }

    @Override
    public boolean remove(Integer id) {
        return md.delete(id)==1?true:false;
    }

    @Override
    public boolean updateprice(Double price, Integer id) {
        Moblie moblie=new Moblie();
        moblie.setPrice(price);
        moblie.setId(id);
        return  md.update(moblie)==1?true:false;
    }
}

控制层

public class C {
    MSevice ms = new MServiceImpl();
    Scanner input = new Scanner(System.in);

    public void mainMenu() {
        System.out.println("欢迎使用迷你DVD管理系统");
        System.out.println("--------------------------------------");
        System.out.println("1.手机录入");
        System.out.println("2.根据手机品牌查手机信息");
        System.out.println("3.查询全部手机信息");
        System.out.println("4.根据手机编号改手机价格");
        System.out.println("5.根据手机编号删除手机记录");
        System.out.println("6.退\t\t出");
        System.out.println("--------------------------------------");
        System.out.println("请选择：");
        Scanner input = new Scanner(System.in);
        int index = input.nextInt();
        switch (index) {
            case 1:
                System.out.println("---> 手机录入");
                method1();
                break;
            case 2:
                System.out.println("---> 根据手机品牌查手机信息");
                method2();
                break;
            case 3:
                System.out.println("---> 查询全部手机信息");
                 method3();
                break;
            case 4:
                System.out.println("---> 根据手机编号改手机价格");
                 method4();
                break;
            case 5:
                System.out.println("---> 根据手机编号删除手机记录");
                method5();
                break;
            case 6:
                System.out.println("谢谢使用！");
                System.exit(0);
        }
        System.out.println("*******************");
        System.out.println("请输入0返回：");
        int num = input.nextInt();
        if (num == 0) {
            mainMenu();
        }
    }

    public void method1() {
        System.out.println("请输入手机id");
        Integer id = input.nextInt();
        System.out.println("请输入手机品牌");
        String brand = input.next();
        System.out.println("请输入手机型号");
        String model = input.next();
        System.out.println("请输入手机价格");
        Double price = input.nextDouble();
        System.out.println("请输入手机数量");
        Integer count = input.nextInt();
        System.out.println("请输入手机版本");
        String version = input.next();
        boolean b = ms.add(id, brand, model, price, count, version);
        System.out.println(b ? "添加成功" : "添加失败");
    }

    public void method2() {
        System.out.println("请输入你要查询的id");
        Integer id = input.nextInt();
        System.out.println("序号\t\t" + "品牌\t\t" + "型号\t\t" + "价格\t\t" + "数量\t\t" + "版本");
        List<Moblie> list = ms.findById(id);
        for (Moblie m : list) {
            System.out.println(m.toString());

        }

    }

    private void method3() {
        List<Moblie> moblies = ms.findAll();
        System.out.println("序号\t\t" + "品牌\t\t" + "型号\t\t" + "价格\t\t" + "数量\t\t" + "版本");
        for (Moblie b : moblies) {
            System.out.println(b.toString());
        }
    }
    public void method5(){
        System.out.println("请输入你要删除的id");
        Integer id = input.nextInt();
        boolean b= ms.remove(id);
        System.out.println(b ? "删除成功" : "删除失败");
    }
    public void method4(){
        System.out.println("请输入你要修改手机的id");
        Integer id= input.nextInt();
        System.out.println("请输入你要修改的价格为");
        Double price= input.nextDouble();
        boolean b=ms.updateprice(price,id);
        System.out.println(b?"修改成功":"修改失败");
    }
}

实现层

public class Promain {
    public static void main(String[] args) {
        C c=new C();
        c.mainMenu();
    }
}