代码如下.
package studyB;import java.sql.*;
import java.sql.Blob;public class B12_HelloDB{ public static void main(String[] args){
int i;
try
{
//
String STR1 = "insert into TESTTABLE1( TESTNO , NAME , KANA ) values( 105,`2`,`234` )";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //.newInstance();
//
String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=C:\\java\\db1.mdb";
//
Connection conn = DriverManager.getConnection(url);
//
Statement stmtNew=conn.createStatement();
System.out.println("connect OK!");
//
//ResultSet rs = null;
// stmtNew.executeUpdate(STR1); //这句总是报错.
conn.commit(); //
// commit();
//stmtNew.execute( sql );
//
//rs.close();
stmtNew.close();
conn.close();
}
catch (Exception e)
{
e.printStackTrace();
} }
} 信息如下.java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at studyB.B12_HelloDB.main(B12_HelloDB.java:33)
package studyB;import java.sql.*;
import java.sql.Blob;public class B12_HelloDB{ public static void main(String[] args){
int i;
try
{
//
String STR1 = "insert into TESTTABLE1( TESTNO , NAME , KANA ) values( 105,`2`,`234` )";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //.newInstance();
//
String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=C:\\java\\db1.mdb";
//
Connection conn = DriverManager.getConnection(url);
//
Statement stmtNew=conn.createStatement();
System.out.println("connect OK!");
//
//ResultSet rs = null;
// stmtNew.executeUpdate(STR1); //这句总是报错.
conn.commit(); //
// commit();
//stmtNew.execute( sql );
//
//rs.close();
stmtNew.close();
conn.close();
}
catch (Exception e)
{
e.printStackTrace();
} }
} 信息如下.java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at studyB.B12_HelloDB.main(B12_HelloDB.java:33)
NAME 和KANA 都是字符型的吗?
那也应该是'2','234' 而不是`2`,`234`