请教连接数据库问题:连接access和sql server 2000失败的问题!!!
建立好相应数据库后,也设置好了odbc数据源,但是执行java时都显示为:
java.sql.SQLException: No suitable driver
我连接access的代码如下:
package myaccess;
import java.sql.*;
public class AccessDemo {
public static void main(String[] args)throws Exception{
String url = "jdbc.odbc.FaqsAccess";
String query,subject,answer;
Connection conn;
Statement statement;
ResultSet resultSet = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
conn = DriverManager.getConnection(url,"","");
statement = conn.createStatement();
query = "select count(*) as rowCount from faq";
resultSet = statement.executeQuery(query);
resultSet.next();
if(resultSet.getInt("rowCount")==0){
for(int i = 1;i<11;++i){
String sql = "insert into faq values("+i+",'问题"+i+"','答案"+i+"')";
statement.executeUpdate(sql);
}
}
query = "select * from faq";
resultSet = statement.executeQuery(query);
while(resultSet.next()){
subject = resultSet.getString("subject");
answer = resultSet.getString("answer");
System.out.print("问题内容 = "+subject);
System.out.print(",答案内容 = "+answer);
}
resultSet.close();
statement.close();
conn.close();
}
}