<hibernate-mapping package="itembank.javabean">
<class name="Question" table="question">
<id name="qid" type="integer">
<column name="qid" />
<generator class="native" />
</id>
<property name="qname" type="string">
<column name="qname" length="50" not-null="true" />
</property>
<property name="options" type="string">
<column name="options" length="50" not-null="true" />
</property>
<property name="answer" type="string">
<column name="answer" length="50" not-null="true" />
</property>
<property name="turn" type="integer">
<column name="turn" />
</property>
<many-to-one name="itemBank" class="itembank.javabean.ItemBank"
column="itemBankId" >
</many-to-one>
</class>
</hibernate-mapping>hibernate-mapping package="itembank.javabean">
<class name="ItemBank"
table="itemBank">
<id name="itemBankId" type="integer">
<column name="itemBankId" />
<generator class="native" />
</id>
<list name="itemBankList" cascade="all">
<key column="qid" />
<!-- <list-index column="turn" base="1"/>-->
<index column="turn"/>
<one-to-many class="Question" />
</list>
<property name="itemBankName" type="string">
<column name="itemBankName" length="50" not-null="true" />
</property>
<property name="itembankType" type="integer">
<column name="itembankType" not-null="true" />
</property>
</class>
</hibernate-mapping>package itembank.dao;import java.util.List;
import itembank.javabean.ItemBank;
import org.hibernate.Session;
import org.hibernate.Transaction;
import util.SessionFactoryHolder;public class ExcelDaoImpl implements ExcelDao { public boolean insertExcelToDB(ItemBank itemBank) {
// 将表格数据插入到数据库中
Session session=null;
Transaction tran=null;
try {
session = SessionFactoryHolder.getSession();
System.out.println("session:"+session);
tran=session.beginTransaction();
System.out.println("tran:"+tran);
System.out.println("保存题库前");
session.save(itemBank);
System.out.println("递交题库前");//这一行没有执行!!!
tran.commit();
} catch (Exception e) {
tran.rollback();
return false;
}finally{
session.close();
}
return true;
}
<class name="Question" table="question">
<id name="qid" type="integer">
<column name="qid" />
<generator class="native" />
</id>
<property name="qname" type="string">
<column name="qname" length="50" not-null="true" />
</property>
<property name="options" type="string">
<column name="options" length="50" not-null="true" />
</property>
<property name="answer" type="string">
<column name="answer" length="50" not-null="true" />
</property>
<property name="turn" type="integer">
<column name="turn" />
</property>
<many-to-one name="itemBank" class="itembank.javabean.ItemBank"
column="itemBankId" >
</many-to-one>
</class>
</hibernate-mapping>hibernate-mapping package="itembank.javabean">
<class name="ItemBank"
table="itemBank">
<id name="itemBankId" type="integer">
<column name="itemBankId" />
<generator class="native" />
</id>
<list name="itemBankList" cascade="all">
<key column="qid" />
<!-- <list-index column="turn" base="1"/>-->
<index column="turn"/>
<one-to-many class="Question" />
</list>
<property name="itemBankName" type="string">
<column name="itemBankName" length="50" not-null="true" />
</property>
<property name="itembankType" type="integer">
<column name="itembankType" not-null="true" />
</property>
</class>
</hibernate-mapping>package itembank.dao;import java.util.List;
import itembank.javabean.ItemBank;
import org.hibernate.Session;
import org.hibernate.Transaction;
import util.SessionFactoryHolder;public class ExcelDaoImpl implements ExcelDao { public boolean insertExcelToDB(ItemBank itemBank) {
// 将表格数据插入到数据库中
Session session=null;
Transaction tran=null;
try {
session = SessionFactoryHolder.getSession();
System.out.println("session:"+session);
tran=session.beginTransaction();
System.out.println("tran:"+tran);
System.out.println("保存题库前");
session.save(itemBank);
System.out.println("递交题库前");//这一行没有执行!!!
tran.commit();
} catch (Exception e) {
tran.rollback();
return false;
}finally{
session.close();
}
return true;
}
是这吧如果你想一起存的话发现你好象没"及联"
我也是初学者请指教