JDBC第一题第一种解法

import java.io.BufferedReader;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
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 Demo05 {//把比平均数小的工资都加1000再插回去
    public static void main(String[] args) throws IOException, SQLException {
        FileReader fileReader = new FileReader("input4.txt");//获取数据
        BufferedReader bufferedReader = new BufferedReader(fileReader);

        String line=bufferedReader.readLine();

        int count=0;
        double sum = 0;
        List<Double> list = new ArrayList<>();
        List<Integer> integerList = new ArrayList<>();
        while (line!=null){
            String[] arr = line.split(" ");

            sum+=Double.parseDouble(arr[5]);
            list.add(Double.parseDouble(arr[5]));
            integerList.add(Integer.parseInt(arr[0]));
            System.out.println(line);
            line = bufferedReader.readLine();
            count++;
        }
        double avg = sum/count;
        System.out.println(avg);
        System.out.println(list);
        for (int i = 0; i < count; i++) {
            if(list.get(i)<avg){
                list.set(i,list.get(i)+1000.0);
            }
        }
        System.out.println(list);
        System.out.println(integerList);


        Connection connection = JDBCUtils.getConnection();


        //preparedStatement.setString(1,"zhangsan");//前边的数字表示第几个问号
        //ResultSet resultSet = preparedStatement.executeQuery();
        for (int i = 0; i < count; i++) {
            String sql = "update emp set sal = ? where empno=?";
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setDouble(1,list.get(i));
            preparedStatement.setInt(2,integerList.get(i));
            int executeUpdate = preparedStatement.executeUpdate();
            System.out.println(executeUpdate);
            JDBCUtils.close(connection,preparedStatement);
        }



        /*JDBCUtils.close(connection,preparedStatement);*/
    }
}