本文介绍如何使用Ruby语言连接并操作MySQL数据库，包括错误处理及数据模型的创建过程。
如果报can't load such file--mysql 就安装gem install
mysql
require
"mysql"
dbh =
Mysql.real_connect("localhost","root","hulei2009","test",3306)
sql = "select *
from scores"
res =
dbh.query(sql)
dbh.close
class Score
def
initialize(id=0,subject,score,student_name,explain)
@id = id
@subject
@score =
score
@student_name =
student_name
@explain =
explain
end
attr_accessor
:id,:subject,:score,:student_name,:explain
end
def
createSQL(score)
"INSERT INTO
VALUES (
'#{score.subject}', 34,
)"
end
#注意alues 中值的符号引用
def
saveScore(dbh,score)
sql
=createSQL(score);
dbh.query(sql)
if(dbh.affected_rows==1)
puts "xues
#{score.student_name} have been saved!"
end
end
peter =
Score.new("shuxue",'83',"peter","dsgfsd")
begin
dbh =
Mysql.real_connect("localhost","root","hulei2009","test")
saveScore(dbh,peter)
rescue
Mysql::Error =>e
puts "Error
Number:#{e.errno}"
puts "Error
Message:#{e.error}"
puts "Error
State:#{e.sqlstate}"
ensure
dbh.close
end
扫一扫
200
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
