代码如下：我这段代码应该不能实现向数据库中插入100个不同随机数的功能，麻烦高手看下。数据库很简单，shop.mdb里面trade表，里面是ID和buyer这两列，分别是long和文本String型的。数据源也建立了。
import java.util.*;
import java.sql.*;
public class IntoData {
public static void main(String[] args) {
String url="jdbc:odbc:shop";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException e){
System.err.print("ERROR:");
System.err.print(e.getMessage());
}
try{
for(int i=1;i<101;i++){
Random random =new Random();
int r = 0;
while(true){
r = random.nextInt(57) + 65;
if(r>70&&r<122||r==0)continue;
break;
}
char a = (char)r;
}
Connection connection =DriverManager.getConnection(url);
Statement stmt =connection.createStatement( );
stmt.executeUpdate("UPDATE trade SET buyer='a' WHERE id='i'");
String query="SELECT * FROM trade";
ResultSet rs=stmt.executeQuery(query);
System.out.println("id:"+" "+"buyer");
while(rs.next()){
Long r1=rs.getLong("id");
String r2=rs.getString("buyer");
System.out.println(r1+" "+r2);
}
rs.close();
stmt.close();
connection.close();
}catch(SQLException ex){
ex.printStackTrace();
}
}
}
编译没有问题，执行的时候报错：
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 不能打开数据库 '(未知的)'。应用程序可能无法识别该数据库，或文件可能损坏。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at IntoData.main(IntoData.java:28)
Process completed.