scala-第九章-scala操作外部数据

目录

操作文件
操作MySQL

操作文件

package com.imooc.scala.course09

import scala.io.Source

object FileApp {
  def main(args: Array[String]): Unit = {
    val file = Source.fromFile("D:\\scala_test\\src\\com\\imooc\\scala\\hello.txt")(scala.io.Codec.UTF8)

    def readLine(): Unit = {
      for (line <- file.getLines()) {
        println(line)
      }
    }

    //    readLine()

    def readChar(): Unit = {
      for (ele <- file) {
        println(ele)
      }
    }

    //    readChar()

    def readNet(): Unit = {
      val file = Source.fromURI("http://www.baidu.com")
      for(line<-file.getLines()){
        println(line)
      }
    }
    readNet()

  }
}

操作MySQL

package com.imooc.scala.course09

import java.sql.{Connection, DriverManager}

object MySQLApp {
  def main(args: Array[String]): Unit = {
    val url = "jdbc:mysql://localhost:3306/mysql"
    val username = "root"
    val password = ""

    var connection: Connection = null
    try {
      // make the connection
      //      classOf[com.mysql.jdbc.Driver]

      connection = DriverManager.getConnection(url, username, password)

      // create the statement ,and run the select query
      val statement = connection.createStatement()
      val resultSet = statement.executeQuery("select host,user from user")
      while (resultSet.next()) {
        val host = resultSet.getString("host")
        val user = resultSet.getString("user")
        println(s"$host,$user")

      }
    }
    catch {
      case e: Exception => e.printStackTrace()
    }
    finally {
      //free
      if (connection == null) {
        connection.close()
      }
    }

  }
}