关于#Java,数据库,tomact#的问题，如何解决？

Question

package com.laboratory.db; 

import java.sql.Connection;//导入Connection接口
import java.sql.DriverManager;//导入DriverManager类
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;

/**
 * 数据库管理类
 * 
 *
 */
public class DBManager {
    public static final String DEFAULT_DRIVER_NAME = " com.mysql.cj.jdbc.Driver";
    public static final String DEFAULT_DB_URL = " jdbc:mysql://localhost:1433/laboratory?useUnicode=true&characterEncoding=UTF-8&userSSL=false&serverTimezone=GMT%2B8";


    public static String DB_URL = null;

    public static Properties prop = null;

    public Connection getConnection() {

        Connection coon = null;
        try {
            Class.forName(DEFAULT_DRIVER_NAME);
            coon = DriverManager.getConnection(DEFAULT_DB_URL,"sa","8888");
        } catch (Exception e) {
            e.printStackTrace();
        }
        return coon;
    }

    public static void main(String[] args) {
        DBManager manager = new DBManager();
        manager.getConnection();
    }

    public boolean login(String username, String pwd) {

        Connection coon = getConnection();
        ResultSet rs = null;
        PreparedStatement pstmt = null;
        try {
            pstmt = coon
                    .prepareStatement("select * from admin where name='"
                            + username + "' and pwd='" + pwd + "'");

            rs = pstmt.executeQuery();
            while (rs.next()) {
                return true;
            }

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (pstmt != null)
                    pstmt.close();
                if (coon != null)
                    coon.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        return false;
    }

}

这是运行的代码，主要是想进http://127.0.0.1:8080/laboratory/login.jsp这里的，但代码运行的时候没有run on serve
,并且浏览器输入这个网址打不开 ，但是浏览器打得开http://localhost:8080, 现在不知道怎么办辽，数据库也已经连上了ldf和mdf两个文件， 进入SQLserve管理器查看TCP/IP端口也是1433

点击Java Application运行结果如下：

java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:520)
at java.base/java.lang.Class.forName0(Native Method)
at java.base/java.lang.Class.forName(Class.java:375)
at com.laboratory.db.DBManager.getConnection(DBManager.java:31)
at com.laboratory.db.DBManager.main(DBManager.java:41)

Answer 1

你是sqlServer的数据库为啥用mysql的驱动路径，而且你也没引用mysql的驱动jar包吧