史诗级基础之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 stubClass.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"));}}}