使用scalikejdbc操作MySQL数据库
关于scalikejdbc:
一、在IDEA中导入scalikejdbc的依赖
二、在resources下添加文件:
在里面编辑:
三、在数据库下创建一张user的表:
四、首先是插入10条数据:
DBs.setupAll()
val person:List[user] = List (
user(1,"simayi",54),
user(2,"zhugeliang",56),
user(3,"caocao",68),
user(4,"liubei",66),
user(5,"sunquan",53),
user(6,"zhanyun",45),
user(7,"lvbu",55),
user(8,"yuanshao",69),
user(9,"zhouyu",45),
user(10,"machao",57)
)
val insert = DB.localTx{implicit session => {
for (x<-person){
SQL("insert into user values(?,?,?)").bind(x.id,x.name,x.age).update().apply()
}
}
五、查询所有数据:
val memberIDs = DB readOnly{implicit session =>{
sql"select * from user ".map(rs=>user(rs.int("id"),rs.string("name"),rs.int("age"))).list.apply()
}
}
六、将ID=8的age加10:
val update = DB.autoCommit{implicit session =>{
SQL("update user set age = age + 10 where id = ?").bind("8").update().apply()
}
}
去虚拟机的数据库上看看:
七、写在后面的:
别忘了定义类 user