老师，这个是没找到数据库还是什么呢

首页课程实战体系课手记专栏慕课教程

老师，这个是没找到数据库还是什么呢

来源：2-1 JDBC的入门

qq_慕莱坞4316410

2019-12-17 10:35:44

package com.icoom.JDBC;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import org.junit.jupiter.api.Test;

public class JAVAJDBC {

@Test

public void demo01(){

try {

//创建JDBC

Class.forName("com.mysql.jdbc.driver");

//连接数据库

Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc","root","root");

//执行SQL语句

/*1.建立SQL语句*/

String sql="SELECT*FROM urse";

Statement state= conn.createStatement();

/*2.执行SQL语句*/

ResultSet set= state.executeQuery(sql);

while(set.next()){

int uid=set.getInt("uid");

String uname=set.getString("uname");

String upassword=set.getString("upassword");

int uage=set.getInt("uage");

String uemil=set.getString("uemil");

System.out.println(uid+">>>"+uname+">>>"+upassword+">>>"+uage+">>>"+uemil);

}

//释放资源

conn.close();

state.close();

set.close();

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

java.lang.ClassNotFoundException: com.mysql.jdbc.driver

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at com.icoom.JDBC.JAVAJDBC.demo01(JAVAJDBC.java:15)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:675)

at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:125)

at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:132)

at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:124)

at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:74)

at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)

at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:104)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:62)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:43)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:35)

at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)

at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)

at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:202)