src/org/wdl/hotelAppTest/dao/DinnerTableDaoImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package org.wdl.hotelAppTest.dao;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.wdl.hotelTest.bean.DinnerTable;
import org.wdl.hotelTest.util.ConnectionFactory;

public class DinnerTableDaoImpl implements DinnerTableDao {

    @Override
    public List<DinnerTable> findDinnerTables(String tableStatus, String tableName) {
        Connection connection = null;
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;
        try {
            //①获取连接
            connection = ConnectionFactory.getConnection();

            //②准备SQL
            StringBuffer sql = new StringBuffer("SELECT * FROM tb_dinner_table WHERE disabled = 0");

            if (tableName != null && !tableName.equals("")) {
                sql.append(" and table_name like '%" + tableName + "%' ");
            }

            if (tableStatus != null && !tableStatus.equals("")) {
                sql.append(" and table_status = " + tableStatus);
            }
            System.out.println("sql:" + sql);

            //③ 获取集装箱
            preparedStatement = connection.prepareStatement(sql.toString());
            //索引从1开始

            //④ 执行SQL语句
            resultSet = preparedStatement.executeQuery();

            List<DinnerTable> dinnerTables = new ArrayList<>();
            //指针下移一位，因为将表头信息也查询出来了，而表头信息不需要封装
            while (resultSet.next()) {
                DinnerTable dinnerTable = new DinnerTable();
                dinnerTable.setId(resultSet.getInt("id"));
                dinnerTable.setTableName(resultSet.getString("table_name"));
                dinnerTable.setTableStatus(resultSet.getInt("table_status"));
                dinnerTable.setDisabled(resultSet.getInt("disabled"));
                dinnerTable.setCreateDate(resultSet.getTimestamp("create_date"));
                dinnerTable.setUpdateDate(resultSet.getTimestamp("update_date"));
                dinnerTable.setUseUserId(resultSet.getInt("use_user_id"));
                System.out.println(" dao :" + dinnerTable);
                dinnerTables.add(dinnerTable);
            }

            return dinnerTables;
        } catch (SQLException e) {