Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.io.*;
- import java.util.Collections;
- import java.util.Scanner;
- public class CSV1 {
- public void csv(){
- int symbol;
- char ch;
- Scanner scanner = null;
- String data;
- byte index = 0;
- StringBuilder stringBuilder = new StringBuilder();
- String folderCSV = "D:\\test\\test.csv";
- InputStreamReader reader = null;
- try {
- reader = new InputStreamReader(new FileInputStream(folderCSV), "cp1251");
- symbol = reader.read();
- while (symbol != -1) {
- ch = (char) symbol;
- if (ch != '\n' ) {
- stringBuilder.append(ch);
- }else if(ch == '\r'){
- }else {
- scanner = new Scanner(stringBuilder.toString());
- scanner.useDelimiter(";");
- User user = new User();
- while (scanner.hasNext()) {
- data = scanner.next();
- if (index == 0) {
- user.setLastName(data);
- } else if (index == 1) {
- user.setName(data);
- } else if (index == 2) {
- user.setYear(Integer.parseInt(data));
- } else {
- System.out.println("Error field");
- }
- index++;
- }
- index = 0;
- stringBuilder.setLength(0);
- users.add(user);
- }
- symbol = reader.read();
- }
- } catch (UnsupportedEncodingException e) {
- e.printStackTrace();
- } catch (IOException e) {
- e.printStackTrace();
- }
- Collections.sort(users, (o1, o2) -> o2.getYear() - o1.getYear());
- OutputStream outputStream = new FileOutputStream(folderCSV);
- stringBuilder.setLength(0);
- for (User user : users) {
- stringBuilder.append(user.getLastName()).append(";");
- stringBuilder.append(user.getName()).append(";");
- stringBuilder.append(user.getYear()).append("\n");
- }
- try {
- outputStream.write(stringBuilder.toString().getBytes("Cp1251"));
- } catch (IOException e) {
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement