使用java访问MySQL数据库

   try
        {
          String url="jdbc:mysql://localhost/test";
          String user="root";
          String pwd="123456";
          
          //加载驱动，这一句也可写为：Class.forName("com.mysql.jdbc.Driver");
         Class.forName("com.mysql.jdbc.Driver").newInstance();
          //建立到MySQL的连接
           Connection conn = DriverManager.getConnection(url,user, pwd);
        
          //执行SQL语句
           Statement stmt = conn.createStatement();//创建语句对象，用以执行sql语言
          ResultSet rs = stmt.executeQuery("select * from data1036");
         
           //处理结果集
          while (rs.next())
          {
            String name = rs.getString("stageStory");
            System.out.println(name);
          }
          
          rs.close();//关闭数据库
          conn.close();
        }
        catch (Exception ex)
        {
          System.out.println("Error : " + ex.toString());
        }