Advertisement
anhkiet2507

Demo Read from File, Put data to ArrayList and Put into DB

Sep 25th, 2022
1,441
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 2.97 KB | None | 0 0
  1. package texttoarraylistthentodb;
  2. import java.sql.Connection;
  3. import java.sql.DriverManager;
  4. import static java.sql.DriverManager.getConnection;
  5. import java.sql.ResultSet;
  6. import java.sql.Statement;
  7. import java.text.*;
  8. import java.util.*;
  9. import java.io.*;
  10. import java.text.SimpleDateFormat;
  11. import java.util.concurrent.TimeUnit;
  12. public class TextToArrayListThenToDB {
  13.     private static String DB_URL = "jdbc:sqlserver://192.168.101.23:1433;" + "databaseName=T2AL2DB;"+ "integratedSecurity=false;" + "encrypt=false;" + "trustServerCertificate=true;";
  14.     private static String USER_NAME = "sa";
  15.     private static String PASSWORD = "Su$sybaka";
  16.     static class SV{
  17.         private String Ma;
  18.         private String Ten;
  19.         private String Lop;
  20.         private double D1;
  21.         private double D2;
  22.         private double D3;
  23.         public SV(String Ma, String Ten, String Lop, double D1, double D2, double D3){
  24.             this.Ma = Ma;
  25.             this.Ten = Ten;
  26.             this.Lop = Lop;
  27.             this.D1 = D1;
  28.             this.D2 = D2;
  29.             this.D3 = D3;
  30.         }
  31.         public String getMa(){
  32.             return Ma;
  33.         }
  34.         @Override
  35.         public String toString(){
  36.             return String.format("%s %s %s %.1f %.1f %.1f", Ma, Ten, Lop, D1, D2, D3);
  37.         }
  38.     }
  39.    
  40.     public static void main(String[] args) throws FileNotFoundException {
  41.         Scanner cin = new Scanner(new File("E:\\OOP\\TextToArrayListThenToDB\\src\\texttoarraylistthentodb\\input.txt"));
  42.         int t = cin.nextInt();
  43.         cin.nextLine();
  44.         List<SV> dssv = new ArrayList<>();
  45.         while(t-->0){
  46.             String Ma = cin.nextLine();
  47.             String Ten = cin.nextLine();
  48.             String Lop = cin.nextLine();
  49.             double D1 = Double.parseDouble(cin.nextLine());
  50.             double D2 = Double.parseDouble(cin.nextLine());
  51.             double D3 = Double.parseDouble(cin.nextLine());
  52.             SV sv = new SV(Ma,Ten,Lop,D1,D2,D3);
  53.             dssv.add(sv);
  54.         }
  55.         dssv.sort(Comparator.comparing(SV::getMa));
  56.         int stt = 1;
  57.         for(SV i : dssv){
  58.             try{
  59.                 Connection ketnoi = getConnection(DB_URL, USER_NAME, PASSWORD);
  60.                 Statement stmt = ketnoi.createStatement();
  61.                 String cmd = "INSERT INTO BangDiem VALUES ('" + stt + "','" + i.Ma + "','" + i.Ten + "','" + i.Lop + "'," + i.D1 + "," + i.D2 + "," + i.D3 + ");";
  62.                 stmt.executeQuery(cmd);
  63.                 stt++;
  64.             }catch (Exception ex){
  65.                 ex.printStackTrace();
  66.             }
  67.         }
  68.     }
  69. }
  70.  
  71. /*
  72. Create TABLE Command
  73. CREATE TABLE BangDiem(
  74.    stt int,
  75.    ma VARCHAR(15) PRIMARY KEY,
  76.    ten VARCHAR(50),
  77.    lop VARCHAR(15),
  78.    d1 float,
  79.    d2 float,
  80.    d3 float
  81. );
  82. */
  83.  
  84. /*
  85. input.txt
  86. 3
  87. B20DCCN999
  88. Nguyen Van An
  89. D20CQCN04-B
  90. 10.0
  91. 9.0
  92. 8.0
  93. B20DCAT001
  94. Le Van Nam
  95. D20CQAT02-B
  96. 6.0
  97. 6.0
  98. 4.0
  99. B20DCCN111
  100. Tran Hoa Binh
  101. D20CQCN04-B
  102. 9.0
  103. 5.0
  104. 6.0
  105. */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement