从旧表读取特定字段，存入新表

// 从旧表读取特定字段，存入新表。
public class IdShortener {
    public static void main(String[] args) {
        String dbUrl = "jdbc:mysql://";
        String dbUser = "";
        String dbPassword = "@123";
        String sourceTable = "device_instruct";
        String targetTable = "new_instruct";
        String[] columnsToCopy = {"name", "instruct", "remark", "status"}; // 要复制的列的名称

        try (Connection conn = DriverManager.getConnection(dbUrl, dbUser, dbPassword)) {
            Statement stmt = conn.createStatement();

            // 从表中读取数据
            String selectQuery = "SELECT name, instruct, remark, status FROM device_instruct";
            ResultSet rs = stmt.executeQuery(selectQuery);

            while(rs.next()){
                // 通过字段检索
                String name = rs.getString("name");
                String instruct = rs.getString("instruct");
                String remark = rs.getString("remark");
                String status = rs.getString("status");

            }

            //执行插入
            String sql2 =  "insert into new_instruct (name,instruct,remark,status) select name,instruct,remark,status from device_instruct";
            stmt.executeUpdate(sql2);

            // 完成后关闭
            rs.close();
            stmt.close();

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}