使用hibernate框架对mysql数据库进行增删改查
1、创建一个java工程,并且创建一个数据库hibernate
2、创建一个lib文件夹,拷贝jar包,并且build path(圈起的三个是测试jar包,编辑器有的话可以不考)
3、创建hibernate配置文件hibernate.cfg.xml,这里创建在根目录下
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.username">root</property>
<property name="connection.password">newstar</property>
<property name="connection.driver_class">
com.mysql.jdbc.Driver
</property>
<property name="connection.url">
<![CDATA[jdbc:mysql://localhost:3306/hibernate?useUnicode=true&characterEncoding=utf8]]>
</property>
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
<property name="hbm2ddl.auto">update</property>
<property name="show_sql">true</property>
<mapping resource="com/itstar/domain/Person.hbm.xml" />
</session-factory>
</hibernate-configuration>
4、创建持久化类
package com.itstar.domain;
import java.io.Serializable;
public class Person implements Serializable {
private Long pid;
private String name;
private String password;
public Long getPid() {
return pid;
}
public void setPid(Long pid) {
this.pid = pid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
5、创建映射文Person.hbm.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.itstar.domain.Person" table="person">
<id name="pid" column="pid" length="5">
<generator class="increment"></generator>
</id>
<property name="name" length="20" type="java.lang.String"></property>
<property name="password" length="20" type="java.lang.String"></property>
</class>
</hibernate-mapping>
6、创建测试类开始测试
package com.itstar.test
import org.hibernate.Session
import org.hibernate.SessionFactory
import org.hibernate.Transaction
import org.hibernate.cfg.Configuration
import org.junit.Test
import com.itstar.domain.Person
public class TestHibernateCRUD {
//保存用户
@Test
public void testSavePerson(){
Configuration configuration = new Configuration()
//在跟根目录,不需要添加参数
configuration.configure()
SessionFactory sessionFactory = configuration.buildSessionFactory()
Session session = sessionFactory.openSession()
Transaction transaction = session.beginTransaction()
Person person = new Person()
person.setPid(1L)
person.setName("张三")
person.setPassword("123456")
session.save(person)
transaction.commit()
session.close()
}
//查询用户
@Test
public void testGetPerson(){
Configuration configuration = new Configuration()
configuration.configure()
SessionFactory sessionFactory = configuration.buildSessionFactory()
Session session = sessionFactory.openSession()
Person person = (Person)session.get(Person.class, 2L)
System.out.println(person.getName())
session.close()
}
//更改用户
@Test
public void testChangePerson(){
Configuration configuration = new Configuration()
configuration.configure()
SessionFactory sessionFactory = configuration.buildSessionFactory()
Session session = sessionFactory.openSession()
Transaction transaction = session.beginTransaction()
Person person = (Person)session.get(Person.class, 2L)
person.setName("李四")
session.update(person)
transaction.commit()
session.close()
}
//删除用户
@Test
public void testDeletePerson(){
Configuration configuration = new Configuration()
configuration.configure()
SessionFactory sessionFactory = configuration.buildSessionFactory()
Session session = sessionFactory.openSession()
Transaction transaction = session.beginTransaction()
Person person = (Person)session.get(Person.class, 3L)
session.delete(person)
transaction.commit()
session.close()
}
}