grails配置mysql

把mysql的jdbc驱动放到lib目录下。

grails-app\conf\DataSource.groovy：

dataSource {
//	pooled = true
//	driverClassName = "org.hsqldb.jdbcDriver"
//	username = "sa"
//	password = ""
	pooled = false
	driverClassName = "com.mysql.jdbc.Driver"
	username = "root"
	password = "888888"
}
hibernate {
    cache.use_second_level_cache=true
    cache.use_query_cache=true
    cache.provider_class='com.opensymphony.oscache.hibernate.OSCacheProvider'
}
// environment specific settings
environments {
	development {
		dataSource {
			dbCreate = "create-drop" // one of 'create', 'create-drop','update'
//			url = "jdbc:hsqldb:mem:devDB"
			url = "jdbc:mysql://localhost:3306/contact_dev?useUnicode=true&characterEncoding=UTF-8"
		}
	}
	test {
		dataSource {
			dbCreate = "update"
//			url = "jdbc:hsqldb:mem:testDb"
			url = "jdbc:mysql://localhost:3306/contact_test?useUnicode=true&characterEncoding=UTF-8"
		}
	}
	production {
		dataSource {
			dbCreate = "update"
//			url = "jdbc:hsqldb:file:prodDb;shutdown=true"
			url = "jdbc:mysql://localhost:3306/contact_prod?useUnicode=true&characterEncoding=UTF-8"
		}
	}
}

 

 

让Grails + MySQL正确处理中文
其实Grails用MySQL数据源处理中文还是很方便的，基本只要注意2点：

在xxxDataSource.groovy里，mysql url注意要加上参数，例如：jdbc:mysql://server?useUnicode=true&characterEncoding=UTF-8
MySQL数据库要用UTF-8编码

create database book_dev character set utf8
另外，gsp里要注意：
< meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″ />
默认应该就是这样

 

 

1 在my.cf文件的[mysqld]段设置：
default-character-set=utf8

2 单独设置某个数据库：
alter database testdb character set utf8;

3.查看mysql支持的编码：
show character set;

 

评论

1 楼 topbox163 2012-12-17  

JAR包是：mysql-connector-java-5.1.10.jar 放在工程下的 lib 目录下

按你的配置，就是显示不了数据，请问是什么原因？

dataSource {
    pooled = false
    driverClassName = "com.mysql.jdbc.Driver" //将原来的HSQLDB的驱动名改成MySql的,一定要注册变量的大小写啊,我开始就是将driverClassName的大小写搞错了,结果找了半天错误,哈.
    username = "root"  //MySql的用户名
    password = "root"  //相应的密码
}
hibernate {
    cache.use_second_level_cache = true
    cache.use_query_cache = true
    cache.provider_class = 'net.sf.ehcache.hibernate.EhCacheProvider'
}
// environment specific settings
environments {
    development {
        dataSource {
            dbCreate = "update" // one of 'create', 'create-drop','update'
            url = "jdbc:mysql://localhost:3306/clothes_grails?useUnicode=true&amp;characterEncoding=UTF8 " //将URL改成MySql的,与Java的一样
        }
    }
    test {
        dataSource {
            dbCreate = "update"
           url = "jdbc:mysql://localhost:3306/clothes_grails?useUnicode=true&amp;characterEncoding=UTF8 " //将URL改成MySql的,与Java的一样
        }
    }
    production {
        dataSource {
            dbCreate = "update"
            url = "jdbc:mysql://localhost:3306/clothes_grails?useUnicode=true&amp;characterEncoding=UTF8 " //将URL改成MySql的,与Java的一样
        }
    }
}