2021 11 30

CSV导入mysql；

package org.example;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.*;
import java.nio.charset.StandardCharsets;
import java.sql.*;
import java.util.ArrayList;
import java.util.regex.Pattern;

public class Tomysql {
    public Connection getConnection()
    {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        String url = "jdbc:mysql://localhost:3306/jianmin?serverTimezone=GMT%2B8";
        String username = "root";
        String password="123456";
        Connection a=null;
        try {
            a = DriverManager.getConnection(url,username,password);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return a;
    }
    public String insert(String content,String channelName,String title)
    {
        String result="导入成功";
        Connection coon = getConnection();
        String sql ="Insert into news(content,channelName,title)values(?,?,?)";
        try {
            PreparedStatement ps = coon.prepareStatement(sql.toString());
            coon.setAutoCommit(false);
            ps.setString(1, content);
            ps.setString(2, channelName);
            ps.setString(3, title);
            ps.addBatch();
            ps.executeBatch();
            coon.commit();
            ps.close();
            coon.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return result;
    }
}