mysql²éѯÓï¾ä³ö´í - Java / Java EE
String sql = "select resourceSn,aclState&1,aclState&2,aclState&4,aclState&8,aclTriState from acl ";
ÎÒÓõÄÊÇmysqlÊý¾Ý¿â£¬ÎÒÏëÎÊÏÂΪʲôËüÌáʾsqlÓï¾äÓÐ´í¡£ËüµÄ´íÎóÊÇÕâÑùµÄ £¬ºÃÏñÈÏʶ²»³ö& ·ûºÅ£¬²»ÊÇmysqlÖ§³ÖÕâÑù²éѯÂð£¿
´íÎóÐÅÏ¢£º
unexpected char: '&' [ select resourceSn,aclState&1,aclState&2,aclState&4,aclState&8,aclTriState from acl
ËÄܰïæ½â¾ö ÔÚÏߵȡ£¡£Ð»ÁË¡£
ÕýÔÚѧϰÖÐ
ÊDz»ÊÇ&ǰºóȱÁ˿ոñ°¡£¿
aclStateÊÇ×Ö¶ÎÃû,¶íÈÕÎÒÒªµÃµ½µÄ½á¹ûÊÇÒªaclState&1
3¥˵µÄÊDz»ÊÇ&ǰºóȱÁ˿ոñ,ÎÒÊÔÁË »¹ÊDz»ÐÐ select resourceSn,aclState & 1,aclState & 2,aclState & 4,aclState & 8,aclTriState from acl
ллÄãÃÇ £¬ÎÒ½â¾öÁË ÊÇÎÒÓôíÁËhibernateµÄÒ»¸ö·½·¨£¬ÎÒд³Éthis.getSession().createQuery(sql).list(); ÒòΪÓë²Ù×÷ÔÚhqlÖв»Ö§³Ö£¬ËùÒÔÖ»ÄÜÓÃthis.getSession().createSQLQuery(sql).list();
public List searchAclRecords(String principalType,String principalSn){
String sql =
" select resourceSn,aclState&1,aclState&2,aclState&4,aclState&8,aclTriState from acl " +" where principalType = '"+principalType + "' and principalSn = "+principalSn;
return this.getSession().createSQLQuery(sql).list();
}
ÌṩÒÔÏÂÓï¾äµÄ½á¹û£º
show create table acl;
select aclState
Ïà¹ØÎÊ´ð£º
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
ΪʲôHTMLÒÔ¼°Ò»Ð©ÆäËü±êÇ©»áÏÔÊ¾Ò»Ð©ÌØ¶¨±íÏÖÐÎÊ½ÄØ£¿ÈçHTMLÖеĻ»ÐбêÇ©<BR/>ÔڵײãÊÇÔõÑùʵÏÖµÄÄØ£¿ÏÖʵµÄÔÀíÊÇÊ²Ã´ÄØ
È¥W3C¹Ù·½ÍøÕ¾ÉÏ£¬¿´¿´°É£¡ÎÒÏëÒ»¿´Äã¾ÍÃ÷°×ÁË
ÎҲºͱàÒëÔÀíÓйأ¬ä¯ÀÀÆ÷Àï¿É ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
ÇëÎʸ÷λ¸ç¸ç½ã½ã£¬ÈçºÎÔËÓÃÏֳɵÄÄ£°åÀ´ÖÆ×÷ƯÁÁµÄJSPÍøÒ³Ñ½,»ØÕßÓзÖ!
×Ô¼º¶¥Ï£¬×ÜÓиßÊÖ°É,ÆÚ´ýÖÐ......
Èç¹ûÖ±½ÓÒýÓýøÈ¥
¿ÉÒÔÖ±½ÓÓÃjspµÄÖ¸ÁҲ¿ÉÒÔÓÃfreemarkÒýÓ㬼ǵøø·Ö
лл¸÷λÁË£¬¿´À´Î ......
ÔھƵê¹ÜÀíϵͳÖÐ,ÓÐÒ»¸ö¶ÔÄÚµÄϵͳ,¹©Ç°Ì¨·þÎñÔ±ºÍ¾ÀíʹÓÃ
»¹ÓÐÒ»¸ö¾ÍÊǶÔÍâ,Èÿͻ§¿ÉÒÔÔÚÍøÉÏÔ¤¶©·¿¼ä,
ËüÃÇÖ®¼äÊÇÔõôͨѶµÄ.?µ±ÎÒÌá½»Ô¤¶©·¿¼äÐÅÏ¢µÄʱºò,
ÔÚ¶ÔÄÚµÄϵͳÖÐ,ÈçºÎÖªµÀÎÒÒѾÌá½»ÁËÐÅÏ¢¹ýÈ¥.Ê¹Ç ......