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ū)動(dòng)程序

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

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

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

//3.通過(guò)數(shù)據(jù)庫(kù)的連接操作數(shù)據(jù)庫(kù)，實(shí)現(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"));

}

}

}