package com.jdbc;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class Jdbc {

 private static final String URL ="jdbc:mysql://127.0.0.1:3306/lee";

 private static final String USER="root";

 private static final String PASSWORD ="123";

    public static void main (String[ ]  args) throws Exception    {

    //1.加载驱动程序

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

//2.获得数据库的连接

Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);

//3.通过数据库的连接操作数据库，实现增删改查；

Statement stat = conn.createStatement();

ResultSet rs = stat.executeQuery("select  user_name,age  from immoc_goddess");

while (rs.next()) {

System.out.println(rs.getString("user_name")+","+rs.getString("age"));

}

    }

}

异常：

Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

at java.net.URLClassLoader$1.run(URLClassLoader.java:200)

at java.security.AccessController.doPrivileged(Native Method)

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

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

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

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

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)

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

at java.lang.Class.forName(Class.java:169)

at com.jdbc.Jdbc.main(Jdbc.java:17)