jspÁ¬½Ómysql¶ÔÊý¾Ý¿â½øÐвÙ×÷ÂÒÂëµÄ½â¾ö
Èç¹ûjsp²åÈëmysqlÊý¾Ý¿â³öÏÖÂÒÂ룬mysqlÊý¾Ý¿â°²×°Ê±±àÂëÉèΪutf8£¬ÔÚÖ´ÐвåÈëÓï¾äµÄÇ°Ãæ£¨½ô°¤×ÅÖ´ÐÐÓï¾ä£©Ìí¼ÓתÂëÓï¾ä£ºString na="";
try{
na=rowSet.getString(k);
byte bb[]=na.getBytes("iso-8859-1");
na=new String(bb);
}catch(UnsupportedEncodingException ex){
throw new RuntimeException("unsupported encoding type.");
}
Èç¹ûjsp´ÓmysqlÊý¾Ý¿âÖжÁ³öÀ´µÄÖÐÎÄΪÂÒÂ룬ÔòÔÚÏÔʾ²Ù×÷½á¹ûµÄÓï¾äÇ°ÃæÌí¼ÓתÂëÓï¾ä£ºString na="";
try{
na=rowSet.getString(k);
byte bb[]=na.getBytes("iso-8859-1");
na=new String(bb);
&
Ïà¹ØÎĵµ£º
(1)include ÔÚJSP±àÒë³ÉJavaÀàÎļþʱ£¬ÏȽ«includeÎļþÄÚÈݺϲ¢ºó£¬ÔÙ½øÐбàÒë
(2)jsp:include ÔËÐÐʱºÏ²¢,»á½«ÔËÐÐʱµÄ½á¹û°üº¬½øÀ´
(3)c:import ÔËÐÐʱºÏ²¢,»á½«ÔËÐÐʱµÄ½á¹û°üº¬½øÀ´
Òò´Ë£¬
£¨1£©ÀûÓÃinclude°üº¬µÄÒ³ÃæÖÐÈç¹û°üº¬Á˺ÍÔÒ ......
Óï·¨£º
select * from table_name where column_name regexp 'ÕýÔò±í´ïʽ'
»òÇø·Ö´óСд
select * from table_name where column_name regexp binary 'ÕýÔò±í´ïʽ'
Ö§³ÖµÄÕýÔò±í´ïʽ·ûºÅ£º
. ÈÎÒâ×Ö·û
| »ò£¬È磺a|b|c
[] ·¶Î§£¬±ÈÈ磺[a-z],[0-9],[^0-9]²»°ü ......
Ò»¡¢ÏÈ¿´¿´ÈçºÎÈ¡µ±Ç°Ê±¼ä²¢ÏÔʾµÄ´úÂ룺
------------------------------------------------
<%
java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
java.util.Date currentTime = new java.util.Date();//µÃµ½µ±Ç°ÏµÍ³Ê±¼ä
String str_date1 = formatter.form ......
jspµÄÄÚÖöÔÏó¡¢¹¦ÄÜÒÔ¼°Ö÷Òª·½·¨
JspÄÚÖöÔÏó ¹¦ÄÜ Ö÷Òª·½·¨
out Ïò¿Í»§¶ËÊä³öÊý¾Ý print() println() flush() clear() isAutoFlush() getBufferSize() close() …………
request Ïò¿Í»§¶ËÇëÇóÊý¾Ý getAttributeNames() getCookies() getParameter() getParameterValues() ......