Servlet报错Access denied for user ‘root‘@‘localhost‘ (using password: YES)，但mysql在非Servlet下正常

dverlove

已于 2023-10-29 11:22:14 修改

阅读量118

点赞数

分类专栏： java 文章标签： eclipse java tomcat servlet

于 2023-03-09 21:29:09 首次发布

本文链接：https://blog.csdn.net/dverlove/article/details/129431656

版权

java 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

该代码段展示了如何使用Java连接到MySQL数据库，初始版本依赖于config.properties文件存储数据库信息。优化后，数据库凭据直接在代码中硬编码。连接过程涉及Class.forName()方法加载驱动，以及使用DriverManager.getConnection()建立连接。

摘要由CSDN通过智能技术生成

可能使用了config.properties保存、获取数据库信息导致


public class Connecter {
    private static String DBName;
    private static String acc;
    private static String pwd;
    public static Connection connectDB() {
        Connection con = null;
        getProperties();
        //System.out.println(DBName + acc + pwd);
        String url = "jdbc:mysql://localhost:3306/"+DBName+
                "?useSSL=true&&serverTimezone=UTC&characterEncoding=UTF-8";
        
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch(Exception e) {
            System.out.println("DB Driver loading failed");
        }
        
        try {
            con = DriverManager.getConnection(url, acc, pwd);
        }catch(SQLException e) {
            System.out.println(e + "\nDB connection failed");
        }
        
        return con;
    }
    
    public static void getProperties() {
        Properties properties = new Properties();
        File file = new File("./config.properties");
        if (!file.exists()) {
            try {
                file.createNewFile();
                FileWriter write = new FileWriter(file);
                write.write("DBName=shopstore\nacc=root\npwd=admin\n");
                write.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        try {
            InputStream in = new FileInputStream(file);
            properties.load(in);
        } catch (IOException e) {
            e.printStackTrace();
        }

        DBName = properties.getProperty("DBName");
        acc = properties.getProperty("acc");
        pwd = properties.getProperty("pwd");
    }
}

改用以下即可


public class Connecter {
    private static String DBName = "****";
    private static String acc = "***";
    private static String pwd = "***";
    public static Connection connectDB() {
        Connection con = null;
        //System.out.println(DBName + acc + pwd);
        String url = "jdbc:mysql://localhost:3306/"+DBName+
                "?useSSL=true&&serverTimezone=UTC&characterEncoding=UTF-8";
        
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch(Exception e) {
            System.out.println("DB Driver loading failed");
        }
        
        try {
            con = DriverManager.getConnection(url, acc, pwd);
        }catch(SQLException e) {
            System.out.println(e + "\nDB connection failed");
        }
        
        return con;
    }