Question

用java向access数据库中读取和写入数据。读取时正常 但是写入时出现了错误：

Connection conn=null;
try {
Class.forName("com.hxtt.sql.access.AccessDriver").newInstance();
String url = "jdbc:Access:///d:\\leo.accdb";
conn=DriverManager.getConnection(url,"","");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from Table1");
while (rs.next()) {
System.out.println("HI " + rs.getString(2));

}
System.out.println(conn);

String sql = "Insert into user(NAME,STU,FAMILY) values('dd','dd','dd');";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.executeUpdate();
pstmt.close();

} catch (Exception e) {
e.printStackTrace();
}finally {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}

错误如下：
java.sql.SQLException: Failed to find table user in database

Answer 1

你操作数据库的用户下么有“user”这个表。
java.sql.SQLException: Failed to find table user in database
或者是你的系统里面么有这个表

注意看你的表名。

Answer 2

表、或表名出错 。。。。。。。。。。