mysqlasyn,mysqlasyn实战

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

def configurationWithPassword &＃61; newConfiguration(

host&＃61; "localhost",

port&＃61; 3306,

username&＃61; "root",

password&＃61; Some("123"),

database&＃61; Some("test")

)

Configuration文件本身是case class&＃xff0c;它的code是

case classConfiguration(username: String,

host: String&＃61; "localhost",

port: Int&＃61; 5432,

password: Option[String]&＃61;None,

database: Option[String]&＃61;None,

charset: Charset&＃61;Configuration.DefaultCharset,

maximumMessageSize: Int&＃61; 16777216,

allocator: AbstractByteBufAllocator&＃61;PooledByteBufAllocator.DEFAULT,

connectTimeout: Duration&＃61; 5.seconds,

testTimeout: Duration&＃61; 5.seconds

)

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

对于单连接

def sinConnection: MySQLConnection &＃61;{

val configuration: Configuration&＃61;configurationWithPasswordnewMySQLConnection(configuration)

}

对于线程池连接

def poolConnection: ConnectionPool[MySQLConnection] &＃61;{

val configuration: Configuration&＃61;configurationPool

val factory&＃61; newMySQLConnectionFactory(configuration)

val pool&＃61; newConnectionPool[MySQLConnection](factory, PoolConfiguration.Default)

pool

}

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

trait ResultSet extends IndexSeq[RowData]

而rowData则表示一行数据&＃xff0c;也是一个顺序表

trait RowData extends IndexedSeq[Any]

这样&＃xff0c;ResultSet就像是个二维表了

原文&＃xff1a;http://www.cnblogs.com/xinsheng/p/4336066.html