mysql asyn_mysql asyn 实战

创建configuration时，发现URLParser找不到，于是只能使用配置文件来，当然使用配置文件比使用URL初始化还要直观些

def configurationWithPassword = new Configuration(

host = "localhost",

port = 3306,

username = "root",

password = Some("123"),

database = Some("test")

)

Configuration文件本身是case class，它的code是

case class Configuration(username: String,

host: String = "localhost",

port: Int = 5432,

password: Option[String] = None,

database: Option[String] = None,

charset: Charset = Configuration.DefaultCharset,

maximumMessageSize: Int = 16777216,

allocator: AbstractByteBufAllocator = PooledByteBufAllocator.DEFAULT,

connectTimeout: Duration = 5.seconds,

testTimeout: Duration = 5.seconds

)

这让我想到了slick，slick我连配置文件都搞不出来。总觉得slick的设计有些反人类。

对于单连接

def sinConnection: MySQLConnection ={

val configuration: Configuration =configurationWithPassword

newMySQLConnection(configuration)

}

对于线程池连接

def poolConnection: ConnectionPool[MySQLConnection] = {

val configuration: Configuration = configurationPool

val factory = new MySQLConnectionFactory(configuration)

val pool = new ConnectionPool[MySQLConnection](factory, PoolConfiguration.Default)

pool

}

ResultSet并不是java.sql.resultSet而是作者自己创建的新类型

trait ResultSet extends IndexSeq[RowData]

而rowData则表示一行数据，也是一个顺序表

trait RowData extends IndexedSeq[Any]

这样，ResultSet就像是个二维表了