??????????rails1.9.3?????mysql2?????????????????mysql?????????о?????????????????????????windows????????????????????????????????mysql?????????????????￡?
????1.????ж???mysql2??
????gemuninstallmysql2
????2.???mysqlruby?????????????????????????????????
????geminstallmysql--platform=ruby--'--with-mysql-lib="[mysql???·??]lib"--with-mysql-include="[mysql???·??]include"--with-mysql-dir="[mysql???·??]"'
????3.???database.yml?????
????adapter??mysql2?????mysql
????4.????????gemfile??
??????????????У?
????#gemmysql2
?????????
????gemmysql
????5.?????????????mysql??????????????mysql????????railsTest??database?????run????????????
MySqlTest.rb:
classMysqlTest
#Codehere
require"mysql"
deftestMysql
dbc=Mysql.real_connect('localhost'??'root'??'fm0vrwc'??'mysql')
res=dbc.query('select*fromuser')
puts"TestMysql...."
whilerow=res.fetch_rowdo
puts"#{row[0]}"
end
end
defcreateTable
dbc=Mysql.real_connect('localhost'??'root'??'fm0vrwc'??'railsTest')
dbc.query("droptableifexistsusers")
dbc.query("createtableusers(idint??namechar(20)??ageint)")
dbc.query("insertintousersvalues(1??'Tom'??30)")
dbc.query("insertintousersvalues(2??'Art'??50)")
dbc.query("insertintousersvalues(3??'Kevin'??40)")
printf"CreateTable........"
printf"%drowswereinserted "??dbc.affected_rows
res=dbc.query("SELECT*FROMusers")
puts"===SelectData=== "
whilerow=res.fetch_rowdo
printf"%d??%s??%d "??row[0]??row[1]??row[2]
end
puts"================== "
puts"Serverversion:"+dbc.get_server_info
rescueMysql::Error=>e
puts"Errorcode:#{e.errno}"
puts"Errormessage:#{e.error}"
puts"ErrorSQLSTATE:#{e.sqlstate}"ife.respond_to?("sqlstate")
ensure
puts"CloseConnection......."
dbc.closeifdbc
end
(MysqlTest.new).testMysql
(MysqlTest.new).createTable
end