java Á¬½Ómysql ÎÊÌâ
String user_name = request.getParameter("user_name");
private Date user_register_time;//Õâ¸öÊÇÏë»ñµÃµ±Ç°µÄʱ¼ä
ÎÒÏëÓÃSQLÓï¾ä²åÈëMYSQLÊý¾Ý¿âÖÐusers±íÖÐ ÊôÐÔÊÇ£º£¨user_name varchar(30),user_register_time date£©
SQLÓï¾äÎÒдµÄ²»¶Ô£¬ÕâÀﻹÓиöʱ¼ä´¦ÀíµÄÎÊÌâ
Ï£ÍûÓÐÄÄλ°ïæָµ¼Ò»Ï¡¢¡¢¡¢¡¢
insert into users values('username',now())
¶¼²»Óô«ÈÕÆÚµ½SQLÀïÃæ¡£¡£
Ïë´«Ò²ÐУ¬ÓÃÔ¤´¦Àí¶ÔÏó¾ÍÐÐÁË£¬PreparedStatementÕâ¸ö¶ÔÏó¿ÉÒÔ×÷µ½¡£¡£
ʱ¼ä´¦Àí¿ÉÒÔÓÃSimpleDateFormatµÄformat·½·¨
SimpleDateFormatµÄparse·½·¨£¬°Ñ×ÖÌõ´®ÐÎʽµÄÈÕÆÚ½âÎöΪDATE¶ÔÏó£¬È»ºóÖ±½Ó²åÈëµ½DBÖÐÁË
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚÏëÓÃsshÕûºÏÀ´×öÒ»¸öÂÛ̳£¬µ«Êý¾Ý¿â·½Ãæ²»ÐУ¬ÎÒÖ÷Òª²»»áÉæ¼°Êý¾Ý¿â£¬²»ÖªµÀ·¢Ìû±í£¬ºÍ»ØÌû±íÒªÈçºÎÉè¼ÆºÍÇø·Ö¡£²»ÖªµÀËÓÐÒ»¸ö¼òµ¥µÄ˼·£¬À´Éè¼ÆÕâЩ±í¡£Ð»Ð»ÁË¡£
·¢ÌûºÍ»ØÌûÓÃͬһÕÅ±í ¡£·¢Ìû id user ......
×Ö·ûÁ÷µÄ¶ÁºÍд×îÖÕÔڵײ㶼ÊÇͨ¹ý×Ö½ÚÁ÷À´Íê³ÉµÄÂ𣿡¡¶ÁдÎı¾Îļþ×Ö·ûÁ÷Ó¦¸Ã¾Í¿ÉÒÔÁ˰ɡ£¡£
¸÷λ´ó¸ç´ó½ã°ï°ïæ°¢
JavaÁ÷°üÀ¨×Ö½ÚÁ÷ºÍ×Ö·ûÁ÷£¬×Ö½ÚÁ÷ͨ¹ýIOÉ豸ÒÔ×Ö½ÚÊý¾ÝµÄ·½Ê½¶ÁÈ룬¶ø×Ö·ûÁ÷ÔòÊÇͨ¹ý×Ö½ÚÁ÷ ......
ÎÊÌâÃèÊö£ºÐ´ÈÕÖ¾¹¦ÄÜ£¬Ð´ºÃµÄдÈÕÖ¾·þÎñ£¬ÆäËûÓû§Í¨¹ýhttpµ÷Ó÷þÎñ£¬´«Èë²ÎÊý£¬È»ºó¼Ç¼ÈÕÖ¾£¬
ÎҵķþÎñ¸ÃÔõôд£¬ ±ðÈËÔõôͨ¹ýhttpµ÷ÓÃÎҵķþÎñ£¬ÎÒÓÃwebserviceдºÃÁËÒ»¸ö£¬¿ÉÊDz¢·¢ÓÐÉÏÏߣ¬Ïë¸ÄÓ ......
ÎÒÃÇÓÐÏîÄ¿Ïë×齨һ¸ö¿ª·¢ÍŶӣ¬
Ö÷ÒªÓà tomcat,java,struts2,ÎÒÃǵĺËÐijÉÔ±¶¼ÊǾÑé·Ç³£·á¸»µÄϵͳÉè¼ÆÊ¦£¬
Èç¹ûÄúÔÚÌì½ò£¬Í¬Ê±¶Ôjava±È½Ï¸ÐÐËȤ£¬
¿ÉÒÔ¼ÓÈëÎÒÃÇ¡£
Ï£ÍûÒªÇó
1¡£°®ºÃ±à³Ì
......
Java code:
public static void main(String[] args)throws Exception {
String json="{\"installer_id\":\"00000003\",\"installer_name\":\"ÍõÎå\& ......