UC知道eclipse java 数据库MySQL 连接出错
来源：百度知道 编辑：UC知道 时间：2024/05/26 13:13:56
我在测试一个JDBC的用例时，如下：
package Mypacket;
import java.sql.*;
public class DataConnection {
public static void main(String [] args)
{
String driver="com.MySQL.jdbc.Driver";
String url="jdbc:MySQL://localhost/netfile";
String user="root";
String password="tiger";
try
{
Class.forName(driver);
Connection con=DriverManager.getConnection(url, user, password);
String insert="insert into client(ZH,UPASSWORD,IFPUBLIC) values(?,?,?)";
PreparedStatement perstatement=con.prepareStatement(insert);
String [] zha = { "yinghu","maott","tiger","fen"};
String [] psd = {"123","123","123","123"};
int [] pu={1,1,1,1};
for(int i=0;i<4;i++)
{
perstatement.setString(1,zha[i]);
perstatement.setString(2,psd[i]);
per
package Mypacket;
import java.sql.*;
public class DataConnection {
public static void main(String [] args)
{
String driver="com.MySQL.jdbc.Driver";
String url="jdbc:MySQL://localhost/netfile";
String user="root";
String password="tiger";
try
{
Class.forName(driver);
Connection con=DriverManager.getConnection(url, user, password);
String insert="insert into client(ZH,UPASSWORD,IFPUBLIC) values(?,?,?)";
PreparedStatement perstatement=con.prepareStatement(insert);
String [] zha = { "yinghu","maott","tiger","fen"};
String [] psd = {"123","123","123","123"};
int [] pu={1,1,1,1};
for(int i=0;i<4;i++)
{
perstatement.setString(1,zha[i]);
perstatement.setString(2,psd[i]);
per
错误呢.....
的确应该是com.mysql.jdbc.Driver
明显报的类找不到. 检查mysql的jar文件是否在环境中.
如果上面的正确 String driver="com.MySQL.jdbc.Driver";
确定这个是正确的.
com.MySQL.jdbc.Driver
改成com.mysql.jdbc.Driver 应该就好了
com.MySQL.jdbc.Driver 改成
com.mysql.jdbc.Driver
com.mysql.jdbc.Driver