Access insert问题

Question

stmt.executeQuery("insert into test(strName) values('ddd')");
该为stmt.execute("insert into test(strName) values('ddd')");
executeQuery是查找，改为execute

Answer 1

import java.sql.*;public class aa
{
public static void main(String arg[])
{
String url =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E:\\java\\db1.mdb";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
stmt.executeQuery("insert into test(strName) values('ddd')");
System.out.println("OK"); stmt.close();
conn.close();
} catch (Exception e)
{
System.out.println(e.getMessage());
}
}
}import java.sql.*;public class aa
{
public static void main(String arg[])
{
String url =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E:\\java\\db1.mdb";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
//---------------------------------------------------------------------------------
stmt.execute("insert into test(strName) values('ddd')");
//-----------------------------------------------------------------------------------
System.out.println("OK"); stmt.close();
conn.close();
} catch (Exception e)
{
System.out.println(e.getMessage());
}
}
}