No suitable driver

package com.imooc.jdbc.demo2;

import java.sql.Connection;

import java.sql.Date;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import org.junit.Test;

import com.imooc.jdbc.utils.JDBCutils;

import com.mchange.v2.c3p0.ComboPooledDataSource;

/**

 * 连接池的测试类

 * 

 * @author Justxin

 *

 */

public class DateDemo1 {

@Test

public void demo2() {

// 创建连接池

Connection conn = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

try {

ComboPooledDataSource dataSource = new ComboPooledDataSource();

conn = dataSource.getConnection();

String sql = "SELECT * FROM course";

pstmt = conn.prepareStatement(sql);

rs = pstmt.executeQuery();

while (rs.next()) {

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

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

String category = rs.getString("category");

String desp = rs.getString("desp");

Date createTime = rs.getDate("createTime");

System.out.println(id + " " + name + " " + category + " " + desp + " " + createTime + " ");

}

} catch (Exception e) {

e.printStackTrace();

} finally {

JDBCutils.release(rs, pstmt, conn);

}

}

}

<?xml version="1.0" encoding="UTF-8"?>

<c3p0-config>

<default-config>

<property name="driverClass">com.mysql.cj.jdbc.Driver</property>

<property name="jdbcUrl">jdbc:mysql://localhost:3306/jdbctest?serverTimezone=UTC&characterEncoding=utf-8</property>

<property name="user">root</property>

<property name="password">X@angS@erSheng</property>

</default-config>

</c3p0-config>