PATH="$PATH":/usr/local/mysql/bin

mysql -u root -p

package com.mysql;

import java.sql.*;

import com.mysql.jdbc.Statement;


public class Driver {
	public static void main(String[] args){ 
	  try {
		   
		    Class.forName("com.mysql.jdbc.Driver");
		    System.out.println("测试通过");
		    java.sql.Connection conn;
		    conn=DriverManager.getConnection("jdbc:mysql://localhost/test","root","*****");
		    System.out.println("conn-------------"+conn);
		    Statement stmt=(Statement) conn.createStatement();
		    ResultSet rs=stmt.executeQuery("select * from mytable");
		    while(rs.next()){                          
		    String name=rs.getString("name");
		     String sex=rs.getString("sex");
		     System.out.println("name------"+name+"--------sex-"+sex);
		    }
		   } catch (ClassNotFoundException e) {
		    // TODO Auto-generated catch block
		    e.printStackTrace();
		   } catch (SQLException e) {
		    // TODO Auto-generated catch block
		    e.printStackTrace();
		   }
}
	}

 conn=DriverManager.getConnection("jdbc:mysql://localhost/test","root","*****");