java.sql.SQLException:找不到合适的驱动程序

前端之家收集整理的这篇文章主要介绍了java.sql.SQLException:找不到合适的驱动程序前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
我试图使用下面的DbQuery. java类执行简单查询,该类使用DbConnector从DriverManager获取连接.

注意:

>我已经在我的网站上加入了“@R_404_198@-connector-java-5.1.25-bin.jar”
classpath via:export
CLASSPATH = $CLASSPATH:/home/me/ocpjp/chapter-10/@R_404_198@-connector-java-5.1.25/@R_404_198@-connector-java-5.1.25-bin.jar
>我能够使用“@R_404_198@ -uroot -ptcial”连接到@R_404_198@
地址簿“,如果重要的话.
>还尝试使用’-cp’运行
争论无济于事.
>我能够让我的#3 DbConnect.java类说“已建立数据库连接”.
>#4 DbQueryWorking.java没有问题,并提供预期的输出.

你能帮我理解这里的问题吗?

1)DbConnector.java

  1. package com.me.ocpjp.chapter10;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.sqlException;
  6.  
  7. public class DbConnector{
  8. public static Connection connectToDb() throws sqlException{
  9. String url = "jdbc:@R_404_198@//localhost:3306/";
  10. String db = "addressBook";
  11. String username = "root";
  12. String password = "tcial";
  13. return DriverManager.getConnection(url+db,username,password);
  14. }
  15.  
  16. }

2)DbQuery.java

  1. package com.me.ocpjp.chapter10;
  2.  
  3. import java.sql.Connection ;
  4. import java.sql.Statement ;
  5. import java.sql.ResultSet ;
  6. import java.sql.sqlException ;
  7. import com.me.ocpjp.chapter10.DbConnector;
  8.  
  9. public class DbQuery{
  10. public static void main(String[] args){
  11. try(Connection connection = DbConnector.connectToDb();
  12. Statement statement = connection.createStatement();
  13. ResultSet resultSet = statement.executeQuery("select * from contact")){
  14. System.out.println("ID \tfName \tlName \temail \t\tphoneNo");
  15. while(resultSet.next()){
  16. System.out.println(resultSet.getInt("id") + "\t"
  17. + resultSet.getString("firstName") + "\t"
  18. + resultSet.getString("lastName") + "\t"
  19. + resultSet.getString("email") + "\t"
  20. + resultSet.getString("phoneNo") );
  21. }
  22.  
  23. }catch(sqlException sqle){
  24. sqle.printStackTrace();
  25. System.exit(-1);
  26. }
  27.  
  28. }
  29. }

3)DbConnect.java

  1. package com.me.ocpjp.chapter10;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5.  
  6.  
  7.  
  8. public class DbConnect{
  9. public static void main(String[] args){
  10.  
  11. String url = "jdbc:@R_404_198@://localhost:3306/";
  12. String database = "addressBook";
  13. String userName = "root";
  14. String password = "tcial";
  15.  
  16. try(Connection connection = DriverManager.getConnection(url+database,userName,password)){
  17. System.out.println("Database connection established");
  18. }catch(Exception e){
  19. System.out.println("Database connectioni NOT established");
  20. e.printStackTrace();
  21. }
  22.  
  23. }
  24.  
  25. }

4)DbQueryWorking.java

  1. package com.me.ocpjp.chapter10;
  2.  
  3. import java.sql.Connection ;
  4. import java.sql.Statement ;
  5. import java.sql.ResultSet ;
  6. import java.sql.sqlException ;
  7. import java.sql.DriverManager;
  8.  
  9. public class DbQuery{
  10. public static void main(String[] args){
  11. String url = "jdbc:@R_404_198@://localhost:3306/";
  12. String database = "addressBook";
  13. String userName = "root";
  14. String password = "tcial";
  15. try(Connection connection = DriverManager.getConnection(url + database,password);
  16. Statement statement = connection.createStatement();
  17. ResultSet resultSet = statement.executeQuery("select * from contact")){
  18. System.out.println("ID \tfName \tlName \temail \t\tphoneNo");
  19. while(resultSet.next()){
  20. System.out.println(resultSet.getInt("id") + "\t"
  21. + resultSet.getString("firstName") + "\t"
  22. + resultSet.getString("lastName") + "\t"
  23. + resultSet.getString("email") + "\t"
  24. + resultSet.getString("phoneNo") );
  25. }
  26.  
  27. }catch(sqlException sqle){
  28. sqle.printStackTrace();
  29. System.exit(-1);
  30. }
  31.  
  32. }
  33. }

解决方法

它看起来像DbConnector.java中的URL是错误的.结肠丢失了.网址必须是:
  1. jdbc:@R_404_198@://localhost:3306/

并不是

  1. jdbc:@R_404_198@//localhost:3306/

猜你在找的Java相关文章