个人中心
gpt4 book ai didi

Java MySQL : ClassNotFoundException -> Could not find driver

转载 作者：行者123 更新时间：2023-11-30 09:48:31 25 4
gpt4 key购买 nike

<分区>

Possible Duplicate:
ClassNotFoundException com.mysql.jdbc.Driver

我已将 mysql-connector-java-5.1.16-bin.jar 包含到我的 Eclipse 库中，此代码基于我在网上找到的教程，因为我还没有之前在 Java 中使用过 MySQL。不幸的是，我看不到我在哪里使用 acutual mysql-connector-java-5.1.16-bin.jar 并且控制台打印 Could not find driver. 意思是 抛出 ClassNotFoundException。您是否看到了我没有看到的(可能很明显的)问题？

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;
import java.sql.Timestamp;

public class MysqlConnector {

    private static MysqlConnector instance = null;
    private static Connection conn = null;

    private static String dbHost = "localhost";
    private static String dbPort = "3306";
    private static String database = "sample";
    private static String dbUser = "root";
    private static String dbPassword = "";

    public MysqlConnector() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://" + dbHost + ":"
                    + dbPort + "/" + database + "?" + "user=" + dbUser + "&"
                    + "password=" + dbPassword);
        } catch (ClassNotFoundException e) {
            System.out.println("Could not find driver."); //TODO LOGGER
        } catch (SQLException e) {
            System.out.println("Could not connect to database."); //TODO LOGGER
        }
    }

    public static MysqlConnector getInstance()
    {
        if(instance == null)
            instance = new MysqlConnector();
        return instance;
    }

    public boolean validateApiKey(String apikey)
    {
        if(conn != null)
        {
            Statement query;
            try {
                query = conn.createStatement();

                String sql = "SELECT startdate, expiration, active " + "FROM apikeys "
                        + "WHERE apikey = '" + apikey +"'";
                ResultSet result = query.executeQuery(sql);

                if(result.getFetchSize()>0 && result.getInt("active")==1){
                    Date now = new Date();
                    Date startdate = result.getDate("startdate");
                    Date expirationdate = result.getDate("expiration");
                    if(now.before(expirationdate) && now.after(startdate)){
                        return true;
                    } else {
                        return false;
                    }
                } else {
                    return true;
                }
            } catch (SQLException e) {
                e.printStackTrace();
                return false;
            }
        }
        return false;
    }

}

25 4 0
文章推荐： javascript - Unbreak my code - 如何在 javascript 的另一个函数中使用函数名作为参数
文章推荐： java - 每个子类都有表的 Hibernate 鉴别器列
文章推荐： java - Selenium 无法点击
文章推荐： java - 存储大量小文件 : archive vs. 文件系统
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com