首先下载Mysql 在安装时编码选择utf-8,然后建立数据库连接类:
- String url="jdbc:mysql://localhost:3306/sfq?user=root&password=root&characterEncoding=utf-8";
- try {
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- Connection con = DriverManager.getConnection(url);
- PreparedStatement prepareStatement=con.prepareStatement("insert into stu_score(name,sex,score) values('小宋','男',95.5)");
- prepareStatement.execute();
- } catch (Exception e) {
- e.printStackTrace();
- }
如果要用到hibernate哪么它的hibernate.cfg.xml配置文件如下
- <hibernate-configuration>
- <session-factory>
- <property name="connection.username">root</property>
- <property name="connection.url">
- jdbc:mysql://127.0.0.1:3306/hbpcp4?characterEncoding=UTF-8
- </property>
- <property name="dialect">
- org.hibernate.dialect.MySQLDialect
- </property>
- <property name="myeclipse.connection.profile">mysql</property>
- <property name="connection.password">root</property>
- <property name="connection.driver_class">
- com.mysql.jdbc.Driver
- </property>
- <property name="hibernate.show_sql">true</property>
- <mapping resource="com/cqwle/model/Member.hbm.xml" />
- <mapping resource="com/cqwle/model/Idcard.hbm.xml" />
- </session-factory>
- </hibernate-configuration>
以上例子是用的utf-8编码所以在连接字符串中加入了characterEncoding=UTF-8 。