src/org/wdl/hotelSysTest/sys/dao/MessageDaoImpl.java

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

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

package org.wdl.hotelSysTest.sys.dao;

import org.wdl.hotelTest.bean.Message;
import org.wdl.hotelTest.bean.Notice;
import org.wdl.hotelTest.util.ConnectionFactory;

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

public class MessageDaoImpl implements MessageDao {

    @Override
    public List<Message> find() {
        //① 获取连接
        Connection connection = ConnectionFactory.getConnection();
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;


        //② 准备SQL语句  SELECT * FROM tb_food WHERE food_name LIKE  '%干锅%' AND foodType_id = 2
        StringBuffer sql = new StringBuffer();
        sql.append("SELECT * from tb_message");
        try {
            //③准备集装箱
            preparedStatement = connection.prepareStatement(sql.toString());

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

            List<Message> messages = new ArrayList<>();
            while (resultSet.next()) {
                Message message = new Message();
                message.setId(resultSet.getInt("id"));
                message.setUserid(resultSet.getInt("userid"));
                message.setText(resultSet.getString("text"));
                message.setCreattime(resultSet.getTimestamp("creattime"));

                messages.add(message);
            }
            //遍历foods，根据food中foodTypeId查询菜系，就可以获取food对于的菜系名字 不采取这种方法
            return messages;
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            ConnectionFactory.close(connection, preparedStatement, resultSet);
        }

        return null;
    }

    @Override
    public List<Message> findById(int id) {
        //① 获取连接
        Connection connection = ConnectionFactory.getConnection();
        PreparedStatement preparedStatement = null;