package jdbc;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class Liu {

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

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 conn=DriverManager.getConnection(URL, USER, PASSWORD);

? ? Statement stmt=conn.createStatement();

? ?ResultSet rs= stmt.executeQuery("select user_name,age form imooc_goddess");

? ?while(rs.next()) {

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

? ?}

}

}