初学者问题——关于jdbc数据库连接
import java.net.URL;
import java.sql.*;
public class Test{
public static void main(String[] args)
{
int r,c;
String url="jdbc:odbc:MS Access Database";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url,"zq","zq");
Statement stmt=con.createStatement();
//可以运行到这
ResultSet rs=stmt.executeQuery("SELECT * FROM param1");
//这一步无法运行到,为什么?数据库名叫lp,两个表分别是param1和matrix
c=rs.getInt(2);
r=rs.getInt(1);
rs=stmt.executeQuery("SELECT * FROM matrix");
while(rs.next())
{
for(int i=4;i<=c+3;i++)
{
System.out.println(rs.getInt(i-3));
}
}
}catch(Exception e){};
}
}