Ìâ¿â

C£®·µ»Ø·ÖÊý×îµÍµÄ5¸öѧÉú D£®·µ»Ø·ÖÊý×îµÍµÄ6¸öѧÉú 38¡¢

ÔÚHibernateµÄHQL²éѯÖУ¬ÏÂÁÐ˵·¨²»ÕýÈ·µÄÊÇ£¨ £©¡£

A£®HQL×Ӿ䱾ÉíµÄ´óСдûÓвîÒ죬µ«ÀàÃûºÍÊôÐÔÃû±ØÐëÇø·Ö´óСд B£®HQLÖ§³Öwhere×Ó¾ä C£®HQLÖ§³Öas×Ó¾ä

D£®where¡¢as¹Ø¼ü×ÖÇø·Ö´óСд 39¡¢

ÔÚHibernateµÄHQL²éѯÖУ¬ÓÐÊý¾Ý¿â±í£¨dept£©¶ÔÓ¦µÄ¶ÔÏóÃû³ÆΪDept£¬ÏÂÁÐ

HQLд·¨ÕýÈ·µÄÓУ¨ £©¡£¡¾Ñ¡Á½Ïî¡¿

A£®String hql = \; B£®String hql = \C£®String hql = \D£®String hql = \; 40¡¢

¹ØÓÚHQL²éѯ£¬ÏÂÁÐ˵·¨ÕýÈ·µÄÓУ¨ £©¡£¡¾Ñ¡Á½Ïî¡¿

A£®HQL²éѯµÄselect×Ó¾äÖбØÐëÇø·Ö´óСд B£®HQLÖ§³Ö²»Í³¼Æº¯Êý

C£®HQLÖ§³Ö½ö²éѯ¶ÔÏóµÄij¼¸¸öÊôÐÔ£¬²éѯ½á¹û±£´æÓÚObjectÊý×éÖÐ D£®HQL²éѯΪ¹Ù·½ÍƼöµÄ²éѯ·½Ê½ 41¡¢

ÔÚHibernateÖУ¬ÏÂÃæ´úÂëʵÏÖÁ˶ÔBookʵÌåÖÐtitleÊôÐÔµÄÄ£ºý²éѯ£¬ÔòÏÂÁÐ

Ñ¡ÏîÖÐ˵·¨ÕýÈ·µÄÊÇ£¨ £©¡£

Session session=this.getSession();

String hql = \from Book model where model.title like ?; \ //£¨1£© Query query = session.createQuery(hql); //£¨2£© query.setString(0, \%java%\)£» //£¨3£©(ÖÐÎÄ·ÖºÅ) List list = query.list(); //£¨4£© A. µÚ£¨1£©ÐУ¬BookÓëmodelÖ®¼ä±ØÐëÓÐas¹Ø¼ü×Ö

B. µÚ£¨2£©ÐУ¬Ã»ÓдíÎó

C. µÚ£¨3£©ÐÐÓ¦¸ÃΪ£ºquery.setString(0, \java\); D. µÚ£¨4£©ÐÐÓ¦¸ÃΪ£ºList llist = query.executeQuery(); 42¡¢

¹ØÓÚHQLÓëSQL£¬ÏÂÁÐ˵·¨ÕýÈ·µÄÓУ¨£©¡£¡¾Ñ¡Á½Ïî¡¿

A£®HQLÓëSQLûÓжàÉÙ²î±ð

B£®HQLÃæÏò¶ÔÏ󣬶øSQL²Ù×ݹØϵÊý¾Ý¿â

C£®ÔÚHQLÓëSQLÖУ¬¶¼°üº¬select,insert,update,deleteÓï¾ä£¨¶ººÅ»¹ÊǶٺţ© D£®HQL½öÓÃÓÚ²éѯÊý¾Ý£¬²»Ö§³Öinsert,updateºÍdeleteÓï¾ä£¨¶ÙºÅ»¹ÊǶººÅ£© 43¡¢

ÔÚHQLÓïÑÔÖУ¬Query¶ÔÏóÌرðÌṩÁË£¨ £©·½·¨£¬ÓÃÓÚ»ñµÃÒ»¸öΨһÐÐΨһÁÐ

µÄ¶ÔÏó¡£ A£®list B£®uniqueResult C£®result D£®queryResult 44¡¢

¹ØÓÚHQL²éѯ£¬ÏÂÁÐ˵·¨´íÎóµÄÊÇ£¨ £©¡£

A£®HQL²éѯ¿ÉÒÔÖ´ÐÐT-SQLÓï¾ä£¬Ö´ÐÐËٶȸü¿ì

B£®HQLÖ§³ÖÖ»²éѯ¶ÔÏóµÄij¼¸¸öÊôÐÔ£¬²éѯ½á¹û½«±£´æÔÚÒ»¸öObjectÊý×éÖÐ C£®HQLÖ§³Öͳ¼Æº¯Êý

D£®HQLÓï¾ä¿ÉÒÔʵÏÖÀàËÆPreparedStatementµÄЧ¹û 45¡¢

ÔÚJAVAÖУ¬¹ØÓÚÊôÐÔÎļþ£¬ÏÂÁÐÑ¡Ïî˵·¨ÕýÈ·µÄÊÇ£¨£©¡£

A£®ÊôÐÔÎļþÒÔÃû³ÆºÍÖµµÄÐÎʽ±£´æÐÅÏ¢ B£®ÊôÐÔÎļþ²»ÄÜдÖÐÎÄ£¨£¿£¿£¿£© C£®ÊôÐÔÎļþÖÐÄܱ£´æ¸÷ÖÖÊý¾ÝÀàÐ͵ÄÐÅÏ¢ D£®ÊôÐÔÎļþµÄÎļþÀ©Õ¹ÃûÊÇ.xml 46¡¢

ÔÚHibernateÖУ¬ÏÂÁйØÓÚHQL²ÎÊý°ó¶¨µÄд·¨ÕýÈ·µÄÓУ¨ £©¡£¡¾Ñ¡Á½Ïî¡¿

String hql =\Dept as model where model.deptName =? and model.createDate =? \; A£®µÚÒ»¸ö²ÎÊýµÄλÖÃΪ0 B£®µÚÒ»¸ö²ÎÊýµÄλÖÃΪ1

C£®ÉèÖòÎÊýµÄ·½·¨Îª£ºsetEntity() D£®ÉèÖòÎÊýµÄ·½·¨Îª£ºsetParameter() 47¡¢

ÔÚHibernateÖУ¬ÏÂÃæµÄ³ÌÐò´úÂë¶ÔCustomerµÄnameÊôÐÔ½øÐÐÁËÁ½´ÎÐ޸ģº

tx = session.beginTransaction();

Customer customer=(Customer)session.load(Customer.class, new Long(1)); customer.setName(\Jack\); customer.setName(\Mike\); tx.commit();

ÔòÖ´ÐÐÒÔÉϳÌÐòʱ£¬HibernateÐèÒªÏòÊý¾Ý¿âÌá½»( )ÌõupdateÓï¾ä¡£ A£®0 B£®1 C£®2 D£®3 48¡¢

¹ØÓÚCriteria²éѯ£¬ÏÂÁÐ˵·¨ÕýÈ·µÄÓУ¨ £©¡£¡¾Ñ¡ÈýÏî¡¿

A£®Criteria²éѯͨ¹ýÃæÏò¶ÔÏ󻯵ÄÉè¼Æ½«Êý¾Ý²éѯÌõ¼þ·â×°³ÉÒ»¸ö¶ÔÏó B£®Criteria²éѯ¿É¶ÁÐÔÇ¿

C£®Criteria²éѯ·ûºÏJava³ÌÐòÔ±µÄ±à³ÌÏ°¹ß D£®Criteria²éѯûÓÐHQL²éѯÈÝÒ×Àí½â 49¡¢

Criteria²éѯͨ¹ýÃæÏò¶ÔÏ󻯵ÄÉè¼Æ½«Êý¾Ý²éѯÌõ¼þ·âװΪһ¸ö£¨ £©¡£

A£®¶ÔÏó B£®ÐòÁÐ C£®Àà D£®HQLÓï¾ä

50¡¢ ÔÚHibernateÖУ¬Criteria±¾ÉíÖ»ÊDzéѯÈÝÆ÷£¬Æä¾ßÌåµÄÌõ¼þÊÇͨ¹ý£¨ £©·½

·¨Ìí¼ÓÖÁCriteriaʵÀýÖС££¨ÌâÄ¿ÓÐÎÊÌ⣩ A£®Criteria.add B£®Criteria.update C£®Criteria.save D£®Criteria.put 51¡¢

ÔÚHibernateµÄCriteria²éѯÖУ¬Expression¶ÔÏó¾ßÌåÃèÊöÁ˲éѯÌõ¼þ£¬Æä¶ÔÓ¦

SQLÌõ¼þÖеÄfield>=valueµÄ·½·¨ÊÇ£¨ £©¡£ A£®Expression.eq B£®Expression.gt C£®Expression.ge D£®Expression.lt 52¡¢

ÔÚHibernateµÄCriteria²éѯÖУ¬Expression¶ÔÏó¾ßÌåÃèÊöÁ˲éѯÌõ¼þ£¬ÆäÖÐ

Expression.le¶ÔÓ¦µÄSQLÌõ¼þÊÇ£¨ £©¡£ A£®field>value B£®field>=value C£®field

ÔÚHibernateµÄCriteria²éѯÖУ¬´ÓµÚ5Ìõ¼Ç¼¿ªÊ¼²éѯµÄ·½·¨ÊÇ£¨ £©¡£

A£®criteria.setFirstResult(4); B£®criteria.setFirstResult(5); C£®criteria.setMaxResult(4); D£®criteria.setMaxResult(5); 54¡¢

ÔÚHibernateµÄCriteria²éѯÖУ¬²éѯ5Ìõ¼Ç¼µÄ·½·¨ÊÇ£¨ £©¡£

A£®criteria.setFirstResult(4); B£®criteria.setFirstResult(5);