本人小白,表示視頻一看就覺(jué)得會(huì)了,做起來(lái)老是出錯(cuò),嚴(yán)重影響學(xué)習(xí)進(jìn)度,為糾正錯(cuò)誤我反復(fù)又把視頻看了很多遍,百度查了說(shuō)是跟主鍵生成方式有關(guān),也按自己能理解的去做了,現(xiàn)在真是不知道錯(cuò)在哪兒了,下面貼出代碼,請(qǐng)大蝦高手前輩幫忙指點(diǎn)指點(diǎn),感激不盡?。?!oralce數(shù)據(jù)庫(kù)建表語(yǔ)句:
CREATE?TABLE?GRADE?(CID?NUMBER(20)?NOT?NULL?CONSTRAINT?PK_CLA?PRIMARY?KEY,
CNAME?VARCHAR2(50),
CDESC?VARCHAR2(200));
CREATE?TABLE?STUDENT?(SID?NUMBER(20)?NOT?NULL?CONSTRAINT?PK_STU?PRIMARY?KEY,
SNAME?VARCHAR2(50),
SAGE?NUMBER(2),
SSEX?VARCHAR2(2),
SPHONENO?VARCHAR2(15),
CID?NUMBER(20)?NOT?NULL);
ALTER?TABLE?STUDENT?ADD?CONSTRAINT?FK_STU?FOREIGN?KEY??(CID)?REFERENCES?GRADE(CID);hibernate運(yùn)行的控制臺(tái)信息:2017-5-11 19:46:17 org.hibernate.tool.hbm2ddl.TableMetadata <init>INFO: HHH000261: Table found: MKADMIN.GRADE2017-5-11 19:46:17 org.hibernate.tool.hbm2ddl.TableMetadata <init>INFO: HHH000037: Columns: [cdesc, cid, cname]2017-5-11 19:46:17 org.hibernate.tool.hbm2ddl.TableMetadata <init>INFO: HHH000108: Foreign keys: []2017-5-11 19:46:17 org.hibernate.tool.hbm2ddl.TableMetadata <init>INFO: HHH000126: Indexes: [pk_cla]2017-5-11 19:46:18 org.hibernate.tool.hbm2ddl.TableMetadata <init>INFO: HHH000261: Table found: MKADMIN.STUDENT2017-5-11 19:46:18 org.hibernate.tool.hbm2ddl.TableMetadata <init>INFO: HHH000037: Columns: [sid, sage, sphoneno, ssex, sname, cid]2017-5-11 19:46:18 org.hibernate.tool.hbm2ddl.TableMetadata <init>INFO: HHH000108: Foreign keys: [fk_stu]2017-5-11 19:46:18 org.hibernate.tool.hbm2ddl.TableMetadata <init>INFO: HHH000126: Indexes: [pk_stu]2017-5-11 19:46:18 org.hibernate.tool.hbm2ddl.SchemaUpdate executeINFO: HHH000232: Schema update completeHibernate:?? ? insert?? ? into? ? ? ? GRADE? ? ? ? (CNAME, CDESC, CID)?? ? values? ? ? ? (?, ?, ?)Hibernate:?? ? update? ? ? ? Student?? ? set? ? ? ? CID=??? ? where? ? ? ? SID=?這里為什么GRADE表是插入,學(xué)生表卻是更新呢?是不是錯(cuò)在這?JUNIT4 的錯(cuò)誤跟蹤信息:org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1 at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:81) at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:73) at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:59) at org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1256) at org.hibernate.persister.collection.OneToManyPersister.recreate(OneToManyPersister.java:183) at org.hibernate.action.internal.CollectionRecreateAction.execute(CollectionRecreateAction.java:58) at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:377) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:369) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:292) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:339) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52) at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1234) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:404) at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101) at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175) at HbmTest.destory(HbmTest.java:31) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:36) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222) at org.junit.runners.ParentRunner.run(ParentRunner.java:300) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)配置文件hibernate.cfg.xml:<?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>
<property?name="javax.persistence.validation.mode">none</property>
<property?name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property?name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
<property?name="hibernate.connection.username">MKADMIN</property>
<property?name="hibernate.connection.password">MK123456</property>
<property?name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property?name="show_sql">true</property>
<property?name="format_sql">true</property>
<property?name="hbm2ddl.auto">update</property>
<property?name="current_session_context_class">thread</property>
<mapping?resource="Grade.hbm.xml"/>
<mapping?resource="Student.hbm.xml"/>
</session-factory>
</hibernate-configuration>映射文件:Grade.hbm.xml<?xml?version="1.0"?encoding="UTF-8"?>
<!DOCTYPE?hibernate-mapping?PUBLIC?
????"-//Hibernate/Hibernate?Mapping?DTD?3.0//EN"
????"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<!--?dynamic-update?列動(dòng)態(tài)更新,那列變化更新那個(gè)?-->
<class?name="po.Grade"?table="GRADE"?dynamic-update="true">
<id?name="cId"?type="java.lang.Integer">
<column?name="CID"?length="20"/>
<generator?class="assigned"/>
</id>
<property?name="cName"?type="java.lang.String">
<column?name="CNAME"?length="50"/>
</property>
<property?name="cDesc"?type="java.lang.String">
<column?name="CDESC"?length="200"/>
</property>
<set?name="students"?table="student">
<key?column="CID"/>
<one-to-many?class="po.Student"/>
</set>
</class>
</hibernate-mapping>映射文件:Student.hbm.xml<?xml?version="1.0"?encoding="UTF-8"?>
<!DOCTYPE?hibernate-mapping?PUBLIC?
????"-//Hibernate/Hibernate?Mapping?DTD?3.0//EN"
????"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<!--?dynamic-update?字段動(dòng)態(tài)更新,那個(gè)變化更新那個(gè)?-->
<class?name="po.Student"?table="Student"?dynamic-update="true">
<id?name="sId"?type="java.lang.Integer">
<column?name="SID"?length="20"/>
<generator?class="assigned"/>
</id>
<property?name="sName"?type="java.lang.String">
<column?name="SNAME"?length="50"/>
</property>
<property?name="sPhoneNo"?type="java.lang.String">
<column?name="SPHONENO"?length="15"/>
</property>
<property?name="sSex"?type="java.lang.String">
<column?name="SSEX"?length="2"/>
</property>
<property?name="sAge"?type="java.lang.Integer">
<column?name="SAGE"?length="2"/>
</property>
</class>
</hibernate-mapping>測(cè)試類代碼:因?yàn)閷?shí)體類主要是屬性和構(gòu)造方法,就不貼了import?java.util.HashSet;
import?java.util.Set;
import?org.hibernate.Session;
import?org.hibernate.SessionFactory;
import?org.hibernate.Transaction;
import?org.hibernate.cfg.Configuration;
import?org.hibernate.service.ServiceRegistry;
import?org.hibernate.service.ServiceRegistryBuilder;
import?org.junit.After;
import?org.junit.Before;
import?org.junit.Test;
import?po.Grade;
import?po.Student;
public?class?HbmTest?{
private?SessionFactory?sf=null;
private?Session?session=null;
private?Transaction?tran=null;
@Before
public?void?init(){
Configuration?cfg=new?Configuration().configure();
ServiceRegistry?sr=new?ServiceRegistryBuilder().applySettings(cfg.getProperties()).buildServiceRegistry();
sf=cfg.buildSessionFactory(sr);
session=sf.getCurrentSession();
tran=session.beginTransaction();
}
@After
public?void?destory(){
tran.commit();
sf.close();
}
@Test
public?void?test(){
Grade?c1=new?Grade(1,"java1班","java軟件開(kāi)發(fā)一班");
Student?s1=new?Student(1,"黃三","07913356566","男",15);
Student?s2=new?Student(2,"王五","07913300000","女",18);
Set<Student>students=new?HashSet<Student>();
students.add(s1);
students.add(s2);
c1.setStudents(students);
session.save(c1);
}
}
添加回答
舉報(bào)
0/150
提交
取消