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"));

   }

}

}