Question

java 连接 access SQLExcepion:[Microsoft][ODBC Microsoft Access 驱动程序] 字段定义语法错误

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
public class CreateTable {
//网桥JDBC/ODBC驱动程序
private static String DBDRIVER="sun.jdbc.odbc.JdbcOdbcDriver";
//数据库URL
private static String DBURL = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=e:\\SMS.mdb";

public static void main(String[] args) {
Connection con = null;
Statement stmt = null;
String createString = "create table student"+"(ID INTEGER,NAME char(8),grade NUMGER,class char(10))";
try {
Class.forName(DBDRIVER);//加载驱动程序
//建立与数据库的连接
con=DriverManager.getConnection(DBURL);
}
catch (ClassNotFoundException e) {
System.out.println("ClassNotFoundException:" + e.getMessage());
System.exit(1);//终止应用程序
}
catch (SQLException ex) {
System.out.println("SQLException:" + ex.getMessage());
System.exit(1);//终止应用程序
}
try {
stmt=con.createStatement();//创建SQL语句对象
stmt.executeUpdate(createString);//执行SQL语句
System.out.println("在SMS数据库创建表student成功");
}
catch (SQLException ex){
System.out.println("SQLExcepion:" + ex.getMessage());
}
finally {
if (stmt != null) {
try {
stmt.close();//关闭语句
}
catch (SQLException e) {}
}
if (con != null) {
try {
con.close();//关闭与数据库的连接
}
catch (SQLException e) {}
}
}//try/catch/finally块结束
}//main方法结束

}//类CreateTable结束

Answer 1

你的程序没有大问题，只是在创建表时写错了：

String createString = "create table student"+"(ID INTEGER,NAME char(8),grade NUMBER,class char(10))";

“NUMBER”，你写成了“NUMGER”

把这一句改了就可以了。我测试过了。

完整的Java程序：

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
public class CreateTable {
//网桥JDBC/ODBC驱动程序
private static String DBDRIVER="sun.jdbc.odbc.JdbcOdbcDriver";
//数据库URL
private static String DBURL = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=e:\\SMS.mdb";

public static void main(String[] args) {
Connection con = null;
Statement stmt = null;
String createString = "create table student"+"(ID INTEGER,NAME char(8),grade NUMBER,class char(10))";
try {
Class.forName(DBDRIVER);//加载驱动程序
//建立与数据库的连接
con=DriverManager.getConnection(DBURL);
}
catch (ClassNotFoundException e) {
System.out.println("ClassNotFoundException:" + e.getMessage());
System.exit(1);//终止应用程序
}
catch (SQLException ex) {
System.out.println("SQLException:" + ex.getMessage());
System.exit(1);//终止应用程序
}
try {
stmt=con.createStatement();//创建SQL语句对象
stmt.executeUpdate(createString);//执行SQL语句
System.out.println("在SMS数据库创建表student成功");
}
catch (SQLException ex){
System.out.println("SQLExcepion:" + ex.getMessage());
}
finally {
if (stmt != null) {
try {
stmt.close();//关闭语句
}
catch (SQLException e) {}
}
if (con != null) {
try {
con.close();//关闭与数据库的连接
}
catch (SQLException e) {}
}
}//try/catch/finally块结束
}//main方法结束

}

运行测试：

在SMS数据库创建表student成功

Answer 2

楼上正解