sql语句:sb.append("select id as id,roleid as roleid,fullname as fullname from TUser where flag=1 and fullname = “+name);
Query query = getSession().createQuery(sb.toString());//
query.setFirstResult((pageNow-1)*pageSize);//设置第一条记录开始的位置
query.setMaxResults(pageSize);//设置返回的纪录总条数
System.out.println("数量: "+query.list().size());
我这样写为什么给我报:ORA-00904: "C235": 标识符无效这个错误?name的值=”c235“我在数据库中可以查到值,为什么在这里差不到?
ä¸çå°±æ¯c235æ¯ä¸ªå符串
ä½ å¨æ¥è¯¢éåºè¯¥å ä¸åå¼å·
sb.append("select id as id,roleid as roleid,fullname as fullname from TUser where flag=1 and fullname = "+name);--åæ¶ä½ è¿ä¸ªæåçåå¼å·ç¨çä¸å¯¹ï¼ä½ ç¨çä¸æåæ³ä½ è¿åå°æ¯ä»ä¹ç
ä½ ççä½ é£ä¸ªå符串æä¹ä¼ å°åéé
追é®åµåµæå·²ç»æ¾å°é误äºï¼è°¢è°¢æ¨çåçï¼ä¸æ¯æä¼ çåæ°çé®é¢ï¼æ¯æåçå页pageSizeåpageNowé½çäº0ï¼æ以èå·®ä¸å°ï¼ææsb.append("select id as id,roleid as roleid,fullname as fullname from TUser where flag=1 and fullname = '"+name+"'");åæè¿æ ·ä¹è¡ï¼
追çæ©ï¼å ¶å®è¿æ¯èªå·±æ¾å°æ´ææå°±æ
追é®åµåµï¼è°¢è°¢ä½ ææ³é®ä¸ªé®é¢å°±æ¯ï¼å°±æ¯ä½ æ¯ç¨ä»ä¹å·¥å ·æ代ç åæè¿æ ·çï¼
ä¸ä¼æç»ä½ 满æåç ï¼éº»ç¦ä½ äºï¼
ä½ æ¾ä¸ªçµèåç±»çé¢ï¼åçæ¡ä¸è¾¹æ
çè§ä»£ç è¯è¨äºåï¼éæ©ä¸ªè¯è¨ï¼è¾å
¥ï¼æ交åå°±æ¯è¿æ ·äº