Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package texttoarraylistthentodb;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import static java.sql.DriverManager.getConnection;
- import java.sql.ResultSet;
- import java.sql.Statement;
- import java.text.*;
- import java.util.*;
- import java.io.*;
- import java.text.SimpleDateFormat;
- import java.util.concurrent.TimeUnit;
- public class TextToArrayListThenToDB {
- private static String DB_URL = "jdbc:sqlserver://192.168.101.23:1433;" + "databaseName=T2AL2DB;"+ "integratedSecurity=false;" + "encrypt=false;" + "trustServerCertificate=true;";
- private static String USER_NAME = "sa";
- private static String PASSWORD = "Su$sybaka";
- static class SV{
- private String Ma;
- private String Ten;
- private String Lop;
- private double D1;
- private double D2;
- private double D3;
- public SV(String Ma, String Ten, String Lop, double D1, double D2, double D3){
- this.Ma = Ma;
- this.Ten = Ten;
- this.Lop = Lop;
- this.D1 = D1;
- this.D2 = D2;
- this.D3 = D3;
- }
- public String getMa(){
- return Ma;
- }
- @Override
- public String toString(){
- return String.format("%s %s %s %.1f %.1f %.1f", Ma, Ten, Lop, D1, D2, D3);
- }
- }
- public static void main(String[] args) throws FileNotFoundException {
- Scanner cin = new Scanner(new File("E:\\OOP\\TextToArrayListThenToDB\\src\\texttoarraylistthentodb\\input.txt"));
- int t = cin.nextInt();
- cin.nextLine();
- List<SV> dssv = new ArrayList<>();
- while(t-->0){
- String Ma = cin.nextLine();
- String Ten = cin.nextLine();
- String Lop = cin.nextLine();
- double D1 = Double.parseDouble(cin.nextLine());
- double D2 = Double.parseDouble(cin.nextLine());
- double D3 = Double.parseDouble(cin.nextLine());
- SV sv = new SV(Ma,Ten,Lop,D1,D2,D3);
- dssv.add(sv);
- }
- dssv.sort(Comparator.comparing(SV::getMa));
- int stt = 1;
- for(SV i : dssv){
- try{
- Connection ketnoi = getConnection(DB_URL, USER_NAME, PASSWORD);
- Statement stmt = ketnoi.createStatement();
- String cmd = "INSERT INTO BangDiem VALUES ('" + stt + "','" + i.Ma + "','" + i.Ten + "','" + i.Lop + "'," + i.D1 + "," + i.D2 + "," + i.D3 + ");";
- stmt.executeQuery(cmd);
- stt++;
- }catch (Exception ex){
- ex.printStackTrace();
- }
- }
- }
- }
- /*
- Create TABLE Command
- CREATE TABLE BangDiem(
- stt int,
- ma VARCHAR(15) PRIMARY KEY,
- ten VARCHAR(50),
- lop VARCHAR(15),
- d1 float,
- d2 float,
- d3 float
- );
- */
- /*
- input.txt
- 3
- B20DCCN999
- Nguyen Van An
- D20CQCN04-B
- 10.0
- 9.0
- 8.0
- B20DCAT001
- Le Van Nam
- D20CQAT02-B
- 6.0
- 6.0
- 4.0
- B20DCCN111
- Tran Hoa Binh
- D20CQCN04-B
- 9.0
- 5.0
- 6.0
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement