annotion 连接orcale

不念不忘少年蓝@ 2022-04-03 07:10 220阅读 0赞

package ctl.annotion.teacher;  
import org.hibernate.Session;  
import org.hibernate.SessionFactory;  
import org.hibernate.cfg.AnnotationConfiguration;  
public class OrcaleTeacherTestSessionFactory \{  
public static void main(String\[\] args) \{  
Teacher t = new Teacher();  
t.setName("ctl");  
t.setTitle("Ich liebe dich");  
SessionFactory sf = new AnnotationConfiguration().configure("Orcalehibernate.cfg.xml").buildSessionFactory();  
Session session = sf.openSession();  
session.beginTransaction();  
session.save(t);  
session.getTransaction().commit();  
session.close();  
sf.close();  
\}

package ctl.annotion.teacher;  
import javax.persistence.Column;  
import javax.persistence.Entity;//注意是javax.persistence  
import javax.persistence.GeneratedValue;  
import javax.persistence.GenerationType;  
import javax.persistence.Id;  
@Entity  
public class Teacher \{  
private int id;  
private String name;  
private String title;  
@Id//@Id在哪那个字段即为主键  
@GeneratedValue(strategy = GenerationType.AUTO) 在mysql中可以实现从1自增但是在orcale中虽然实现了自增但是不是从1开始行  
public int getId() \{  
return id;  
\}  
public void setId(int id) \{  
this.id = id;  
\}  
@Column  
public String getName() \{  
return name;  
\}  
public void setName(String name) \{  
this.name = name;  
\}  
@Column  
public String getTitle() \{  
return title;  
\}  
public void setTitle(String title) \{  
this.title = title;  
\}  
\}

<?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="hbm2ddl.auto">update</property>  
<property name="dialect">  
org.hibernate.dialect.Oracle9Dialect  
</property>  
<property name="connection.url">  
jdbc:oracle:thin:@localhost:1521:orcl  
</property>  
<property name="connection.username">scott</property>  
<property name="connection.password">Admin518</property>  
<property name="connection.driver\_class">  
oracle.jdbc.driver.OracleDriver  
</property>  
<property name="myeclipse.connection.profile">  
oracle.jdbc.driver.OracleDriver  
</property>  
<property name="format\_sql">true</property>  
<property name="show\_sql">true</property><mapping resource="ctl/hibernate/db/OrcaleStudent.hbm.xml" />  
<mapping class="ctl.annotion.teacher.Teacher"/>  
</session-factory>  
  
  
</hibernate-configuration>