hibernate ʹÓÃÊý¾Ý¿âmysql ²åÈëÊý¾Ý ÂÒÂëÎÊÌâ
³öÏÖÒÔÏÂÎÊÌâ:Çë´ó¼Ò°ïæ½â¾ö
´ÓÍøÉϲéÕÒÁËһϷ½·¨µ«ÊDz»ÐÐ,
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/hibernate_basemapping?useUnicode=true&characterEncoding=GBK</property>
ÎҵľßÌå²Ù×÷ÈçÏÂ:
дÁËÒ»¸ö²âÊÔ·½·¨:
public void testSaveUser1(){
Session session = null;
Transaction transaction = null;
User1 user = null;
try {
session = HibernateUtils.getSession();
transaction = session.beginTransaction();
user = new User1();
user.setName("ÍúÍú");
user.setPassword("123");
user.setCreateTime(new Date());
user.setExpireTime(new Date());
session.save(user);
transaction.commit();
} catch (Exception e) {
// TODO: handle exception
transaction.rollback();
} finally {
HibernateUtils.closeSession(session);
}
}
³öÏÖÈçϵĴíÎó,²»ÄܲåÈëÖØ¸´,ÒòΪÎÒÉèÖÃÁËΨһÐÔÔ¼Êø,µ«ÊÇÃû³µ³öÏÖÁË????ÂÒÂëÎÊÌâ
Caused by: java.sql.BatchUpdateException: Duplicate entry '?—??—?' for key 2
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1213)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:912)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)<
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
±í
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ÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......
mysql¶¨Ê±±¸·Ý ÔÚwindowsÉÏ
¿ÉÒÔÏÂÔØÒ»¸ö Navicat for MySQL£¬ÀïÃæÓиö¶¨Ê±±¸·Ý¹¦ÄÜ£¬·Ç³£ºÃÓá£
дһ¸öphpµÄ±¸·Ýº¯Êý.È»ºóÀûÓÃwindowsµÄ¼Æ»®ÈÎÎñÖ´Ðб¸·Ý³ÌÐò!
Navicat¡£¡£ÀïÃæ¿ÉÒÔд±¸·Ý¼Æ»®µÈ
ÊDz»ÊÇÓà ......