Hibernate框架(未完待续······)

<!-- 我分别来写MySQL 与 Oracle 的 下面，先写MySQL的-->
<hibernate-configuration>
<!-- 构造数据库的连接工厂，这是Hibernate的核心类 -->
<session-factory> <!-- 这里是简单的数据库连接的基本信息，也可以写在配置文件中，或者利用JNDI来调用数据源 -->
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/example?useUnicode=true&characterEncoding=utf8</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.username">sm</property>
<property name="hibernate.connection.password">1</property> <!-- 在控制台里打印生成的SQL语句 -->
<property name="hibernate.show_sql">true</property>
<!-- 格式化控制台输出的SQL语句，这两条都是方便我们来学习Hibernate框架 -->
<property name="hibernate.format_sql">true</property> <!--
方言：根据指定的方言与数据库打交道，完成SQL的具有语句生成，因为不同的数据库sql语法还是有区别的，
这里相当于告诉Hibernate框架，我们使用的是什么数据库。
MySQL : org.hibernate.dialect.MySQLDialect
Oracle : org.hibernate.dialect.OracleDialect
-->
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> <!-- 管理所有的映射资源文件，这里仅仅配置了User类的配置映射文件，应该将我们的所有的映射配置文件设置到这里，这样我们框架才能找到 -->
<mapping resource="com/ljh/hibernate/pojo/User.hbm.xml"/> </session-factory>
</hibernate-configuration> <!--然后下面这是Orcale的-->
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <!-- Database connection settings -->
<property name="connection.driver_class">oracle.jdbc.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
<property name="connection.username">sm</property>
<property name="connection.password">1</property> <!-- JDBC connection pool (use the built-in) -->
<!-- <property name="connection.pool_size">1</property> --> <!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.Oracle10gDialect</property> <!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property> <!-- Drop and re-create the database schema on startup -->
<property name="format_sql">true</property> <mapping class="cn.sm.entity.Student" /> </session-factory> </hibernate-configuration>

package cn.sm.entity;
//学生实体类
public class Student { private int stuno; private String stuname; private int stuage; private int stuid; private int stuseat; public Student() {
super();
} public Student(String stuname, int stuage, int stuid, int stuseat) {
super();
this.stuname = stuname;
this.stuage = stuage;
this.stuid = stuid;
this.stuseat = stuseat;
} public Student(int stuno, String stuname, int stuage, int stuid, int stuseat) {
super();
this.stuno = stuno;
this.stuname = stuname;
this.stuage = stuage;
this.stuid = stuid;
this.stuseat = stuseat;
} public int getStuid() {
return stuid;
} public void setStuid(int stuid) {
this.stuid = stuid;
} public int getStuseat() {
return stuseat;
} public void setStuseat(int stuseat) {
this.stuseat = stuseat;
} public int getStuno() {
return stuno;
} public void setStuno(int stuno) {
this.stuno = stuno;
} public String getStuname() {
return stuname;
} public void setStuname(String stuname) {
this.stuname = stuname;
} public int getStuage() {
return stuage;
} public void setStuage(int stuage) {
this.stuage = stuage;
} }

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="cn.zhang.entity">
<class name="Student" table="stuinfo">
<id name="stuno" column="stuno">
<!-- 主键生成策略：native:
native:如果后台是Oracle
后台是MySQL，自动应用自增 -->
<generator class="native"/>
</id>
<property name="stuname" type="string" column="stuname"/>
<property name="stuage"/> <property name="stuid" type="int" column="stuid"/>
<property name="stuseat"/>
</class> </hibernate-mapping>

package cn.sm.test;
//新增一条数据
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session; import cn.sm.entity.Student; public class InsertTest { public static void main(String[] args) {
//准备对象
Student student=new Student("云云", 12,112333,2);//Student.hbm.xml已配置编号为自增，所以这里不用添加编号了
//读取大配置文件，获取要连接的数据库信息
Configuration configuration=new Configuration().configure();
//创建SessionFactory
SessionFactory factory = configuration.buildSessionFactory();
//加工session
Session openSession = factory.openSession(); Transaction beginTransaction = openSession.beginTransaction();
openSession.save(student); beginTransaction.commit(); System.out.println("成成成成成功！"); } }

package cn.sm.test;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session; import cn.sm.entity.Student; public class UpdateTest { /**
* @param args
*/
public static void main(String[] args) {
//1.读取大配置文件，获取要连接的数据库信息
Configuration conf=new Configuration().configure();
//2.创建SessionFactory
SessionFactory factory =conf.buildSessionFactory();
//3加工session
Session session = factory.openSession();
Transaction tx=session.beginTransaction();
//获取对象
Student stu =new Student(1,"云云", 12,112333,2);
//更新
session.update(stu);
//提交事务
tx.commit();
System.out.println("更新成成成成成功"); } }

package cn.sm.test;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;import cn.sm.entity.Student;
public class DeleteTest { public static void main(String[] args) {
//1.读取大配置文件，获取要连接的数据库信息
Configuration conf=new Configuration().configure();
//2.创建SessionFactory
SessionFactory factory =conf.buildSessionFactory();
//3.加工session
Session session = factory.openSession(); Transaction tx=session.beginTransaction();
//获取对象
Student stu =new Student();
stu.setStuno(3);//指定要删除的编号
//删除指定
session.delete(stu);
//提交事务
tx.commit();
System.out.println("删除成成成成成功"); }}

package cn.sm.test; import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session; import cn.sm.entity.Student; public class SelectTest { public static void main(String[] args) {
//1.读取大配置文件，获取要连接的数据库信息
Configuration conf=new Configuration().configure();
//2.创建SessionFactory
SessionFactory factory =conf.buildSessionFactory();
//3.打开session
Session session = factory.openSession();
//4.加载数据操作
//如果表中没有你指定的主键列，get()方法的是null
Student student =(Student)session.get(Student.class, 4);
//如果表中没有你指定的主键列，程序运行到student.getStuname()时会抛出异常
//Student student =(Student)session.load(Student.class, 4);
//5.输出数据
System.out.println(student.getStuname());
//6.关闭session
session.close(); } }