表test只有一个字段
sno 文本类型------------------
import java.sql.*;
public class Dbaccess{public static void main(String args[]) throws Exception{ Connection conn;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String dburl ="jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=D:\\mydb.mdb"; conn=DriverManager.getConnection(dburl);
Statement stmt;
ResultSet rs;
stmt=conn.createStatement();
String query="insert into test values('god')";
//System.out.println(query);
rs=stmt.executeUpdate(query); rs.close(); stmt.close(); conn.close();}}一个很简单的对access操作程序,但编译时出错:
Dbaccess.java:18: incompatible types
found : int
required: java.sql.ResultSet
rs=stmt.executeUpdate(query);
sno 文本类型------------------
import java.sql.*;
public class Dbaccess{public static void main(String args[]) throws Exception{ Connection conn;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String dburl ="jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=D:\\mydb.mdb"; conn=DriverManager.getConnection(dburl);
Statement stmt;
ResultSet rs;
stmt=conn.createStatement();
String query="insert into test values('god')";
//System.out.println(query);
rs=stmt.executeUpdate(query); rs.close(); stmt.close(); conn.close();}}一个很简单的对access操作程序,但编译时出错:
Dbaccess.java:18: incompatible types
found : int
required: java.sql.ResultSet
rs=stmt.executeUpdate(query);
不要返回值
stmt.executeUpdate(query);
System.out.print("插入成功");试下看
public class Dbaccess{public static void main(String args[]) throws Exception{ Connection conn;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String dburl ="jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=D:\\mydb.mdb"; conn=DriverManager.getConnection(dburl);
Statement stmt;
ResultSet rs;
stmt=conn.createStatement();
String query="insert into test values('god')";
stmt.executeUpdate(query);
System.out.print("插入成功" rs.close(); stmt.close(); conn.close();}}
看看能不能通过...
rs.close();
^
1 error
什么意思