¹ØÓÚhibernateÌí¼ÓÊý¾Ýµ½mysqlµÄÎÊÌâ
ÎÒÔÚʹÓÃhibernateÌí¼ÓÊý¾ÝµÄʱºò£¬Èç¹ûÊý¾ÝÖÐûÓÐÖÐÎÄ×Ö·û¾ÍûÓÐÎÊÌ⣬Èç¹ûÓÐÖÐÎÄ×Ö·û¾ÍÓÐÎÊÌâ¡£
µ«ÊÇÎÒÊý¾Ý¿âÖÐÓÐ2ÕÅ±í£¬ÎÒÍùµÚÒ»ÕűíÀïÃæÌí¼ÓÖÐÎÄÊý¾Ý¾ÍûÓÐÎÊÌ⣬ÏòµÚ¶þÕűíÀïÃæÌí¼ÓÊý¾ÝµÄʱºò¾Í±¨´íÁË¡£
ÎÒÏÖÔÚ°Ñ´úÂëÌùÉÏÀ´´ó¼Ò°ïÎÒ¿´¿´
Servicelog.hbm.xml´úÂ룺
XML code:
<?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">
<!--
Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
<class name="com.hpxx.hibernate.Servicelog" table="servicelog" catalog="hpxx">
<id name="serId" type="java.lang.Integer">
<column name="serId" />
<generator class="native" />
</id>
<many-to-one name="orderinfo" class="com.hpxx.hibernate.Orderinfo" fetch="select">
<column name="orderId" not-null="true" />
</many-to-one>
<many-to-one name="manager" class="com.hpxx.hibernate.Manager" fetch="select">
<column name="managerId" not-nul
Ïà¹ØÎÊ´ð£º
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
mysqlµÄÖ´ÐÐinsertÊÇ·ñÓзµ»ØÖµ£¿ÏñoracleµÄ·µ»ØÖµÊÇsqlcode£¬
mysqlÓзµ»ØÖµÃ´£¿Âé·³ÄÄλ¸æËßһϡ£
°ï¶¥ MYSQL½¨ÒéÈ¥ÆäËûÊý¾Ý¿â¿ª·¢°æ¿é
mysqlÓзµ»ØÖµÃ´£¿
---
ÎÒÖªµÀmssqlÓУ¬@@error
²»ÖªµÀÓÐûÓÐÀàË ......
±¾ÈËÏëÖªµÀMySqlÔõôÔÚÊý¾Ý°²×°µÄʱºò¾ÍÄÜ×Ô¶¯È¥Éú³ÉһЩĬÈϵÄÓû§ºÍȨÏÞÄØ£¨Óû§£ºClient£¬ÃÜÂ룺12345£©£¿
±ÈÈçÊDz»ÊÇÐèҪд×Ô¶¯°²×°½Å±¾°¢£¿µÈµÈ£¬Ð»Ð»£¡
MySQLµÄ±ê×¼°²×°£¬»òÕ߷ǰ²×°°æ±¾Öв»»á°ïÄã´´½¨ÕâЩ ......