JAVA連接MySQL

 
 
String driver="com.mysql.jdbc.Driver";
  String url="jdbc:mysql://localhost:3306/test";
    
  try {   
   Class.forName(driver);
   Connection conn=DriverManager.getConnection(url,"root","3.14");
   PreparedStatement pstmt=conn.prepareStatement("select * from person");
   ResultSet rs=pstmt.executeQuery();
   while(rs.next()){
    System.out.println(rs.getString("username"));
   }
   rs.close();
   pstmt.close();
   conn.close();
  } catch (ClassNotFoundException e) {   
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  }