Hibernate connection MySQL

1 Downloads hibernate-3.6.0 final.zip to any directory, unzip to get hibernate directory

2 download Slf4j-1.7.13.zip to any directory and get slf4j-1.7.13 after decompression

3 Creating a student table in the test library

Msql-localhost-u root–p

Use test

CREATE TABLE student (no char, name varchar (), PrimaryKey (no));

4 Creating a Java Project named Hibernatedemo

5 Adding a Package

Add all packages in the Hibernate\jar

Add Slf4j-nop-1.7.13.jar in slf4j-1.7.13

Add a MySQL driver Mysql-connector-java-5.1.38-bin.jar

6 adding two configuration files and two classes

Hibernate.cfg.xml

Student.java

Student.hbm.xml

Test.java

(1) Add Hibernate.cfg.xml in the SRC directory under Add directory

[Java]View PlainCopy 

2. <! DOCTYPE hibernate-configuration Public
4. "-//hibernate/hibernate Configuration DTD 3.0//en"
6. "HTTP://HIBERNATE.SOURCEFORGE.NET/HIBERNATE-CONFIGURATION-3.0.DTD" >
10. <session-factory>
12. < whether a real SQL statement is displayed when the program executes!--
14. <property name="Show_sql" >true</property>
16. <!--uses the corresponding "dialect" of SQL, here is the "dialect" of Oracle11--
18. <property name="dialect" >org.hibernate.dialect.mysqlinnodbdialect
20. </property>
22. Driver--> of <!--connected Database
24. <property name="Connection.driver_class" >
26. Com.mysql.jdbc.Driver
28. </property>
30. <!--database connection url-->
32. <property name="Connection.url" >
34. Jdbc:mysql://localhost:3306/test
36. </property>
38. <!--user name--
40. <property name="Connection.username" >root</property>
42. <!--password--
44. <property name="Connection.password" >123456</property>
46. <mapping resource="Student.hbm.xml"/>
48. </session-factory>

(2) Add Student.java to the COM.ABC package in the SRC directory

[Java]View PlainCopy 

2. Package com.abc;
6. Public class Student {
8. private String NO;
10. private String name;
14. Public String Getno () {
16. return NO;
18. }
20. public void Setno (String NO) {
22. this.no = NO;
24. }
26. Public String GetName () {
28. return name;
30. }
32. public void SetName (String name) {
34. this.name = name;
36. }
38. }

(3) Add Student.hbm.xml in src directory

[Java]View PlainCopy 

2. <?xml version="1.0" encoding="Utf-8"?>
4. <! DOCTYPE hibernate-mapping
6. Public "-//hibernate/hibernate Mapping DTD 3.0//en"
8. "HTTP://HIBERNATE.SOURCEFORGE.NET/HIBERNATE-MAPPING-3.0.DTD" >
10. package="COM.ABC" >
12. <class Name="Student" table="Student" >
14. <id name="NO" >
16. <generator class="Assigned"/>
18. </id>
20. <property name="name" column="name" type="java.lang.String"/>
22. </class>

(4) Test.java

[Java]View PlainCopy 

2. Package com.abc;
6. Import org.hibernate.*;
8. Import org.hibernate.cfg.*;
12. Public class Test {
14. public static void Main (string[] args) {
16. try {
18. //Get a Sessionfactory object through the configuration
20. Sessionfactory SF = new Configuration (). Configure (). Buildsessionfactory ();
22. //Open a session
24. Session session = Sf.opensession ();
26. //Start a transaction
28. Transaction tx = Session.begintransaction ();
30. //Create a Student object
32. Student stu = new Student ();
34. //Save the Student object to the database using the Save () method of the session
36. Stu.setno ("2016003");
38. Stu.setname ("Zhang San");
40. Session.save (Stu);
42. //Commit a transaction
44. Tx.commit ();
46. //Close Session
48. Session.close ();
50. } catch (Exception e) {
52. E.printstacktrace ();
54. }
56. }
58. }

7 Verification

(1) Run the Test.java, the result is

Hibernate:insert into Student (name, NO) VALUES (?,?)

(2) querying data from MySQL

Hibernate connection MySQL