java连接MySQL数据库

import java.sql.*;  
public class Demo {  
    public static void main(String[] args){  
       Connection conn = null;  
       Statement statement = null;  
       ResultSet resultSet = null;  
  
       final String PASSWORD = "6855639";  
       final String USER = "root";  
       final String PROTOCOL = "jdbc:mysql://localhost:3306/qsuron";  
       try {  
            Class.forName("com.mysql.jdbc.Driver");  
           conn = DriverManager.getConnection(PROTOCOL,USER,PASSWORD);  
           statement = conn.createStatement();  
           resultSet = statement.executeQuery("select * from account");  
           while(resultSet.next()){  
                System.out.println(resultSet.getString("id"));  
            }  
       } catch (ClassNotFoundException e) {  
          System.out.println("找不到相应的类!");  
      } catch (SQLException e) {  
          System.out.println("连接数据库出错!");  
      } finally{  
          try{  
              if(resultSet != null){  
                   resultSet.close();  
                   resultSet = null;  
                }  
               if(statement != null){  
                   statement.close();  
                    statement = null;  
               }  
                if(conn != null){  
                    conn.close();  
                    conn = null;  
                }  
            } catch(SQLException e){  
                e.printStackTrace();  
            }  
        }  
    }  
}