CREATE TABLE goods(

  id INT PRIMARY KEY AUTO_INCREMENT,

  name VARCHAR(20) NOT NULL,

  price FLOAT NOT NULL,

  desp VARCHAR(30) NOT NULL

);

INSERT  goods(name,price,desp) VALUES('手机', 2000.0, '黑色，存储容量32G'),

('冰箱', 1500.0,'银色，对开门'),

('洗衣机', 3000.0,'滚筒'),

('空调', 4000,'变频空调');

package jdbc;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import org.junit.jupiter.api.Test;

import com.mysql.jdbc.Driver;

public class Demo1 {

@Test

public void test1() {

try {

DriverManager.registerDriver(new Driver());

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

String sql="SELECT * FROM user.student";

Statement stmt=conn.createStatement();

ResultSet set=stmt.executeQuery(sql);

while(set.next()){

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

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

System.out.println(id+" "+name);

}

set.close();

stmt.close();

conn.close();

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

Class not found jdbc.Demo1

java.lang.ClassNotFoundException: jdbc.Demo1

at java.net.URLClassLoader.findClass(URLClassLoader.java:382)

at java.lang.ClassLoader.loadClass(ClassLoader.java:424)

at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)

at java.lang.ClassLoader.loadClass(ClassLoader.java:357)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.loadClass(RemoteTestRunner.java:773)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.loadClasses(RemoteTestRunner.java:502)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:525)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:763)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:463)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:209)