.. include:: ../services/rds.rst


在Java运行环境中使用独享MySQL
===============================

.. code-block:: java

    String URL = "jdbc:mysql://主库地址:端口/数据库";
    String USER = "用户名";
    String PASSWORD = "密码";

    //1.加载驱动程序
    Class.forName("com.mysql.jdbc.Driver");
    //2. 获得数据库连接
    Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
    //3.操作数据库，实现增删改查
    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("SELECT user_name, age FROM imooc_goddess");
    //如果有数据，rs.next()返回true
    while(rs.next()){
        System.out.println(rs.getString("user_name")+" 年龄："+rs.getInt("age"));
    }