¶®PHP¡¢MySQLµÄJava¸ßÊÖ°ï°ïÎÒ°É
1.Ê×ÏÈÊÇ t_user ±íµÄ¼û±íÓï¾ä£º
SQL code:
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`uid` int(4) NOT NULL,
`uname` varchar(10) NOT NULL,
`uage` int(4) NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2.È»ºóÊÇÔÚPHPÖÐÖ´ÐеÄÒ»Ìõ²åÈëÓï¾ä£º
PHP code:
$_SGLOBAL['db']->query("INSERT INTO t_user (uid,uname) VALUES ('1','lucy')");
3.ÔÙ¿´JavaÖÐÖ´ÐÐÒ»Ìõ²åÈëÓï¾ä£º
Java code:
pstmt = conn.prepareStatement(sql);
rows = pstmt.executeUpdate();
ͬÑùÒ»ÌõMySQLµÄSQLÓï¾ä£¬¶¼Ö»²åÈëÁ½¸ö×ֶΣ¬µÚÈý¸ö×Ö¶ÎûÓвåÈëÖµ£¬ÓÉÓÚt_userµÄ¼û±íÓï¾äûÓиøµÚÈý¸ö×Ö¶ÎuageÌṩĬÈÏÖµ£¬ËùÒÔÔÚJavaÖÐÖ´ÐвåÈëµÄʱºò»á±¨´í£ºField 'uage' doesn't have a default value,¿ÉÊÇΪʲôÔÚPHPÖÐÖ´ÐÐÈ´ÄÜͨ¹ý£¿PHPÊDz»ÊǽøÐÐʲôÉèÖÃÁË£¬ÎÒ²»Ôõô¶®PHP£¬ÇëÎÊPHPÔõôÉèÖõĴó¸ÅÊÇ£¿JavaÏëÒª×öµ½PHPµÄЧ¹ûÔõôŪ£¿
²»¶®PHP£¬javaÖеÄjdbcÖ´ÐÐsqlÓï¾äÊÇÒªÊý¾Ý¿âÖ§³ÖµÄ£¬Èç¹ûÄãµÄÊý¾Ý¿â²»ÄÜʶ±ðsqlÓï¾ä£¬ÄǾͻá³ö´í¡£
ËùÒÔsqlÓï¾äÒ»¶¨ÒªÐ´¶ÔÁ˲ÅÐС£
Äã¿ÉÒÔд¸ö·½·¨£¬ÑéÖ¤ÄãÒªÖ´ÐеÄsqlÓï¾äÊÇ·ñÕýÈ·£¬Èç¹û²»ÕýÈ·£¬ÓÐȱʡֵµÄ»°(¼´ÓÐ×Ö¶ÎûÓи³Öµ)£¬¸ø¸öĬÈÏÖµ£¬È»º
Ïà¹ØÎÊ´ð£º
ÎÒµÄjava applet ǶÈëhtmlºóÎÞ·¨ÏÔʾ£¬¶øÓÃappletviewerÏÔʾÕý³£ÎªÊ²Ã´£¬»¹ÓоÍÊÇÓÃhtml converterת»¯ºó¿ÉÒÔÏÔʾ£¬ÎªÊ²Ã´£¿Çë´óÏÀ´Í½Ì£¡
HTML code:
<HTML>
<HEAD>
<TITLE>TEST.HTML< ......
ÓÃRandomAccessFileдÈëTXTÎļþ²é¿´Ê±ÊÇÂÒÂ룬ÇëÎÊÓÐʲô·½·¨¿ÉÒÔд³É¿É¶ÁµÄÎļþ£¬²»ÊÇÓÃÆäËûµÄÎļþ²Ù×÷£¬¾ÍÊÇÖ»ÓÃRandomAccessFileµÄ·½·¨ÊÇ·ñ¿ÉÒÔʵÏÖ£¿
Java code:
import java.io.*;
public class RandomAcce ......
ÎÒÏëÓÃJavaдһ¸ö³ÌÐò£¬¾ÍÊÇÎÒÏëÔÚÔËÐдúÂëºó£¬ÔÚÖ¸¶¨µÄʱ¼ä´ò¿ªÄ³³ÌÐò£¬ÀýÈçÎÒÔËÐдúÂëºó£¬½²ÔÚ12£º00´ò¿ª"D:\Program Files\Tencent\QQ2009\Bin\QQ.exe"Õâ¸ö³ÌÐò£¬Çó¸ßÈËÖ¸µã¡£»¹ÓпÉÄܵϰÔÚÖ¸¶¨µÄʱ¼ä ......
Ïë換個µØ·½¹¤×÷£¬²»ÊÇ´ó連¾ÍÐУ¬
java對ÈÕÍâ°ü4Äê經驗£¬ÈÕ語3級£¬±¾¿Æ
ÓÐÄÄλ´ó´ó給ÍÆÒ»個Ŷ
ÉϺ£±±¾©ºÜ¶àµÄ£¬È¥´³Ò»Ï°É
¶ÔÈյϹÐÐ.
ÄãÔõô² ......
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......