¶®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Óï¾äÊÇ·ñÕýÈ·£¬Èç¹û²»ÕýÈ·£¬ÓÐȱʡֵµÄ»°(¼´ÓÐ×Ö¶ÎûÓи³Öµ)£¬¸ø¸öĬÈÏÖµ£¬È»º
Ïà¹ØÎÊ´ð£º
ÓÃRandomAccessFileдÈëTXTÎļþ²é¿´Ê±ÊÇÂÒÂ룬ÇëÎÊÓÐʲô·½·¨¿ÉÒÔд³É¿É¶ÁµÄÎļþ£¬²»ÊÇÓÃÆäËûµÄÎļþ²Ù×÷£¬¾ÍÊÇÖ»ÓÃRandomAccessFileµÄ·½·¨ÊÇ·ñ¿ÉÒÔʵÏÖ£¿
Java code:
import java.io.*;
public class RandomAcce ......
ÎÒÏëÓÃJavaдһ¸ö³ÌÐò£¬¾ÍÊÇÎÒÏëÔÚÔËÐдúÂëºó£¬ÔÚÖ¸¶¨µÄʱ¼ä´ò¿ªÄ³³ÌÐò£¬ÀýÈçÎÒÔËÐдúÂëºó£¬½²ÔÚ12£º00´ò¿ª"D:\Program Files\Tencent\QQ2009\Bin\QQ.exe"Õâ¸ö³ÌÐò£¬Çó¸ßÈËÖ¸µã¡£»¹ÓпÉÄܵϰÔÚÖ¸¶¨µÄʱ¼ä ......
ÎÒÏ£ÍûÔÚ±à¼ÎÄ×Öºó°Ñ·¢Ëͼü¸Äµ½ÆÁÄ»Öм䣬¾ßÌå˵¾ÍÊÇ
ÔÚkb.classÖеIJ¿·Ö×÷³öÐÞ¸Ä
²¿·Ö´úÂ룺
V = new TextBox(ld.a(383), "", 190, 0);
X = new Comma ......
ÎÒÏÖÔÚÓÃstruts2¿ò¼Ü,ÐèҪʹÓÃajaxʵÏÖ¾Ö²¿Ë¢Ð£¬µ«ÊÇ´ÓÈÝÆ÷Àï·µ»ØµÄÖµ²»ÖªµÀÔõô´Óstruts.xmlÅäÖÃÎļþÀïÓ³Éäµ½jspÒ³ÃæÀÒÔǰservletÀïдout.orint("xxxxx")¾Í¿ÉÒԵõ½~£¬µ«ÊÇÏÖÔÚÓÃstruts¾Í²»ÖªµÀÔõôР......
<html><head><title>[@title]</title>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<script language='javascript'>
function diyCheck ......