class?Score
????????def?initialize(id=0,subject,socre,student_name,explain)
????????????????@id?=id
????????????????@subject?=subject
????????????????@score?=score
????????????????@student_name?=student_name
????????????????@explain=explain
????????end
????????attr_accessor?:id,:subject,:score,:student_name,:explain
end
require?"mysql"
def?createSQL(score)
????????"insert?into?scores(subject,score,student_name,`explain`)"+
????????"values('#{score.subject}',#{score.score},'#{score.student_name}','#{score.explain}')"
end
def?saveScore(dbh,score)
????????sql=createSQL(score)
????????dbh.query(sql)
????????if(dbh.affected_rows==1)
????????????????puts?"學生?#{score.student_name}?的成績已經被放入數據庫"
????????end
end
peter=Score.new("數學",83,"Peter","")#提示的位置
libei=Score.new("數學",100,"李貝","")
liubuyi=Score.new("數學",58,"劉不一","因為遲到,題沒做完")
begin
????????dbh=Mysql.real_connect("localhost","root","root","db_student")
????????saveScore(dbh,peter)
????????#saveScore(dbh,libei)
????????#saveScore(dbh,liubuyi)
????????#
????????#sql="update?scores?set?score?=#{86}?where?student_name='#{"peter"}'"
????????#dbh.query(sql)
????????#if(dbh.affected_rows==1)
????????#???????puts?"學生#{"李貝"}的成績刪除成功"
????????#end
rescue??Mysql::Error=>e
????????puts?"Error?Number:?#{e.errno}"
????????puts?"Error?Number:?#{e.errno}"
????????puts?"Error?Message:?#{e.error}"
????????puts?"Error?State:?#{e.sqlstate}"?if?e.respond_to?("sqlstate")
ensure
????????dbh.close
end這是運行ruby文件后的提示求解如何修改
添加回答
舉報
0/150
提交
取消