我正在尝试通过 Java 从文本文件将数据加载到我的 MySQL 数据库。到目前为止，我有以下代码。当我运行它时，它成功地从文件中读取数据并将其打印出来，但随后出现此错误并且没有数据添加到数据库中:

Exception in thread "main" java.lang.IllegalArgumentException
at java.sql.Date.valueOf(Date.java:143)
at jdbc.Jdbc.main(Jdbc.java:81)

package jdbc;

import java.sql.*; 
import java.io.*;
import java.util.*; 
import java.io.File;
import java.io.FileReader;
import java.io.BufferedReader;

public class Jdbc { 
public static void main (String args []) 
  throws SQLException, IOException { 

  // the following statement loads the MySQL jdbc driver
  // make sure it is in the CLASSPATH

try {
  Class.forName ("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
    System.out.println ("Could not load the driver"); 
  }

String user, password, host;

Scanner sc = new Scanner(System.in);
System.out.println("Type userid, password, hostname or ipaddress: ");
user = sc.next();
password = sc.next();
host = sc.next();
System.out.println(user+" "+password+" "+host);

//  userid, password and hostname are obtained from the console

Connection conn = DriverManager.getConnection
              ("jdbc:mysql://localhost/PoemsAss", user, password);

/* JDBC default is to commit each SQL statement as it is sent to the database.  Setting autocommmit=false changes the default
   behaviour so that transactions have to be committed explicity.
 */
conn.setAutoCommit(false);

// Creating a statement lets us issue commands against the connection.

Statement s = conn.createStatement();



//Create Tables
s.executeUpdate("create table IF NOT EXISTS Poet(Poet CHAR(20)  PRIMARY KEY,     DOB DATE, PlaceOfBirth CHAR(20), Nationally CHAR(20),  Language CHAR(15))");
System.out.println("Table created");
s.executeUpdate("create table IF NOT EXISTS Translator(Translator_Name CHAR(30)  PRIMARY KEY,  Poem_Title VARCHAR(50), Translation_Date DATE)");
System.out.println("Table created");
s.executeUpdate("create table IF NOT EXISTS Poem(Poem_Title VARCHAR(50)  PRIMARY KEY,  Date_Published DATE, Language CHAR(20), Num_Words SMALLINT, Translator_Name CHAR(30))");
System.out.println("Table created");
s.executeUpdate("create table IF NOT EXISTS Recording(RecordingID VARCHAR(4)  PRIMARY KEY, Date DATE, Place CHAR(20), Duration TINYINT, Format VARCHAR(10), Poem_Title VARCHAR(50))" );
System.out.println("Table created");


String data_file = "src/jdbc/poet_data.txt";
File inputFile = new File(data_file);
FileReader inf = new FileReader(inputFile);
BufferedReader inb = new BufferedReader(inf);
System.out.println("Ready to read line");
String line = inb.readLine(); // read a line



String psq2 = "insert into Poet values (?,?,?,?,?)";
PreparedStatement ps2=conn.prepareStatement(psq2);


java.sql.Date when;

while ((line != null)) {
String[] tokens = line.split(","); // split line into ‘,’
System.out.println(tokens[0] + " " + tokens[1] +
" " + tokens[2] + " " + tokens[3] + " " +
tokens[4] + " ");
//Should trim leading/trailing spaces from tokens.
ps2.setString(1, tokens[0]);
when = java.sql.Date.valueOf(tokens[1]);
ps2.setDate(2, when);
ps2.setString(3, tokens[2]);
ps2.setString(4, tokens[3]);
//convert yyyy-mm-dd string to date
ps2.setString(5, tokens[4]);
ps2.execute();
ps2.clearParameters();
line = inb.readLine(); //read next line
}


conn.commit();


 conn.close();
  }
}

最佳答案

很明显你的问题出在tokens[1]字符串的格式上。

您正在尝试从不匹配可接受格式 yyyy-mm-dd 的字符串创建 java.sql.Date 对象

例如，如果您的 String 是这样的:21/12/2002 将抛出一个运行时异常，就像您已经拥有的那样。为了使其正常工作，您必须解析您的字符串，以使其对java.sql.Date.valueOf 方法可读。

例子:

SimpleDateFormat textFormat = new SimpleDateFormat("dd/MM/yyyy");
java.util.Date myDate = textFormat.parse(tokens[1]);
when = new java.sql.Date(myDate.getTime());

作为旁注，parse() 方法抛出 ParseException，因此请确保将代码包含在相关的 try/catch block 或使您的方法 throw 此异常。

希望对你有帮助

关于java - JDBC - 从文本文件加载数据，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/33881404/