package com.imooc.db;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class DBUtil {

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

private static final String USER="root";

private static final String PASSWORD="195723";

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

//1.加載驅(qū)動程序

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

//2.獲得數(shù)據(jù)庫的連接

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

//3.通過數(shù)據(jù)庫的連接操作數(shù)據(jù)庫，實現(xiàn)增刪改查

Statement stmt=conn.createStatement();

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

while(rs.next()) {

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

}

}

}