Jdbc的一个简单小项目(点餐系统)

本文链接：https://blog.csdn.net/m0_74640928/article/details/130027795

刚开始写一点思路没有然后自己慢慢摸索一点一点写一点一点改，最后也是皇天不负有心人达到了自己想要的成果。

首先，先把结构文件搭建出来

接着把测试类控制台信息写出来

接着把两个实体类写出来

public class order implements Serializable {
    /*
    实体类
     */
    private Integer id;
    private String name;
    private String menu;
    private Integer copies;
    private Integer time;
    private String address;
    private double money;
    private Integer status;

    public order(){}

    public order(Integer id, String name, String menu, Integer copies, Integer time, String address, double money, Integer status) {
        this.id = id;
        this.name = name;
        this.menu = menu;
        this.copies = copies;
        this.time = time;
        this.address = address;
        this.money = money;
        this.status = status;
    }

    public order(String name, String menu, Integer copies, Integer time, String addrss, double money) {
        this.name = name;
        this.menu = menu;
        this.copies = copies;
        this.time = time;
        this.address = addrss;
        this.money = money;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getMenu() {
        return menu;
    }

    public void setMenu(String menu) {
        this.menu = menu;
    }

    public Integer getCopies() {
        return copies;
    }

    public void setCopies(Integer copies) {
        this.copies = copies;
    }

    public Integer getTime() {
        return time;
    }

    public void setTime(Integer time) {
        this.time = time;
    }

    public String getAddrss() {
        return address;
    }

    public void setAddrss(String addrss) {
        this.address = addrss;
    }

    public Integer getStatus() {
        return status;
    }

    public void setStatus(Integer status) {
        this.status = status;
    }

    public double getMoney() {
        return money;
    }

    public void setMoney(double money) {
        this.money = money;
    }

    @Override
    public String toString() {
        return id+"  "+name+"  "+menu+"  "+copies+"  "+time+"  "+address+"  "+money+"  ";
    }
}

public class message implements Serializable {
    private Integer id;
    private String menu;
    private double price;

    public message() {
    }

    public message(Integer id, String menu, double price) {
        this.id = id;
        this.menu = menu;
        this.price = price;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getMenu() {
        return menu;
    }

    public void setMenu(String menu) {
        this.menu = menu;
    }

    public double getPrice() {
        return price;
    }

    public void setPrice(double price) {
        this.price = price;
    }

    @Override
    public String toString() {
        return id+"  "+ menu + "   " + price;
    }
}

然后在进行第一步编写订餐类，先确定返回值和参数还有sql语句:insert into '订单信息表名' vaues(?,?,?,?,?,?);

查看餐袋也是先确定返回值和参数还有sql语句 select * from '订单信息表名'

public interface orderDao {

/*
接口类
*/
    //获取所有菜品信息  参数:无   返回值:list
    List<message> showAll();

    //下单  参数:Object  返回值:int
    int insert(order order);

    //查看餐袋      参数:无       返回值:list
    List<order> showOrder();

    //签收订单      参数:id      返回值:int
    int sigFor(int id);

    //获取签收值     参数:id       返回值:int
    int draw(int id);

    //删除订单      参数:id       返回值:int
    int delete(int id);

}

/*
接口实现类
 */
public class orderDaoImpl implements orderDao {
    //查询所有菜品
    @Override
    public List<message> showAll() {
        Connection conn = JdbcUtil.getConn();
        ResultSet rs = null;
        PreparedStatement pstmt = null;
        List<message> list = new ArrayList();
        try {
            pstmt = conn.prepareStatement("select * from message");
            rs = pstmt.executeQuery();
            while (rs.next()) {
                int id = rs.getInt("id");
                String menu = rs.getString("menu");
                double price = rs.getDouble("price");

                message me = new message(id, menu, price);
                list.add(me);
            }
            return list;
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        } finally {
            JdbcUtil.close(pstmt, rs, conn);
        }
        return list;
    }

    //下单
    @Override
    public int insert(order order) {
        String sql = "insert into order1 values (default,?,?,?,?,?,?,0)";
        Object[] obj = {order.getName(), order.getMenu(), order.getCopies(), order.getTime(), order.getAddrss(), order.getMoney()};
        int update = JdbcUtil.update(sql, obj);
        return update;
    }

    //查看餐袋
    @Override
    public List<order> showOrder() {
        Connection conn = JdbcUtil.getConn();
        PreparedStatement pstmt = null;
        ResultSet rs = null;

        List<order> list = new ArrayList<>();
        try {
            pstmt = conn.prepareStatement("select * from order1");
            rs = pstmt.executeQuery();
            while (rs.next()) {
                int id = rs.getInt("id");
                String name = rs.getString("name");
                String menu = rs.getString("menu");
                int copies = rs.getInt("copies");
                int time = rs.getInt("time");
                String address = rs.getString("address");
                double money = rs.getDouble("money");
                int status = rs.getInt("status");

                order order = new order(id, name, menu, copies, time, address, money, status);

                list.add(order);

            }
            return list;
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        } finally {
            JdbcUtil.close(pstmt, rs, conn);
        }
        return list;
    }

    //签收订单
    @Override
    public int sigFor(int id) {
        Connection conn = JdbcUtil.getConn();
        String sql = "update order1 set status=1 where id=?";
        Object[] obj = {id};
        int update = JdbcUtil.update(sql, obj);
        return update;
    }

    //获取签收值
    @Override
    public int draw(int id) {
        Connection conn = JdbcUtil.getConn();
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {
            pstmt = conn.prepareStatement("select status from order1 where id=" + id);
            rs = pstmt.executeQuery();
            while (rs.next()) {
                int status = rs.getInt("status");
                return status;
            }

        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return 0;
    }

    //删除订单
    @Override
    public int delete(int id) {
        String sql = "delete from order1 where id=?";
        Object[] obj = {id};
        int update = JdbcUtil.update(sql, obj);
        return update;
    }


}

好了最后在奉上运行图