关于jdbc连接数据库出现No suitable driver found for com.mysql.cj.jdbc.Driver报错
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Date;
import com.mysql.cj.xdevapi.Result;
public class nothing{
private static final String DBDRIVER="com.mysql.cj.jdbc.Driver";
private static final String DBURL="jdbc:mysql://127.0.0.1:3306/test";
private static final String USER="root";
private static final String PASSWORD="111111";
public static void main(String ags[])throws Exception
{
Class.forName(DBDRIVER);
Connection conn=DriverManager.getConnection(DBDRIVER, USER, PASSWORD);
String sql="SELECT goods_id,goods_name,goods_price FROM tdb_goods Order by goods_id";
PreparedStatement a=conn.prepareStatement(sql);
ResultSet rs=a.executeQuery();
while (rs.next())
{
int good_id=rs.getInt(1);
String goods_name=rs.getString(2);
String goods_cate=rs.getString(3);
String brand_name=rs.getString(4);
int goods_price=rs.getShort(5);
int is_show =rs.getInt(6);
int is_saleoff=rs.getInt(7);
System.out.println("序号:"+good_id+" 名称："+goods_name+" 种类："+goods_cate+" 品牌："+brand_name+" 价格："
+brand_name);
conn.close();
}
}
}
代码如上。
出现的错误是
Exception in thread "main" java.sql.SQLException: No suitable driver found for com.mysql.cj.jdbc.Driver
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.yootk.demo.nothing.main(nothing.java:16)
有没有大神解答呀~
最新回答
半顆糖甜入心
2024-05-02 02:34:20
需要引用的JDBC驱动jar包或依赖配置没有加载成功、比如
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --><dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>6.0.6</version></dependency>
如果本地没有jar就从打开链接去下载mysql-connector-java 6
https://mvnrepository.com/artifact/mysql/mysql-connector-java/6.0.6
http://central.maven.org/maven2/mysql/mysql-connector-java/6.0.6/mysql-connector-java-6.0.6.jar
回眸丶时光冷
2024-05-02 00:06:50
DBURL去哪了？
热门标签
