_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
CString strServer = "Localhost"; //±¾»ú·þÎñÆ÷Ãû³Æ
CString strDBFile = "xscj"; //Êý¾Ý¿âÃû
& ......
±ÈÈçmysqlÀïÓÐÒ»¸ötable students
ÀïÃæÓÐÒ»ÏîÊǿγÌ
ÀïÃæÓи÷ÖÖ¸÷ÑùµÄ¿Î³Ì ±ÈÈçÊýѧ°¡ ÓïÎİ¡ »òÆäËûµÄ ÎÒÒ²²»Çå³þ¾ßÌåÓжàÉٿγÌ
ÎÒÔõôͳ¼Æ³öÕâÏîÓжàÉÙÖµ ÿ¸öÖµÓжàÉÙnum
student
name course
СÕÅ ÓïÎÄ
ÀîËÄ ......
PHPÓëMySQL³ÌÐòÉè¼Æ (µÚ3°æ) ¸ßÇåPDFÖÐÎİæ
¶¥Ò»¸ö£¬½Ó·Ö
ok.mark
¶àл ·ÖÏí
¿´¿´£¡
лл·ÖÏí
лл·ÖÏí£¬²»´í£¡
лл·ÖÏí¡¡
Ê¥µ®¿ìÀÖ
лл·ÖÏíÕâôºÃÈí¼þ¡£¡£
......
´íÎóÈçͼËùʾ£¬µ«Ã¿´ÎÔËÐаüº¬Á´½ÓMySQLº¯ÊýµÄ³ÌÐòʱ£¬¶¼»áµ¯³ö·¢ËÍ´íÎ󱨸æµÄ´°¿Ú£¬Èç¹ûµã»÷²»·¢ËÍ£¬Ò³Ãæ¾Í±ä³É¸ÃÒ³ÎÞ·¨ÏÔʾÁË£¬ÊÔ¹ýºÜ¶àÍøÉϵķ½·¨¶¼ÎÞ·¨½â¾ö£¬ºÃÏñÍøÉÏÕâÑùµÄÇé¿öÒ²²»ÊǺܶ࣬Èç¹ûµã»÷²»·¢ËÍ£¬Ò³Ãæ¾Í±ä³É¸ÃÒ³ÎÞ·¨ÏÔʾÁË£¬Âé·³´ó¼Ò°ï°ïæ°¡£¡
Äܲ»ÄÜ·¢Ò»Ï ÈÕÖ¾£¡
Ã²ËÆ´íÎóͦÑÏÖØ£¬Ä㻹ÊÇÖØÐÂװһϠ......
Êý¾ÝĬÈϵÄ×Ö·û¼¯Îªlatin1 ,ÔËÐÐÒ»¶Îʱ¼äºó£¬·¢ÏÖÊý¾Ý¿âÖдæ·ÅµÄ¼Ç¼ֻҪΪÖÐÎĵĶ¼ÎªÂÒÂë¡£°ÑÊý¾Ý¿âµ¼³öÀ´£¬È»ºóÖØÐÂÉèÖÃÁËmysql±àÂëΪutf-8.ÇëÎÊÔٰѱ¸·Ý³öÀ´µÄÊý¾Ý¿âÎļþΪsql¸ñʽµÄ£¬ÄÜÇ¿ÖÆ×ª»»Îªutf-8Âð£¿ÖÐÎÄÄÜÕý³£ÏÔʾÂð
±¸·ÝÎļþÖеĺº×ÖÊÇʲôÑù£¿Èç¹û²»ÊÇÂÒÂëÔò¿ÉÒÔ¡£
ºº×Ö¶¼ÊÇÂÒÂ룬µ«ÔÚÒ³ÃæÉϳÌÐò¶Á³öÀ´µÄ¶ ......
Java code:
Connection con = connectionFactory.getconnection();
String sql1="insert into $hanzdb.photolist (content,imageurl) values ('fileForm.getContend','upload/¡¯+fname)";
PreparedStatement ps = con.prepareStatement(sql1);
ps.setString(1, fileForm.getConte ......