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
Ïà¹ØÎÊ´ð£º
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ã潫²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
ÔÚJSPÒ³ÃæÓÐÒ»¸ö<input type="hidden" name="index" value="0">/>¿Ø¼þ
µ±ÎÒÓÃÏÂÃæµÄJavaScriptº¯Êý¸Ä±äÆävalueµÄÖµµÄʱºò Èç¹ûÂú×ãÌõ¼þ£¨¼´i>=3µÄʱºò£©ÎªÊ²Ã´valueµÄ ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......
ÎÒÓõÄÊÇmysql6.0Ϊʲôһ´´½¨Á½¸ö±íÕâ¼äÓÃÍâ¼üÀ´Á¬½Óʱ¾Í˵´´½¨²»ÁË£ºcan"nt create table ...
ÄãµÄÓï¾äÊÇʲô£¿ÄãµÄ±íÊÇʲô´æ´¢ÒýÇ棿 Èç¹ûÊÇmyisam Ôò²»Ö§³ÖÍâ¼ü£¬ÄãÐèÒª°Ñ±í¸ÄΪinndb
貼³öSQL ......