| | |
|---|
| | | |
|---|
| | | import cn.hutool.core.io.FileUtil; |
|---|
| | | import com.chinaztt.mes.docx.dto.GetFileDto; |
|---|
| | | import com.chinaztt.mes.docx.dto.ThicknessData; |
|---|
| | | import com.opencsv.CSVReader; |
|---|
| | | import com.opencsv.CSVReaderBuilder; |
|---|
| | | import com.opencsv.exceptions.CsvValidationException; |
|---|
| | |
|---|
| | | StringBuilder stringBuilder = new StringBuilder(); |
|---|
| | | String strTmp = ""; |
|---|
| | | while ((strTmp = buffReader.readLine()) != null) { |
|---|
| | | strTmp = strTmp.replaceAll("\t",","); |
|---|
| | | stringBuilder.append(strTmp).append("\n"); |
|---|
| | | } |
|---|
| | | buffReader.close(); |
|---|
| | |
|---|
| | | return R.failed("数据库名或表名不能为空"); |
|---|
| | | } |
|---|
| | | // 数据库连接信息 |
|---|
| | | String url = "jdbc:mysql://localhost:3306/"+dbName+"?useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true&characterEncoding=utf8"; |
|---|
| | | String url = "jdbc:mysql://localhost:3307/"+dbName+"?useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true&characterEncoding=utf8"; |
|---|
| | | Connection connection = null; |
|---|
| | | PreparedStatement preparedStatement = null; |
|---|
| | | ResultSet resultSet = null; |
|---|
