java mysql eclipse_eclipse java 连接mysql

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.*;

import com.mysql.jdbc.Connection;

public class MySql {

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

try {

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

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

String url="jdbc:mysql://localhost:3306/mysql";

String username="root";

String password="root";

Connection con=(Connection) DriverManager.getConnection(url,username,password);

if(con!=null) {

System.out.println("成功");

}

Statement stmt;

ResultSet res;

stmt=con.createStatement();

res=stmt.executeQuery("select *from user");

while(res.next()){

String name=res.getString("User");

System.out.println(name);

}

res.close();

}

}