Using SCALIKEJDBC config (src\main\resources)
# MySQL (Dev) dev.db.default.driver= "com.mysql.jdbc.Driver" dev.db.default.url= "jdbc:mysql:// 192.168.1.151:3306/scalalearning?useunicode=true&characterencoding=utf8 "dev.db.default.user=" root " Dev.db.default.password= "12345" # Connection Pool settingsdev.db.default.poolinitialsize= 5dev.db.default.poolmaxsize=7dev.db.default.poolconnectiontimeoutmillis=1000dev.db.default.poolvalidationquery = "Select 1 as One" # MySQL (prod) prod.db.default.driver= "Com.mysql.jdbc.Driver" prod.db.default.url= "jdbc:mysql:// 192.168.1.151:3306/scalalearning?useunicode=true&characterencoding=utf8 "prod.db.default.user=" root " Prod.db.default.password= "12345" # Connection Pool settingsprod.db.default.poolinitialsize= 5prod.db.default.poolmaxsize=7prod.db.default.poolconnectiontimeoutmillis= 1000prod.db.default.poolvalidationquery= "Select 1 as one"
Import Scalikejdbc._import scalikejdbc.config._object Configdemo { def main (args:array[string]): Unit = { Dbswithenv ("Dev"). Setupall () Case class User (Id:int, name:string, Age:int) val allcolumns = (rs:wrappedresult Set) = = User ( id = rs.int ("id"), name = rs.string ("name"), Age = Rs.int ("Age")) Val Users:list[user] = DB ReadOnly {implicit session = = SQL ("SELECT * from User Limit"). Map (Allcolumns). List.apply () } for (User <-users) { println (user.id + "," + User.Name + "," + User.age) } dbswithenv ("Dev"). CloseAll () }}
SCALIKEJDBC Study notes (2)