第二次冲刺 06

今天进行会议主要是对于广告播放的问题进行解决。

package com.example.math.repositiory;

import com.example.math.bean.advertBean;
import com.example.math.jdbc.JDBCtools;

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 Advert_res {
    public static List<advertBean> advertBeans(String name) throws Exception {
        List<advertBean> list = new ArrayList<>();
        Connection connection = JDBCtools.getConnect();
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;
        String sql = "select advert_name,price,time from advert where user_name = ?";
        try{
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1,name);
            resultSet = preparedStatement.executeQuery();
            while (resultSet.next()){
                String advert1 = resultSet.getString("advert_name");
                float price1 = resultSet.getFloat("price");
                String time1 = resultSet.getString("time");
                advertBean bean = new advertBean(advert1,price1,time1);
                list.add(bean);
            }
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
        finally {
            JDBCtools.release(connection,preparedStatement,resultSet);
        }
        return list;
    }
}

 
            List<String> s = new ArrayList<>();
            Connection c=Tool.getConnection();
            PreparedStatement pre = null;
            ResultSet res = null;
            String sql = "SELECT * FROM advert where user_name= ? ";
            try {
                pre = c.prepareStatement(sql);
                pre.setString(1,"111");
                //pre.setString(2,tel);
                res = pre.executeQuery();
                while (res.next()) {
                    String s1 = res.getString("advert_name");
                    s.add(s1);
                    
                }