Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ïòmysql²åÈëÊý¾Ý³ö´í

java.sql.SQLException: Incorrect string value: '\xA9z </sp...' for column 'Content' at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1605)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1524)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at com.scccms.content.model.ContentDB.insertData(ContentDB.java:183)
at com.scccms.content.web.ContentAction.execute(ContentAction.java:131)
at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)


Ïà¹ØÎÊ´ð£º

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

mysqlÉèÖûº´æ´óС

set global query_cache_size=10; ûÎÊÌâ
set global query_cache_size=4000; Óо¯¸æ
set global query_cache_size=400000; ûÎÊÌâ

ÊÇʲôԭÒò£¿ÉèÖôóСºÍʲôÓйØÏµ£¿
¾¯¸æ ÐÅÏ¢ÊÇʲô£¿

ÉèÖôóÐ ......

ÇóÒ»mysql sql

ÓÐÁ½ÕÅ±í£º¹«Ë¾±ícompany(id,name...)£¬ºÏͬ±íhetong(id,title,companyid,type...)
Ò»¸ö¹«Ë¾¿ÉÄÜÓж೤ºÏͬ£¬typeΪ1-10µÇ¼Ç
ÀýÈ磺company±í
                id ......

ÇóÖúMySQL²éѯ

select *from tabA limit (2*pagesize)
ÎÒÏëÔÚ´æ´¢¹ý³ÌÀïʵÏÖÒÔÉϹ¦ÄÜ£¬pagesizeÊÇint²ÎÊý£¬
ÔõÃ´ÅªÄØ£¿
ÆäʵÊÇÏëŪ¸ö·ÖÒ²µÄ´æ´¢¹ý³Ì ²ÎÊýÊÇ µ±Ç°Ò³Êý¡¢Ò³ÃæÏÔʾÌõÊý

²»¶®£¬°ï¶¥

ûÓа취£¬Ö»ÄÜÓÃ
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ