java.sql.SQLException: [Microsoft][ODBC Visual FoxPro Driver]Syntax error.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)
at exceltodbfjavabdx.DBF.executeUpdate(DBF.java:46)
at exceltodbfjavabdx.Excel.ExcelTodbf(Excel.java:76)
at exceltodbfjavabdx.Main.main(Main.java:31)
生成成功(总时间:1 秒)
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)
at exceltodbfjavabdx.DBF.executeUpdate(DBF.java:46)
at exceltodbfjavabdx.Excel.ExcelTodbf(Excel.java:76)
at exceltodbfjavabdx.Main.main(Main.java:31)
生成成功(总时间:1 秒)
at exceltodbfjavabdx.Excel.ExcelTodbf(Excel.java:76)sql语句语法错误,看看你的代码
a是dbf数据库的文件名.
public void ExcelTodbf (String dbfPath, String dbfFileName)
{
DBF dbf = new DBF (dbfPath, dbfFileName);
for(int i=0; i<iRows; i++)
{
String tmp = "";
for(int j=0; j<iColumns; j++)
{
Cell cell = sht.getCell(j, i);//按行读取单元格内容。
String strFormat = getCellValue (cell);
if(j<=iColumns) strFormat +=",";
tmp += strFormat;
}
String cmd = "INSERT INTO " + dbfFileName +" VALUES" + "(" + tmp + ")";
dbf.executeUpdate(cmd);
}
dbf.close();
}
这样写"INSERT INTO "+dbfFileName+" values('"+tmp+"')";
values('value','value')
insert into语句中:'字符',1,'日期' 是上述这样格式的吗?还有如果是[空值]是否就一定用''这个符号代替?请帮我看看上面我的INSERT INTO语句是否正确。。谢谢。