java操作Mysql数据库简单操作

首先下载Mysql 在安装时编码选择utf-8,然后建立数据库连接类：

1.         String url="jdbc:mysql://localhost:3306/sfq?user=root&password=root&characterEncoding=utf-8";
2.         try {
3.             Class.forName("com.mysql.jdbc.Driver").newInstance();
4.             Connection con = DriverManager.getConnection(url);
5.             PreparedStatement prepareStatement=con.prepareStatement("insert into stu_score(name,sex,score) values('小宋','男',95.5)");
6.             prepareStatement.execute();
7.         } catch (Exception e) {
8.             e.printStackTrace();
9.         }

如果要用到hibernate哪么它的hibernate.cfg.xml配置文件如下

1. <hibernate-configuration>
3.     <session-factory>
4.         <property name="connection.username">root</property>
5.         <property name="connection.url">
6.             jdbc:mysql://127.0.0.1:3306/hbpcp4?characterEncoding=UTF-8
7.         </property>
8.         <property name="dialect">
9.             org.hibernate.dialect.MySQLDialect
10.         </property>
11.         <property name="myeclipse.connection.profile">mysql</property>
12.         <property name="connection.password">root</property>
13.         <property name="connection.driver_class">
14.             com.mysql.jdbc.Driver
15.         </property>
16.         <property name="hibernate.show_sql">true</property>
17.         <mapping resource="com/cqwle/model/Member.hbm.xml" />
18.         <mapping resource="com/cqwle/model/Idcard.hbm.xml" />
19.     </session-factory>
21. </hibernate-configuration>

以上例子是用的utf-8编码所以在连接字符串中加入了characterEncoding=UTF-8 。