史诗级基础之JDBC

package com.soong.jdbctest;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class DBConnect {
	private static final String URL = "jdbc:mysql://127.0.0.1:3306/CnPHP";
	private static final String USER = "root";
	private static final String PASSWORD = "123456";

	public static void main(String[] args) throws Exception{
		// TODO Auto-generated method stub
		Class.forName("com.mysql.jdbc.Driver");
		Connection connection = DriverManager.getConnection(URL,USER,PASSWORD);
		Statement statement = connection.createStatement();
		ResultSet set = statement.executeQuery("select name from student");
		while(set.next()){
			System.out.println(set.getString("name"));
		}
	}

}